Database Migrations Master
Implements safe, reversible database schema changes and zero-downtime deployment patterns across multiple SQL engines and ORMs.
This skill equips Claude with industry-standard patterns for managing database evolutions in production environments. It provides specialized guidance for PostgreSQL and MySQL, alongside deep integration patterns for popular tools like Prisma, Drizzle, Django, and golang-migrate. By enforcing core principles such as the separation of DDL and DML, non-blocking index creation, and the Expand-Contract pattern, this skill ensures that database migrations are performed reliably without service interruptions or data loss.
Key Features
01Batch-processed data backfilling and migration scripts
02ORM-specific workflows for Prisma, Drizzle, Django, and TypeORM
03Non-blocking index creation and safe column modifications
04Zero-downtime deployment strategies (Expand-Contract pattern)
05Comprehensive safety checklists for production-scale schema changes
06130,864 GitHub stars
Use Cases
01Automating complex data backfills for millions of records using batch updates
02Scaling production database schemas without locking tables or service downtime
03Generating safe migration files for CI/CD pipelines across different environments