How does it ensure zero-downtime during migrations?

It utilizes multi-phase strategies such as adding backward-compatible columns, dual-writing data to old and new fields, and verified backfilling before deprecating legacy structures.

Does it handle errors during the migration process?

Yes, it emphasizes transaction-based migrations and checkpoint-based rollbacks to ensure that if a migration fails, the database can be safely restored to its previous state.

Can I use this for cross-database migrations?

Yes, it includes patterns for handling dialect-specific differences, such as managing JSON vs JSONB types when moving between MySQL and PostgreSQL.

Which ORMs does this skill support?

The skill provides comprehensive guidance, code snippets, and best practices for Sequelize, TypeORM, and Prisma.

Database Migration & Schema Management

Name: Database Migration & Schema Management
Author: duanbiao2000

byduanbiao2000

0•

データベース管理

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

This skill empowers developers to manage complex database evolutions with confidence, providing standardized patterns for Sequelize, TypeORM, and Prisma. It simplifies high-risk tasks like renaming columns or changing data types by implementing multi-step, zero-downtime strategies and transaction-based rollbacks. Whether you are migrating between ORMs, refactoring data models, or upgrading database versions, this skill ensures data integrity and continuous availability through proven deployment patterns and automated verification scripts.

主な機能

01Cross-database compatibility handling for PostgreSQL and MySQL

02Complex data transformation and backfilling logic

03Zero-downtime deployment strategies using Blue-Green patterns

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

05Transactional and checkpoint-based rollback procedures

060 GitHub stars

ユースケース

01Refactoring production database schemas without service interruption

02Executing safe, multi-step data transformations on large-scale datasets

03Migrating an application's data layer from one ORM to another

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add duanbiao2000/obsidiandoc26 database-migration

For use in Claude.ai and ChatGPT

Download Skill