Datasette API

Datasette API as documented publicly: 5 operations. Contract generated from the documentation by API Evangelist (2026-10-20); not the provider's own document.

Operations 5

GET /-/actor.json GET /-/actor.json #
GET /fixtures.db GET /fixtures.db #
POST /mydatabase/add_message Writable canned queries #
GET /teapot GET /teapot #
GET /{id}/{id}/{id}/404227475.geojson GET /{id}/{id}/{id}/404227475.geojson #

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API
curl "https://apis.io/api/v1/apis/datasette:datasette-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

datasette-openapi-generated.yml Raw ↑
openapi: 3.1.0
info:
  title: Datasette API
  version: '2026-10-20'
  description: 'GENERATED FROM DOCUMENTATION by API Evangelist on 2026-10-20: 5 operation(s) read from 7 public documentation page(s) (each operation
    names its page in x-source). This is not the provider''s published contract; Datasette has published no machine-readable contract that the
    pipeline could find. Engine: local.'
  x-evidence-tiers:
    code-example: 4
    documentation: 1
    pages-with-code: 6
    pages-read: 7
  x-generated-from: documentation
  x-provenance: generated
  x-authored-by: API Evangelist
  x-generated: '2026-10-20'
  x-generator: generate-contract-from-docs.py
  x-engine: local
  x-sources:
  - https://docs.datasette.io/en/stable/custom_templates.html
  - https://docs.datasette.io/en/stable/plugin_hooks.html
  - https://docs.datasette.io/en/stable/_sources/deploying.rst.txt
  - https://docs.datasette.io/en/stable/_sources/sql_queries.rst.txt
  - https://docs.datasette.io/en/stable/_sources/spatialite.rst.txt
  - https://docs.datasette.io/en/stable/_sources/custom_templates.rst.txt
  - https://docs.datasette.io/en/stable/_sources/plugin_hooks.rst.txt
servers:
- url: https://latest.datasette.io
paths:
  /-/actor.json:
    get:
      operationId: get_actor_json
      tags:
      - API
      summary: GET /-/actor.json
      x-source: https://docs.datasette.io/en/stable/plugin_hooks.html
      responses:
        '200':
          description: Success (shape read from the example response on the page)
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetActorJsonResponse'
      x-evidence:
        kind: code-example
        language: curl
        snippet: "curl -H 'Authorization: Bearer this-is-a-secret' http://localhost:8003/-/actor.json\n Instead of returning a dictionary, this\
          \ function can return an awaitable function which itself returns either None or a dictionary. This is useful for authentication functions\
          \ that need to make a database query - for example: \n from datasette import hookimpl \n @hookimpl \n def actor_from_request ( datasette\
          \ , reque"
  /fixtures.db:
    get:
      operationId: get_fixtures_db
      tags:
      - Fixtures
      summary: GET /fixtures.db
      x-source: https://docs.datasette.io/en/stable/_sources/deploying.rst.txt
      responses:
        '200':
          description: Success (status as documented)
      x-evidence:
        kind: code-example
        language: curl
        snippet: curl -O https://latest.datasette.io/fixtures.db
  /mydatabase/add_message:
    post:
      operationId: post_mydatabase_add_message
      tags:
      - Mydatabase
      summary: Writable canned queries
      x-source: https://docs.datasette.io/en/stable/_sources/sql_queries.rst.txt
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PostMydatabaseAddMessageRequest'
      responses:
        '201':
          description: Success (status as documented)
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PostMydatabaseAddMessageResponse'
      x-evidence:
        kind: documentation
  /teapot:
    get:
      operationId: get_teapot
      tags:
      - Teapot
      summary: GET /teapot
      x-source: https://docs.datasette.io/en/stable/custom_templates.html
      responses:
        '200':
          description: Success (status as documented)
      x-evidence:
        kind: code-example
        language: curl
        snippet: "curl -I 'http://127.0.0.1:8001/teapot'\nHTTP/1.1 418\ndate: Sun, 26 Apr 2020 18:38:30 GMT\nserver: uvicorn\nx-teapot: I am\n\
          content-type: text/html; charset=utf-8\n Returning 404s ¶ \n To indicate that content could not be found and display the default 404\
          \ page you can use the raise_404(message) function: \n {% if not rows %} \n {{ raise_404 ( \"Content not found\" ) }} \n {% endif %}\
          \ \n If you call raise_404("
  /{id}/{id}/{id}/404227475.geojson:
    get:
      operationId: get_id_id_id_404227475_geojson
      tags:
      - '404227475'
      summary: GET /{id}/{id}/{id}/404227475.geojson
      x-source: https://docs.datasette.io/en/stable/_sources/spatialite.rst.txt
      parameters:
      - name: id
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Success (status as documented)
      x-evidence:
        kind: code-example
        language: python
        snippet: "requests.get(\n        \"https://data.whosonfirst.org/404/227/475/404227475.geojson\"\n    )"
components:
  schemas:
    GetActorJsonResponse:
      type: object
      properties:
        max_id:
          type: integer
    PostMydatabaseAddMessageRequest:
      type: object
      properties:
        message:
          type: string
          description: The message to insert
      required:
      - message
    PostMydatabaseAddMessageResponse:
      type: object
      properties:
        ok:
          type: boolean
          description: Indicates success
        message:
          type: string
          description: Result message, e.g., "Query executed, 1 row affected"
        redirect:
          type: string
          description: Redirect path if applicable
  securitySchemes:
    bearer:
      type: http
      scheme: bearer
security:
- bearer: []
tags:
- name: '404227475'
- name: API
- name: Fixtures
- name: Mydatabase
- name: Teapot