add-dbup

What problem does it solve?

This skill streamlines adding DbUp SQL migration scripts by ensuring correct sequential numbering, consistent PascalCase naming, embedded-resource configuration, and safe SQL patterns so migrations execute reliably and in order.

Core Features & Use Cases

• Sequential numbering: Detects the highest existing numeric prefix and generates the next zero-padded NNNN to avoid collisions and preserve execution order.
• Naming and safety conventions: Enforces descriptive PascalCase filenames, schema-qualified identifiers, GO terminators, idempotent guards, and guidelines to avoid destructive changes.
• Verification and alignment: Verifies dotnet build success and prompts developers to align EF Core IEntityTypeConfiguration with the SQL schema; ideal for creating tables, adding columns, seeding data, indexes, and stored procedures.

Quick Start

Create a new script using the next zero-padded number and a PascalCase descriptive name in src/Database/Scripts, then run dotnet build src/Database to confirm compilation before review.