Which ORMs does this database migration skill support?

The skill provides specific implementation patterns and best practices for popular JavaScript/TypeScript ORMs including Sequelize, TypeORM, and Prisma.

What safety measures are implemented for risky migrations?

The skill emphasizes transaction-based migrations to ensure atomicity, checkpoint-based rollbacks with temporary backup tables, and idempotent script design.

How does the skill handle zero-downtime migrations?

It utilizes a multi-phase approach: creating backward-compatible changes, deploying dual-writing code, backfilling data, and finally removing legacy structures.

Can I use this for migrating between different database engines?

Yes, the skill includes strategies for handling dialect differences, such as converting between PostgreSQL JSONB and MySQL JSON types during migration.

Database Migration & ORM Tools

Name: Database Migration & ORM Tools
Author: HermeticOrmus

byHermeticOrmus

データベース管理

Executes and manages database schema migrations, data transformations, and rollback procedures across multiple ORMs and platforms.

概要

This skill provides Claude with specialized expertise in managing complex database lifecycles and schema evolution. It enables seamless transitions between popular ORMs like Sequelize, TypeORM, and Prisma while implementing sophisticated zero-downtime deployment strategies. Whether you are refactoring data models, upgrading database versions, or performing multi-step schema transformations using blue-green deployment patterns, this skill ensures data integrity and system availability through robust rollback procedures, transaction-based scripts, and idempotent migration logic.

主な機能

Multi-ORM support for Sequelize, TypeORM, and Prisma migration workflows
Automated rollback procedures and transaction-based safety mechanisms
Cross-database compatibility handling for dialects like PostgreSQL and MySQL
Zero-downtime migration strategies including multi-phase blue-green deployments
0 GitHub stars
Complex data transformation and backfilling utilities for high-volume tables

ユースケース

Implementing complex schema refactoring with automated backups and verification
Migrating an existing application's data layer from Sequelize to Prisma
Renaming production database columns without service interruption or data loss

概要

主な機能

Multi-ORM support for Sequelize, TypeORM, and Prisma migration workflows
Automated rollback procedures and transaction-based safety mechanisms
Cross-database compatibility handling for dialects like PostgreSQL and MySQL
Zero-downtime migration strategies including multi-phase blue-green deployments
0 GitHub stars
Complex data transformation and backfilling utilities for high-volume tables

ユースケース

Implementing complex schema refactoring with automated backups and verification
Migrating an existing application's data layer from Sequelize to Prisma
Renaming production database columns without service interruption or data loss