simonwillison.net·Jul 2, 2026
Simon Willison's latest blog post discusses using the DSPy framework to enhance the SQL system prompts of Datasette Agent, focusing on improving its ability to execute read-only SQL queries. The research involves evaluating the current prompts and identifying areas for refinement to enhance performance and user experience.
The most valuable insight for you is the use of DSPy to refine system prompts for Datasette Agent's SQL question-answering feature. By including column names in the prompt's schema listing, you can prevent error-retry loops and improve the accuracy of SQL queries, a method that could be applied to enhance other AI coding tools you are interested in.