Does this skill support specific ORMs?

Yes, it provides detailed workflows and code snippets for Prisma, Drizzle, Django, TypeORM, and golang-migrate.

How can I add an index to a large production table safely?

The advisor provides patterns for creating indexes concurrently, which allows the database to build the index without blocking writes to the table.

What is the 'expand-contract' pattern for migrations?

It is a three-phase strategy where you first expand the schema (add new fields), migrate the data and application logic, and finally contract the schema (remove old fields) to ensure zero downtime.

Can it help with large-scale data backfills?

Absolutely. It offers patterns for batch-based updates using loops and 'FOR UPDATE SKIP LOCKED' to process millions of rows without causing long-running transaction issues.

Migration Advisor

Name: Migration Advisor
Author: kangnam7654

bykangnam7654

0•

Database Management

Provides expert guidance on safe, zero-downtime database schema changes and data migrations across major SQL engines and ORMs.

Migration Advisor is a specialized skill designed to help developers navigate the complexities of production database schema changes without risking downtime or data loss. It provides battle-tested patterns for PostgreSQL and MySQL, alongside implementation-specific advice for popular ORMs like Prisma, Drizzle, Django, and TypeORM. By emphasizing the expand-contract pattern, concurrent indexing, and the separation of schema and data migrations, this skill ensures your database operations are reversible, safe, and efficient even on tables with millions of rows.

Key Features

01Safety checklists for preventing full table locks on production systems

02Standardized workflows for creating, testing, and rolling back migrations

03Language-specific guidance for Prisma, Drizzle, Django, and golang-migrate

040 GitHub stars

05Patterns for concurrent indexing and batch-based data backfills

06Zero-downtime migration strategies including the expand-contract pattern

Use Cases

01Refactoring large datasets using batch updates to manage transaction log size

02Adding a NOT NULL column to a multi-million row table without locking it

03Executing a safe column rename across both database schema and application code

Key Features

01Safety checklists for preventing full table locks on production systems

02Standardized workflows for creating, testing, and rolling back migrations

03Language-specific guidance for Prisma, Drizzle, Django, and golang-migrate

040 GitHub stars

05Patterns for concurrent indexing and batch-based data backfills

06Zero-downtime migration strategies including the expand-contract pattern

Use Cases

01Refactoring large datasets using batch updates to manage transaction log size

02Adding a NOT NULL column to a multi-million row table without locking it

03Executing a safe column rename across both database schema and application code