AIToday
Simon Willison's WeblogPublished: Jul 3, 2026, 04:01 JST1 min read

DSPy used to refine Datasette Agent's SQL prompts

Key takeaway

  • A research project used DSPy, a framework for refining AI systems, to improve the system prompts that Datasette Agent—a tool for answering questions about data by running SQL queries—uses in production.

  • Testing with GPT-4.1 models identified specific improvements, such as including column names in schema documentation to prevent the AI from guessing column names and entering error-retry loops.

  • This shows how systematic evaluation can make AI-powered tools more reliable and efficient.

3 Key Points

  1. What happened

    A research project used DSPy, a framework for evaluating and improving AI systems, to test and refine the core system prompts that Datasette Agent uses when answering questions by executing read-only SQL queries. The work identified several improvements, including better schema documentation to avoid column-name guessing and reduce error-retry loops.

  2. Why it matters

    Datasette Agent is a tool for querying databases with natural language. Improving its system prompts means it will answer user questions more accurately and efficiently, reducing unnecessary back-and-forth exchanges. This demonstrates a practical approach to making AI tools more reliable in production use.

  3. What to watch

    The research tested improvements using GPT-4.1 mini and nano models and identified promising directions for refinement, particularly around how database schemas are presented in prompts to the AI.

Ask the AI about this article →

FAQ

What is Datasette Agent?
Datasette Agent is a read-only SQL question answerer that executes SQL queries to answer user questions about data.
What improvement was identified in the research?
The research found that including column names in the schema listing, rather than just table names, would prevent the AI from guessing column names and reduce error-retry loops.
Simon Willison's WeblogRead Original Article

Get AI news like this every morning

For example, today's edition would include:

  • CrowdStrike unveils SafeMind, autonomous red teamingSiliconANGLE AI · 1h ago
  • ASE CEO: AI resource squeeze is short-termDIGITIMES Asia · 1h ago
  • Google signs largest enhanced geothermal deal with FervoYahoo Finance AI · 1h ago

AI-summarized, only the topics you pick — one digest a day via Email, Slack, or Discord.

Free · takes 30 seconds · unsubscribe anytimeWhat is AIToday? →

Ask AI

Ask AI anything about this article. Q&As are published on this page for other readers too.

Next articleTokyo University and Kubota develop drone method to predict potato yield before harvest