datasette-agent 0.3a0: Write SQL via Natural Language with User Approval
Original: datasette-agent 0.3a0
datasette-agent adds a user-approved write SQL tool and unsafe auto-approval CLI flags for natural-language database editing.
Version 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 is an open-source plugin by Simon Willison that brings AI agent capabilities to Datasette, his widely used Python tool for exploring and publishing SQLite databases. Version 0.3a0 (alpha) is a significant functional step: it introduces the ability to write to databases through natural language prompts, protected by a user-approval mechanism that ensures humans remain in the loop by default.
Free shows the 3-line summary; Pro unlocks the full deep summary (~300 words) so you never have to click through.
See Pro plans →Want the original English / full article?
Read on Simon Willison's Weblog →Summaries are AI-generated; the original article is authoritative.