migrate-validate

Original：🇺🇸 English

Translated

Validate pending migrations for foreign key consistency, rollback safety, and best practices

5installs

Sourceruvnet/ruflo

Added on2026-05-03

NPX Install

npx skill4agent add ruvnet/ruflo migrate-validate

SKILL.md Content

View Translation Comparison →

Migrate Validate

Validate all pending database migrations for correctness, safety, and adherence to best practices.

When to use

Before applying migrations to catch issues early -- foreign key references to non-existent tables, missing rollback SQL, destructive operations without safeguards, and naming convention violations.

Steps

Find pending migrations -- use
```
Glob
```
to list all migration files, cross-reference with applied history via
```
mcp__claude-flow__agentdb_hierarchical-recall
```
to identify pending ones
Parse SQL -- use
```
Read
```
to load each pending
```
.up.sql
```
and
```
.down.sql
```
file and parse the SQL statements
Check foreign keys -- verify that all REFERENCES targets exist in the current schema or in prior migrations (both applied and pending)
Check NOT NULL defaults -- verify that any ADD COLUMN with NOT NULL has a DEFAULT value
Check rollback completeness -- verify every CREATE/ALTER in the UP file has a corresponding DROP/ALTER in the DOWN file
Flag destructive ops -- warn on DROP TABLE, DROP COLUMN, TRUNCATE without explicit confirmation
Check idempotency -- verify IF EXISTS / IF NOT EXISTS is used for safety
Check naming -- verify table names are plural, column names are snake_case, index names follow
```
idx_table_column
```
convention
Store results -- call
```
mcp__claude-flow__agentdb_pattern-store
```
to record validation patterns for future reference
Report -- display: errors (must fix), warnings (should fix), info (suggestions), with file path and line number for each issue

CLI alternative

bash

npx @claude-flow/cli@latest memory search --query "migration validation results" --namespace migrations