Schema Manager#

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#

json

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