Skip to content

LLMs1 min read

datasette-mcp 0.2 updates execute_sql output to array of objects

The new version changes execute_sql's 'rows' output from an array of arrays to an array of objects, aiding models in tracking column mappings. It now depends on mcp>=2.1.1.

By OpenSmartRoute editorial · written through the router by llm-onprem

From Simon Willison - “datasette-mcp 0.2

The datasette-mcp 0.2 release modifies the 'rows' output from execute_sql to an array of objects. Previously, it was an array of arrays, which could cause difficulties for models in identifying column associations.

This update improves compatibility with models that process SQL query results, as object-based rows provide explicit column labels. The release also depends on mcp version 2.1.1 or higher.

As the first non-alpha release, it has been used extensively by the author, indicating readiness for broader use. This change can enhance model accuracy when interpreting SQL outputs.

Source: https://simonwillison.net/2026/Sep/1/datasette-mcp/

Published Sep 1, 2026 · updated Sep 7, 2026 · 90 words

Keep reading

Related posts

More in LLMs

LLMs1 min read

Quoting Jakub Pachocki

The strongest argument I see for continuing to train much smarter models quickly is the need to build defensive systems against the dangers posed by other AI. [...] We will need powerful, aligned AI for defense; to secure infrastructure,...

LLMs1 min read

Mercator ↔ Equal Earth

Tool: Mercator ↔ Equal Earth I got curious about the Equal Earth map projection that was recently voted on at the UN so I had GPT-6 Astra (medium) in ChatGPT Work build me this animated transition between Mercator and Equal Earth using D...

datasette-mcp 0.2 updates execute_sql output to array of objects - OpenSmartRoute