skill-database-migration

What problem does it solve?

Best practices and practical patterns for applying database migrations across multiple tools (Prisma Migrate, TypeORM, Alembic, Flyway) with a focus on idempotence, rollback, small steps, and safe deployment workflows.

Core Features & Use Cases

• Migration principles: ensure idempotent migrations, provide down migrations, avoid altering run migrations on shared environments, keep migrations small and focused, test on staging before production, back up databases, and order migration files properly.
• Tool coverage: guidance for Prisma Migrate, TypeORM, Alembic, Flyway, and zero-downtime strategies like expand-contract and safe operations.
• Use Case: a typical workflow where schema changes are introduced, migrations are generated, backfilled data done in separate scripts, and production rollout uses a expand-deploy-cleanup pattern.

Quick Start

Execute a Prisma migration to apply the schema changes in your development environment.