skills.rest
Long-NguyenHai
Long-NguyenHaiCOMMUNITY
Explore all skills by this author →
GitHub

database-migrations

Plan and execute database schema changes and data migrations.

Updated Jul 4, 2026
Search Tags:#rollback#database migration#schema change#data migration#zero-downtime deployment
One-click install
npx skills add https://github.com/Long-NguyenHai/warehouse-ai --skill database-migrations-long-nguyenhai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/Long-NguyenHai/warehouse-ai/tree/main/.agents/skills/database-migrations
Command: npx skills add https://github.com/Long-NguyenHai/warehouse-ai --skill database-migrations-long-nguyenhai

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 provides guidance on implementing database migration best practices, ensuring safe and efficient schema changes, data migrations, rollbacks, and zero-downtime deployments across various databases and ORMs.

Core Features & Use Cases

  • Schema Changes: Safe and reversible database schema changes for production systems.
  • Data Migrations: Running data migrations (backfill, transform).
  • Zero-Downtime Deployments: Planning and executing zero-downtime schema changes.
  • ORM Support: Integration with Prisma, Drizzle, Kysely, Django, TypeORM, and golang-migrate.
  • Use Case: When setting up migration tooling for a new project or when planning a complex schema change in an existing database.

Quick Start

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

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 for schema changes in production?▼

Zero-downtime database migrations require planning reversible schema changes and executing backfill data migrations without locking tables. This approach ensures production systems remain available during deployments by integrating compatible ORM migration tools.

What is the best way to handle data migrations and schema rollbacks safely?▼

Safe data migrations and schema rollbacks involve running reversible database schema changes alongside data backfills. Using established ORM migration tools ensures that failed deployments can be rolled back without losing transformed data.

Does this database migration guidance work with Prisma, Django, and golang-migrate?▼

Yes, the database migration guidance supports integration with Prisma, Drizzle, Kysely, Django, TypeORM, and golang-migrate. It provides best practices for schema changes and zero-downtime deployments across these specific ORMs.

How do I add a new column to a PostgreSQL table without causing downtime?▼

Adding a new column to a PostgreSQL table without downtime requires a zero-downtime deployment strategy. You must apply non-breaking schema changes first, backfill the data asynchronously, and then update the application to use the new column.

When do I need to use specialized database migration tooling for my project?▼

You need specialized database migration tooling when setting up a new project or planning complex schema changes in an existing database. It ensures safe data transformations, rollback procedures, and zero-downtime deployments across PostgreSQL and MySQL.

Related Skills

Explore More Software Engineering Skills→
TeiNamTeiNam
12

database-migrations

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

Community
Advanced
blocknaviblocknavi
1

convex-migrations

Automate incremental Convex schema migrations with migration tracking and batched processing.

Official
Advanced
sunholo-datasunholo-data
33

AILANG Release Manager

Automates end-to-end AILANG release management including pre-release checks, version bumps, changelog updates, git tagging, CI/CD verification, and release broadcasting.

Official
Intermediate
Rune-kitRune-kit
82

db

Generate and validate database schema migrations for ORMs and raw SQL.

Official
Advanced