Which ORMs does this skill support?

The skill provides patterns and guidance for Sequelize, TypeORM, and Prisma, as well as raw SQL migration strategies for general use.

What safety measures are included for production migrations?

It emphasizes transaction-based migrations, checkpoint-based rollbacks, and small incremental steps to minimize risk and ensure data can be restored if an error occurs.

Can I use this for migrations between different database types?

Yes, the skill includes patterns for cross-database migrations, such as handling dialect-specific types between PostgreSQL and MySQL.

How does it handle zero-downtime migrations?

It utilizes multi-phase strategies including backward-compatible schema changes, asynchronous data backfilling, and phased code deployments to ensure the application remains online.

Does it support complex data transformations?

Yes, it provides scripts and patterns for transforming existing data during a migration, such as splitting address strings into structured columns.

Database Migration Mastery

Name: Database Migration Mastery
Author: pur3v4d3r

bypur3v4d3r

•

データベース管理

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

This skill provides a comprehensive framework for managing database evolutions within Claude Code, offering standardized patterns for Sequelize, TypeORM, and Prisma. It covers critical scenarios such as schema transformations, complex data migrations, and cross-database transitions (e.g., PostgreSQL to MySQL). By implementing blue-green deployment strategies and transaction-based rollbacks, it ensures that your application remains highly available and data-consistent during architectural shifts or infrastructure upgrades.

主な機能

011 GitHub stars

02Cross-database dialect handling for seamless infrastructure moves

03Zero-downtime deployment and blue-green migration strategies

04Safe schema transformations including column renaming and type changes

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

06Transaction-based and checkpoint-based rollback procedures

ユースケース

01Implementing complex data transformations and backfilling procedures

02Refactoring production database schemas without service interruption

03Switching application ORMs while maintaining data integrity

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add pur3v4d3r/pur3-pkb-codebase database-migration

For use in Claude.ai and ChatGPT

Download Skill