Can it help with adding indexes to large tables?

Yes, it provides specific 'CREATE INDEX CONCURRENTLY' patterns for PostgreSQL to ensure that index creation does not block write operations on your production tables.

Why shouldn't I mix schema and data migrations?

Mixing DDL (schema) and DML (data) changes in a single migration makes rollbacks difficult and can lead to long-running transactions that exhaust database resources. This skill provides patterns to keep them separate and safe.

What databases and ORMs are supported?

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

How does this skill prevent production downtime?

It advocates for the 'Expand-Contract' pattern, which involves adding new fields as nullable first, migrating data in batches, and only then removing old fields, ensuring the application remains compatible throughout the transition.

Database Migrations & Schema Management

Name: Database Migrations & Schema Management
Author: oabdelmaksoud

byoabdelmaksoud

0•

数据库管理

Guides the implementation of safe, reversible database schema changes and zero-downtime deployments across major SQL databases and ORMs.

This skill provides a comprehensive framework for managing database evolutions across multiple languages and frameworks, including PostgreSQL, MySQL, Prisma, Drizzle, and Django. it enforces critical safety patterns like the expand-contract strategy, concurrent indexing, and the separation of DDL and DML operations to prevent production outages. By providing specific SQL snippets and framework commands, it helps developers avoid common pitfalls like table locks on large datasets, ensuring that every database change is traceable, testable, and reversible.

主要功能

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

020 GitHub stars

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

04Zero-downtime migration patterns using the Expand-Contract strategy

05Batch processing strategies for large-scale production data migrations

06Pre-deployment safety checklists to prevent accidental production table locks

使用场景

01Altering production database schemas without interrupting user traffic

02Setting up robust migration workflows for new Node.js, Python, or Go projects

03Performing complex data backfills on tables with millions of records

主要功能

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

020 GitHub stars

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

04Zero-downtime migration patterns using the Expand-Contract strategy

05Batch processing strategies for large-scale production data migrations

06Pre-deployment safety checklists to prevent accidental production table locks

使用场景

01Altering production database schemas without interrupting user traffic

02Setting up robust migration workflows for new Node.js, Python, or Go projects

03Performing complex data backfills on tables with millions of records