Datasette Agent

Simon Willison · Simon Willison · 2026-05-21

Simon Willison announces Datasette Agent, an extensible open-source AI assistant that lets users query Datasette databases via natural language conversation, generate charts, and run code through a plugin architecture.

Open original ↗

Appears in

Simon Willison Launches Datasette Agent: Natural Language SQL Interface

Extraction

Topics: natural-language-sqlai-toolingopen-source-toolsplugin-architecturedatasette

Claims

Datasette Agent provides a conversational interface for querying data stored in Datasette using natural language.
The system is extensible via plugins, with three already shipped covering charts, image generation, and persistent sandbox execution.
The live demo runs on Gemini 3.1 Flash-Lite, which is fast, cheap, and reliable for writing SQLite queries.
Open-weight models released in the past six months are increasingly capable of reliable tool calls and SQL generation against SQLite.
Claude Code and OpenAI Codex are effective at writing Datasette Agent plugins when pointed at the reference repository.

Key quotes

Datasette Agent represents the moment that LLM and Datasette finally come together.

The live demo runs on Gemini 3.1 Flash-Lite - it's cheap, fast and has no trouble writing SQLite queries.

Claude Code and OpenAI Codex are both proving excellent at writing plugins - just point them at a checkout of the datasette-agent repo for reference and tell them what you want to build!