The Hallway Track
Engineering Insights

SQLite Query Explainer

Simon Willison · Jul 18, 2026 · Engineering Insights

Simon Willison used Claude Fable to build a browser-based SQLite query plan explainer.

“Maybe one day I'll learn to read a query plan.”

Simon Willison built an interactive SQLite EXPLAIN tool by prompting Claude Fable, running SQLite via Pyodide in WebAssembly inside the browser. The tool wraps both EXPLAIN and EXPLAIN QUERY PLAN with natural language annotations. It is a minor but illustrative example of using AI to build niche developer utilities quickly, though Willison himself cautions the AI-generated explanations are unverified.

sqlite developer-tools claude-fable pyodide ai-assisted-development webassembly

Watch / read the original source →