Database Migration Integrity Checker

Audits SQL migration files for destructive actions, potential table locks, and compatibility issues. Use before applying migrations to production databases to prevent downtime and ensure data integrity.

jorgealves Updated

File contents

Database Migration Integrity Checker

Purpose and Intent

The database-migration-integrity-checker is a safety net for your most critical asset: your data. It catches dangerous SQL operations that might pass a standard code review but could cause production outages or data loss.

When to Use

  • CI/CD Pipelines: Block deployments if a migration contains a high-risk operation without manual override.
  • Local Development: Run before committing a new migration to ensure it follows safe DDL practices.

When NOT to Use

  • Data Querying: This is for schema changes, not for auditing standard SELECT/INSERT queries.

Security and Data-Handling Considerations

  • Reads SQL files only; no database access required.
  • Safe for local use.

jorgealves/agent_skills/tree/main/database-migration-integrity-checker commit 5b14fb51de

Frequently asked questions

npx skillmds@latest add jorgealves/database-migration-integrity-checker