Which ORMs are compatible with this skill?

The skill provides specialized guidance and implementation patterns for Sequelize, TypeORM, and Prisma.

Can I use this for zero-downtime production deployments?

Absolutely. It includes a multi-phase blue-green strategy for making backward-compatible changes, allowing you to update your database without stopping your application.

How does it handle differences between PostgreSQL and MySQL?

It includes cross-database logic to handle dialect-specific differences, such as correctly using JSON vs. JSONB types depending on the connected database.

Is it safe for migrating large tables with millions of rows?

Yes, the skill recommends multi-step approaches for column changes on large tables to prevent lock-related performance issues and ensure reliability.

Does this skill support database rollback procedures?

Yes, it includes detailed patterns for both transaction-based and checkpoint-based rollback strategies to ensure data safety during failed migrations.

Database Migration & Schema Management

Name: Database Migration & Schema Management
Author: HermeticOrmus

byHermeticOrmus

0•

Database Management

Automates and guides complex database migrations across multiple ORMs with a focus on zero-downtime and data integrity.

This skill provides a comprehensive framework for managing database schema and data migrations using popular ORMs like Sequelize, TypeORM, and Prisma. It empowers developers to implement complex data transformations, perform cross-database migrations, and execute zero-downtime deployment strategies with built-in rollback procedures. By providing standardized patterns and best practices, it ensures data consistency and minimizes risk during structural database changes in production environments.

Key Features

010 GitHub stars

02Safe schema transformations for large-scale production tables

03Zero-downtime deployment strategies using multi-phase transitions

04Cross-database dialect handling for PostgreSQL and MySQL compatibility

05Transaction-based and checkpoint-based rollback procedures

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

Use Cases

01Adding columns or renaming fields in production without application downtime

02Refactoring legacy database structures through complex multi-step data transformations

03Transitioning an existing project from one ORM to another (e.g., Sequelize to Prisma)

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/floreserlife database-migration

For use in Claude.ai and ChatGPT

Download Skill