Version 7

Simon Willison launched Datasette Agent on May 21, 2026, merging his LLM library and Datasette data-publishing tool after three years of parallel development [1][2]. The system uses a plugin architecture; three first-party plugins shipped at or near launch — datasette-agent-charts, datasette-agent-openai-imagegen, and datasette-agent-sprites (a persistent sandbox executor via Fly Sprites) [7][6] — layered atop an existing community ecosystem including visualization tools, embedding support [13], and a SQL-driven permissions system [14]. The live demo runs on Gemini 3.1 Flash-Lite, and plugin development began quietly on May 12, over a week before the announcement [3].

Datasette Agent demonstrates a practical, plugin-based pattern for grafting LLM-powered natural language interfaces onto existing data infrastructure without replacing the underlying tool. Willison's observation that open-weight models released in the past six months now reliably generate SQLite queries and tool calls [1] suggests the launch timing reflects a genuine capability inflection point. Datasette's mature SQL-driven permissions system [14] provides a pre-existing access control foundation for multi-tenant deployments — a critical consideration for any natural-language SQL interface handling sensitive or shared data.

On May 21, 2026, Simon Willison published the central announcement for Datasette Agent, framing it as the moment his two flagship open-source projects — the LLM library and the SQLite-based data publishing tool Datasette — finally converged after three years of parallel development [1]. The result is a chat-style interface that lets users query any Datasette database in plain English, with the agent translating natural language into SQL behind the scenes. The official Datasette blog simultaneously published its own coverage, describing the project as an extensible AI assistant for Datasette [2].

The architecture is deliberately extensible, and development of the plugin layer preceded the public announcement by over a week. The charts plugin (datasette-agent-charts) first appeared as version 0.1a0 on May 12 [3], with the 0.1a1 release on May 20 adding magnitude-based sequential color shading, interactive tooltips, and an execute-sql permission check [4], then 0.1a2 on May 21 [5]. A second first-party plugin — datasette-agent-openai-imagegen — handles image generation using OpenAI's API [6]. The third first-party plugin, datasette-agent-sprites (0.1a0), enables the agent to execute arbitrary commands inside a Fly Sprites persistent sandbox [7][8]. The core datasette-agent package reached 0.1a3 on May 21, adding 'View SQL query' buttons, suppressed empty reasoning chunks, and improved handling of truncated SQL responses [9].

The broader Datasette plugin ecosystem that datasette-agent lands on top of includes community-built tools like datasette-dashboards [10], the datasette-plot visualization plugin built on Observable Plot [11][12], datasette-llm-embed for LLM-powered embeddings [13], and a SQL-driven permissions system (datasette-permissions-sql) with a documented authentication layer [14][15]. The live demo runs on Gemini 3.1 Flash-Lite, chosen for speed, low cost, and reliability on SQLite query generation [1]. Willison notes that Claude Code and OpenAI Codex can both write new plugins effectively when given the reference repository as context, lowering the contribution barrier considerably [1].

Willison made a broader observation about the model landscape: open-weight models released in the past six months are increasingly capable of reliable tool calls and SQL generation against SQLite, positioning datasette-agent's launch as deliberately timed to a genuine capability inflection [1]. Early third-party reception has been positive, with social media commentary calling the project a great win for making data accessible [16], and aggregator coverage appearing on developer news sites [17]. The competitive natural-language-to-SQL landscape includes tools like Vanna AI [18] and a range of others tracked in roundups [19], but no independent head-to-head technical evaluations of datasette-agent against these alternatives have surfaced. Willison remains the sole substantive technical voice on the project's design and tradeoffs.