Can it handle cross-database migrations?

Yes, it provides logic for handling dialect-specific differences, such as switching between PostgreSQL JSONB and MySQL JSON types during migrations.

Which ORMs does this skill support?

It provides patterns and best practices for major JavaScript/TypeScript ORMs including Sequelize, TypeORM, and Prisma, including specific CLI commands and syntax.

Can I use this for zero-downtime deployments?

Yes, it includes detailed multi-phase strategies like blue-green deployments and backward-compatible schema changes to ensure services remain online.

Does it help with data loss prevention?

Absolutely. It emphasizes transaction-based migrations, automated rollback procedures, and checkpoint-based backup strategies to ensure data integrity.

Database Migration & Schema Evolution

Name: Database Migration & Schema Evolution
Author: Activer007

byActiver007

数据库管理

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

关于

This skill empowers Claude to master the database lifecycle by providing implementation patterns for complex schema changes, data migrations, and rollback procedures. It supports popular ORMs including Sequelize, TypeORM, and Prisma, while focusing on high-availability techniques like blue-green deployments and transaction-based migrations. Whether you are refactoring data models, upgrading database versions, or migrating between different ORM platforms, this skill ensures data integrity and minimizes service interruptions through standardized best practices.

主要功能

Zero-downtime migration strategies and blue-green deployments
Complex data transformation and column refactoring patterns
Cross-database dialect handling for PostgreSQL and MySQL
Multi-ORM support for Prisma, TypeORM, and Sequelize
Transaction-safe rollback and recovery procedures
0 GitHub stars

使用场景

Implementing complex data transformations during schema updates
Executing zero-downtime deployments for high-traffic applications
Migrating a production database between different ORMs without data loss

关于

主要功能

Zero-downtime migration strategies and blue-green deployments
Complex data transformation and column refactoring patterns
Cross-database dialect handling for PostgreSQL and MySQL
Multi-ORM support for Prisma, TypeORM, and Sequelize
Transaction-safe rollback and recovery procedures
0 GitHub stars

使用场景

Implementing complex data transformations during schema updates
Executing zero-downtime deployments for high-traffic applications
Migrating a production database between different ORMs without data loss