About the SQL Index Advisor
Reads the WHERE, JOIN, ORDER BY and GROUP BY parts of a slow query and suggests composite indexes in the right column order, with the CREATE INDEX statements ready to copy.
This tool runs entirely in your browser. Nothing you type is uploaded.
How to use it
- 1Type or paste your input in the box (or open a file where offered).
- 2The result updates instantly — adjust the options to fine-tune it.
- 3Use Copy or Download to take the result with you.
- 4Everything runs in your browser, so you can use it on private data.
Frequently asked questions
Is the SQL Index Advisor free?
Yes. The SQL Index Advisor is completely free with no sign-up and no usage limits for normal use. It is provided by Quick2Host as a free resource for developers and site owners.
Is my data uploaded anywhere?
No. The SQL Index Advisor runs entirely in your web browser. Nothing you type, paste or open is sent to our servers.
What does the SQL Index Advisor do?
Suggest indexes for a slow query. Reads the WHERE, JOIN, ORDER BY and GROUP BY parts of a slow query and suggests composite indexes in the right column order, with the CREATE INDEX statements ready to copy.
How do I import a CSV file into MySQL?
Use the CSV to SQL tool to generate CREATE TABLE and INSERT statements, or for very large files use LOAD DATA INFILE with the same column list.
Turn CSV and JSON into SQL, view large CSV files, build connection strings and tune MySQL and PostgreSQL — all offline in your browser. See all 13 data & databases tools →