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

数据库管理

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.

主要功能

Validation of rollback/reverse migration logic to ensure safe recovery from failed deployments.
0 GitHub stars
Framework-specific guidance for Prisma, TypeORM, Django, and Rails migrations.
Pattern suggestions for concurrent index creation and batch processing for large-scale data migrations.
Lock and downtime analysis to identify operations that block table access in PostgreSQL and other RDBMS.
Automated risk assessment for dangerous schema changes like renames and type modifications.

使用场景

Pre-deployment review of complex SQL or ORM migrations to prevent production outages.
Refactoring high-risk single-step migrations into safe, multi-step zero-downtime processes.
Generating comprehensive rollback strategies for database schema changes in CI/CD pipelines.

关于

主要功能

Validation of rollback/reverse migration logic to ensure safe recovery from failed deployments.
0 GitHub stars
Framework-specific guidance for Prisma, TypeORM, Django, and Rails migrations.
Pattern suggestions for concurrent index creation and batch processing for large-scale data migrations.
Lock and downtime analysis to identify operations that block table access in PostgreSQL and other RDBMS.
Automated risk assessment for dangerous schema changes like renames and type modifications.

使用场景

Pre-deployment review of complex SQL or ORM migrations to prevent production outages.
Refactoring high-risk single-step migrations into safe, multi-step zero-downtime processes.
Generating comprehensive rollback strategies for database schema changes in CI/CD pipelines.