Architects safe, reversible, and production-grade PostgreSQL schema migrations using zero-downtime patterns.
This skill equips Claude with the specialized knowledge required to design and implement robust PostgreSQL migrations. It focuses on maintaining database integrity and enabling continuous deployment through proven strategies like the expand-contract pattern, up/down migration pairs, and non-blocking index operations. By enforcing idempotency with guard clauses and providing clear documentation for irreversible operations, it helps developers minimize downtime and prevent data loss during complex schema evolutions.
Key Features
010 GitHub stars
02Implements Expand-Contract patterns for zero-downtime deployments
03Enforces idempotency using SQL guard clauses and IF NOT EXISTS logic
04Ensures non-blocking schema changes with CREATE INDEX CONCURRENTLY
05Generates reversible Up/Down migration pairs for easy rollbacks
06Provides structured documentation for high-risk irreversible operations
Use Cases
01Automating the creation of idempotent SQL scripts for CI/CD pipelines
02Refactoring legacy table structures using multi-phase migration strategies
03Applying schema changes to high-traffic production databases without maintenance windows
