code-add-migration

To safely generate database migrations for production, this Skill detects your project's migration tooling, classifies schema changes as ADDITIVE, MUTATING, or DESTRUCTIVE, and produces a structured report with phased rollout commands and reversal considerations.

Adding a NOT NULL column to a populated Postgres table requires a multi-step approach to avoid downtime. This Skill flags NOT NULL additions as landmines and generates a phased rollout plan to backfill data and apply the constraint safely.

Yes, this Skill works with Drizzle, Prisma, Knex, and raw SQL. It automatically detects your project's migration tooling to ensure the correct generator and runner are used for your specific schema modifications.

Creating large Postgres indexes without locking the database requires using the CONCURRENTLY keyword. This Skill enforces concurrency-aware safety checks and coordinates deploy steps to prevent missing this critical flag.

Handling destructive schema changes like dropping columns safely requires classifying them as DESTRUCTIVE and delaying the drop. This Skill produces a structured report with phased rollout guidance to ensure destructive drops are not executed too early.