skills.rest
LiamVDB1
LiamVDB1COMMUNITY
Explore all skills by this author →
GitHub

database-migrations

Manage database schema changes and data migrations across SQL databases and ORMs.

Updated Feb 13, 2026
Search Tags:#database#postgresql#migrations#data migration#prisma#schema changes#zero downtime
One-click install
npx skills add https://github.com/LiamVDB1/opencode-config --skill database-migrations-liamvdb1
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/LiamVDB1/opencode-config/tree/main/skills/database-migrations
Command: npx skills add https://github.com/LiamVDB1/opencode-config --skill database-migrations-liamvdb1

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a comprehensive guide and best practices for managing database schema changes and data migrations safely and efficiently, preventing data loss and minimizing downtime.

Core Features & Use Cases

  • Safe Schema Evolution: Learn patterns for adding/removing columns, renaming, and indexing without locking production databases.
  • Data Migration Strategies: Implement robust techniques for backfilling and transforming data in batches.
  • Zero-Downtime Deployments: Understand the expand-contract pattern for critical production updates.
  • Tooling Integration: Examples for Prisma, Drizzle, Django, TypeORM, and golang-migrate.

Quick Start

Use the database-migrations skill to learn how to safely add a new column to a PostgreSQL table.

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

Zero-downtime database schema changes use the expand-contract pattern to add, alter, or remove columns without locking tables. This approach minimizes production risks and ensures continuous data integrity during deployments.

What is the best way to safely backfill data during a migration?▼

Safe data backfilling involves transforming and populating data in small batches rather than single large transactions. This technique prevents long-running locks and maintains database performance during schema evolution.

Does this database migration approach work with Prisma and Django?▼

These database migration patterns and best practices integrate directly with ORMs and tools like Prisma, Django, Drizzle, TypeORM, and golang-migrate. They provide tool-specific examples for safe schema evolution across various SQL databases.

How to add a column to a PostgreSQL table without locking the database?▼

Adding a column without locking requires safe schema evolution patterns like creating concurrent indexes and avoiding default values on new columns. This ensures the database remains responsive during production updates.

When do I need the expand-contract pattern for data migrations?▼

The expand-contract pattern is needed for critical zero-downtime deployments where breaking schema changes must be deployed gradually. It separates changes into backward-compatible stages to prevent application errors and data loss.

Related Skills

Explore More Software Engineering Skills→
R2W1csR2W1cs
1

prisma-expert

Optimize Prisma ORM schemas, migrations, queries, connections, and transactions.

Community
Advanced
yunseo-kimyunseo-kim
1

gitlab-ci-patterns

Generate GitLab CI/CD pipeline patterns for build, test, and deploy stages.

Community
Intermediate
Software-Design-ClubSoftware-Design-Club
1

Backend Migrations

Automates reversible database migrations with up/down scripts and zero-downtime deployments.

Official
Basic
doanchienthangdevdoanchienthangdev
4

managing-database-migrations

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

Community
Advanced