Which ORMs are supported by this skill?

The skill provides patterns and best practices for popular Node.js ORMs including Sequelize, TypeORM, and Prisma.

Can I perform rollbacks if a migration fails?

Yes, the skill focuses on transaction-based migrations and backup checkpoint strategies to ensure you can safely revert changes without data loss.

How does it handle zero-downtime migrations?

It implements a multi-phase approach: making changes backward compatible, dual-writing data, backfilling historical records, and finally removing legacy structures once verified.

Does it support cross-database platform migrations?

Yes, it includes logic to handle dialect differences between systems like PostgreSQL and MySQL, such as managing JSON vs JSONB types.

Database Migration

Name: Database Migration
Author: Activer007

byActiver007

データベース管理

Executes and manages database schema migrations, data transformations, and zero-downtime deployment strategies across major ORMs.

概要

This skill empowers developers to handle complex database transitions with confidence, supporting popular ORMs like Sequelize, TypeORM, and Prisma. It provides comprehensive guidance for performing safe schema transformations, complex data backfilling, and multi-step zero-downtime deployments. Whether you are migrating between database platforms, upgrading versions, or refactoring existing data models, this skill ensures data integrity through robust rollback procedures and transaction-based migration patterns.

主な機能

Transaction-based rollback and checkpoint-driven recovery strategies
Zero-downtime migration strategies and Blue-Green deployment patterns
Multi-ORM support including Sequelize, TypeORM, and Prisma
Cross-database migration logic for PostgreSQL, MySQL, and more
Automated schema transformation and safe column renaming procedures
0 GitHub stars

ユースケース

Refactoring a production database schema without impacting live users
Migrating an existing application from one ORM to another
Performing complex data transformations during a database version upgrade

概要

主な機能

Transaction-based rollback and checkpoint-driven recovery strategies
Zero-downtime migration strategies and Blue-Green deployment patterns
Multi-ORM support including Sequelize, TypeORM, and Prisma
Cross-database migration logic for PostgreSQL, MySQL, and more
Automated schema transformation and safe column renaming procedures
0 GitHub stars

ユースケース

Refactoring a production database schema without impacting live users
Migrating an existing application from one ORM to another
Performing complex data transformations during a database version upgrade