Does it support rollback procedures?

Absolutely. The skill enforces a core principle that migrations must be reversible, providing checklists for both 'UP' and 'DOWN' migration scripts.

How does it ensure zero downtime during migrations?

It utilizes the 'expand-contract' pattern, which involves adding new columns as nullable, backfilling data, and only dropping old columns after application code has been fully updated.

What databases does this skill support?

It primarily supports PostgreSQL and MySQL, providing specific implementation patterns for popular tools like Prisma, Drizzle, Django, and golang-migrate.

Can it help with large-scale data updates?

Yes, it includes advanced patterns for batch data migrations that avoid full table locks by processing updates in small, committed chunks with progress tracking.

Why shouldn't I add a NOT NULL column directly to a large table?

Adding a NOT NULL constraint without a default on an existing table requires a full table rewrite and lock. This skill teaches safe alternatives like adding nullable columns first.

Database Migrations

Name: Database Migrations
Author: unju-ai

byunju-ai

0•

Gestión de Bases de Datos

Implements safe, zero-downtime database schema changes and data migrations across multiple SQL engines and ORMs.

This skill equips Claude with specialized knowledge for managing database evolutions without risking production uptime. It provides standardized patterns for PostgreSQL and MySQL, alongside implementation guides for popular ORMs like Prisma, Drizzle, and Django. By following the 'expand-contract' strategy and strictly separating schema from data changes, it ensures that every migration is reversible, tested, and optimized for high-volume production environments.

Características Principales

01Safe PostgreSQL patterns for non-blocking index and column modifications

02Batch data migration scripts designed for production-scale tables

03ORM-specific workflows for Prisma, Drizzle, Django, and golang-migrate

04Zero-downtime deployment strategies using the Expand-Contract pattern

050 GitHub stars

06Comprehensive migration safety checklists to prevent table locking

Casos de Uso

01Planning complex schema changes for high-traffic production databases

02Refactoring existing data models while maintaining 100% service availability

03Setting up robust migration tooling and workflows for new backend projects

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add unju-ai/ecc database-migrations

For use in Claude.ai and ChatGPT