New plugin for sqlite-utils that lets you ask questions of a SQLite database (or a even against one or more CSV/TSV/JSON files) in human language and have an LLM write a SQL query for you to get the answer.

Simon Willison

New plugin for sqlite-utils that lets you ask questions of a SQLite database (or a even against one or more CSV/TSV/JSON files) in human language and have an LLM write a SQL query for you to get the answer. https://simonwillison.net/2024/Nov/25/ask-questions-of-sqlite/

Shaun McDonald

@simon could this be integrated into Datasette?

Simon Willison

@smsm1 definitely - I have an initial version of that here but I'm working on a much improved one https://github.com/datasette/datasette-query-assistant