Does this skill support rollback procedures?

Yes, it provides specific strategies for transaction-based migrations and checkpoint-based rollbacks to ensure data safety and recoverability.

Which ORMs are supported by this skill?

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

Can I use this for zero-downtime deployments?

Absolutely. It includes patterns for multi-phase migrations, such as blue-green strategies, that allow applications to remain online during column updates.

Does it handle differences between PostgreSQL and MySQL?

Yes, it includes logic for handling dialect-specific features, such as the differences between JSONB in PostgreSQL and JSON in MySQL.

What are the best practices included in this skill?

It emphasizes essential practices like always providing a rollback (down method), using transactions, backing up data, and breaking changes into small steps.

Database Migration & Schema Evolution

Name: Database Migration & Schema Evolution
Author: HermeticOrmus

byHermeticOrmus

0•

Database Management

Automates complex database schema changes and data migrations across multiple ORMs with a focus on zero-downtime strategies.

This skill equips Claude with specialized expertise for managing database migrations across popular Node.js ORMs including Sequelize, TypeORM, and Prisma. It provides comprehensive patterns for executing schema transformations, complex data backfilling, and multi-step zero-downtime deployments. By focusing on safety and reliability, the skill helps developers implement robust rollback procedures, transaction-based updates, and cross-database compatibility logic, ensuring that structural database changes never compromise application uptime or data integrity.

Key Features

01Cross-database dialect handling for PostgreSQL and MySQL

020 GitHub stars

03Complex data transformation and column renaming patterns

04Multi-phase zero-downtime deployment strategies

05Support for Sequelize, TypeORM, and Prisma ORM migrations

06Transaction-based and checkpoint-based rollback procedures

Use Cases

01Migrating an existing application from one ORM to another without data loss

02Performing breaking schema changes on high-traffic production databases

03Refactoring legacy data models through safe, incremental migration steps

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/hermetic-academy database-migration

For use in Claude.ai and ChatGPT

Download Skill