database-migrations

Generate safe migration plans for PostgreSQL schema changes.

1|Updated Apr 11, 2026

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

Ready to run

npx skills add https://github.com/its-Basudeba/Care-HMS --skill database-migrations-its-basudeba

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/its-Basudeba/Care-HMS/tree/main/.agent/skills/database-migrations
Command: npx skills add https://github.com/its-Basudeba/Care-HMS --skill database-migrations-its-basudeba

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill eliminates the risk of production database outages and data corruption caused by manual schema changes or poorly planned migrations.

Core Features & Use Cases

Zero-Downtime Patterns: Implements expand-contract strategies for renaming columns or changing data types without locking tables.
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 execution to ensure production stability.

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 run zero-downtime database migrations in PostgreSQL without locking tables?▼

Zero-downtime database migrations use expand-contract patterns and concurrent index creation to evolve PostgreSQL schemas without locking tables. Enforcing strict separation of DDL and DML changes prevents production outages during deployment.

What is the expand-contract pattern for renaming database columns safely?▼

The expand-contract pattern for renaming database columns involves adding the new column, migrating data, and dropping the old column later. This reversible migration strategy avoids locking tables and ensures zero-downtime schema evolution.

Does this migration workflow support Prisma, Drizzle, Kysely, Django, and golang-migrate?▼

Yes, this migration workflow supports Prisma, Drizzle, Kysely, Django, and golang-migrate. Standardized tooling workflows provide safe schema evolution across these diverse ORM and migration tool ecosystems.

What's the best way to add a new column to a users table in PostgreSQL safely?▼

The best way to add a new column to a PostgreSQL users table safely is generating a reversible migration plan with strict DDL and DML separation. Safety guardrails enforce concurrent index creation to prevent production data corruption.

Why do I need to separate schema and data changes during database migrations?▼

You need to separate schema and data changes during database migrations to prevent table locks and production outages. Enforcing strict DDL and DML execution separation ensures production stability during complex zero-downtime deployments.