Index Advisor

A composite-index advisor: define query patterns (equality columns + an optional range/order column), and get leftmost-prefix-deduped CREATE INDEX recommendations with per-pattern 'new index' vs 'covered by' status and copy-ready SQL.

npx shadcn@latest add https://rocket.gozturk.dev/r/index-advisor.json

WHERE =

RANGE / ORDER BY

(customer_id, status, created_at)new index

WHERE =

RANGE / ORDER BY

(customer_id)covered by (customer_id, status, created_at)

WHERE =

RANGE / ORDER BY

(region, created_at)new index

Recommended indexes2 indexes

CREATE INDEX idx_orders_customer_id_status_created_at ON orders (customer_id, status, created_at);serves 2 patterns

CREATE INDEX idx_orders_region_created_at ON orders (region, created_at);serves 1 pattern