How does this skill help with zero-downtime deployments?

It provides specific 'expand-contract' patterns that allow the application to transition between schema versions gradually, ensuring compatibility while the database and code are updated in phases.

Does it work with modern TypeScript ORMs?

Yes, it includes detailed workflows and best practices for popular ORMs like Prisma and Drizzle, including how to handle manual SQL for operations the ORMs can't natively express.

Which database engines are supported?

While many principles apply universally, the skill provides specific, optimized SQL patterns and best practices for PostgreSQL and MySQL.

How does it handle large-scale data migrations?

The skill suggests batch-based update patterns and background backfill strategies to prevent long-running transactions from locking tables and causing application timeouts.

Database Migration Expert

Name: Database Migration Expert
Author: nbossn

bynbossn

0•

数据库管理

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

This skill equips Claude with the expertise to guide developers through complex database lifecycle management, ensuring schema evolution is handled safely and professionally. It provides standardized patterns for schema changes, data backfilling, and rollbacks while preventing common production hazards like full table locks. By implementing strategies such as the expand-contract pattern, it enables zero-downtime deployments across various ecosystems including PostgreSQL, Prisma, Drizzle, Django, and golang-migrate.

主要功能

01Non-blocking index creation and safe column modification techniques

02Batch-based data migration patterns for large-scale production tables

03Zero-downtime deployment strategies using Expand-Contract patterns

04Pre-deployment safety checklists for schema and data migrations

050 GitHub stars

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

使用场景

01Adding indexes to tables with millions of rows without locking writes

02Refactoring production database schemas without service interruption

03Automating data backfills and transformations within migration scripts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nbossn/claude-code-base database-migrations

For use in Claude.ai and ChatGPT

主要功能

01Non-blocking index creation and safe column modification techniques

02Batch-based data migration patterns for large-scale production tables

03Zero-downtime deployment strategies using Expand-Contract patterns

04Pre-deployment safety checklists for schema and data migrations

050 GitHub stars

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

使用场景

01Adding indexes to tables with millions of rows without locking writes

02Refactoring production database schemas without service interruption

03Automating data backfills and transformations within migration scripts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nbossn/claude-code-base database-migrations

For use in Claude.ai and ChatGPT