Does it prevent table locking on large datasets?

Yes, it includes best practices such as using CREATE INDEX CONCURRENTLY in Postgres and performing batch updates for data migrations to avoid holding long-running locks on production tables.

Can it help me fix failed migrations?

It provides guidance on safe rollback strategies and manual fix patterns for 'dirty' migration states commonly found in tools like golang-migrate or Prisma.

How does this skill help with zero-downtime deployments?

It provides a step-by-step 'expand-contract' pattern that allows you to add new schema elements, migrate data, and eventually remove old structures in separate deployment phases to ensure application compatibility throughout the transition.

Which databases and ORMs are supported?

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

Database Migrations

Name: Database Migrations
Author: flatrick

byflatrick

0•

データベース管理

Implements safe, zero-downtime database schema changes and data migrations using industry-standard best practices.

This skill provides Claude with comprehensive patterns for managing database schema evolution across production environments without risking downtime or data loss. It features specific implementation guides for PostgreSQL and MySQL, alongside specialized workflows for popular ORMs like Prisma, Drizzle, and Django. By enforcing the 'expand-contract' strategy and providing safety checklists for high-traffic tables, the skill ensures that schema changes, index additions, and data backfills are handled through versioned, reversible, and non-blocking operations.

主な機能

01Non-blocking index creation and safe column modification patterns for PostgreSQL

02Safety checklists to prevent full table locks and performance degradation

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

04Standardized patterns for separating schema (DDL) and data (DML) migrations

050 GitHub stars

06Zero-downtime 'expand-contract' migration strategies for production systems

ユースケース

01Executing complex data backfills using batched transactions to maintain performance

02Refactoring existing schemas through multi-phase deployment strategies

03Adding columns or indexes to high-traffic tables without locking the database

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt database-migrations

For use in Claude.ai and ChatGPT