How does this skill help with production database safety?

It provides checklists and SQL patterns specifically designed to avoid table locks, such as using CONCURRENTLY for index creation and batching updates for large data sets.

What is the expand-contract migration pattern?

It is a three-phase strategy (Expand, Migrate, Contract) that allows you to change database schemas by adding new fields while keeping old ones active, ensuring the application remains compatible during the transition.

Which ORMs are supported by this skill?

The skill provides specific implementation patterns and CLI workflows for Prisma, Drizzle, Django ORM, TypeORM, and golang-migrate.

Can I use this for both SQL and NoSQL?

While the primary focus is on relational databases like PostgreSQL and MySQL, the core principles of versioned, immutable migrations apply to most structured data stores.

Database Migrations

Name: Database Migrations
Author: flatrick

byflatrick

0•

データベース管理

Implements safe, reversible database schema changes and zero-downtime deployment strategies across major ORMs and SQL dialects.

This skill equips Claude with specialized knowledge for managing complex database schema evolutions without risking data loss or system downtime. It provides implementation patterns for PostgreSQL and MySQL, along with specific workflows for popular tools like Prisma, Drizzle, Django, and golang-migrate. By enforcing principles like immutable migrations and the expand-contract pattern, the skill ensures that developers can confidently handle high-traffic database changes, concurrent indexing, and large-scale data backfills while maintaining a clear audit trail and reliable rollback paths.

主な機能

01SQL patterns for concurrent indexing and non-locking column updates

02Safety checklists for non-blocking schema changes

03Zero-downtime deployment patterns (Expand-Contract)

040 GitHub stars

05Batching strategies for large-scale production data migrations

06Framework-specific guidance for Prisma, Drizzle, and Django

ユースケース

01Backfilling data for millions of rows without locking the database

02Setting up versioned migration workflows for a new project

03Renaming or dropping columns in high-traffic production tables

主な機能

01SQL patterns for concurrent indexing and non-locking column updates

02Safety checklists for non-blocking schema changes

03Zero-downtime deployment patterns (Expand-Contract)

040 GitHub stars

05Batching strategies for large-scale production data migrations

06Framework-specific guidance for Prisma, Drizzle, and Django

ユースケース

01Backfilling data for millions of rows without locking the database

02Setting up versioned migration workflows for a new project

03Renaming or dropping columns in high-traffic production tables