gpt-config.md

Setting up a ChatGPT Action to access Datasette Cloud

Actions schema. Modify simon.datasette.cloud to your own instance:

openapi: 3.0.1
info:
  title: Datasette API
  description: Execute SQL queries against a Datasette database and return the results as JSON
  version: v1
servers:
  - url: https://simon.datasette.cloud
paths:
  /data.json:
    get:
      operationId: query
      summary: Execute a SQLite SQL query against the data database
      description: Accepts SQLite SQL query, returns JSON. Does not allow PRAGMA statements.
      parameters:
        - name: sql
          in: query
          description: The SQL query to be executed
          required: true
          schema:
            type: string
        - name: _shape
          in: query
          description: The shape of the response data. Must be "array"
          required: true
          schema:
            type: string
            enum:
              - array
      responses:
        "200":
          description: Successful SQL results
          content:
            application/json:
              schema:
                type: array
                items:
                  type: object
        "400":
          description: Bad request
        "500":
          description: Internal server error

Set authentication to API key, Auth Type to Bearer and paste in a Datasette Cloud API key.