Which ORMs are supported by this skill?

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

Does it support data transformation?

Absolutely. It provides patterns for complex data migrations, including splitting single columns into multiple fields or reformatting data types safely.

Can I use this for cross-database migrations?

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

How does this skill handle zero-downtime migrations?

It implements multi-phase strategies including making backward-compatible schema changes, backfilling data, and updating application logic before removing old structures.

Does it include safety measures for failed migrations?

Yes, it emphasizes transaction-based migrations and provides checkpoint-based rollback strategies to ensure database consistency in case of errors.

Database Migration & Schema Evolution

Name: Database Migration & Schema Evolution
Author: HermeticOrmus

byHermeticOrmus

データベース管理

Automates database schema migrations, data transformations, and zero-downtime deployment strategies across multiple ORMs.

概要

This skill empowers developers to manage complex database transitions with confidence by providing standardized patterns for popular ORMs like Prisma, Sequelize, and TypeORM. It covers everything from basic schema additions to sophisticated zero-downtime 'blue-green' migrations and cross-database transitions, ensuring data integrity through robust rollback procedures and transaction-based execution scripts designed for high-availability production environments.

主な機能

Cross-ORM support for Prisma, TypeORM, and Sequelize
Multi-dialect support for PostgreSQL and MySQL environments
Complex data transformation and field refactoring scripts
Zero-downtime deployment and blue-green migration patterns
Automated rollback and transaction-based safety procedures
0 GitHub stars

ユースケース

Migrating an existing application between different ORM frameworks
Refactoring complex data models while maintaining legacy data integrity
Performing schema updates on high-traffic databases without service interruption