SQLite Query Explainer
Simon Willison released SQLite Query Explainer, an interactive tool that runs SQL queries against a SQLite database in the browser and annotates EXPLAIN QUERY PLAN and low-level EXPLAIN bytecode output with plain-English descriptions. The tool runs SQLite in Python via Pyodide in WebAssembly. Willison cautions he cannot verify the results himself but finds them cromulent.
Developers can now visually understand SQLite query plans without deep expertise.


