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.

About

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

Multi-ORM support for Sequelize, TypeORM, and Prisma migrations
Zero-downtime deployment strategies including blue-green patterns
Automated schema transformations and complex data refactoring logic
Robust rollback procedures using transactions and checkpoints
Cross-database dialect handling for PostgreSQL to MySQL transitions
3 GitHub stars

Use Cases

Migrating a production application between different ORMs without data loss
Implementing safe, idempotent data transformations for version upgrades
Executing breaking schema changes on high-traffic databases using phased deployments

About

Key Features

Multi-ORM support for Sequelize, TypeORM, and Prisma migrations
Zero-downtime deployment strategies including blue-green patterns
Automated schema transformations and complex data refactoring logic
Robust rollback procedures using transactions and checkpoints
Cross-database dialect handling for PostgreSQL to MySQL transitions
3 GitHub stars

Use Cases

Migrating a production application between different ORMs without data loss
Implementing safe, idempotent data transformations for version upgrades
Executing breaking schema changes on high-traffic databases using phased deployments