Which ORMs are covered by these patterns?

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

Can it prevent production table locks?

Yes, it includes specific patterns for concurrent index creation and non-blocking column additions to ensure high-traffic tables remain accessible during updates.

What databases does this skill support?

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

How does it handle zero-downtime deployments?

It utilizes the expand-contract pattern: first adding new fields, then backfilling data while the app writes to both, and finally removing the old schema in a separate phase.

Database Migration Patterns

Name: Database Migration Patterns
Author: flatrick

byflatrick

0•

データベース管理

Implements safe, reversible database schema changes and zero-downtime deployments across major SQL databases and ORMs.

This skill provides Claude with advanced expertise in database lifecycle management, prioritizing production safety and system uptime. It covers essential strategies like the 'expand-contract' pattern for zero-downtime changes, safe indexing techniques to avoid table locks, and immutable migration workflows. By integrating best practices for PostgreSQL, MySQL, and popular ORMs such as Prisma, Drizzle, and Django, it helps developers navigate complex schema evolutions and data backfills without risking data integrity or service availability.

主な機能

010 GitHub stars

02ORM-specific workflows for Prisma, Drizzle, Django, and TypeORM

03Batch-processing logic for large-scale data migrations

04Zero-downtime 'expand-contract' migration strategies

05Comprehensive migration safety checklists for production environments

06Non-blocking PostgreSQL indexing and column modification patterns

ユースケース

01Setting up robust migration pipelines for new TypeScript or Python projects

02Renaming or removing database columns without service interruption

03Adding non-blocking indexes to high-traffic production tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt database-migrations

For use in Claude.ai and ChatGPT