Which ORMs are supported by this skill?

This skill provides comprehensive patterns, code snippets, and best practices for Sequelize, TypeORM, and Prisma.

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

Yes, it includes specific strategies for handling differences between database systems, such as converting JSONB types in PostgreSQL to JSON types in MySQL.

What happens if a migration fails during execution?

The skill emphasizes safety through transaction-based migrations and checkpoint-based rollbacks, ensuring that your database can be restored to its previous state if an error occurs.

How does this skill handle zero-downtime migrations?

It utilizes a multi-phase approach including backward-compatible schema changes, dual-writing data, backfilling, and final cleanup to ensure the application remains online throughout the process.

Database Migration & Schema Evolution

Name: Database Migration & Schema Evolution
Author: GaitanS

byGaitanS

0•

Database Management

Executes complex database migrations and schema transformations across multiple ORMs using zero-downtime strategies and robust rollback procedures.

This skill equips Claude with the expertise to manage intricate database schema changes and data transformations while minimizing service disruption. It provides standardized implementation patterns for popular ORMs like Sequelize, TypeORM, and Prisma, ensuring best practices such as transactional updates, blue-green deployment strategies, and cross-database compatibility. Whether you are refactoring legacy data models, upgrading database versions, or migrating between different platforms, this skill offers the specific guidance and idempotent scripts needed for safe, professional-grade database operations.

Key Features

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

02Zero-downtime deployment strategies for production environments

03Complex data transformation and column refactoring scripts

040 GitHub stars

05Atomic, transaction-based migration and rollback patterns

06Cross-database compatibility logic (e.g., PostgreSQL to MySQL)

Use Cases

01Refactoring existing database schemas without interrupting live services

02Implementing automated rollback procedures for failed deployment attempts

03Migrating application data between different ORMs or database engines

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add gaitans/ai-mancare database-migration

For use in Claude.ai and ChatGPT

Download Skill