How does this skill prevent production downtime during migrations?

It utilizes the Expand-Contract pattern, which separates schema additions from deletions and ensures the application can handle both versions of the database during the transition.

What databases and ORMs are supported by this skill?

The skill provides comprehensive patterns for PostgreSQL and MySQL, with specific implementation guides for Prisma, Drizzle, Django, TypeORM, and golang-migrate.

Can it help with long-running migrations on large tables?

Yes, it includes patterns for batch updates and concurrent index creation to avoid table locks that would otherwise block application writes.

Does it provide guidance on migration rollbacks?

Absolutely. A core principle of the skill is that every migration must have a rollback plan (UP and DOWN patterns) or be explicitly marked as irreversible.

Database Migrations & Schema Patterns

Name: Database Migrations & Schema Patterns
Author: flatrick

byflatrick

0•

Gestión de Bases de Datos

Implements safe, reversible database schema changes and zero-downtime deployment patterns for production-grade systems.

The Database Migrations skill equips Claude Code with the domain-specific knowledge required to handle complex database transitions without risking data loss or system downtime. It provides standardized patterns for PostgreSQL and MySQL, alongside specialized workflows for popular ORMs like Prisma, Drizzle, and Django. By following the 'Expand-Contract' pattern and enforcing strict safety checklists, this skill ensures that schema modifications, index additions, and large-scale data backfills are performed efficiently and safely in high-traffic production environments.

Características Principales

01Non-blocking index creation and safe column modification patterns

020 GitHub stars

03Zero-downtime deployment strategies using the Expand-Contract pattern

04ORM-specific workflows for Prisma, Drizzle, Django, and TypeORM

05Batch-processed data migration templates for large-scale backfills

06Standardized migration safety checklists to prevent production locks

Casos de Uso

01Refactoring legacy database schemas while maintaining application compatibility

02Automating complex data backfills and normalization tasks with batching logic

03Adding or altering columns on massive production tables without service interruption

Características Principales

01Non-blocking index creation and safe column modification patterns

020 GitHub stars

03Zero-downtime deployment strategies using the Expand-Contract pattern

04ORM-specific workflows for Prisma, Drizzle, Django, and TypeORM

05Batch-processed data migration templates for large-scale backfills

06Standardized migration safety checklists to prevent production locks

Casos de Uso

01Refactoring legacy database schemas while maintaining application compatibility

02Automating complex data backfills and normalization tasks with batching logic

03Adding or altering columns on massive production tables without service interruption