How does this skill prevent production downtime?

It utilizes the expand-contract pattern, allowing application code and database schema changes to be deployed in phases that maintain backward compatibility.

Which ORMs are covered by these migration patterns?

It includes specific implementation guidance for Prisma, Drizzle, Django, TypeORM, and golang-migrate.

What databases does this skill support?

The skill focuses on PostgreSQL and MySQL, but the principles and patterns are applicable to most relational database management systems.

Can it help with large-scale data updates?

Yes, it provides SQL and ORM patterns for batched updates that prevent long-running transactions and table locks on production-sized datasets.

Database Migration Expert

Name: Database Migration Expert
Author: flatrick

byflatrick

0•

数据库管理

Implements safe, zero-downtime database schema changes and migration patterns across multiple platforms and ORMs.

The Database Migrations skill equips Claude with specialized knowledge for managing complex database evolutions without compromising production stability. It provides comprehensive guidance on performing schema and data migrations using industry-standard best practices, such as the expand-contract pattern and non-blocking index creation. Whether you are using specialized ORMs like Prisma and Drizzle or raw SQL for PostgreSQL and MySQL, this skill ensures your migrations are immutable, reversible, and tested against production-scale data risks. It is an essential resource for developers aiming to achieve zero-downtime deployments while maintaining strict data integrity and performance.

主要功能

01Safety checklists for preventing full table locks on large datasets

02Batched data backfilling techniques for high-traffic environments

03Specific workflows for Prisma, Drizzle, Django, and golang-migrate

040 GitHub stars

05Standardized rollback plans and anti-pattern identification

06Zero-downtime deployment strategies using Expand-Contract patterns

使用场景

01Performing large-scale data transformations on millions of rows safely

02Standardizing migration workflows across different ORMs and languages

03Altering production schemas without interrupting application availability

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt database-migrations

For use in Claude.ai and ChatGPT