Create paired SQL migration files with a six-digit numeric prefix.
npx skills add https://github.com/guarzo/slabledger --skill new-migration-guarzo
Please help me install this Agent Skill. Skill: new-migration Source: https://github.com/guarzo/slabledger/tree/main/.claude/skills/new-migration Command: npx skills add https://github.com/guarzo/slabledger --skill new-migration-guarzo
Create a pair of SQL migration files (up and down) to modify the database schema safely and reversibly.
Run this skill to generate the next migration pair in the migrations directory.
High-intent search queries and answers about installing and using this skill.
To create reversible database migrations, generate a paired up and down SQL script set. This ensures schema changes can be safely applied and rolled back, standardizing the migration process for deterministic, testable database updates.
The naming convention for SQL schema change files is a six-digit numeric prefix followed by a short snake_case description, using the NNNNNN_short_description.{up,down}.sql format. This standardizes file tracking and ensures proper migration ordering.
To determine the next migration number for database schema changes, evaluate the existing migration files in your directory. The workflow enforces sequential six-digit numeric prefixes to maintain strict version control over applied database migrations.
Yes, the migration process includes running validations after writing up and down scripts. Beyond generating the SQL file pair, the workflow guides you through embedding migrations, updating documentation, and executing validation checks to ensure schema safety.
A down migration script is required for every database schema change to ensure reversibility. Pairing up and down SQL scripts allows you to safely roll back modifications if an error occurs, maintaining a deterministic and testable database state.
Yes, you can use this migration workflow without external database dependencies. The process operates independently to generate the up and down SQL files, enforce naming conventions, and guide documentation updates for your version-controlled schema changes.
sjtwGenerate and apply timestamped goose database migrations in Go.
bastosGenerate and manage Rails database migrations with reversible up/down patterns.
TorbenMerraldAutomate database migrations with reversible up/down methods and versioning.
ntaksh42Generate SQL and TypeORM database migration scripts with rollback support.
