How does it handle migration rollbacks?

It enforces the principle that migrations should be reversible where possible, providing guidance on writing 'down' migrations and documenting rollback plans.

Does it work with TypeScript ORMs?

Absolutely, it contains specific workflows for Prisma and Drizzle, including how to handle operations like concurrent index creation that ORMs might not generate automatically.

Can it help with large-scale data backfills?

Yes, it includes patterns for batch-processing data updates to avoid long-running transactions and table locks on large production datasets.

Does this skill support zero-downtime deployments?

Yes, it specifically utilizes the expand-contract pattern to ensure applications remain online while the database schema is evolving.

Which databases are supported?

It provides specialized patterns for PostgreSQL and MySQL, though the core principles of safe migrations apply to most relational database systems.

Database Migrations

Name: Database Migrations
Author: flatrick

byflatrick

0•

Database Management

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

This skill equips Claude Code with industry-standard patterns for managing database evolutions without service disruption. It provides specific guidance for PostgreSQL and MySQL while supporting popular tools like Prisma, Drizzle, and Django. By enforcing principles like the expand-contract pattern and concurrent index creation, it ensures that schema changes are reversible, performant, and safe for high-traffic production environments, preventing common pitfalls like table locks and application downtime.

Key Features

01Safe schema and data migration patterns for PostgreSQL and MySQL

02Best practices for concurrent index creation and batch data backfills

03Migration safety checklists and automated rollback planning guidance

04Implementation of zero-downtime expand-contract deployment strategies

05Support for popular ORMs including Prisma, Drizzle, Django, and TypeORM

060 GitHub stars

Use Cases

01Performing large-scale data backfills using safe batch processing techniques

02Planning and executing schema changes on high-traffic production databases

03Generating migration scripts for specific ORMs like Prisma or Drizzle

Key Features

01Safe schema and data migration patterns for PostgreSQL and MySQL

02Best practices for concurrent index creation and batch data backfills

03Migration safety checklists and automated rollback planning guidance

04Implementation of zero-downtime expand-contract deployment strategies

05Support for popular ORMs including Prisma, Drizzle, Django, and TypeORM

060 GitHub stars

Use Cases

01Performing large-scale data backfills using safe batch processing techniques

02Planning and executing schema changes on high-traffic production databases

03Generating migration scripts for specific ORMs like Prisma or Drizzle