Does it provide code examples for data backfilling?

Absolutely. It includes optimized SQL and ORM patterns for updating large datasets in batches to ensure performance remains stable during data migrations.

What databases and tools does this skill support?

It provides best practices for PostgreSQL and MySQL, along with specific workflows for ORMs like Prisma, Drizzle, Django, TypeORM, and golang-migrate.

Can this skill help prevent production database locking?

Yes, it includes patterns for non-blocking operations, such as 'CREATE INDEX CONCURRENTLY' in PostgreSQL and batching large updates to avoid holding long-term table locks.

How does it help achieve zero-downtime migrations?

The skill provides the 'Expand-Contract' pattern, which guides you through adding new fields, syncing data, and only then removing old fields to ensure the application remains functional during the update.

Database Migrations Best Practices

Name: Database Migrations Best Practices
Author: saar120

bysaar120

0•

Database Management

Provides production-grade guidance and implementation patterns for safe, zero-downtime database migrations across major SQL engines and ORMs.

This skill empowers Claude with specialized knowledge for managing database schema changes and data migrations in production environments. It covers critical safety patterns like Expand-Contract, concurrent indexing for PostgreSQL, and safe data backfilling to prevent table locking on large datasets. With support for major tools like Prisma, Drizzle, Django, and golang-migrate, it ensures that database evolutions are reversible, tested, and performed without service interruptions.

Key Features

01ORM-specific migration workflows for Prisma, Drizzle, Django, and TypeORM

020 GitHub stars

03Batch-processing patterns for large-scale production data backfills

04Zero-downtime deployment strategies using the Expand-Contract pattern

05Comprehensive migration safety checklists and anti-pattern prevention

06Non-blocking index creation and safe column modification techniques

Use Cases

01Generating safe migration scripts for large-scale PostgreSQL or MySQL tables

02Setting up robust migration pipelines and workflows for new software projects

03Renaming or deleting columns in high-traffic production databases without downtime

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add saar120/skillgate-registry database-migrations

For use in Claude.ai and ChatGPT

Key Features

01ORM-specific migration workflows for Prisma, Drizzle, Django, and TypeORM

020 GitHub stars

03Batch-processing patterns for large-scale production data backfills

04Zero-downtime deployment strategies using the Expand-Contract pattern

05Comprehensive migration safety checklists and anti-pattern prevention

06Non-blocking index creation and safe column modification techniques

Use Cases

01Generating safe migration scripts for large-scale PostgreSQL or MySQL tables

02Setting up robust migration pipelines and workflows for new software projects

03Renaming or deleting columns in high-traffic production databases without downtime

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add saar120/skillgate-registry database-migrations

For use in Claude.ai and ChatGPT