Free · open source · no DB connection required
Your Postgres is missing indexes. Get them back as a diff.
Paste your schema and your slow queries. IndexPilot finds the composite indexes your queries are begging for — and the redundant ones quietly taxing every write — and hands you a ready-to-apply migration. A diff, not a dashboard.
Run the analyzer
Everything runs in your browser — your schema and queries never leave this page.
How it works
Parse
Reads your CREATE TABLE / CREATE INDEX DDL and your queries — plain SQL or straight out of pg_stat_statements.
Match
Extracts equality, range, JOIN and ORDER BY columns per table, orders them the way the planner wants, and drops anything an existing index already covers.
Ship
Emits CREATE INDEX CONCURRENTLY statements as a migration-file diff — plus DROP statements for duplicate and prefix-redundant indexes.
Want this running on autopilot?
The IndexPilot bot watches pg_stat_statements in your Supabase, Neon, or RDS database, verifies every candidate with hypopg before/after costs, and opens a reviewable GitHub PR when an index is worth it. Free open-source core; a paid team tier adds continuous monitoring and Slack alerts. Join the waitlist for early access.