A Browser Tool That Finally Explains SQLite's EXPLAIN Output
SQLite Query Explainer is a browser tool that runs SQLite via Python and Pyodide in WebAssembly to turn a query's EXPLAIN QUERY PLAN output into plain-language explanations.
What it is
A free interactive tool from Simon Willison's tools collection, built after reading Julia Evans' post on learning to run SQLite, where she admitted she still can't read a query plan.
What it does
It runs SQLite entirely client-side (SQLite in Python in Pyodide in WebAssembly, in the browser) so you can paste a query, see its execution plan, and get a breakdown of what each plan step actually means, with no server round trip or setup required.
Why it matters
Query plans are dense and most engineers, by Julia Evans' own admission, never fully learn to parse them. A tool that translates SQLite's plan output into readable explanations lowers the bar for actually debugging slow queries instead of guessing.
How to use it
Open the SQLite Query Explainer in a browser, paste in a SQL query (and schema if needed), and read the generated explanation of its query plan.