CAcaveman

POST /projects/{projectId}/sql

POST /api/v1/projects/{projectId}/sql on the Caveman Cloud control plane. Requires the trace:read_metadata scope. Exposed to autonomous agents as the query action of the caveman_sql tool (read access). One read-only ClickHouse SELECT over the bound project's SQL tables (requests, spans, tool_events, evals, logs, errors, events). The database pins the tenant and the window. Read sql.schema first. Per-person columns need billing:read; payload columns need payload:read and trace:read_payload. Results are bounded, never paged by re-running.

post/projects/{projectId}/sql

Request

  • Base URL
    https://api.caveman.so/api/v1
  • URL
    https://api.caveman.so/api/v1/projects/{projectId}/sql
  • Auth
    • OAuth 2
      Authorization code: /api/v1/oauth/authorize
      Token URL: /api/v1/oauth/token scopes: trace:read_metadata
    • or HTTP bearer
    • or API key in cookie cave_access
    • or API key in cookie __Secure-cave_identity.session_token

Request body

sqlstring required

One ClickHouse SELECT over the SQL tables that sql.schema lists. Bind values as {name:Type} placeholders.

paramsobject

Values for the {name:Type} placeholders; names may not start with cave_ or param_.

windowstring

Look back from now, 1h to 90d. Send window or from/to; neither reads the last 7 days.

fromstring

UTC start, RFC3339 or YYYY-MM-DD; at most 90 days before to.

tostring

UTC end, RFC3339 or YYYY-MM-DD; defaults to now.

Response

Successful response. Exact status depends on synchronous or durable delivery outcome.

Changes

No recorded changes to this operation across all 1 revision of this API.