Does this skill support rollback procedures?

Yes, it provides specific strategies for transaction-based migrations and checkpoint-based rollbacks to ensure data safety and recoverability.

Which ORMs are supported by this skill?

The skill includes specialized implementation guidance for Sequelize, TypeORM, and Prisma.

Can I use this for zero-downtime deployments?

Absolutely. It includes patterns for multi-phase migrations, such as blue-green strategies, that allow applications to remain online during column updates.

Does it handle differences between PostgreSQL and MySQL?

Yes, it includes logic for handling dialect-specific features, such as the differences between JSONB in PostgreSQL and JSON in MySQL.

What are the best practices included in this skill?

It emphasizes essential practices like always providing a rollback (down method), using transactions, backing up data, and breaking changes into small steps.

Database Migration & Schema Evolution

Name: Database Migration & Schema Evolution
Author: HermeticOrmus

byHermeticOrmus

データベース管理

Automates complex database schema changes and data migrations across multiple ORMs with a focus on zero-downtime strategies.

概要

This skill equips Claude with specialized expertise for managing database migrations across popular Node.js ORMs including Sequelize, TypeORM, and Prisma. It provides comprehensive patterns for executing schema transformations, complex data backfilling, and multi-step zero-downtime deployments. By focusing on safety and reliability, the skill helps developers implement robust rollback procedures, transaction-based updates, and cross-database compatibility logic, ensuring that structural database changes never compromise application uptime or data integrity.

主な機能

Cross-database dialect handling for PostgreSQL and MySQL
0 GitHub stars
Complex data transformation and column renaming patterns
Multi-phase zero-downtime deployment strategies
Support for Sequelize, TypeORM, and Prisma ORM migrations
Transaction-based and checkpoint-based rollback procedures

ユースケース

Migrating an existing application from one ORM to another without data loss
Performing breaking schema changes on high-traffic production databases
Refactoring legacy data models through safe, incremental migration steps

概要

主な機能

Cross-database dialect handling for PostgreSQL and MySQL
0 GitHub stars
Complex data transformation and column renaming patterns
Multi-phase zero-downtime deployment strategies
Support for Sequelize, TypeORM, and Prisma ORM migrations
Transaction-based and checkpoint-based rollback procedures

ユースケース

Migrating an existing application from one ORM to another without data loss
Performing breaking schema changes on high-traffic production databases
Refactoring legacy data models through safe, incremental migration steps