Can I migrate data between different database engines?

Yes, it includes logic for handling dialect-specific differences, such as migrating JSON types between PostgreSQL and MySQL.

How does it handle migration failures?

The skill emphasizes safety through transaction-based rollbacks and checkpoint-based recovery, ensuring your database can return to a stable state if a migration fails.

Does it support zero-downtime deployments?

Yes, it includes blue-green deployment strategies and multi-phase migration patterns (Add, Copy, Remove) to ensure your application stays online during schema changes.

What ORMs are compatible with this skill?

This skill provides specific implementation patterns for Prisma, Sequelize, and TypeORM, but the underlying strategies can be adapted for most modern ORMs.

Database Migration & ORM Tools

Name: Database Migration & ORM Tools
Author: HermeticOrmus

byHermeticOrmus

Database Management

Executes seamless database migrations across major ORMs with zero-downtime strategies and robust rollback procedures.

About

This skill empowers Claude to manage complex database schema and data migrations across popular Node.js ORMs like Sequelize, TypeORM, and Prisma. It provides standardized patterns for implementing blue-green deployments, renaming columns without downtime, and performing complex data transformations while ensuring data integrity through transaction-based rollbacks and checkpoint strategies. It is particularly useful for developers refactoring legacy data models or migrating between different database technologies without interrupting service availability.

Key Features

Atomic rollback procedures using transaction-based migrations
Complex data backfilling and transformation scripting utilities
Zero-downtime schema transformation and blue-green deployment patterns
0 GitHub stars
Cross-database migration logic for PostgreSQL, MySQL, and more
Multi-ORM support for Sequelize, TypeORM, and Prisma

Use Cases

Implementing non-breaking column renames in high-traffic environments
Refactoring legacy address strings into structured relational data tables
Migrating an active production application from Sequelize to Prisma ORM

About

Key Features

Atomic rollback procedures using transaction-based migrations
Complex data backfilling and transformation scripting utilities
Zero-downtime schema transformation and blue-green deployment patterns
0 GitHub stars
Cross-database migration logic for PostgreSQL, MySQL, and more
Multi-ORM support for Sequelize, TypeORM, and Prisma

Use Cases

Implementing non-breaking column renames in high-traffic environments
Refactoring legacy address strings into structured relational data tables
Migrating an active production application from Sequelize to Prisma ORM