Custom On-Chain SQL Query, Background Job (ClickHouse, Read-Only)

{
  "type": "object",
  "required": [
    "sql"
  ],
  "properties": {
    "sql": {
      "type": "string",
      "minLength": 1,
      "description": "Read-only ClickHouse SELECT/WITH query to execute as a durable background job. Same shape and rules as /onchain/sql. Rules (server-enforced or query-killing): SELECT/WITH only (read-only); table references must be database-qualified as agent.<table>; ALWAYS filter on block_date or block_number (partition key — without it the query times out); compare address columns directly against lowercase literals (wrapping the column in lower() is rejected); never filter on symbol columns (unindexed full scan, and symbol matches surface scam clones — resolve a ticker to a contract address with /search/token first); on transfer tables use separate UNION ALL branches instead of OR across from/to; use single quotes for strings, e.g. toDate('2026-04-07')."
    },
    "max_rows": {
      "type": "integer",
      "default": 1000,
      "maximum": 10000,
      "minimum": 1,
      "description": "Maximum result rows to retain. Example: 5000. Defaults to 1000 (server-side), capped at 10000."
    }
  },
  "additionalProperties": false
}

{
  "type": "object",
  "properties": {
    "data": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "trades": {
            "type": "number",
            "description": "Row count for the day, observed as the alias used in the real calibration query's count() column. Only present when the SELECT list computes it."
          },
          "block_date": {
            "type": "number",
            "description": "Unix seconds for the day bucket, observed when the query groups by a block_date column as in the real calibration query. Only present when the SELECT list includes it."
          },
          "volume_usd": {
            "type": [
              "number",
              "null"
            ],
            "description": "Summed USD volume for the day, observed as the alias used in the real calibration query's sum() column; observed null on one day in the real calibration query (a day with trades but no amount_usd values summed). Only present when the SELECT list computes it."
          }
        },
        "additionalProperties": true
      },
      "description": "Result rows, empty when the query legitimately matches nothing (observed with a query filtered on a future date). Column names depend entirely on the query's own SELECT list -- the fields below describe the one observed populated shape (a daily Ethereum DEX trade-count and volume aggregation), not a fixed schema."
    },
    "meta": {
      "type": "object",
      "properties": {
        "limit": {
          "type": "number",
          "description": "Effective row limit applied. Observed equal to the number of rows returned, not always echoing max_rows verbatim -- 0 on the empty-result fixture."
        },
        "total": {
          "type": "number",
          "description": "Total row count for the query, 0 when nothing matched."
        },
        "cached": {
          "type": "boolean"
        },
        "offset": {
          "type": "number"
        }
      },
      "additionalProperties": true
    }
  },
  "description": "The completed background job's query result.",
  "additionalProperties": true
}