How does this skill help prevent production downtime?

It advocates for the 'Expand-Contract' pattern and provides specific SQL commands, like CREATE INDEX CONCURRENTLY, that avoid table locks during schema updates.

Does it provide rollback strategies?

Absolutely. It emphasizes that every migration should be reversible and provides patterns for forward-only rollbacks and 'down' migration scripts.

Which databases and ORMs are supported by this skill?

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

Can it assist with data backfilling?

Yes, it includes templates for batch-processing data updates in SQL and Python/Django to ensure large-scale migrations don't exhaust system resources.

Database Migrations & Schema Patterns

Name: Database Migrations & Schema Patterns
Author: oabdelmaksoud

byoabdelmaksoud

0•

Gestión de Bases de Datos

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

This skill provides Claude with specialized expertise for managing database evolution in production environments, focusing on safety, reversibility, and performance. It covers best practices for PostgreSQL and MySQL while offering specific implementation patterns for popular tools like Prisma, Drizzle, Django, and golang-migrate. By emphasizing the separation of DDL and DML and utilizing the expand-contract pattern, it helps developers avoid common pitfalls such as locking large tables or breaking application compatibility during deployments. It is an essential companion for backend developers planning complex schema refactors or high-scale data backfills.

Características Principales

01Safe PostgreSQL patterns for concurrent indexing and non-blocking column changes

02Batch data migration scripts for processing millions of rows without locking

030 GitHub stars

04ORM-specific workflows for Prisma, Drizzle, Django, and TypeORM

05Zero-downtime migration strategies using the Expand-Contract pattern

06Comprehensive safety checklists for pre-deployment migration audits

Casos de Uso

01Transitioning from manual SQL updates to structured ORM-based migration workflows

02Refactoring legacy database schemas in high-traffic production environments

03Adding constraints and indexes to large tables without causing service interruptions

Características Principales

01Safe PostgreSQL patterns for concurrent indexing and non-blocking column changes

02Batch data migration scripts for processing millions of rows without locking

030 GitHub stars

04ORM-specific workflows for Prisma, Drizzle, Django, and TypeORM

05Zero-downtime migration strategies using the Expand-Contract pattern

06Comprehensive safety checklists for pre-deployment migration audits

Casos de Uso

01Transitioning from manual SQL updates to structured ORM-based migration workflows

02Refactoring legacy database schemas in high-traffic production environments

03Adding constraints and indexes to large tables without causing service interruptions