SQLite Query Explainer

Simon Willison's Weblog Simon Willison's Weblog —

Tool: https://tools.simonwillison.net/sqlite-query-explainer">SQLite Query Explainer


Julia Evan's, in https://jvns.ca/blog/2026/07/17/learning-about-running-sqlite/">Learning a few things about running SQLite:



Maybe one day I’ll learn to read a query plan.



Big same.... which inspired me to https://github.com/simonw/tools/pull/299#issue-4919268017">have Fable build this interactive explain tool, which runs SQLite in Python in Pyodide in Web Assembly in the browser and adds a layer of explanation to the results of both EXPLAIN and EXPLAIN QUERY PLAN.


Approach with caution, since I don't know enough about SQLite query plans to verify the results myself, but it seems cromulent enough to me.




Tags: https://simonwillison.net/tags/sql">sql, https://simonwillison.net/tags/sqlite">sqlite, https://simonwillison.net/tags/tools">tools, https://simonwillison.net/tags/julia-evans">julia-evans, https://simonwillison.net/tags/pyodide">pyodide, https://simonwillison.net/tags/claude-mythos-fable">claude-mythos-fable

Read full article at Simon Willison's Weblog →