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

0•

データベース管理

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.

主な機能

01Complex data transformation and backfilling utilities

02Multi-phase zero-downtime deployment strategies for production environments

030 GitHub stars

04Automated rollback and transaction-based migration patterns

05Cross-dialect compatibility logic for PostgreSQL and MySQL

06Comprehensive support for Sequelize, TypeORM, and Prisma ORMs

ユースケース

01Implementing fail-safe data migration scripts with backup and checkpoint procedures

02Renaming or modifying database columns in production without service interruption

03Switching between different ORMs within a Node.js or TypeScript project

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/hermetic-line database-migration

For use in Claude.ai and ChatGPT

Download Skill