How does it help with zero-downtime deployments?

It guides you through the Expand-Contract pattern, ensuring your database can support both old and new versions of your application code simultaneously during a rollout.

Can it generate migration files for specific ORMs?

Yes, it provides workflow commands and code examples for popular tools including Prisma, Drizzle, Django, TypeORM, and golang-migrate.

Does it prevent dangerous database locks?

It includes a safety checklist that warns against operations like creating indexes without the CONCURRENTLY keyword or adding NOT NULL columns without defaults on large tables.

What databases are supported by this migration skill?

While the principles apply to most SQL databases, it provides specific, optimized patterns for PostgreSQL and MySQL.

Database Migrations Expert

Name: Database Migrations Expert
Author: LuciferDono

byLuciferDono

•

Database Management

Implements safe, zero-downtime database schema changes and data migrations using industry best practices and popular ORM workflows.

This skill provides comprehensive guidance for managing database lifecycles in production environments without risk. It covers essential patterns for PostgreSQL and MySQL, such as the 'Expand-Contract' strategy for zero-downtime deployments, concurrent indexing, and non-blocking schema updates. By integrating best practices for popular tools like Prisma, Drizzle, Django, and golang-migrate, it helps developers avoid common pitfalls such as long-running table locks, irreversible migrations, and data inconsistency during deployments.

Key Features

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

02Guidelines for separating DDL (schema) and DML (data) migrations

031 GitHub stars

04Anti-pattern detection to prevent production database locks

05Safety checklists for concurrent indexing and non-blocking column changes

06Zero-downtime deployment strategies (Expand-Contract pattern)

Use Cases

01Automating safe backfill operations for large-scale data migrations.

02Standardizing database migration workflows across a multi-language engineering team.

03Planning and executing complex schema changes on high-traffic production databases.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add luciferdono/labs database-migrations

For use in Claude.ai and ChatGPT

Key Features

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

02Guidelines for separating DDL (schema) and DML (data) migrations

031 GitHub stars

04Anti-pattern detection to prevent production database locks

05Safety checklists for concurrent indexing and non-blocking column changes

06Zero-downtime deployment strategies (Expand-Contract pattern)

Use Cases

01Automating safe backfill operations for large-scale data migrations.

02Standardizing database migration workflows across a multi-language engineering team.

03Planning and executing complex schema changes on high-traffic production databases.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add luciferdono/labs database-migrations

For use in Claude.ai and ChatGPT