datasette-agent 0.3a0: Write SQL via Natural Language with User Approval
Simon Willison's Weblog42 days agoReleaseVersion 0.3a0 of datasette-agent introduces `execute_write_sql`, a new tool that translates natural language into write SQL statements and prompts the user to confirm before execution. The `datasette agent chat` terminal mode now supports these approval flows, with three new flags — `--root`, `--yes`, and `--unsafe` — to control permission levels and auto-approval. Together these additions enable fully conversational, autonomous modification of SQLite databases via an AI agent.
datasette-agent-edit 0.1a0
Simon Willison's Weblog50 days agoReleaseSimon Willison released datasette-agent-edit 0.1a0 as a base plugin for Datasette Agent. It is intended to support future plugins that edit existing text, including collaborative Markdown, large SQL queries, and SVG files. The design follows Claude’s text editor tool pattern, exposing view, str_replace, and insert primitives so other plugins can reuse a stricter editing workflow.