How does this skill handle zero-downtime migrations?

It implements the expand-contract pattern, which involves adding new columns, updating application code to write to both, backfilling data, and finally removing the old column only after it is no longer in use.

What is the benefit of concurrent indexing?

Creating indexes concurrently allows PostgreSQL to build the index without taking a write lock on the table, ensuring the database remains available during the migration process.

Which database systems and ORMs are supported?

The skill provides patterns for PostgreSQL and MySQL, with specific implementation guides for Prisma, Drizzle, Django, TypeORM, and golang-migrate.

Why should I separate schema and data migrations?

Separating DDL (schema) and DML (data) operations prevents long-running transactions that can lock tables and makes rollbacks significantly safer and easier to manage.

Database Migration Patterns

Name: Database Migration Patterns
Author: LuciferDono

byLuciferDono

•

Database Management

Implements safe, reversible database schema changes and zero-downtime deployment patterns across major ORMs and SQL dialects.

This skill provides a comprehensive framework for managing database schema evolutions safely in production environments, helping developers avoid table locks and application downtime. It offers specialized patterns for PostgreSQL and MySQL while supporting popular ORMs including Prisma, Drizzle, and Django. By enforcing core principles like the expand-contract strategy and concurrent indexing, the skill ensures that migrations remain immutable, testable, and reversible even when dealing with production-sized datasets.

Key Features

01Safety-first PostgreSQL patterns including concurrent index creation and batch updates

021 GitHub stars

03Framework-specific workflows for Prisma, Drizzle, Django, and golang-migrate

04Guidelines for separating DDL schema changes from DML data migrations

05Structured checklists to prevent common migration anti-patterns and table locks

06Zero-downtime 'expand-contract' migration strategies for high-traffic systems

Use Cases

01Setting up robust migration tooling and workflows for a new backend project

02Renaming or removing columns in production databases without interrupting service

03Performing large-scale data backfills using batched transactions to prevent performance degradation

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add luciferdono/labs database-migrations

For use in Claude.ai and ChatGPT

Key Features

01Safety-first PostgreSQL patterns including concurrent index creation and batch updates

021 GitHub stars

03Framework-specific workflows for Prisma, Drizzle, Django, and golang-migrate

04Guidelines for separating DDL schema changes from DML data migrations

05Structured checklists to prevent common migration anti-patterns and table locks

06Zero-downtime 'expand-contract' migration strategies for high-traffic systems

Use Cases

01Setting up robust migration tooling and workflows for a new backend project

02Renaming or removing columns in production databases without interrupting service

03Performing large-scale data backfills using batched transactions to prevent performance degradation

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add luciferdono/labs database-migrations

For use in Claude.ai and ChatGPT