Can I use this skill to migrate between different database types?

Yes, it includes specialized guidance for cross-database migrations, such as handling dialect differences between PostgreSQL (JSONB) and MySQL (JSON).

How does this skill handle zero-downtime migrations?

It utilizes multi-phase strategies such as adding backward-compatible columns, dual-writing data, and eventually removing old columns to ensure the application stays online throughout the process.

Does it include safety features like rollbacks?

Absolutely. The skill emphasizes transaction-based migrations and checkpoint-based rollback procedures to ensure you can safely revert changes if a migration fails during execution.

Which ORMs are supported by the Database Migration skill?

The skill provides specific patterns and best practices for popular ORMs including Sequelize, TypeORM, and Prisma, as well as raw SQL migration strategies.

Database Migration Specialist

Name: Database Migration Specialist
Author: nguyendinhquocx

bynguyendinhquocx

0•

Database Management

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

The Database Migration skill empowers Claude to architect and execute sophisticated database lifecycle tasks, ranging from simple schema updates to complex multi-step data transformations. It provides specialized knowledge for popular ORMs like Sequelize, TypeORM, and Prisma, ensuring migrations are safe, transactional, and reversible. Whether you are performing a blue-green deployment to maintain 100% uptime or refactoring legacy data models into a new structure, this skill provides the patterns and rollback strategies necessary to maintain data integrity and minimize service interruptions.

Key Features

01Cross-database migration logic for PostgreSQL, MySQL, and more

02Zero-downtime deployment strategies and blue-green patterns

03Safe schema transformation and column renaming procedures

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

05Transaction-based rollback and checkpoint recovery scripts

060 GitHub stars

Use Cases

01Executing complex schema changes in high-traffic production environments without downtime

02Implementing automated rollback procedures for failed database deployments

03Migrating an existing application between different ORMs while preserving data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nguyendinhquocx/code-ai database-migration

For use in Claude.ai and ChatGPT

Download Skill