Which ORMs and frameworks are supported?

It includes specialized guidance for Prisma, Drizzle, Django, TypeORM, and golang-migrate, covering both SQL and framework-specific migration commands.

What is the expand-contract strategy mentioned in the skill?

It is a multi-phase deployment pattern that allows you to perform breaking changes, like renaming or deleting columns, without any application downtime.

How does this skill help with large database tables?

The skill provides specific patterns for non-blocking operations, such as creating indexes concurrently and batching data updates to prevent long-running table locks.

Does it support data migrations as well as schema changes?

Yes, it enforces the best practice of separating DDL (schema) and DML (data) migrations, providing templates for safe data backfills and transformations.

Database Migration Specialist

Name: Database Migration Specialist
Author: flatrick

byflatrick

0•

数据库管理

Manages safe, zero-downtime database schema changes and data migrations using industry-standard patterns.

This skill equips Claude with specialized knowledge for planning and executing database migrations across major SQL engines and ORMs. It prioritizes production safety through patterns like expand-contract, concurrent index creation, and the separation of schema changes from data migrations. Whether you're working with PostgreSQL, MySQL, or modern ORMs like Prisma and Drizzle, this skill provides the guardrails necessary to evolve your database architecture without risking performance degradation or system downtime.

主要功能

010 GitHub stars

02Multi-ORM guidance for Prisma, Drizzle, and Django

03Batch-based data backfill and transformation logic

04Safe schema evolution for PostgreSQL and MySQL

05Concurrent index creation and non-blocking SQL

06Zero-downtime expand-contract migration patterns

使用场景

01Optimizing large databases by adding non-blocking indexes

02Migrating data between columns while maintaining application uptime

03Refactoring production table schemas without downtime

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt database-migrations

For use in Claude.ai and ChatGPT