Database Migration Patterns

Safe, reversible database schema changes for production systems.

When to Activate

• Creating or altering database tables
• Adding/removing columns or indexes
• Running data migrations (backfill, transform)
• Planning zero-downtime schema changes

Core Principles

1. Every change is a migration — never alter production manually
2. Migrations are forward-only in production — rollbacks use new forward migrations
3. Schema and data migrations are separate — never mix DDL and DML
4. Test against production-sized data — 100 rows != 10M rows
5. Migrations are immutable once deployed — create new migration instead