database-migration

Database migrations are timestamped SQL files with up and down scripts that enable schema changes and rollbacks. This Skill generates migration files following conventions for Knex, Prisma, and TypeORM, automatically creating paired up/down scripts so you can apply or reverse schema modifications safely.

Yes, migrations handle all common schema operations: creating or dropping tables, adding or removing columns, defining constraints, and managing indexes. Each migration file contains the up script to apply changes and a down script to revert them if needed.

The Skill validates SQL syntax, ensures unique timestamps on each migration file, and confirms proper up/down structure. It checks adherence to standard migration naming conventions so migrations integrate cleanly with your ORM or migration runner.

Yes, the migration generator integrates with Knex, Prisma, and TypeORM by following each framework's standard conventions for file naming, directory structure, and up/down function signatures.

Each generated migration includes a down script that reverses the changes from the up script. Run the down migration through your framework to safely revert schema modifications to the previous state.

Yes, you can generate migrations by describing desired schema changes in a prompt. The Skill creates timestamped, validated migration files with matching up/down scripts based on your specifications.