Plan zero-downtime database schema migrations with the expand-contract pattern: additive migration, dual-write application release, batched backfill, cutover, contract migration, and rollback. Use when the user renames or splits columns, changes types, restructures tables in a live database, or asks how to migrate without downtime.
