Can I use this for migrating between different database engines?

Yes, the skill includes specific patterns for handling dialect differences, such as adjusting JSON types when moving between PostgreSQL and MySQL.

Which ORMs are supported by this Claude Code skill?

This skill includes comprehensive implementation patterns and CLI commands for Sequelize, TypeORM, and Prisma, as well as general SQL strategies.

Does it include automated rollback procedures?

Absolutely. The skill emphasizes best practices like transaction-based migrations and checkpoint-based rollbacks to ensure you can always revert to a stable state if a migration fails.

How does this skill help with zero-downtime deployments?

It provides a multi-phased approach (Blue-Green strategy) to ensure schema changes are backward-compatible, allowing your application to remain online while the data layer evolves.

Database Migration & Schema Management

Name: Database Migration & Schema Management
Author: Microck

byMicrock

•

数据库管理

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

This skill empowers developers to manage complex database evolutions with confidence, covering everything from simple schema changes to high-stakes zero-downtime deployments. It provides specialized implementation patterns for popular ORMs like Sequelize, TypeORM, and Prisma, ensuring data integrity through transaction-based rollbacks and checkpoint strategies. Whether you're refactoring data models, upgrading database versions, or migrating between different database engines like PostgreSQL and MySQL, this skill offers the blueprints for safe, idempotent, and well-documented migrations.

主要功能

01Robust rollback procedures using transactions and checkpoints

02Complex data transformation and backfilling patterns

03Cross-database dialect handling for PostgreSQL and MySQL

04Zero-downtime deployment strategies like Blue-Green migrations

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

0681 GitHub stars

使用场景

01Implementing safe, reversible schema updates within automated CI/CD pipelines

02Migrating production databases between different ORM frameworks or platforms

03Refactoring existing data models while maintaining 100% application uptime

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microck/ordinary-claude-skills database-migration

For use in Claude.ai and ChatGPT

Download Skill