Your files stay on your device

SQL index advisor

Read pasted queries and DDL, then propose B-tree indexes with column order reasoning, size estimates, and write cost warnings.
SQL queries to analyze, separated with semicolonsCREATE TABLE and CREATE INDEX statements

Paste queries to see candidate indexes.

This advisor reads text only. Nothing is executed, no statistics are consulted, and nothing leaves the page. Column order follows fixed rules: equality columns first, then at most one range column, then ORDER BY and GROUP BY columns when a statement filters on equalities alone. Size numbers come from the entry formula (column widths plus 14 bytes) times rows times 1.3, with widths guessed from your DDL, so treat them as a ballpark. Run EXPLAIN against the real database before creating anything.
Options

More regex & cron tools

- CSV → SQL (/config/csv-to-sql)
- SQL to CSV (/config/sql-to-csv)
- JSON query (/json/query)
All regex & cron tools (/dev)

Was this tool useful?
YesNo

Canonical HTML: https://nutter.tools/dev/sql-index-advisor
Markdown version: https://nutter.tools/dev/sql-index-advisor.md
Plain-text version: https://nutter.tools/dev/sql-index-advisor.txt
Agent index: https://nutter.tools/llms.txt