Back to browse
Datasette Agent

Datasette Agent

by simonw·May 21, 2026·10 points·1 comment

AI Analysis

●●SolidCozySolve My Problem

Simon Willison's Datasette Agent finally marries LLMs to SQLite with charting plugins.

Strengths
  • Plugin architecture allows adding image generation and code execution sandboxes easily.
  • Runs reliably against local models like Gemma via LM Studio for offline data analysis.
  • Generates Observable Plot charts directly from natural language questions about datasets.
Weaknesses
  • Limited to SQLite backends; cannot query Postgres or Snowflake without complex ETL pipelines.
  • Relies on model tool-calling reliability which varies significantly across open weight models.
Target Audience

Data analysts, Python developers, Datasette users

Similar To

Vanna AI · SQLChat · LangChain SQL Agents

Similar Projects