database-migrations

Name: database-migrations
Availability: InStock
Author: 529-studio

Generate safe migration plans for Prisma schema changes.

2|1|Updated Mar 25, 2026

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

Ready to run

npx skills add https://github.com/529-studio/Vmarble-Warehouse-Management-Client --skill database-migrations-529-studio

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/529-studio/Vmarble-Warehouse-Management-Client/tree/main/.agents/skills/database-migrations
Command: npx skills add https://github.com/529-studio/Vmarble-Warehouse-Management-Client --skill database-migrations-529-studio

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill addresses the high-risk challenge of modifying production database schemas without causing downtime, data loss, or table locks.

Core Features & Use Cases

Zero-Downtime Patterns: Implements expand-contract strategies for column renames and removals.
Tooling Support: Provides standardized workflows for Prisma, Drizzle, Kysely, Django, and golang-migrate.
Safety Guardrails: Enforces best practices like concurrent index creation and separate DDL/DML operations.

Quick Start

Use the database-migrations skill to generate a safe migration plan for adding a new column to the users table using Prisma.

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 use expand-contract strategies to decouple schema changes from data migrations, preventing table locks. This approach enforces concurrent index creation and reversible steps to ensure production reliability.

Does this database migration workflow support Prisma and Drizzle?▼

Yes, the database migration workflow supports Prisma, Drizzle, Kysely, Django, and golang-migrate. It provides standardized migration workflows and safety guardrails tailored to these specific ORM and migration tools.

What is the best way to rename a column without locking the database?▼

The best way to rename a column without locking the database is using an expand-contract strategy. This zero-downtime pattern safely manages column renames and removals by decoupling schema changes from data migrations over multiple deployment phases.

How do I add a new column to a production database safely?▼

To add a new column to a production database safely, generate a reversible migration plan that separates DDL and DML operations. This enforces concurrent index creation and prevents data loss during schema evolution.

Why should schema changes be decoupled from data migrations?▼

Schema changes should be decoupled from data migrations to enforce safe, reversible migration patterns and avoid table locks. Separating DDL and DML operations ensures zero-downtime deployment and production reliability during database evolution.