Does it support different database engines?

Yes, it handles dialect-specific differences, such as the nuances between JSONB in PostgreSQL and JSON in MySQL.

Which ORMs are supported by this migration skill?

The skill provides specialized patterns and scripts for Prisma, TypeORM, and Sequelize.

How does this skill ensure zero-downtime deployments?

It utilizes multi-phase strategies that keep the database backward-compatible with older application versions while new columns are added and data is backfilled.

What happens if a migration fails?

The skill emphasizes transaction-based migrations and checkpoint-based rollbacks to revert changes and restore data integrity automatically.

Can I perform data transformations during migration?

Yes, it includes scripts for complex data migrations, such as splitting a single address string into multiple street, city, and state columns.

Database Migration

Name: Database Migration
Author: HermeticOrmus

byHermeticOrmus

Database Management

Executes database schema and data migrations across multiple ORMs with zero-downtime strategies and rollback procedures.

About

This skill provides a comprehensive framework for managing database evolutions using popular ORMs like Sequelize, TypeORM, and Prisma. It guides developers through complex tasks such as schema transformations, data backfilling, and cross-database migrations while prioritizing system availability. By implementing multi-step deployment patterns and transaction-based rollback strategies, it ensures that database updates are safe, reversible, and compatible with high-traffic production environments.

Key Features

Cross-database dialect handling for PostgreSQL and MySQL
Zero-downtime deployment strategies including blue-green patterns
Complex data transformation and column refactoring logic
Multi-ORM support for Sequelize, TypeORM, and Prisma
0 GitHub stars
Transaction-based and checkpoint-based rollback procedures

Use Cases

Performing breaking schema changes on live databases without maintenance windows
Refactoring data models and migrating legacy data to new structures
Migrating an existing application from one ORM to another

About

Key Features

Cross-database dialect handling for PostgreSQL and MySQL
Zero-downtime deployment strategies including blue-green patterns
Complex data transformation and column refactoring logic
Multi-ORM support for Sequelize, TypeORM, and Prisma
0 GitHub stars
Transaction-based and checkpoint-based rollback procedures

Use Cases

Performing breaking schema changes on live databases without maintenance windows
Refactoring data models and migrating legacy data to new structures
Migrating an existing application from one ORM to another