IndexPilot 1.1.0a1 — workload-aware migration review
Pre-release
Pre-release
IndexPilot's first focused advisory preview.
The promise
Review proposed PostgreSQL indexes against the workload your database actually runs—before the migration is merged.
Included
- Batch
CREATE INDEXmigration review using PostgreSQL catalogs andpg_stat_statements - SQLGlot PostgreSQL AST parsing with no regex fallback
- Optional session-local HypoPG planner evidence routed through the existing admission rules
doctor, conservativeaudit, and offline post-deploycomparecommands- Markdown, JSON, and SARIF output with opt-in CI verdict gates
- Factual legacy index inventory; automatic cleanup and REINDEX remain disabled
- Authenticated single-operator dashboard API
Install
pipx install "git+https://github.com/eyeinthesky6/indexpilot.git@v1.1.0a1"
indexpilot doctor --help
indexpilot review --helpThis is an evaluation release, not an autonomous production DBA. IndexPilot does not execute supplied migrations or physical index DDL from the public review commands.