database-migrations

Apply safe, reversible database migrations across PostgreSQL, MySQL, and popular ORMs.

1|Updated Mar 31, 2026
One-click install
npx skills add https://github.com/aayushsoam/clawbot-plus --skill database-migrations-aayushsoam
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/aayushsoam/clawbot-plus/tree/main/skills/database-migrations
Command: npx skills add https://github.com/aayushsoam/clawbot-plus --skill database-migrations-aayushsoam

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Managing database migrations safely across diverse stacks is complex, error-prone, and can cause production downtime without proper tooling. This guide consolidates best practices for schema changes, data migrations, and rollback strategies to ensure smooth deployments across PostgreSQL, MySQL, and popular ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate).

Core Features & Use Cases

  • Safe, reversible migrations with clear UP/DOWN semantics and zero-downtime patterns.
  • Expand-contract migration strategy guidance and data backfill patterns across ORMs.
  • Deployment-ready templates and checklists for production-grade migrations.

Quick Start

Run a safe migration plan in a staging environment before deploying to production.

Frequently Asked Questions about database-migrations

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

FAQPage Schema
How do I perform zero-downtime database migrations in production?

The expand-contract strategy enables zero-downtime migrations by separating schema changes into additive and destructive phases. This approach prevents production downtime by ensuring old and new application versions run concurrently during deployment.

Can I use Prisma or Drizzle for safe data backfill patterns?

Yes, Prisma, Drizzle, TypeORM, Django, and golang-migrate support safe data backfill patterns. The workflows provide end-to-end deployment templates that enforce migration safety checklists across these popular ORMs.

What is the expand-contract pattern for schema changes?

The expand-contract pattern splits schema changes into additive steps followed by destructive steps. This zero-downtime strategy allows you to deploy database migrations safely by keeping old and new application versions running concurrently.

How do I rollback a database migration across PostgreSQL and MySQL?

You rollback database migrations using clear UP/DOWN semantics applied across PostgreSQL and MySQL environments. Reversible migration workflows ensure you can safely undo schema changes and data updates during production deployment failures.

Does this approach support multi-ORM stacks in the same project?

Yes, the migration workflows are designed for production environments with multi-ORM stacks. It provides consolidated safety checklists and deployment templates that bridge Prisma, Drizzle, Django, TypeORM, and golang-migrate within the same infrastructure.

What are the limitations of zero-downtime database migrations?

Zero-downtime migrations require running a safe migration plan in a staging environment before production deployment. Complex schema changes may necessitate multi-phase expand-contract workflows, making large data backfills time-consuming and dependent on careful execution.