What problem does it solve?
This skill eliminates the risk of production outages, data loss, and extended downtime caused by unplanned or unsafe database schema and data changes, which are a common source of critical incidents for engineering teams.
Core Features & Use Cases
- Multi-database and ORM support: Provides migration best practices for PostgreSQL, MySQL, and popular ORMs including Prisma, Drizzle, Kysely, Django, TypeORM, and golang-migrate.
- Zero-downtime migration patterns: Implements the expand-contract workflow to safely alter large production tables without disrupting user traffic.
- Safe data migration and backfill: Includes batch update strategies that avoid long-running table locks, even for datasets with millions of rows.
- Production guardrails: Offers a pre-migration safety checklist, rollback procedures, and anti-pattern guidance to prevent common migration failures.
- Use case example: If you need to add a non-null column to a 10 million row users table without taking your service offline, this skill walks you through the safe, phased workflow to avoid locking the table and impacting users.
Quick Start
Use the database-migrations skill to plan and execute a zero-downtime schema change to add a new nullable avatar_url column to your production users table.
