Which ORMs are supported by this skill?

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

How does it handle zero-downtime migrations?

It implements multi-phase strategies such as adding backward-compatible columns, dual-writing data, and backfilling data before safely removing old structures.

Can I use this for moving between different databases like PostgreSQL and MySQL?

Yes, the skill includes logic for handling dialect-specific types (like JSON vs JSONB) and provides patterns for cross-database migration compatibility.

What happens if a migration fails mid-way?

The skill emphasizes transaction-based migrations and checkpoint-based rollbacks to ensure your database can be automatically restored to its previous stable state.

Database Migrations & Schema Evolution

Name: Database Migrations & Schema Evolution
Author: gwickman

bygwickman

0•

Database Management

Manages database schema changes and data transformations across multiple ORMs with robust rollback and zero-downtime strategies.

This skill empowers Claude to architect and execute complex database migrations using popular ORMs like Sequelize, TypeORM, and Prisma. It provides standardized patterns for schema evolution, including adding or renaming columns without service interruption, performing multi-step data transformations, and implementing fail-safe rollback procedures. Whether you are upgrading database versions, refactoring data models, or switching between SQL dialects, this skill ensures data integrity and high availability throughout the migration lifecycle.

Key Features

01Cross-database dialect handling for PostgreSQL, MySQL, and SQLite

020 GitHub stars

03Zero-downtime deployment strategies including multi-phase column renaming

04Multi-ORM support for Sequelize, TypeORM, and Prisma migration patterns

05Transactional migration patterns and checkpoint-based rollback procedures

06Complex data transformation and backfilling script templates

Use Cases

01Refactoring a production database schema without taking the application offline

02Implementing automated, transactional database versioning in CI/CD pipelines

03Migrating an existing project between different ORMs or database engines

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add gwickman/auto-dev-test-target-1 database-migration

For use in Claude.ai and ChatGPT

Download Skill