Does this skill support multi-step migrations for zero downtime?

Yes, it provides patterns for phased migrations—such as adding columns, backfilling data, and removing old columns—to ensure continuous availability.

How does it handle migration failures?

It emphasizes safety through transaction-based migrations and checkpoint-based rollback strategies to quickly restore data integrity if an error occurs.

Which ORMs are supported by this skill?

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

Is it suitable for large-scale data transformations?

Absolutely, it provides patterns for batching data updates and refactoring complex models while considering performance and table locking.

Can it assist with migrating between different database engines?

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

Database Migration & Schema Evolution

Name: Database Migration & Schema Evolution
Author: amurata

byamurata

•

Database Management

Manages complex database migrations, schema transformations, and zero-downtime deployment strategies across multiple ORMs.

This skill empowers developers to handle evolving database structures with confidence by providing specialized guidance for executing migrations within popular ORMs like Sequelize, TypeORM, and Prisma. It focuses on maintaining data integrity through multi-phase deployment patterns, transaction-based rollback procedures, and cross-database dialect handling. Whether you are refactoring legacy data models, upgrading database versions, or performing complex data transformations, this skill provides the implementation patterns needed to minimize service interruption and prevent data loss.

Key Features

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

02Zero-downtime deployment strategies including blue-green patterns

03Automated schema transformations and complex data refactoring logic

04Robust rollback procedures using transactions and checkpoints

05Cross-database dialect handling for PostgreSQL to MySQL transitions

063 GitHub stars

Use Cases

01Migrating a production application between different ORMs without data loss

02Implementing safe, idempotent data transformations for version upgrades

03Executing breaking schema changes on high-traffic databases using phased deployments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add amurata/cc-tools database-migration

For use in Claude.ai and ChatGPT

Download Skill