database-migrations

Name: database-migrations
Availability: InStock
Author: zescode

Generate safe migration plans for PostgreSQL schema changes.

Updated Jul 8, 2026

Search Tags:#deployment #database #postgresql #migrations #backend #schema

Ready to run

npx skills add https://github.com/ZESCODE/Zes-Orchestration-System --skill database-migrations-zescode

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/ZESCODE/Zes-Orchestration-System/tree/main/.agents/skills/database-migrations
Command: npx skills add https://github.com/ZESCODE/Zes-Orchestration-System --skill database-migrations-zescode

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill prevents production outages and data corruption caused by improper database schema changes, providing a standardized, safe workflow for evolving database structures.

Core Features & Use Cases

Zero-Downtime Patterns: Implements expand-contract strategies to ensure application availability during schema updates.
Multi-ORM Support: Provides specific workflows for Prisma, Drizzle, Kysely, Django, and golang-migrate.
Safety Guardrails: Includes checklists for concurrent index creation, safe column additions, and batch data migrations to avoid table locks.

Quick Start

Use the database-migrations skill to generate a safe migration plan for adding a new column to the users table in a 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 in PostgreSQL?▼

Zero-downtime database migrations in PostgreSQL require expand-contract strategies and non-blocking operations like concurrent index creation to ensure system availability. This approach enforces safe, reversible migration patterns to prevent table locks during schema updates.

What is the best way to add a new column without locking my database?▼

Adding a new column safely requires structured migration workflows with safety guardrails to avoid table locks. Using expand-contract patterns ensures data integrity and application availability during schema evolution without blocking operations.

Does this database migration workflow support Prisma and Drizzle?▼

Yes, the database migration workflow supports Prisma and Drizzle, alongside Kysely, Django, and golang-migrate. It provides specific migration workflows tailored to these ORMs to ensure safe and reversible schema management across diverse environments.

How do I run batch data migrations without causing production outages?▼

Batch data migrations prevent production outages by following structured migration workflows with safety guardrails. Enforcing non-blocking operations and expand-contract strategies ensures data integrity and system availability during large-scale database schema changes.

When should I use expand-contract patterns for schema changes?▼

Expand-contract patterns for schema changes are needed when application availability during schema updates is critical. They prevent data corruption and production outages by splitting migrations into reversible, non-blocking deployment phases.

Can I standardize database schema evolution across MySQL and PostgreSQL?▼

Yes, you can standardize database schema evolution across MySQL and PostgreSQL. A standardized migration workflow provides safe, reversible patterns and safety guardrails to ensure data integrity and system availability across diverse database environments.

Nick777-Pixel