datasette-agent 0.3a0

Datasette released version 0.3a0 of datasette-agent, introducing an execute_write_sql tool that requests user approval before writing to a database. The update also enhances the datasette agent chat terminal mode with approval support and adds --root, --yes, and --unsafe options for auto-approving queries.

Release: datasette-agent 0.3a0 https://github.com/datasette/datasette-agent/releases/tag/0.3a0 - 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 https://simonwillison.net/2026/Jun/10/datasette-agent/ . 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. Tags: projects https://simonwillison.net/tags/projects , ai https://simonwillison.net/tags/ai , datasette https://simonwillison.net/tags/datasette , annotated-release-notes https://simonwillison.net/tags/annotated-release-notes , generative-ai https://simonwillison.net/tags/generative-ai , llms https://simonwillison.net/tags/llms , llm-tool-use https://simonwillison.net/tags/llm-tool-use , datasette-agent https://simonwillison.net/tags/datasette-agent