Which databases and ORMs are supported?

This skill provides best practices for PostgreSQL and MySQL, with specific implementation guides for Prisma, Drizzle, Django, TypeORM, and golang-migrate.

How does this skill help with zero-downtime deployments?

It implements the 'Expand-Contract' pattern, which involves adding new columns first, dual-writing data, and only dropping old columns once the application code is fully transitioned.

Can it prevent database locks on large tables?

Yes, it provides patterns such as creating indexes concurrently and batching DML updates to ensure that migrations don't block production traffic.

Does it handle data backfills?

Yes, it includes patterns for separate data migrations (DML) that are decoupled from schema changes (DDL) to ensure safer rollbacks and performance.

Database Migrations & Schema Best Practices

Name: Database Migrations & Schema Best Practices
Author: Infopibe

byInfopibe

•

Database Management

Guides developers through safe, reversible database schema changes and zero-downtime deployments using industry-standard patterns.

This skill equips Claude with the specialized knowledge required to manage database migrations in production environments without risk. It provides standardized patterns for schema modifications, data backfilling, and rollback strategies for major tools like Prisma, Drizzle, Django, and golang-migrate. By focusing on the 'Expand-Contract' pattern and avoiding common pitfalls like blocking table locks in PostgreSQL and MySQL, this skill ensures that database evolutions remain safe, predictable, and compatible with high-availability systems.

Key Features

01Optimized PostgreSQL and MySQL schema patterns for concurrent operations

02Safety checklists to prevent common production migration anti-patterns

03Zero-downtime deployment strategies using the expand-contract pattern

04Batch data migration scripts to handle millions of rows without locking

051 GitHub stars

06ORM-specific workflows for Prisma, Drizzle, Django, and golang-migrate

Use Cases

01Refactoring production database schemas without interrupting user service

02Setting up robust migration pipelines for new or existing backend projects

03Performing complex data transformations and backfills on large-scale datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add infopibe/everything-claude-code database-migrations

For use in Claude.ai and ChatGPT

Key Features

01Optimized PostgreSQL and MySQL schema patterns for concurrent operations

02Safety checklists to prevent common production migration anti-patterns

03Zero-downtime deployment strategies using the expand-contract pattern

04Batch data migration scripts to handle millions of rows without locking

051 GitHub stars

06ORM-specific workflows for Prisma, Drizzle, Django, and golang-migrate

Use Cases

01Refactoring production database schemas without interrupting user service

02Setting up robust migration pipelines for new or existing backend projects

03Performing complex data transformations and backfills on large-scale datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add infopibe/everything-claude-code database-migrations

For use in Claude.ai and ChatGPT