datasette 1.0a33

Simon Willison's Blog Tools
datasette alpha-release json-api open-source data-exploration tooling

Summary

Datasette 1.0a33 extends the `?_extra=` pattern to queries and rows, improving JSON API extensibility and documentation, with a custom API explorer built by AI tools.

No content available
Original Article
View Cached Full Text

Cached at: 06/11/26, 09:35 PM

# Release: datasette 1.0a33 Source: [https://simonwillison.net/2026/Jun/11/datasette/](https://simonwillison.net/2026/Jun/11/datasette/) This alpha is a significant step on the road to a stable 1\.0, finally extending the`?\_extra=`pattern I introduced[in Datasette 1\.0a3](https://docs.datasette.io/en/1.0a3/changelog.html#a3-2023-08-09)to cover queries and rows in addition to tables\. That pattern is also[now documented](https://docs.datasette.io/en/latest/json_api.html#expanding-json-responses)\! I wrote a whole lot more about the new release on the Datasette project blog:**[Datasette 1\.0a33 with JSON extras in the API](http://datasette.io/blog/2026/api-extras/)**\. Because API explorer tools are almost free to build now I had Claude Fable 5 in Claude Code \(for[the plan](https://gist.github.com/simonw/d8bf1a8f36e28fbd595cede946e0ab6d)\) and GPT\-5\.5 xhigh in Codex Desktop \(for[the implementation](https://gist.github.com/simonw/12d5e09797072a6807d7b9cfcc8ff6b7)\) build me this[custom extras API explorer](https://tools.simonwillison.net/datasette-extras-explorer)to help demonstrate the feature: ![Screenshot of a web application titled "Datasette extras explorer". A URL input field contains https://latest.datasette.io/fixtures/facetable.json with a teal Explore button next to it. Below, a left panel labeled EXTRAS (30) lists checkboxes: all_columns - All columns in the table, regardless of _col/_nocol filtering; column_types - Column type assignments for this table; columns (checked) - Column names returned by this query; count - Total count of rows matching these filters; count_sql - SQL query used to calculate the total count; custom_table_templates - Custom template names considered for this table; database - Database name; database_color - Color assigned to the database. A right panel labeled RESPONSE shows GET /fixtures/fac… with Copy JSON and Copy URL buttons, then a dark JSON viewer showing 200 - 9.9 KB - 114ms and JSON: "ok": true, "next": null, "columns": (highlighted array) "pk", "created", "planet_int", "on_earth", "state", "_city_id", "_neighborhood", "tags", "complex_array", "distinct_some_null", "n", "rows": list of objects.](https://static.simonwillison.net/static/2026/extras-explorer.png)

Similar Articles

Back-to-school season is about to change everything! A 37,000-star open-source tutor has arrived, offering lifelong personalized tutoring, integrating tutoring, problem-solving, quizzes, research, visualization, and mastery practice into a single workspace! Can AI only chat but not teach? Do materials, question banks, video courses, and error review still need to be handled separately? DeepTutor is an agent-native learning workspace, and its core is...

X AI KOLs Timeline

DeepTutor is an open-source, AI-driven learning workspace that integrates tutoring, problem-solving, quizzes, and more, offering a lifelong personalized learning experience.

Aiki Alpha 3 Released - Performance Improved

Lobsters Hottest

Aiki Alpha 3 is released with substantial performance improvements, including cheaper runtime realization, adaptive number representations, enhanced profiling and coverage, and stricter library constraints.