SQLite Query Explainer from Simon Willison
A small web tool that explains SQLite EXPLAIN QUERY PLAN output in plain language, making it easier to spot missing indexes, costly scans, and join issues.
SQLite Query Explainer — <p><strong>Tool:</strong> <a href="https://tools.simonwillison.net/sqlite-query-explainer">SQLite Query Explainer</a></p> <p>Julia Evan's, in <a href="https://jvns.ca/blog/2026/07/17/learning-about-running-sqlite/">Learning a few things about running SQLite</a>:</p> <blockquote> <p>Maybe one day I’ll learn to read a query plan.</p> </blockquote> <p>Big same.... which inspired me to <a href="https://github.com/simonw/tools/pull/299#issue-4919268017">have Fable build</a...
