Does it support specific database engines like PostgreSQL?

Yes, it includes specialized patterns for PostgreSQL such as 'CREATE INDEX CONCURRENTLY' and advice on version-specific behavior for adding columns with defaults.

Can I use this with Node.js ORMs like Prisma and Drizzle?

Absolutely. The skill includes specific workflows, CLI commands, and schema examples for Prisma, Drizzle, and other popular TypeScript-based tools.

How does this skill prevent production downtime during migrations?

It provides 'expand-contract' patterns which allow application code and database schemas to evolve in compatible phases, ensuring the system remains functional during the transition.

What is the recommended approach for large data migrations?

The skill suggests batching updates using loops with 'LIMIT' and 'SKIP LOCKED' to prevent massive transactions from locking the entire table.

Database Migrations

Name: Database Migrations
Author: Infopibe

byInfopibe

•

데이터베이스 관리

Provides best practices and implementation patterns for safe, zero-downtime database schema changes and data migrations.

This skill equips Claude with specialized knowledge for managing database evolution in production environments without service interruption. It offers detailed guidance on PostgreSQL and MySQL optimization, including safe indexing and column modification, while providing specific workflows for popular ORMs like Prisma, Drizzle, and Django. By utilizing the expand-contract pattern and enforcing the separation of schema and data migrations, it helps developers avoid common pitfalls like table locks, long-running transactions, and irreversible manual changes.

주요 기능

01Comprehensive safety checklists for production deployments

02Batch processing patterns for large-scale data backfilling

03Non-blocking index creation and safe column modifications

041 GitHub stars

05ORM-specific workflows for Prisma, Drizzle, Django, and TypeORM

06Zero-downtime expand-contract migration strategies

사용 사례

01Transitioning from manual database updates to automated, reversible migration workflows

02Generating migration scripts for complex data transformations using batch processing

03Executing schema changes on high-traffic production databases without locking tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add infopibe/everything-claude-code database-migrations

For use in Claude.ai and ChatGPT

주요 기능

01Comprehensive safety checklists for production deployments

02Batch processing patterns for large-scale data backfilling

03Non-blocking index creation and safe column modifications

041 GitHub stars

05ORM-specific workflows for Prisma, Drizzle, Django, and TypeORM

06Zero-downtime expand-contract migration strategies

사용 사례

01Transitioning from manual database updates to automated, reversible migration workflows

02Generating migration scripts for complex data transformations using batch processing

03Executing schema changes on high-traffic production databases without locking tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add infopibe/everything-claude-code database-migrations

For use in Claude.ai and ChatGPT