Datasette API

{
  "openapi": "3.0.1",
  "servers": [
    {
      "url": "http://datasette.local"
    },
    {
      "url": "https://datasette.io"
    }
  ],
  "info": {
    "description": "Execute SQL queries against a Datasette database and return the results as JSON",
    "title": "Datasette API",
    "version": "v1",
    "x-apisguru-categories": [
      "developer_tools"
    ],
    "x-origin": [
      {
        "format": "openapi",
        "url": "https://datasette.io/-/chatgpt-openapi-schema.yml",
        "version": "3.0"
      }
    ],
    "x-providerName": "datasette.local",
    "x-logo": {
      "url": "https://api.apis.guru/v2/cache/logo/https_apis.guru_assets_images_no-logo.svg"
    }
  },
  "paths": {
    "/content.json": {
      "get": {
        "description": "Accepts SQLite SQL query, returns JSON. Does not allow PRAGMA statements.",
        "operationId": "query",
        "parameters": [
          {
            "description": "The SQL query to be executed",
            "in": "query",
            "name": "sql",
            "required": true,
            "schema": {
              "type": "string"
            }
          },
          {
            "description": "The shape of the response data. Must be \"array\"",
            "in": "query",
            "name": "_shape",
            "required": true,
            "schema": {
              "enum": [
                "array"
              ],
              "type": "string"
            }
          }
        ],
        "responses": {
          "200": {
            "content": {
              "application/json": {
                "schema": {
                  "items": {
                    "type": "object"
                  },
                  "type": "array"
                }
              }
            },
            "description": "Successful SQL results"
          },
          "400": {
            "description": "Bad request"
          },
          "500": {
            "description": "Internal server error"
          }
        },
        "summary": "Execute a SQLite SQL query against the content database"
      }
    }
  }
}