Can I use this for cross-database migrations?

Yes, it includes logic for handling dialect-specific differences, such as the variations between PostgreSQL JSONB and MySQL JSON types.

Which ORMs does this database migration skill support?

The skill provides specific implementation patterns and best practices for Sequelize, TypeORM, and Prisma.

How does it help achieve zero-downtime migrations?

It utilizes multi-phase strategies that include making backward-compatible changes, backfilling data, and only removing legacy columns once the new code is fully deployed.

How are rollback procedures handled?

Every migration pattern includes a corresponding 'down' method or rollback strategy, often utilizing database transactions to ensure atomic failures.

Does this skill include data transformation capabilities?

Yes, it includes patterns for complex data migrations, such as splitting address strings into separate columns or transforming JSON data structures.

Database Migration Master

Name: Database Migration Master
Author: HermeticOrmus

byHermeticOrmus

数据库管理

Facilitates seamless database schema and data migrations across multiple ORMs with a focus on zero-downtime strategies and safety.

关于

This skill empowers Claude to manage complex database evolutions across popular ORMs like Sequelize, TypeORM, and Prisma. It provides standardized patterns for schema transformations, complex data migrations, and multi-phase zero-downtime deployment strategies, ensuring that database updates are reliable and reversible. Whether you are switching ORMs, refactoring data models, or performing version upgrades, this skill provides the architectural guidance and implementation scripts needed to prevent data loss and minimize service interruptions through transactional safety and robust rollback procedures.

主要功能

Complex data transformation and backfilling utilities
Multi-phase zero-downtime deployment strategies for production environments
0 GitHub stars
Automated rollback and transaction-based migration patterns
Cross-dialect compatibility logic for PostgreSQL and MySQL
Comprehensive support for Sequelize, TypeORM, and Prisma ORMs

使用场景

Implementing fail-safe data migration scripts with backup and checkpoint procedures
Renaming or modifying database columns in production without service interruption
Switching between different ORMs within a Node.js or TypeScript project

关于

主要功能

Complex data transformation and backfilling utilities
Multi-phase zero-downtime deployment strategies for production environments
0 GitHub stars
Automated rollback and transaction-based migration patterns
Cross-dialect compatibility logic for PostgreSQL and MySQL
Comprehensive support for Sequelize, TypeORM, and Prisma ORMs

使用场景

Implementing fail-safe data migration scripts with backup and checkpoint procedures
Renaming or modifying database columns in production without service interruption
Switching between different ORMs within a Node.js or TypeScript project