db-migrate

To generate database schema migrations using Drizzle ORM, this Skill guides you through modifying schema files, automatically generating SQL migration files, and updating the schema registry to ensure safe schema changes.

The safest way to apply SQL schema changes locally is to generate migration files with breakpoints, verify timestamps, and execute them against your local database. This process catches errors early and ensures data integrity before production deployment.

You do not need to manually write SQL files when adding a new table. This Skill automates migration file generation based on your Drizzle schema modifications, while still allowing you to write custom SQL with breakpoints if needed.

You can verify database migration timestamps and execution order before committing changes. This Skill includes timestamp verification in its workflow, ensuring migrations apply in the correct sequence when executed locally.

After creating a database migration, you should commit both the modified schema files and the generated SQL migration files. This Skill ensures all required files for the schema registry and database state are tracked and committed together.

SQL breakpoints in automated database migrations are supported to allow custom logic during execution, but you must verify migration timestamps and local execution success. This ensures the custom SQL does not disrupt the automated schema registry workflow.