PostgreSQL index decision guide
Review PostgreSQL index migrations in CI
Add a read-only evidence gate for CREATE INDEX migrations and retain review artifacts with each pull request.
The problem
Code review can see the DDL, but it cannot see whether production-like workload supports it.
How IndexPilot helps
Run IndexPilot in CI against a representative PostgreSQL target. Gate only the verdicts your team chooses and retain the evidence for reviewers.
Try it
$ pipx install indexpilot
$ indexpilot review --migration-file migration.sql --sarif-output indexpilot.sarif --fail-on existing_overlap
$ indexpilot review --migration-file migration.sql --sarif-output indexpilot.sarif --fail-on existing_overlap
- Opt-in exit-code gates
- SARIF for code scanning
- Read-only database path
Important limit
IndexPilot decides whether an index has enough evidence to benchmark. It does not claim that planner cost equals production latency or that an index is safe to ship.