Database Migrations

Evolve persistent schemas safely with compatible migrations, backfills, rollback strategy, and integrity checks.

nafeeur 6cd16a0 687 B Updated

File contents

Database Migrations

  • Inspect current schema, data volume, indexes, constraints, and application read/write paths.
  • Prefer additive, backward-compatible phases for live systems.
  • Wrap compatible changes in transactions; make migrations idempotent and versioned.
  • Separate schema change, backfill, and cleanup when locks or runtime compatibility matter.
  • Validate row counts, nullability, uniqueness, foreign keys, FTS/index synchronization, and rollback behavior.
  • Back up or checkpoint before destructive operations.

nafeeur/MaskShift/tree/main/skills/database-migrations commit 6cd16a0f3f

Frequently asked questions

npx skillmds@latest add nafeeur/database-migrations