database-migrations

Standardizes and safely executes database migrations across PostgreSQL, MySQL, and common ORMs.

1|Updated Mar 24, 2026

Search Tags:#database #postgresql #migrations #orm #mysql #zero-downtime #backfill

Ready to run

npx skills add https://github.com/UnlimitedxIQ/consulting-pro-skills-pack --skill database-migrations-unlimitedxiq

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/UnlimitedxIQ/consulting-pro-skills-pack/tree/main/skills/database-migrations
Command: npx skills add https://github.com/UnlimitedxIQ/consulting-pro-skills-pack --skill database-migrations-unlimitedxiq

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Efficiently and safely manage schema changes, data migrations, and rollbacks across PostgreSQL, MySQL, and common ORMs to minimize production risk.

Core Features & Use Cases

Safe, reversible migrations with separate schema and data changes
Zero-downtime strategies (expand-contract pattern) for live apps
Prisma, Drizzle, Django, TypeORM, and golang-migrate workflows and examples

Quick Start

Run an initial migration plan to apply a schema change to a new project and backfill data as needed.

Frequently Asked Questions about database-migrations

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I run zero-downtime database migrations in production?▼

Zero-downtime database migrations apply the expand-contract pattern to update schemas without taking the application offline. This approach safely separates schema and data changes, ensuring live applications remain fully operational during production deployments.

Does this approach work with Prisma and Drizzle ORM workflows?▼

Yes, it standardizes migrations for Prisma, Drizzle, Django, TypeORM, and golang-migrate. It provides compatible workflows and examples to safely execute schema changes and data backfills across these popular ORM environments.

What is the best way to backfill data during a PostgreSQL schema migration?▼

The best way to backfill data during a PostgreSQL migration is to clearly separate data migrations from schema changes. This ensures data is safely populated using reversible paths while minimizing production risk.

How do I create reversible database migrations with UP and DOWN paths?▼

Reversible database migrations are created by defining explicit UP and DOWN paths for both schema and data changes. This standardized rollback capability allows safe recovery from production schema updates and data backfills.

How do I manage multi-team database migrations across MySQL and PostgreSQL?▼

Managing multi-team database migrations across MySQL and PostgreSQL requires standardizing schema changes and data backfills. This ensures safe, reversible execution and zero-downtime deployments across different database systems and ORM tooling.