The Archive

datasette-llm 0.1a9 improves UX by auto-detecting default LLM models, reducing configuration overhead for Datasette Agent users.

llm-tools-datasette 0.1.1 fixes httpx dependency breakage from LLM 0.33 upgrade.

datasette-ports 0.4 released with PID detection support for Datasette instances.

Simon Willison demonstrates integrating Parseable observability platform with Datasette's OpenTelemetry trace support via a working example.

datasette-atom 0.11a0 fixes compatibility with Datasette 1.0a41 alphas.

Datasette 1.0a41 adds OpenTelemetry support and refactors modals to Web Component.

datasette-explain 0.2.2 adds query plan visualization for read-only stored-query pages.

datasette-auth-github reaches 1.0 with session persistence fix for mobile browsers.

Datasette 1.0a40 adds background task API, migrates to httpx2, fixes bugs ahead of stable release.

Datasette 0.65.5 patches security flaw allowing table permission bypass via trailing newline in names.

Datasette security patches (1.0a39, 0.65.4) address vulnerabilities in public/private table isolation, audited with Claude and GPT models.

datasette-publish-fly 1.4 adds force_https, fixes volume bug, supports app-scoped deploy tokens.

Datasette 1.0a39 security release addresses vulnerabilities.

datasette-mcp 0.2 releases with structured SQL result format (objects instead of arrays) to improve weaker model reasoning over tabular data.

Release: datasette-upload-dbs 0.5a0 This plugin has been around for a while - it lets users upload a brand new SQLite database to a hosted Datasette instance, at which point that database will start being served by that instance. It can also be used to atomically swap a database with a more recent version. The uploaded database is saved to a file, verified, then swapped in so /name starts serving the new one. The new release adds a formalized API, so you can replace an existing database (or add a new one) like this: curl -X POST \ -H "Authorization: Bearer $API_TOKEN" \ -H "Accept: applicatio...

Release: datasette-auth-tokens 0.4a13 Upgraded for compatibility with `sqlite-utils 4. Tags: datasette

Release: datasette 1.0a38 This release fixes a SQL injection security issue that affects Datasette instances that serve a mixture of public and private tables in the same database, with access configured using the Datasette permissions system . Site administrators who serve private tables in this way are advised to disable the execute-sql permission ` on that database to prevent users from accessing private tables using raw SQL queries. The bug that has been fixed would have allowed users with access to any public table to execute SQL injection attacks despite that restriction, giving them re...

Release: datasette 0.65.3 Back-ported the SQL Injection security fix from 1.0a38 . Tags: datasette

datasette-apps 0.2a0 adds app_debug() and app_list() tools to enable agentic creation and testing of web apps via sandboxed iframe execution.

MCP 2.0 (stateless Model Context Protocol) launches with significant spec changes; Simon Willison revives mcp-explorer and datasette-mcp tooling.

datasette-agent 0.4a0 adds browser task execution, letting agent plugins run JavaScript directly in user browsers.

Datasette 1.0a37 alpha release with permissions system improvements and plugin compatibility fixes.

Simon Willison documents productivity spike in Datasette project correlating with Opus 4.8 and GPT-5.5 releases via GitHub commit frequency analysis.

Simon Willison uses DSPy to evaluate and optimize SQL system prompts in Datasette Agent, a tool enabling agents to execute read-only database queries.

datasette-export-database 0.3a2 released with dependency constraint fix for Datasette 1.0a27 compatibility.

Release: datasette 1.0a35 I'll write more about this one tomorrow, but it's a big release. Three highlights from the release notes: New "Create table" interface in the database actions menu, backed by the /<database>/-/create JSON API . It can define columns, primary keys, custom column types, NOT NULL constraints, literal defaults, expression defaults and single-column foreign keys. ( #2787 ) New "Alter table" table action and /<database>/<table>/-/alter JSON API for changing existing tables: add, rename, reorder and drop columns; change column types, defaults, NOT NULL constraints, primary ...

Tool: OPFS + Pyodide test harness I've been pondering if Datasette Lite - the Python Datasette application run entirely in the browser using Pyodide and WebAssembly - might be able to edit persistent SQLite files stored on the user's computer. That's what OFPS (Origin Private File System) is for, so I had Claude Code for web build me this playground UI to try it out in different browsers. Tags: browsers , pyodide , datasette-lite

Today we launched a new plugin for Datasette, datasette-apps , with this launch announcement post on the Datasette project blog. That post has the what , but I'm going to expand on that a little bit here to provide the why . The TL;DR Datasette Apps are self-contained HTML+JavaScript applications that run in a tightly constrained <iframe> sandbox hosted on your Datasette application. They can use JavaScript to run read-only SQL queries against data in Datasette, and can run write queries too if you configure them with some stored queries . Here's a very simple example and a more complex custo...

Release: datasette-acl 0.6a0 This release expands datasette-acl from table-only permissions toward a general resource-sharing system. Alex Garcia did most of the work for this release - we're fleshing out the plugin that will allow multi-user Datasette instances finely grained control over who can access which resources within Datasette. Tags: datasette , alex-garcia

Release: datasette 1.0a34 Quoting the release notes: The big feature in this alpha is tools to insert, edit and delete rows within the Datasette interface. These features are available on table pages, and edit and delete are also available as action items on the row page. The inspiration for this feature - which is long overdue - was Datasette Agent . I added SQL write support to that the other day which highlighted how absurd it was that you could insert and edit ties via the chat interface but not in the regular Datasette UI! Tags: projects , datasette , annotated-release-notes