Why should I separate schema and data migrations?

Separating DDL (schema) and DML (data) prevents long-running transactions that can lock tables, making rollbacks safer and more predictable in production.

How does this skill help with zero-downtime deployments?

It provides the expand-contract pattern and non-blocking SQL techniques to ensure your database remains available and responsive during schema changes.

Can it help with large-scale data updates?

Yes, it includes specific patterns for batch updates with progress tracking to avoid table locks and performance degradation on production-sized datasets.

Which ORMs and tools are supported?

The skill includes specialized patterns for Prisma, Drizzle, Django, TypeORM, and golang-migrate, as well as raw SQL for PostgreSQL and MySQL.

Database Migrations & Schema Management

Name: Database Migrations & Schema Management
Author: flatrick

byflatrick

0•

Gestión de Bases de Datos

Implement safe, reversible database schema changes and zero-downtime deployments using industry-standard migration patterns.

This skill equips Claude with specialized knowledge for managing database schema changes across PostgreSQL, MySQL, and popular ORMs like Prisma, Drizzle, and Django. It prioritizes production safety by providing guidance on non-blocking index creation, safe column additions, and the expand-contract pattern for zero-downtime deployments. Whether you are backfilling millions of rows or setting up a new migration workflow, this skill ensures your database operations are immutable, reversible, and optimized for high-traffic environments without causing service interruptions.

Características Principales

01Zero-downtime expand-contract deployment strategies

02Comprehensive migration safety checklists and anti-pattern prevention

03Framework-specific guidance for Prisma, Drizzle, Django, and TypeORM

04Non-blocking PostgreSQL and MySQL index creation patterns

05Safe data migration and batch processing techniques

060 GitHub stars

Casos de Uso

01Transitioning manual database changes to a version-controlled migration system

02Renaming or removing database columns safely in a live environment

03Altering large production tables without locking writes or causing downtime

Características Principales

01Zero-downtime expand-contract deployment strategies

02Comprehensive migration safety checklists and anti-pattern prevention

03Framework-specific guidance for Prisma, Drizzle, Django, and TypeORM

04Non-blocking PostgreSQL and MySQL index creation patterns

05Safe data migration and batch processing techniques

060 GitHub stars

Casos de Uso

01Transitioning manual database changes to a version-controlled migration system

02Renaming or removing database columns safely in a live environment

03Altering large production tables without locking writes or causing downtime