Are rollback procedures included?

Every migration pattern follows the 'up/down' structure and incorporates transaction-based safety to ensure failed migrations can be reverted cleanly.

How does it handle zero-downtime migrations?

It implements a multi-phase approach, including adding backward-compatible columns, dual-writing, and final column removal to ensure the application stays online.

Which ORMs does this skill support?

This skill provides specialized support for major Node.js ORMs including Sequelize, TypeORM, and Prisma.

Can I migrate data between different database dialects?

Yes, the skill includes logic for handling dialect-specific differences, such as JSON vs JSONB when moving between MySQL and PostgreSQL.

Database Migration Master

Name: Database Migration Master
Author: GaitanS

byGaitanS

数据库管理

Manages complex database schema and data migrations across multiple ORMs with zero-downtime and rollback strategies.

关于

The Database Migration skill provides Claude with specialized knowledge to architect and execute sophisticated database updates for modern applications. It offers deep integration with popular ORMs like Prisma, Sequelize, and TypeORM, facilitating seamless schema transformations, cross-database migrations, and complex data backfilling. By leveraging industry-standard patterns such as blue-green deployments and transaction-based rollbacks, this skill ensures data integrity and minimizes service interruptions during critical infrastructure changes.

主要功能

Zero-downtime migration patterns like Blue-Green deployment steps
Complex data transformation and column renaming scripts
0 GitHub stars
Multi-ORM support including Prisma, Sequelize, and TypeORM
Automated rollback procedures and transaction-based safety mechanisms
Cross-database dialect handling for PostgreSQL and MySQL compatibility

使用场景

Performing schema refactoring on high-traffic databases without service interruption
Switching an application from Sequelize to Prisma while preserving data
Implementing safe, reversible data transformations for large-scale production tables

关于

主要功能

Zero-downtime migration patterns like Blue-Green deployment steps
Complex data transformation and column renaming scripts
0 GitHub stars
Multi-ORM support including Prisma, Sequelize, and TypeORM
Automated rollback procedures and transaction-based safety mechanisms
Cross-database dialect handling for PostgreSQL and MySQL compatibility

使用场景

Performing schema refactoring on high-traffic databases without service interruption
Switching an application from Sequelize to Prisma while preserving data
Implementing safe, reversible data transformations for large-scale production tables