SQL Index Advisor
Paste a query and get plain-language index suggestions for its filters, joins and sorts.
Runs in your browser. Nothing is uploaded — your input is processed on this device and discarded when you close the tab.
SQL Index Advisor
How to use this tool
- Paste a SELECT query with WHERE, JOIN or ORDER BY clauses.
- Press Check to list the columns used for filtering and sorting.
- Use the suggestion as a starting point — confirm it against your real schema and query plan before creating an index.
Worked example
The sample query filters on email and status and sorts by created_at, so the tool suggests considering an index on (email, status, created_at), and lists email and status as filter columns.
What this tool does not do / Limits
Suggestions are heuristics from one query only. They ignore table size, existing indexes, selectivity, write load and your database's planner, so they are a starting point for investigation — never a create-this-index order.
Frequently asked questions
Should I create every suggested index?
No. Check whether a similar index already exists, how selective the columns are, and whether the query is actually slow. Unused indexes cost write time and storage.
Does it read my database?
No. It only reads the text you paste; it never connects to a database.
Related tools
JSON Studio
Format, validate, minify, query and compare JSON in your browser, with precise line-and-column errors.
LiveRegex Tester
Test patterns against sample text with match highlighting, capture groups and a safe one-second timeout.
LiveSecurity Header and DNS Checker
Check HSTS, CSP and other security headers, TLS details, and DNS/email authentication records (SPF, DKIM, DMARC).
Live