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

0•

数据库管理

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

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.

主要功能

01Cross-database dialect handling for PostgreSQL and MySQL

02Zero-downtime deployment strategies including blue-green patterns

03Complex data transformation and column refactoring logic

04Multi-ORM support for Sequelize, TypeORM, and Prisma

050 GitHub stars

06Transaction-based and checkpoint-based rollback procedures

使用场景

01Performing breaking schema changes on live databases without maintenance windows

02Refactoring data models and migrating legacy data to new structures

03Migrating an existing application from one ORM to another

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/after-the-third-cup database-migration

For use in Claude.ai and ChatGPT

Download Skill