How does this skill help with zero-downtime deployments?

It provides multi-phase migration patterns, such as the Expand-Contract strategy, which ensures the database remains backward compatible with the application code during the deployment process.

Which ORMs does this database migration skill support?

It includes specific patterns and best practices for Sequelize, TypeORM, and Prisma, as well as general SQL migration strategies.

Is it useful for moving data between different database engines?

Yes, it includes guidance on handling dialect-specific differences, such as transitioning between PostgreSQL JSONB and MySQL JSON types.

Can this skill assist with rolling back a failed migration?

Yes, it provides strategies for transaction-based migrations and checkpoint-based recovery to ensure you can revert changes safely without losing data.

Does this skill help with complex data refactoring?

Absolutely, it covers complex transformations like splitting address strings into structured columns, changing data types for large tables, and renaming columns safely.

Database Migration & Schema Management

Name: Database Migration & Schema Management
Author: HermeticOrmus

byHermeticOrmus

データベース管理

Execute database migrations across multiple ORMs and platforms using zero-downtime strategies and robust rollback procedures.

概要

This skill provides specialized guidance for executing complex database migrations across popular ORMs like Sequelize, TypeORM, and Prisma. It empowers developers to perform schema transformations, data refactoring, and database version upgrades while maintaining high availability through zero-downtime deployment strategies. With built-in patterns for transaction-based rollbacks, cross-dialect compatibility, and multi-phase data backfilling, it ensures data integrity and system stability during critical infrastructure updates.

主な機能

Multi-ORM support including Sequelize, TypeORM, and Prisma
Automated rollback procedures and checkpoint-based recovery
0 GitHub stars
Zero-downtime migration strategies like Blue-Green and Expand-Contract
Cross-database dialect handling for PostgreSQL, MySQL, and more
Complex data transformation and programmatic backfilling scripts

ユースケース

Performing schema refactoring on high-traffic production databases
Migrating between different ORMs or upgrading database versions
Implementing safe data transformations with verification checkpoints

概要

主な機能

Multi-ORM support including Sequelize, TypeORM, and Prisma
Automated rollback procedures and checkpoint-based recovery
0 GitHub stars
Zero-downtime migration strategies like Blue-Green and Expand-Contract
Cross-database dialect handling for PostgreSQL, MySQL, and more
Complex data transformation and programmatic backfilling scripts

ユースケース

Performing schema refactoring on high-traffic production databases
Migrating between different ORMs or upgrading database versions
Implementing safe data transformations with verification checkpoints