How does it handle large table updates?

It provides optimized patterns for batched updates to prevent long-running transactions and table locks on tables with millions of rows.

Is it compatible with Django migrations?

Yes, it covers Django-specific workflows including the use of SeparateDatabaseAndState and safe data migration best practices.

Can it help with zero-downtime deployments?

Absolutely, it provides detailed guidance on the expand-contract pattern to ensure database changes don't interrupt application availability.

Does this skill support PostgreSQL specific features?

Yes, it includes specific patterns for PostgreSQL such as CONCURRENTLY index creation and instant column additions for version 11+.

Database Migration Patterns

Name: Database Migration Patterns
Author: saar120

bysaar120

0•

Database Management

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

This skill equips Claude with specialized knowledge for managing complex database lifecycles in production environments. It provides standardized patterns for schema modifications, data backfills, and index creation without causing downtime. Covering popular tools like Prisma, Drizzle, Django, and golang-migrate, it helps developers avoid common pitfalls like table locking, missing rollbacks, and manual production edits by enforcing rigorous safety checklists and the expand-contract migration pattern for high-availability systems.

Key Features

01Zero-downtime 'expand-contract' migration strategies

02Tool-specific workflows for Prisma, Drizzle, Django, and golang-migrate

03Safe index creation patterns like CREATE INDEX CONCURRENTLY

04Large-scale data backfill patterns with batching and progress tracking

050 GitHub stars

06Separation of schema (DDL) and data (DML) migrations

Use Cases

01Altering high-traffic production tables without causing application timeouts

02Automating migration scripts for PostgreSQL, MySQL, and major ORMs

03Refactoring database schemas using the expand-contract pattern

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

01Zero-downtime 'expand-contract' migration strategies

02Tool-specific workflows for Prisma, Drizzle, Django, and golang-migrate

03Safe index creation patterns like CREATE INDEX CONCURRENTLY

04Large-scale data backfill patterns with batching and progress tracking

050 GitHub stars

06Separation of schema (DDL) and data (DML) migrations

Use Cases

01Altering high-traffic production tables without causing application timeouts

02Automating migration scripts for PostgreSQL, MySQL, and major ORMs

03Refactoring database schemas using the expand-contract pattern

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