SQLite Query Explainer
Simon Willison · Simon Willison · 2026-07-18
Simon Willison releases an interactive SQLite query plan explainer built with AI coding tool Fable, running SQLite via Pyodide in WebAssembly in the browser and adding natural-language explanations to EXPLAIN and EXPLAIN QUERY PLAN output.
Appears in
Extraction
Topics: sqlitedeveloper-toolswebassemblypyodideai-assisted-coding
Claims
- The tool runs SQLite inside Python inside Pyodide inside WebAssembly, executing entirely in the browser with no server required.
- It adds a natural-language explanation layer on top of both EXPLAIN and EXPLAIN QUERY PLAN output.
- Willison used Fable, an AI coding tool, to build the explainer rather than writing it manually.
- Willison cautions that he lacks sufficient SQLite query plan expertise to independently verify the accuracy of the AI-generated explanations.
Key quotes
Maybe one day I'll learn to read a query plan. Big same.... which inspired me to have Fable build this interactive explain tool
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.