Schema Manager
Validates migration SQL, analyzes index health, and applies pending schema migrations to the target database
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
- Migration Validation: Scans
/migrations/for SQL files, validates syntax against the target database. - Index Analysis: Identifies potentially redundant indexes using naming pattern recognition and generates cleanup migrations.
- 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"
}
Related skills
- Downloads
- 594All time
- Security audit
- Review
- Last updated
- 5mo ago
- Current version
- v1.0.0
- License
- MIT-0
