database-migrations

Guide schema changes, data migrations, and rollbacks across PostgreSQL, MySQL, and ORMs.

12|4|Updated Mar 22, 2026

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

Ready to run

npx skills add https://github.com/TeiNam/kiro-with-harness --skill database-migrations-teinam

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/TeiNam/kiro-with-harness/tree/main/skills/database-migrations
Command: npx skills add https://github.com/TeiNam/kiro-with-harness --skill database-migrations-teinam

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses the complexities of database migrations, providing best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across various databases and ORMs.

Core Features & Use Cases

Schema Changes: Offers guidance on safe and reversible database schema changes.
Data Migrations: Assists with running data migrations like backfilling and transforming data.
Rollbacks: Provides strategies for effective rollback processes.
Zero-Downtime: Ensures minimal disruption during schema changes.
ORM Support: Includes best practices for ORMs such as Prisma, Drizzle, Django, TypeORM, and golang-migrate.

Quick Start

Use the database-migrations skill to safely add a new column to your users table in PostgreSQL.

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 require strategies that avoid locking tables during schema changes, ensuring minimal disruption during deployments. This Skill provides best practices for safe, reversible schema changes and data migrations across PostgreSQL and MySQL.

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

Rolling back schema changes in PostgreSQL requires effective rollback strategies built into your migration workflow. This Skill provides guidance on reversible database schema changes and safe rollback processes to prevent data loss.

How do I backfill data during a database migration?▼

Backfilling data during a database migration involves transforming and populating new columns without causing downtime. This Skill assists with running data migrations safely, including backfilling and transforming data across various ORMs.

Can I use this database migration guidance with Prisma or Django ORM?▼

Yes, this database migration guidance includes ORM-specific workflows and best practices for Prisma, Drizzle, Django, TypeORM, and golang-migrate. It ensures safe schema changes and rollbacks tailored to your ORM tooling.

Do I need prior database management knowledge to use these migration workflows?▼

Yes, implementing these database migration workflows requires existing knowledge of database management and ORM tooling. The guidance focuses on advanced zero-downtime operations and safe practices rather than introductory database concepts.

Why do database schema changes cause downtime and how can I avoid it?▼

Database schema changes cause downtime when operations lock tables or block concurrent queries. You can avoid it by following zero-downtime migration practices, splitting changes into reversible steps, and using ORM-specific workflows provided by this Skill.