2026-06-15原文1 min readUpdated: 2026-06-16

datasette-agent 0.3a0

Datasette Agent 0.3a0 introduces a new execute_write_sql tool that requests user approval before writing to databases, enhancing chat mode with approval support and a --unsafe option for auto-approving operations.

SourceSimon Willison's Weblog

Release: datasette-agent 0.3a0

Simon Willison’s Weblog

15th June 2026

Release

datasette-agent 0.3a0 — An LLM-powered agent for Datasette

New tool, execute_write_sql, which requests user approval and then writes to a database - taking user permissions into account. #27

I added a mechanism for asking user approval in datasette agent 0.2a0. The new execute_write_sql tool can now prompt the user for all kinds of useful operations. Here's an example where I add some pelican sightings to my pelican_sightings table:

The new version also enhances the datasette agent chat terminal mode to support approvals, and adds several new options including --unsafe mode for auto-approving them:

datasette agent chat can execute tools that require user approval. #30

Three new options for datasette agent chat - --root to run as root, --yes to approve all ask user questions, and --unsafe for both.

Tools can now provide plain text alternatives to HTML, for display in the datasette agent chat CLI. #31

The datasette agent chat content.db -m gpt-5.5 --unsafe command can now be used to chat directly with a specific database and directly modify it through prompts like "create a notes table", "add a note about X" etc.