database-migrations

Guide database migrations across PostgreSQL, MySQL, and common ORMs.

Updated Apr 6, 2026

Search Tags:#rollback #database migration #schema change #data migration #zero-downtime deployment

Ready to run

npx skills add https://github.com/thangvawn/agent_financial --skill database-migrations-thangvawn

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/thangvawn/agent_financial/tree/main/.cursor/skills/database-migrations
Command: npx skills add https://github.com/thangvawn/agent_financial --skill database-migrations-thangvawn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the challenges of performing database migrations, including schema changes, data migrations, rollbacks, and zero-downtime deployments across various databases and ORMs.

Core Features & Use Cases

Schema Changes: Safely alter database tables, add or remove columns and indexes.
Data Migrations: Run data migrations for backfilling, transforming, and updating data.
Rollbacks: Plan and execute rollbacks for safe and reversible changes.
Zero-Downtime Deployments: Implement strategies for maintaining database availability during schema changes.
ORM Support: Guidance for Prisma, Drizzle, Kysely, Django, TypeORM, and golang-migrate.

Quick Start

Run the migration script to update the database schema.

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?▼

Zero-downtime database migrations maintain availability during schema changes by using strategies like expanding and contracting tables. This approach ensures database operations continue smoothly while altering tables, adding columns, or updating data without locking out users.

What is the best way to rollback a schema change in PostgreSQL?▼

Rolling back a schema change in PostgreSQL requires planning and executing reversible migration steps. Best practices include writing explicit down migrations and testing data backfills to ensure safe and reversible database operations.

Does this database migration guidance work with Prisma and Drizzle?▼

Yes, the database migration guidance supports common ORMs including Prisma, Drizzle, Kysely, TypeORM, Django, and golang-migrate. It provides specific best practices for schema changes, data migrations, and rollbacks across these frameworks.

How do I run data migrations for backfilling and transforming data?▼

Running data migrations for backfilling involves executing scripts designed to safely transform and update existing records. This process ensures data integrity while modifying database schema and migrating large volumes of data without downtime.

When do I need to use specific rollback strategies for database migrations?▼

Specific rollback strategies for database migrations are needed when performing complex schema changes or data transformations that risk data loss. Planning reversible changes ensures you can safely revert alterations if zero-downtime deployments fail or errors occur.