What databases and ORMs does this skill support?

It provides patterns and best practices for PostgreSQL, MySQL, and popular ORMs including Prisma, Drizzle, Django, TypeORM, and golang-migrate.

Can I use this for large-scale data migrations?

Yes, it includes specific strategies for batched data updates using SQL and application logic to prevent long-running transactions and table locks on large datasets.

Does it handle non-blocking index creation?

Absolutely. It prioritizes CONCURRENTLY index creation for PostgreSQL and provides equivalent safety strategies for other engines to ensure database performance is maintained.

How does this skill help with zero-downtime deployments?

It guides users through the expand-contract pattern, which involves adding new fields, backfilling data, and then deprecating old fields in separate phases to ensure the application remains functional throughout the transition.

Database Migrations

Name: Database Migrations
Author: flatrick

byflatrick

0•

Gestión de Bases de Datos

Standardize and automate safe, zero-downtime database schema changes and data migrations across multiple platforms and ORMs.

This skill equips Claude with expert-level guidance for managing database schema evolutions and data migrations without disrupting production services. It covers best practices for popular tools like Prisma, Drizzle, Django, and golang-migrate, while emphasizing safe PostgreSQL and MySQL patterns. By implementing expand-contract strategies and concurrency-first indexing, the skill ensures that schema changes are reversible, performant, and follow strict immutability principles in production environments, preventing common pitfalls like table locks and data loss.

Características Principales

01Separate handling for schema (DDL) and data (DML) migrations

02Comprehensive migration safety checklists and anti-pattern detection

030 GitHub stars

04Multi-ORM support including Prisma, Drizzle, Django, and golang-migrate

05Safe PostgreSQL patterns for non-blocking index creation and column updates

06Step-by-step expand-contract workflows for zero-downtime deployments

Casos de Uso

01Executing complex data backfills and transformations with batching and progress tracking

02Adding columns or indexes to large production tables without locking writes

03Automating schema migration workflows for new TypeScript or Python projects

Características Principales

01Separate handling for schema (DDL) and data (DML) migrations

02Comprehensive migration safety checklists and anti-pattern detection

030 GitHub stars

04Multi-ORM support including Prisma, Drizzle, Django, and golang-migrate

05Safe PostgreSQL patterns for non-blocking index creation and column updates

06Step-by-step expand-contract workflows for zero-downtime deployments

Casos de Uso

01Executing complex data backfills and transformations with batching and progress tracking

02Adding columns or indexes to large production tables without locking writes

03Automating schema migration workflows for new TypeScript or Python projects