datasette 1.0a31
Simon Willison's Weblog4d agoReleaseSimon Willison released Datasette 1.0a31, a significant alpha release with two headline features: write SQL execution and stored queries. Users with the right permissions can now run database-changing queries and save queries privately or for other members of a Datasette instance. The new interface can generate templated insert, update, and delete queries for editable tables while blocking unauthorized actions such as creating tables without permission.
sqlite AGENTS.md
Simon Willison's Weblog5d agoCommentarySQLite added an AGENTS.md file aimed at people pointing coding agents at its codebase, not at its own internal development. The file says SQLite does not accept agentic code, though it will accept agentic bug reports with reproducible test cases. The project has also split AI-generated bug reports into a new SQLite Bug Forum, where D. Richard Hipp is responding with commits.
Datasette Agent: An Extensible AI Assistant for Datasette★ 70
Simon Willison's Weblog12d agoNew ToolSimon Willison announced the first release of Datasette Agent, merging his 'llm' Python library with Datasette. The tool provides a conversational interface to query SQLite databases, with plugin support for generating charts and running code in sandboxes. It runs efficiently on lightweight models like Gemini 3.1 Flash-Lite and supports local open-weight models via LM Studio.
datasette-agent 0.1a3
Simon Willison's Weblog12d agoReleaseSimon Willison 開源的 Datasette 智慧助理 datasette-agent 發布 0.1a3 版本。本次更新為可見表格與摺疊的 SQL 結果工具調用新增了「檢視 SQL 查詢」按鈕，並隱藏了空白的推理區塊。此外，還改善了截斷回應的處理機制，即使 SQL 結果在呈現給 Agent 時被截斷，使用者仍能看到完整的表格。
datasette-llm 0.1a8
Simon Willison's Weblog14d agoReleaseSimon Willison 開源的 Datasette 插件 datasette-llm 發布了 0.1a8 預覽版本。此版本主要修復了一個關鍵 Bug，解決了 llm_prompt_context() 鉤子（hook）在運作時，無法完整收集並串聯對話回應鏈（chains of responses）的問題。這對於依賴該插件進行複雜 LLM 數據檢索與上下文構建的開發者來說是個必要的更新。