Why use this instead of standard ORM documentation?

While ORMs generate basic SQL, this skill adds a safety layer by enforcing production-grade practices like creating indexes concurrently and separating data migrations from schema changes.

Which migration tools and ORMs are included?

It features specialized guidance for Prisma, Drizzle, Django's migration system, TypeORM, and golang-migrate, including custom SQL workarounds for ORM limitations.

How does this skill help prevent database downtime?

It implements the expand-contract pattern, which breaks schema changes into multi-stage deployments. This ensures the application remains compatible with the database at every step of the transition.

Does it support batch updates for large tables?

Yes, the skill provides specific patterns for PostgreSQL batch updates with progress tracking to avoid long-running transactions and table locks on tables with millions of rows.

Database Migrations Best Practices

Name: Database Migrations Best Practices
Author: Fabio29T

byFabio29T

0•

数据库管理

Implements safe, zero-downtime database schema changes and data migrations across major SQL dialects and ORMs.

The Database Migrations skill provides a specialized framework for managing production database changes without risking data loss or system downtime. It equips Claude with industry-standard patterns for PostgreSQL and MySQL, emphasizing the 'expand-contract' strategy and safe DDL operations like concurrent index creation. By providing domain-specific guidance for popular tools such as Prisma, Drizzle, Django, and golang-migrate, this skill ensures that schema evolutions are reversible, immutable, and optimized for performance on production-scale datasets.

主要功能

01Standardized migration safety checklists for production deployments

020 GitHub stars

03Zero-downtime schema evolution strategies using the expand-contract pattern

04ORM-specific workflows for Prisma, Drizzle, Django, and golang-migrate

05Safe PostgreSQL patterns for non-blocking column and index additions

06Batch data migration logic to prevent table locking on large datasets

使用场景

01Planning and executing complex schema changes in a live production environment

02Refactoring large legacy databases while maintaining high availability

03Setting up robust migration tooling and workflows for a new software project

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fabio29t/everything-claude database-migrations

For use in Claude.ai and ChatGPT

主要功能

01Standardized migration safety checklists for production deployments

020 GitHub stars

03Zero-downtime schema evolution strategies using the expand-contract pattern

04ORM-specific workflows for Prisma, Drizzle, Django, and golang-migrate

05Safe PostgreSQL patterns for non-blocking column and index additions

06Batch data migration logic to prevent table locking on large datasets

使用场景

01Planning and executing complex schema changes in a live production environment

02Refactoring large legacy databases while maintaining high availability

03Setting up robust migration tooling and workflows for a new software project

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fabio29t/everything-claude database-migrations

For use in Claude.ai and ChatGPT