void-drizzle-migration-safe

What problem does it solve? Schema changes on a live Postgres database can lock tables, break running application pods, or corrupt data when done naively. This Skill enforces safe multi-deploy migration patterns for Drizzle ORM so columns, indexes, foreign keys, and enums change without downtime. ## Core Features & Use Cases - Safe column lifecycle patterns: Add NOT NULL columns, rename columns, and drop columns across multiple deploys with backfill steps instead of single locking statements. - Lock-free index and constraint creation: Edits drizzle-kit generated SQL to use CREATE INDEX CONCURRENTLY and NOT VALID foreign keys, with validation queries for invalid indexes. - Enum change checklists: Covers adding, renaming, and the multi-migration reality of removing Postgres enum values. - Use Case: When asked to add a NOT NULL locale column to a production users table, the Skill produces three separate migrations (nullable add, backfill, SET NOT NULL) spread across two deploys, plus the hand-edited SQL drizzle-kit will not generate on its own. ## Quick Start Ask the agent to add a NOT NULL column to a production Drizzle table and it will plan the multi-deploy migration sequence with edited SQL.