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

Database Management

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

About

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

Cross-database migration logic for PostgreSQL, MySQL, and more
Zero-downtime deployment strategies and blue-green patterns
Safe schema transformation and column renaming procedures
Multi-ORM support including Prisma, TypeORM, and Sequelize
Transaction-based rollback and checkpoint recovery scripts
0 GitHub stars

Use Cases

Executing complex schema changes in high-traffic production environments without downtime
Implementing automated rollback procedures for failed database deployments
Migrating 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

GitHub