Which ORMs does this database migration skill support?

It provides specialized guidance and code patterns for Prisma, TypeORM, and Sequelize, including specific CLI commands and migration file structures for each.

Can it help with rolling back failed migrations?

Yes, the skill emphasizes 'up' and 'down' migration symmetry and provides patterns for transaction-based migrations and checkpoint-based rollbacks to ensure database consistency.

How does this skill help achieve zero-downtime deployments?

It implements multi-phase strategies such as backward-compatible schema changes, dual-writing, and data backfilling, allowing the application to remain functional while the database evolves.

Does it handle differences between SQL dialects?

Yes, it includes logic for cross-database migrations, such as handling PostgreSQL-specific JSONB types versus MySQL's JSON implementation during schema creation.

Database Migration Assistant

Name: Database Migration Assistant
Author: Activer007

byActiver007

0•

데이터베이스 관리

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

This skill equips Claude with specialized expertise in database schema evolution and data migration patterns for modern applications. It provides detailed implementation guides for popular ORMs like Prisma, TypeORM, and Sequelize, focusing on high-availability strategies such as blue-green deployments and multi-step transformations. By incorporating transaction-based rollbacks and idempotency best practices, it helps developers perform complex database refactoring, version upgrades, and cross-dialect migrations with minimal risk and maximum data integrity.

주요 기능

01Cross-database dialect handling for PostgreSQL, MySQL, and more

02Transaction-based rollback and recovery strategies

03Multi-step data transformation and backfilling workflows

040 GitHub stars

05Comprehensive support for Prisma, TypeORM, and Sequelize migrations

06Zero-downtime schema transformation and column renaming patterns

사용 사례

01Automating safe database version upgrades and schema versioning

02Migrating an existing application between different ORMs or database engines

03Refactoring production data models without interrupting service availability

주요 기능

01Cross-database dialect handling for PostgreSQL, MySQL, and more

02Transaction-based rollback and recovery strategies

03Multi-step data transformation and backfilling workflows

040 GitHub stars

05Comprehensive support for Prisma, TypeORM, and Sequelize migrations

06Zero-downtime schema transformation and column renaming patterns

사용 사례

01Automating safe database version upgrades and schema versioning

02Migrating an existing application between different ORMs or database engines

03Refactoring production data models without interrupting service availability