What databases and ORMs does this skill support?

It provides best practices and code patterns for PostgreSQL and MySQL, with specific implementation guides for Prisma, Drizzle, Django, TypeORM, and golang-migrate.

Can this skill help with large-scale data updates?

Yes, it includes patterns for batched data migrations that use progress tracking and 'SKIP LOCKED' logic to prevent table locking on datasets with millions of rows.

Why is adding a NOT NULL constraint on existing tables discouraged?

Adding NOT NULL without a default value on an existing table requires a full table rewrite in many databases, which can lock the table for a significant amount of time; this skill provides safer alternatives.

How does this skill help achieve zero-downtime deployments?

It implements the 'Expand-Contract' strategy, which involves adding new columns as nullable, backfilling data, and updating application code before finally removing old schema elements.

Database Migrations

Name: Database Migrations
Author: Mark393295827

byMark393295827

•

データベース管理

Implements safe, reversible database schema changes and zero-downtime deployment patterns for modern production environments.

The Database Migrations skill provides comprehensive guidance and implementation patterns for managing database schema evolution across PostgreSQL, MySQL, and popular ORMs like Prisma, Drizzle, and Django. It prioritizes data integrity and system availability by enforcing zero-downtime strategies such as the expand-contract pattern, concurrent indexing, and asynchronous data backfills. Whether you are setting up a new project or modifying large production tables, this skill ensures your schema changes are immutable, tested, and fully reversible.

主な機能

011 GitHub stars

02Zero-downtime schema change patterns (Expand-Contract)

03Batch data migration scripts for processing large-scale datasets

04Pre-migration safety checklists and anti-pattern prevention

05ORM-specific migration workflows for Prisma, Drizzle, and Django

06Safe PostgreSQL indexing and non-blocking column management

ユースケース

01Standardizing migration tooling and workflows for new software projects

02Altering large production database tables without locking writes

03Implementing complex data transformations across millions of rows

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add mark393295827/house-maint-ai database-migrations

For use in Claude.ai and ChatGPT

主な機能

011 GitHub stars

02Zero-downtime schema change patterns (Expand-Contract)

03Batch data migration scripts for processing large-scale datasets

04Pre-migration safety checklists and anti-pattern prevention

05ORM-specific migration workflows for Prisma, Drizzle, and Django

06Safe PostgreSQL indexing and non-blocking column management

ユースケース

01Standardizing migration tooling and workflows for new software projects

02Altering large production database tables without locking writes

03Implementing complex data transformations across millions of rows

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add mark393295827/house-maint-ai database-migrations

For use in Claude.ai and ChatGPT