database-migrations-management
Installation
SKILL.md
Database Migrations
Use this skill when
- Writing and reviewing schema migrations
- Applying migrations to production safely
- Rolling back and repairing migrations
Do not use this skill when
- Ad-hoc DDL in production
- Schema design from scratch (use its own skill)
Instructions
- Every schema change is a reviewable, numbered migration.
- Prefer additive changes; avoid destructive or long-locking DDL.
- Use expand-and-contract for large tables (backfill, then swap).
- Run migrations in CI against a migrated-staged test DB.
- Set timeouts and avoid full-table rewrites during peak.
- Provide a tested rollback or forward-fix path.
- Mirror production shape before release.