What databases and tools does this skill support?

The skill provides specific patterns for PostgreSQL and MySQL, with dedicated implementation guides for Prisma, Drizzle, Kysely, Django, TypeORM, and golang-migrate.

Does it handle data migrations as well as schema changes?

Yes, it includes patterns for safe data backfilling using batched updates and anonymous blocks to prevent long-running transactions from affecting database performance.

How does this skill help prevent production downtime?

It implements the 'expand-contract' pattern and provides SQL snippets for concurrent operations, ensuring that schema changes don't lock tables or break application compatibility during deployment.

Can I use this for reversible migrations?

Absolutely. The skill emphasizes the 'forward-only' principle for production while ensuring every migration has a documented rollback plan or an 'UP/DOWN' structure for development.

Database Migration Patterns

Name: Database Migration Patterns
Author: affaan-m

byaffaan-m

•

112,913

•

データベース管理

Implements safe, zero-downtime database schema changes and data migrations across major SQL engines and ORMs.

This skill equips Claude with expert-level guidance for managing database evolution in production environments without risking downtime or data integrity. It covers essential strategies like the expand-contract pattern, safe column additions, and non-blocking index creation for PostgreSQL and MySQL. By providing standardized workflows for popular tools like Prisma, Drizzle, Kysely, and Django, it helps developers avoid common pitfalls such as table locks and irreversible schema changes while ensuring every migration is tested and immutable.

主な機能

01Safe PostgreSQL patterns including concurrent index creation and non-blocking alters

02Comprehensive safety checklists for verifying migrations before production deployment

03Framework-specific workflows for Prisma, Drizzle, Kysely, and Django

04Large-scale data migration batching techniques to prevent transaction timeouts

05Zero-downtime schema change strategies using the Expand-Contract pattern

06112,913 GitHub stars

ユースケース

01Altering high-traffic production tables without triggering global table locks

02Executing complex data backfills for millions of records using batched SQL updates

03Standardizing migration tooling and rollback procedures for new backend projects

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add affaan-m/everything-claude-code database-migrations

For use in Claude.ai and ChatGPT

主な機能

01Safe PostgreSQL patterns including concurrent index creation and non-blocking alters

02Comprehensive safety checklists for verifying migrations before production deployment

03Framework-specific workflows for Prisma, Drizzle, Kysely, and Django

04Large-scale data migration batching techniques to prevent transaction timeouts

05Zero-downtime schema change strategies using the Expand-Contract pattern

06112,913 GitHub stars

ユースケース

01Altering high-traffic production tables without triggering global table locks

02Executing complex data backfills for millions of records using batched SQL updates

03Standardizing migration tooling and rollback procedures for new backend projects

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add affaan-m/everything-claude-code database-migrations

For use in Claude.ai and ChatGPT