Writing Safe Migrations

Guides Postgres migrations when altering large or live tables, adding indexes or constraints, backfilling columns, changing column types, or planning zero-downtime rollouts. Covers lock levels, lock_timeout, CREATE INDEX CONCURRENTLY, NOT VALID constraints, and expand-and-contract.

pumarogie Updated

File contents

pumarogie/claude-postgres-skills commit c2b4cabfd6

Frequently asked questions

npx get-skill add pumarogie/writing-safe-migrations