skills.rest
doanchienthangdev
doanchienthangdevCOMMUNITY
Explore all skills by this author →
GitHub

managing-database-migrations

Implement zero-downtime database migrations with expand-contract patterns and rollback strategies.

4|1|Updated Dec 30, 2025
Search Tags:#rollback#database migration#schema change#prisma#typeorm#zero downtime
One-click install
npx skills add https://github.com/doanchienthangdev/omgkit --skill managing-database-migrations-doanchienthangdev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: managing-database-migrations
Source: https://github.com/doanchienthangdev/omgkit/tree/main/plugin/skills/databases/database-migration
Command: npx skills add https://github.com/doanchienthangdev/omgkit --skill managing-database-migrations-doanchienthangdev

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill ensures that database schema changes are applied safely and efficiently in production environments, minimizing downtime and risk.

Core Features & Use Cases

  • Zero-Downtime Deployments: Implements strategies like the expand-contract pattern for seamless schema updates.
  • Rollback Planning: Designs and includes rollback procedures for every migration.
  • Safe Schema Alterations: Handles complex operations like adding/removing columns, renaming, and type changes without data loss or service interruption.
  • Use Case: Deploying a new feature that requires adding a user_role column to the users table without taking the application offline.

Quick Start

Use the managing-database-migrations skill to deploy pending database migrations using Prisma.

Frequently Asked Questions about managing-database-migrations

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

FAQPage Schema
How do I do a zero downtime database migration in production?▼

Rollback strategies for database migrations are designed by planning safe reversal procedures for every schema change before deployment. This ensures that failed column alterations or type changes can be safely reverted without data loss.

Can I run Prisma migrations without taking my application offline?▼

TypeORM supports zero downtime migrations by combining schema synchronization with expand-contract deployment strategies. This integration handles complex schema alterations and automates version control during production deployments.

What is the expand-contract pattern for database schema changes?▼

The expand-contract pattern is a database migration strategy that separates schema changes into backward-compatible expand phases and subsequent contract phases. This mechanism allows safe column alterations and type changes without service interruption.

How do I plan a rollback for a failed database migration?▼

Rollback strategies for database migrations are designed by planning safe reversal procedures for every schema change before deployment. This ensures that failed column alterations or type changes can be safely reverted without data loss.

Does this approach work with TypeORM for automated schema deployments?▼

TypeORM supports zero downtime migrations by combining schema synchronization with expand-contract deployment strategies. This integration handles complex schema alterations and automates version control during production deployments.

Related Skills

Explore More Software Engineering Skills→
WesleySmitsWesleySmits
6

managing-database-schemas

Analyze database schemas and generate improvement recommendations for Prisma, TypeORM, or Drizzle.

Community
Advanced
BRANDNEWSHVTBRANDNEWSHVT

ci-cd-audit

Audit CI/CD pipelines for build automation, deployment safety, and environment parity.

Official
Advanced
thanh-abaiithanh-abaii
34

gs:land-and-deploy

Merge pull requests, run CI/CD pipelines, and verify production health.

Community
Advanced
amo-tech-aiamo-tech-ai

supabase

Manage Supabase database schema changes through SQL migrations.

Community
Intermediate