Can this skill help with zero-downtime deployments?

Yes, it includes multi-phase strategies such as blue-green migrations and backward-compatible schema changes to ensure continuous availability.

Can I use this for complex data refactoring?

Absolutely. It provides templates for complex data migrations, including column splitting, merging, and data type transformations.

Does it support migrating between different database types?

Yes, it includes guidance for cross-database migrations, such as handling dialect-specific differences between PostgreSQL and MySQL.

Which ORMs are supported by this migration skill?

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

How does it handle migration failures?

It emphasizes the use of database transactions and checkpoint-based rollback scripts to revert changes safely if an error occurs.

Database Migration & Schema Management

Name: Database Migration & Schema Management
Author: HermeticOrmus

byHermeticOrmus

•

데이터베이스 관리

Executes complex database schema evolutions and data migrations across multiple ORMs using zero-downtime strategies.

소개

The Database Migration skill empowers Claude to handle sophisticated database transitions with a focus on safety and uptime. It provides expert patterns for popular ORMs like Sequelize, TypeORM, and Prisma, guiding users through schema transformations, data refactoring, and cross-platform migrations. By implementing transaction-based logic and multi-phase deployment strategies, this skill ensures that database changes are reversible and compatible with high-availability environments, minimizing the risk of data loss or service interruption.

주요 기능

Transaction-based migration and automated rollback procedures
Zero-downtime schema transformation and column renaming patterns
Multi-ORM support for Sequelize, TypeORM, and Prisma
2 GitHub stars
Complex data transformation and backfilling scripts
Cross-database dialect handling for Postgres and MySQL

사용 사례

Performing safe data transformations during major version upgrades
Transitioning an existing project from one ORM to another
Refactoring production database schemas without service interruption

소개

주요 기능

Transaction-based migration and automated rollback procedures
Zero-downtime schema transformation and column renaming patterns
Multi-ORM support for Sequelize, TypeORM, and Prisma
2 GitHub stars
Complex data transformation and backfilling scripts
Cross-database dialect handling for Postgres and MySQL

사용 사례

Performing safe data transformations during major version upgrades
Transitioning an existing project from one ORM to another
Refactoring production database schemas without service interruption