database-migrations

Guide database schema changes and data migrations with rollback strategies.

Updated Mar 12, 2026

Search Tags:#SQL #database #migrations #ORM #zero-downtime #schema changes

Ready to run

npx skills add https://github.com/ryasrk/AgentBrokeTheMatrix-CopilotVersion --skill database-migrations-ryasrk

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides best practices and patterns for managing database schema changes and data migrations safely and efficiently, preventing downtime and data loss.

Core Features & Use Cases

Schema Evolution: Guides on adding, altering, or removing columns and indexes.
Data Migration: Strategies for backfilling or transforming data without locking tables.
Zero-Downtime Deployments: Patterns for deploying database changes with no user-facing interruption.
ORM Integration: Examples for Prisma, Drizzle, Django, and golang-migrate.

Quick Start

Use the database-migrations skill to learn how to safely add a new nullable column to a PostgreSQL table.

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 when altering schema?▼

Zero-downtime database migrations require breaking schema changes into backward-compatible steps. This Skill provides patterns for safe column alterations and deployments across SQL, Prisma, Drizzle, Django, and golang-migrate to prevent user-facing interruptions.

What is the best way to backfill large data without locking database tables?▼

Backfilling large data without table locks involves batch processing strategies. This Skill outlines data migration patterns for transforming data safely, avoiding prolonged locks, and ensuring production stability during large-scale schema changes.

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

Yes, this database migration guidance integrates with Django and Prisma. It also covers Drizzle and golang-migrate, providing ORM-specific examples and best practices for schema changes, rollbacks, and zero-downtime deployments.

How do I safely add a nullable column to a PostgreSQL table?▼

Safely adding a nullable column to PostgreSQL involves applying non-breaking schema changes first. This Skill guides you through the exact steps to add, alter, or remove columns without causing downtime or data loss.

What are common anti-patterns and safety checks for production database schema changes?▼

Common anti-patterns for production database schema changes include locking tables and breaking backward compatibility. This Skill provides a safety checklist to identify these issues and ensure safe rollbacks.

When do I need specific database migration patterns for ORM schema changes?▼

You need specific database migration patterns when altering schema or backfilling data in production. This Skill addresses when to apply these patterns to prevent data loss and manage safe rollbacks across multiple database systems.