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

数据库管理

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.

主要功能

Cross-database dialect handling for PostgreSQL, MySQL, and more
Transaction-based rollback and recovery strategies
Multi-step data transformation and backfilling workflows
0 GitHub stars
Comprehensive support for Prisma, TypeORM, and Sequelize migrations
Zero-downtime schema transformation and column renaming patterns

使用场景

Automating safe database version upgrades and schema versioning
Migrating an existing application between different ORMs or database engines
Refactoring production data models without interrupting service availability

关于

主要功能

Cross-database dialect handling for PostgreSQL, MySQL, and more
Transaction-based rollback and recovery strategies
Multi-step data transformation and backfilling workflows
0 GitHub stars
Comprehensive support for Prisma, TypeORM, and Sequelize migrations
Zero-downtime schema transformation and column renaming patterns

使用场景

Automating safe database version upgrades and schema versioning
Migrating an existing application between different ORMs or database engines
Refactoring production data models without interrupting service availability