How does this skill help prevent production downtime?

It implements the expand-contract pattern and provides instructions for non-blocking operations, such as creating indexes concurrently, to ensure the database remains available during schema updates.

Can I use this for large data migrations?

Yes, it provides patterns for batching data updates and backfills to prevent long-running transactions and table locks on production-sized datasets.

Why should I separate schema and data migrations?

Separating DDL (schema) and DML (data) migrations makes rollbacks more predictable, reduces transaction complexity, and follows industry standards for database reliability.

Which ORMs and tools are supported?

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

Database Migrations

Name: Database Migrations
Author: flatrick

byflatrick

0•

数据库管理

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

This skill provides Claude with expert-level guidance for managing database schema evolution without risking production stability. It covers essential patterns for safe column additions, concurrent indexing, and the 'expand-contract' strategy for zero-downtime deployments. By following these industry best practices, the skill helps developers navigate complex migrations in PostgreSQL and MySQL while providing specific implementation workflows for popular tools like Prisma, Drizzle, Django, and golang-migrate to prevent table locks and data loss.

主要功能

010 GitHub stars

02Batch processing patterns for large-scale data backfills

03Zero-downtime 'Expand-Contract' deployment strategies

04Non-blocking index creation and safe column modification patterns

05Specialized workflows for Prisma, Drizzle, Django, and TypeORM

06Migration safety checklists and anti-pattern prevention

使用场景

01Refactoring legacy database structures using safe, multi-step migration paths

02Automating database migration scripts within CI/CD pipelines using best-practice ORM workflows

03Executing schema changes on high-traffic production databases without maintenance windows

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt database-migrations

For use in Claude.ai and ChatGPT