Which ORMs are supported by this skill?

The skill provides specific implementation patterns and best practices for Sequelize, TypeORM, and Prisma, as well as general SQL migration strategies.

Can I use this for cross-database migrations?

Yes, it includes logic for handling dialect differences, such as switching between PostgreSQL JSONB and MySQL JSON types during a migration.

How does this skill handle zero-downtime migrations?

It follows a multi-phase approach: adding backward-compatible columns, implementing dual-writes, backfilling data, and eventually removing old columns only after the code is updated.

Does it support automatic rollbacks?

The skill provides templates for transaction-based migrations and checkpoint-based rollbacks using backup tables to ensure you can recover from failures safely.

Database Migration Mastery

Name: Database Migration Mastery
Author: ccf

byccf

データベース管理

Executes complex database migrations and schema transformations across multiple ORMs with a focus on zero-downtime and data integrity.

概要

This skill provides Claude with the specialized knowledge to manage sophisticated database schema changes and data transformations. It covers popular ORMs like Sequelize, TypeORM, and Prisma, offering standardized patterns for zero-downtime deployments, blue-green migration strategies, and robust rollback procedures. Whether you are refactoring data models, switching database dialects, or performing high-stakes production migrations, this skill ensures best practices are followed to prevent data loss and minimize service interruptions.

主な機能

Zero-downtime deployment strategies (Expand-Contract/Blue-Green)
Cross-database dialect handling (PostgreSQL, MySQL, etc.)
Multi-ORM support including Sequelize, TypeORM, and Prisma
Complex data transformation and backfilling scripts
Automated rollback and transaction-based migration patterns
0 GitHub stars

ユースケース

Migrating a production application from one ORM to another without data loss
Implementing safe, idempotent migration scripts with built-in verification steps
Renaming columns or changing data types in high-traffic tables with zero downtime

概要

主な機能

Zero-downtime deployment strategies (Expand-Contract/Blue-Green)
Cross-database dialect handling (PostgreSQL, MySQL, etc.)
Multi-ORM support including Sequelize, TypeORM, and Prisma
Complex data transformation and backfilling scripts
Automated rollback and transaction-based migration patterns
0 GitHub stars

ユースケース

Migrating a production application from one ORM to another without data loss
Implementing safe, idempotent migration scripts with built-in verification steps
Renaming columns or changing data types in high-traffic tables with zero downtime