Which ORMs does this skill support?

This skill provides specialized guidance and code generation for Sequelize, TypeORM, and Prisma, including syntax-specific migration files and CLI commands.

How does it handle production safety during migrations?

It emphasizes zero-downtime strategies such as multi-phase deployments, transaction-based migrations, and creating temporary backups to ensure service availability and data safety.

Can it help with migrating between different database engines?

Yes, it includes patterns for handling dialect differences, such as managing specific types like JSONB in PostgreSQL versus JSON in MySQL.

Does it support data transformations as well as schema changes?

Absolutely. The skill includes scripts for complex data manipulation, such as splitting concatenated address strings into structured street, city, and state columns.

Are rollback procedures included in the generated migrations?

Yes, following best practices, every migration pattern provided includes a corresponding rollback (down) method or strategy to ensure you can safely revert changes.

Database Migration & Schema Evolution

Name: Database Migration & Schema Evolution
Author: Krosebrook

byKrosebrook

•

데이터베이스 관리

Manages complex database migrations across multiple ORMs with zero-downtime strategies and automated rollback procedures.

This skill empowers Claude to master database schema and data migrations across popular ORMs like Sequelize, TypeORM, and Prisma. It provides structured patterns for complex schema transformations, data model refactoring, and cross-database migrations (e.g., PostgreSQL to MySQL). Designed for high-availability environments, it specializes in zero-downtime deployment strategies like blue-green deployments and ensures reliability through robust transaction-based rollback procedures and checkpoint-based backups.

주요 기능

01Multi-ORM support for Sequelize, TypeORM, and Prisma migrations

02Zero-downtime schema transformation patterns and blue-green strategies

03Transactional and checkpoint-based rollback procedures

04Cross-database dialect handling for PostgreSQL and MySQL compatibility

05Complex data transformation and backfilling script generation

061 GitHub stars

사용 사례

01Refactoring monolithic data columns into structured fields without service interruption

02Switching an application from one ORM to another while maintaining data integrity

03Implementing blue-green deployment strategies for schema changes in high-traffic environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add krosebrook/source-of-truth-monorepo database-migration

For use in Claude.ai and ChatGPT

Download Skill