What problem does it solve? Database schema changes in production are risky: blocking index creation, non-idempotent SQL, rebase conflicts in migration files, and backfills that stall deployments. This Skill provides a structured workflow for planning, generating, and hardening Drizzle ORM migrations so schema changes ship safely. ## Core Features & Use Cases - Rollout Strategy Classification: Routes every schema change into one of three paths — regular Drizzle migration, online index creation with CONCURRENTLY, or a dedicated idempotent backfill script — validated against the actual Dev database. - Migration Generation & Hardening: Runs bun run db:generate, renames files meaningfully, updates journal tags, and rewrites SQL with defensive clauses like IF NOT EXISTS and DROP IF EXISTS + ADD for foreign keys. - Development-Stage Cleanup: Handles draft migration regeneration, consolidation of multiple branch migrations, and rebase conflict resolution by regenerating from the rebased schema. - Use Case: When adding a column and index to a large users table, the Skill guides you to create the index manually with CONCURRENTLY before deployment, keep an idempotent non-concurrent version in the migration, and validate timing assumptions on the Dev database first. ## Quick Start Ask the agent to plan and generate a safe Drizzle migration for adding a new column and index to an existing PostgreSQL table.
