Is this skill compatible with Prisma workflows?

Absolutely. It includes detailed workflows for 'prisma migrate dev' and 'deploy', including directory structures and best practices for Prisma schema management.

Does it support automated rollbacks?

Yes, it includes guidance on transaction-based rollbacks and the creation of manual 'down' scripts to ensure every schema change is reversible.

What database systems does this skill support?

It focuses on universal SQL principles with specific implementation patterns tailored for PostgreSQL, MySQL, and the Prisma ORM.

How does it handle migrations on large tables?

The skill provides patterns for batched updates, concurrent index creation, and guidance on using tools like pt-online-schema-change to prevent long-running table locks.

How does it ensure migration safety?

It follows a strict deployment checklist including dry runs, testing on sanitized production data clones, and monitoring for errors during execution.

Database Migration Patterns

Name: Database Migration Patterns
Author: bradtaylorsf

bybradtaylorsf

•

Database Management

Implements safe, reversible, and non-blocking database schema changes following industry best practices for production environments.

The Migration Patterns skill equips Claude with a robust framework for managing complex database schema evolutions without risking data integrity or system uptime. It provides standardized templates for Prisma and raw SQL migrations, emphasizing atomicity, reversibility, and non-blocking operations. Whether handling large-scale table refactors, implementing zero-downtime column renames, or managing batched data backfills, this skill ensures that database changes are tested, versioned, and deployable with high confidence across various SQL environments.

Key Features

01Comprehensive deployment checklists for testing migrations against production-like data.

02Non-blocking schema evolution techniques including concurrent indexing and online schema changes.

036 GitHub stars

04Batched data migration scripts for processing large datasets without performance degradation.

05Standardized workflows for Prisma migrations including dev, deploy, and reset cycles.

06Reversible migration patterns with explicit rollback strategies for every change.

Use Cases

01Safely adding NOT NULL constraints to existing columns through multi-step backfill processes.

02Executing zero-downtime column renames by maintaining dual-write compatibility during deployments.

03Optimizing large production tables using concurrent index creation to avoid table locking.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bradtaylorsf/alphaagent-team migration-patterns

For use in Claude.ai and ChatGPT

Download Skill