Which ORMs are supported by this skill?

The skill provides specialized patterns and best practices for Prisma, TypeORM, and Sequelize, as well as general SQL migration strategies.

Does it support data transformation?

Absolutely. It provides patterns for complex data migrations, including splitting single columns into multiple fields or reformatting data types safely.

Can I use this for cross-database migrations?

Yes, it includes guidance for handling dialect-specific differences, such as migrating between PostgreSQL and MySQL.

How does this skill handle zero-downtime migrations?

It implements multi-phase strategies including making backward-compatible schema changes, backfilling data, and updating application logic before removing old structures.

Does it include safety measures for failed migrations?

Yes, it emphasizes transaction-based migrations and provides checkpoint-based rollback strategies to ensure database consistency in case of errors.

Database Migration & Schema Evolution

Name: Database Migration & Schema Evolution
Author: HermeticOrmus

byHermeticOrmus

0•

Database Management

Automates database schema migrations, data transformations, and zero-downtime deployment strategies across multiple ORMs.

This skill empowers developers to manage complex database transitions with confidence by providing standardized patterns for popular ORMs like Prisma, Sequelize, and TypeORM. It covers everything from basic schema additions to sophisticated zero-downtime 'blue-green' migrations and cross-database transitions, ensuring data integrity through robust rollback procedures and transaction-based execution scripts designed for high-availability production environments.

Key Features

01Cross-ORM support for Prisma, TypeORM, and Sequelize

02Multi-dialect support for PostgreSQL and MySQL environments

03Complex data transformation and field refactoring scripts

04Zero-downtime deployment and blue-green migration patterns

05Automated rollback and transaction-based safety procedures

060 GitHub stars

Use Cases

01Migrating an existing application between different ORM frameworks

02Refactoring complex data models while maintaining legacy data integrity

03Performing schema updates on high-traffic databases without service interruption

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/hermetic-line database-migration

For use in Claude.ai and ChatGPT

Download Skill