skills.rest
cilerler
cilerlerCOMMUNITY
Explore all skills by this author →
Website𝕏@cilerlerGitHub

mssql-table-scaffolder

Generates MSSQL CREATE TABLE scripts and migration scripts following enterprise naming conventions.

2|1|Updated Feb 12, 2026
Search Tags:#database migration#naming conventions#sql server#mssql#t-sql#temporal tables#table scaffolding
One-click install
npx skills add https://github.com/cilerler/lillian --skill mssql-table-scaffolder-cilerler
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mssql-table-scaffolder
Source: https://github.com/cilerler/lillian/tree/main/plugins/ai-toolkit/skills/mssql-table-scaffolder
Command: npx skills add https://github.com/cilerler/lillian --skill mssql-table-scaffolder-cilerler

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Writing production-grade SQL Server tables by hand leads to inconsistent constraint names, missing audit columns, and non-conforming triggers that break EF Core scaffolding and complicate maintenance. This Skill standardizes table creation and legacy-table migration against a fixed set of enterprise conventions. ## Core Features & Use Cases - CREATE Mode: Generates complete CREATE TABLE scripts with standard audit columns (RowGuid, RowVersion, CreatedAt, ModifiedAt, ModifiedBy), deterministic constraint/index/trigger naming, and extended properties. - ANALYZE/MIGRATE Mode: Produces ordered migration scripts (sp_rename, ALTER TABLE, constraints, indexes, triggers) to standardize existing legacy tables. - Feature Matrix: Optional feature blocks for Soft Delete, Delete Logging, Locking, Hierarchy, Temporal tables, Full-Text search, Lookup tables, Enablement, Processing Order, and Dedupe Hash, applied via a subtraction rule. - Use Case: Ask to standardize a legacy tblCust table and receive a full migration script that renames objects to conventions, adds missing audit columns, and fixes constraints and indexes. ## Quick Start Ask the agent to create a Customer table in the dbo schema with Name and Email columns plus Soft Delete and Locking features.

Frequently Asked Questions about mssql-table-scaffolder

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a SQL Server table with standard audit columns?▼

Request a new table by name and columns, and the skill generates a CREATE TABLE script with RowGuid, RowVersion, CreatedAt, ModifiedAt, and ModifiedBy columns, a RowGuid unique index, a ModifiedAt trigger, and extended properties. Custom columns are inferred from naming patterns like *Id, Is*, and *At.

How to standardize a legacy SQL Server table to naming conventions?▼

Provide the existing CREATE TABLE statement and the skill produces an ordered migration script: sp_rename for tables, columns, and objects, then ALTER TABLE statements for missing columns, fixed data types, constraints, indexes, triggers, and extended properties.

Can SQL Server temporal tables be combined with soft delete?▼

No. Temporal and Soft Delete are mutually exclusive because Soft Delete relies on an INSTEAD OF DELETE trigger, which is not allowed on system-versioned temporal tables. The skill never generates both features on the same table.

Why do explicit constraint names matter for EF Core scaffolding?▼

Explicit names let dotnet ef dbcontext scaffold capture them via HasName and HasConstraintName, so later EF migrations reproduce the same names. Unnamed constraints get hash-suffixed auto-generated names that differ across environments and cause diff churn.

What inputs are required for soft delete, full-text, and dedupe hash features?▼

Soft Delete requires a view name, Full-Text requires a catalog name and one or more text columns, and Dedupe Hash requires the list of columns defining a duplicate. The skill asks for these inputs before generating the script if they are missing.

Related Skills

Explore More Software Engineering Skills→
bs-koobs-koo

generate-erd-guide

Generate ERDCloud-ready DDL and DE-08 table-definition drafts from requirements and screen lists.

Community
Intermediate
wonderlydotcomwonderlydotcom

db-migrations

Manage Freetool database schema evolution with DBUp SQL scripts.

Official
Intermediate
gabrielnsmntogabrielnsmnto
3

db-schema-audit

Audits PostgreSQL database schemas for design, performance, security, and integrity issues.

Community
Advanced
BridgingIT-GmbHBridgingIT-GmbH
7

entity-framework-core

Automate EF Core DbContext setup, migrations, and LINQ queries for .NET applications.

Official
Advanced