Index Advisor

Analyze SQL queries and suggest optimal indexes for WHERE, JOIN, ORDER BY, and GROUP BY clauses.

freeworks offlinenothing uploaded
Input
Output
—

About index advisor

Index Advisor is one page doing one thing. No account, no settings to sync, no history building up somewhere.

There is no account and no upload step. Whatever you paste lives in a variable until you close the tab, and then it does not.

You will find it under SQL & databases, alongside 27 other tools for the same sort of job.

Generates ready-to-use CREATE INDEX statements.

How to use it

01
Start it
Every control is on the tool itself. Keyboard shortcuts, where there are any, are listed beside it.
02
Watch it run
It updates in the page as you go. Nothing is sent anywhere, so it keeps working with the network off.
03
Close when done
Nothing is stored between visits. Reloading gives you a clean start rather than picking up where you left off.

Examples

Query with JOIN and WHERE
Analyze a query with JOIN and WHERE clauses for index recommendations
Input
SELECT u.name, o.total FROM users u INNER JOIN orders o ON u.id = o.user_id WHERE o.status = 'completed' ORDER BY o.created_at DESC
Output
Index Advisor Report
==================================================
Queries analyzed: 1
Suggestions: 5

1. [HIGH] orders(status)
   Reason: Column used in WHERE clause with = operator
   SQL: CREATE INDEX idx_orders_status ON orders (status);

2. [HIGH] users(id)
   Reason: Column used in JOIN condition
   SQL: CREATE INDEX idx_users_id ON users (id);

3. [HIGH] orders(user_id)
   Reason: Column used in JOIN condition
   SQL: CREATE INDEX idx_orders_user_id ON orders (user_id);

4. [MEDIUM] orders(created_at)
   Reason: Columns used in ORDER BY clause
   SQL: CREATE INDEX idx_orders_created_at ON orders (created_at);

5. [LOW] orders(status, created_at)
   Reason: Composite index coverin…

Questions

Does Index Advisor work offline?+

Yes. It is JavaScript running in this tab, so once the page has loaded it needs nothing further from the network. Put the machine in flight mode and it carries on. Nothing you do here is sent anywhere, because there is nowhere for it to go.

Does it remember anything between visits?+

No. Reload the page and it starts from nothing. There is no account, no saved state and no cookie holding your last session. That is a deliberate trade: it cannot lose your data because it never keeps any.

Is it accurate?+

Timing comes from performance.now(), the high resolution clock the browser provides, rather than from setInterval, which drifts by a few milliseconds every tick and compounds over minutes. What can still shift things is the browser throttling a tab in the background, so leave it visible if the timing matters.

Does it make a sound?+

Where a sound makes sense, it is generated with the Web Audio API rather than loaded as a file, so there is nothing to download and nothing to block. Browsers refuse to start audio until you have interacted with the page, which is why the first press is what switches it on.

Can I use Index Advisor on a phone?+

Yes. The controls are sized for touch and the layout collapses to one column on a narrow screen. Bear in mind that a phone locking its screen will suspend the page, and timing stops with it.