Which ORMs does this database migration skill support?

The skill provides specific implementation patterns and best practices for popular JavaScript/TypeScript ORMs including Sequelize, TypeORM, and Prisma.

What safety measures are implemented for risky migrations?

The skill emphasizes transaction-based migrations to ensure atomicity, checkpoint-based rollbacks with temporary backup tables, and idempotent script design.

How does the skill handle zero-downtime migrations?

It utilizes a multi-phase approach: creating backward-compatible changes, deploying dual-writing code, backfilling data, and finally removing legacy structures.

Can I use this for migrating between different database engines?

Yes, the skill includes strategies for handling dialect differences, such as converting between PostgreSQL JSONB and MySQL JSON types during migration.

Database Migration & ORM Tools

Name: Database Migration & ORM Tools
Author: HermeticOrmus

byHermeticOrmus

0•

Database Management

Executes and manages database schema migrations, data transformations, and rollback procedures across multiple ORMs and platforms.

This skill provides Claude with specialized expertise in managing complex database lifecycles and schema evolution. It enables seamless transitions between popular ORMs like Sequelize, TypeORM, and Prisma while implementing sophisticated zero-downtime deployment strategies. Whether you are refactoring data models, upgrading database versions, or performing multi-step schema transformations using blue-green deployment patterns, this skill ensures data integrity and system availability through robust rollback procedures, transaction-based scripts, and idempotent migration logic.

Key Features

01Multi-ORM support for Sequelize, TypeORM, and Prisma migration workflows

02Automated rollback procedures and transaction-based safety mechanisms

03Cross-database compatibility handling for dialects like PostgreSQL and MySQL

04Zero-downtime migration strategies including multi-phase blue-green deployments

050 GitHub stars

06Complex data transformation and backfilling utilities for high-volume tables

Use Cases

01Implementing complex schema refactoring with automated backups and verification

02Migrating an existing application's data layer from Sequelize to Prisma

03Renaming production database columns without service interruption or data loss

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/alqvimia-contador database-migration

For use in Claude.ai and ChatGPT

Download Skill