arib-check-migrate

Analyze database migration scripts for performance risks and locking behavior.

2|Updated Apr 19, 2026
One-click install
npx skills add https://github.com/AribSudia/claude-code-methodology --skill arib-check-migrate
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: arib-check-migrate
Source: https://github.com/AribSudia/claude-code-methodology/tree/main/.claude/skills/arib-check-migrate
Command: npx skills add https://github.com/AribSudia/claude-code-methodology --skill arib-check-migrate

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill prevents production database outages by identifying dangerous SQL patterns, calculating lock durations, and verifying rollback procedures before migrations are executed.

Core Features & Use Cases

  • Risk Classification: Automatically categorizes migrations as LOW, MEDIUM, HIGH, or CRITICAL risk.
  • Lock Analysis: Estimates table lock duration based on row counts and operation types to prevent downtime.
  • Safety Gate: Enforces strict protocols for dangerous operations like DROP TABLE or ALTER TYPE, ensuring backups and rollback paths are verified.

Quick Start

Use the arib-check-migrate skill to perform a safety audit on the pending database migration file located in the prisma migrations directory.

Frequently Asked Questions about arib-check-migrate

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I check database migration scripts for locking and downtime risks?

To prevent production database outages, you can audit database migration scripts to identify dangerous SQL patterns, estimate lock durations based on row counts, and verify rollback procedures before execution.

How does migration risk classification work for SQL schema changes?

Migration risk classification evaluates SQL operations to categorize schema changes as LOW, MEDIUM, HIGH, or CRITICAL risk, enforcing strict safety gates for dangerous operations like DROP TABLE or ALTER TYPE.

Can I use automated migration safety audits with Prisma migrations?

Yes, you can perform automated safety audits on pending database migration files located in the prisma migrations directory to prevent downtime and irreversible data loss.

Do I need database management tools to evaluate table sizes for migration risk assessment?

Yes, database migration risk assessment requires integration with database management tools to evaluate table sizes and verify rollback procedures against defined safety protocols.

What is the best way to prevent production outages during schema evolution?

The best way to prevent production outages during schema evolution is to apply automated safety audits that calculate lock durations, verify rollback paths, and enforce strict protocols against dangerous SQL operations.

When should I not use an automated database migration safety gate?

You should not use an automated database migration safety gate when you lack integration with database management tools, as the audit requires table size evaluation and rollback procedure verification to function correctly.