Schema Manager

Validates migration SQL, analyzes index health, and applies pending schema migrations to the target database

Overview

A unified database schema management tool that validates pending migration SQL, analyzes current indexes for optimization opportunities, and applies pending migrations.

Features

1. Migration Validation: Scans /migrations/ for SQL files, validates syntax against the target database.
2. Index Analysis: Identifies potentially redundant indexes using naming pattern recognition and generates cleanup migrations.
3. Migration Execution: Applies all pending migrations (including auto-generated cleanup) in order.

Output Format

{
  "migrations_validated": [],
  "indexes_analyzed": {"total": 2, "redundant": ["idx_users_email_unique"]},
  "migrations_executed": ["003_drop_redundant_indexes.sql"],
  "status": "completed"
}