How does the skill help achieve zero-downtime migrations?

It uses a multi-phase approach involving backward-compatible schema changes, data backfilling, and incremental code deployments to ensure the application remains online during updates.

Which ORMs does this database migration skill support?

It provides specialized patterns and scripts for popular JavaScript/TypeScript ORMs including Sequelize, TypeORM, and Prisma.

Can I use this to migrate between different database types?

The skill includes strategies for cross-database migrations, specifically handling dialect differences between systems like PostgreSQL and MySQL.

Does it handle data loss prevention during migrations?

Yes, the skill emphasizes safety through transaction-based migrations, mandatory rollback (down) procedures, and checkpoint-based backups to ensure data integrity.

Database Migration Expert

Name: Database Migration Expert
Author: HermeticOrmus

byHermeticOrmus

数据库管理

Execute and manage database migrations across multiple ORMs with zero-downtime strategies and robust rollback procedures.

关于

The Database Migration skill empowers Claude to architect and execute complex schema changes and data transformations using popular ORMs like Sequelize, TypeORM, and Prisma. It provides structured guidance on implementing zero-downtime deployments through multi-phase blue-green strategies, performing safe data refactoring, and establishing reliable rollback procedures using transactions or checkpoints. Whether you are switching between ORMs, upgrading database versions, or migrating data between different dialects like PostgreSQL and MySQL, this skill ensures high availability and data integrity throughout the lifecycle of your database evolution.

主要功能

Cross-database dialect handling for PostgreSQL and MySQL
Cross-ORM support for Sequelize, TypeORM, and Prisma
0 GitHub stars
Complex data transformation and column refactoring patterns
Zero-downtime deployment strategies (Blue-Green patterns)
Transaction-based and checkpoint rollback procedures

使用场景

Establishing automated database version upgrade paths for CI/CD pipelines
Migrating production databases between ORMs without service interruption
Implementing safe schema transformations like column renaming or type changes

关于

主要功能

Cross-database dialect handling for PostgreSQL and MySQL
Cross-ORM support for Sequelize, TypeORM, and Prisma
0 GitHub stars
Complex data transformation and column refactoring patterns
Zero-downtime deployment strategies (Blue-Green patterns)
Transaction-based and checkpoint rollback procedures

使用场景

Establishing automated database version upgrade paths for CI/CD pipelines
Migrating production databases between ORMs without service interruption
Implementing safe schema transformations like column renaming or type changes