How does it handle zero-downtime migrations?

It utilizes multi-phase strategies, such as the 'Expand and Contract' pattern, to ensure database changes remain backward compatible with the application during deployment.

Is it suitable for cross-database migrations?

Yes, it includes examples for handling dialect-specific differences between major databases like PostgreSQL and MySQL.

Does it provide rollback support?

Absolutely. Every migration pattern emphasizes the 'up' and 'down' approach, including transaction-based safeguards to prevent partial migration failures.

Can I use this for complex data transformations?

Yes, it includes specialized logic for data transformations, including splitting columns, migrating records between tables, and safe data backfilling.

Which ORMs does this skill support?

It provides standardized patterns and best practices for Sequelize, TypeORM, and Prisma, as well as general SQL-based migration strategies.

Database Migration Master

Name: Database Migration Master
Author: Microck

byMicrock

•

数据库管理

Executes complex database schema changes and data transformations across multiple ORMs using zero-downtime deployment strategies.

关于

This Claude Code Skill provides specialized guidance for executing database migrations using popular ORMs like Sequelize, TypeORM, and Prisma. It focuses on maintaining system availability through zero-downtime deployment patterns, safe schema transformations (such as the expand-and-contract strategy), and robust rollback procedures. Whether you are refactoring data models, upgrading database versions, or migrating between different database engines like PostgreSQL and MySQL, this skill offers the implementation patterns and best practices needed to ensure data integrity and minimal service disruption.

主要功能

Multi-ORM support including Sequelize, TypeORM, and Prisma
Cross-database dialect handling for PostgreSQL and MySQL compatibility
81 GitHub stars
Zero-downtime migration strategies like Blue-Green and Expand/Contract
Complex data transformation and automated backfilling logic
Robust rollback procedures and transaction-based migration patterns

使用场景

Migrating a production database between different ORMs (e.g., Sequelize to Prisma)
Refactoring high-traffic schemas without taking the application offline
Implementing automated rollback scripts for CI/CD deployment pipelines

关于

主要功能

Multi-ORM support including Sequelize, TypeORM, and Prisma
Cross-database dialect handling for PostgreSQL and MySQL compatibility
81 GitHub stars
Zero-downtime migration strategies like Blue-Green and Expand/Contract
Complex data transformation and automated backfilling logic
Robust rollback procedures and transaction-based migration patterns

使用场景

Migrating a production database between different ORMs (e.g., Sequelize to Prisma)
Refactoring high-traffic schemas without taking the application offline
Implementing automated rollback scripts for CI/CD deployment pipelines