Can it detect operations that cause table locks?

Yes, the skill specifically identifies operations that trigger Access Exclusive locks and suggests concurrent alternatives, such as 'CREATE INDEX CONCURRENTLY' in PostgreSQL.

What database frameworks does Migration Checker support?

Migration Checker supports a wide range of popular tools including Prisma, TypeORM, Alembic (Python), Django, Rails migrations, and raw SQL scripts.

How does it ensure zero-downtime for column renames?

It recommends a multi-step workflow: adding a new column, syncing data between both columns, updating application code, and finally dropping the old column after a successful deployment.

Does it help with data migrations as well as schema changes?

Absolutely. It provides best-practice patterns for batch processing and raw SQL updates to handle millions of rows without memory exhaustion or performance degradation.

Migration Checker

Name: Migration Checker
Author: physics91

byphysics91

0•

Gestión de Bases de Datos

Audits database migrations for schema safety, data integrity, and zero-downtime deployment patterns.

The Migration Checker skill provides a comprehensive safety net for database evolution by reviewing schema changes for common pitfalls like blocking locks, backwards compatibility issues, and missing rollback paths. It analyzes migration scripts across various frameworks—including Prisma, TypeORM, Django, and Alembic—to suggest multi-step patterns that prevent application downtime and ensure data preservation during complex updates. By identifying high-risk operations like adding non-nullable columns or dropping tables without proper checks, it helps developers maintain high availability and data integrity in production environments.

Características Principales

01Validation of rollback/reverse migration logic to ensure safe recovery from failed deployments.

020 GitHub stars

03Framework-specific guidance for Prisma, TypeORM, Django, and Rails migrations.

04Pattern suggestions for concurrent index creation and batch processing for large-scale data migrations.

05Lock and downtime analysis to identify operations that block table access in PostgreSQL and other RDBMS.

06Automated risk assessment for dangerous schema changes like renames and type modifications.

Casos de Uso

01Pre-deployment review of complex SQL or ORM migrations to prevent production outages.

02Refactoring high-risk single-step migrations into safe, multi-step zero-downtime processes.

03Generating comprehensive rollback strategies for database schema changes in CI/CD pipelines.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add physics91/claude-vibe migration-checker

For use in Claude.ai and ChatGPT

Download Skill