Run query
run_queryQuery one dataset with Apache DataFusion SQL (https://datafusion.apache.org/user-guide/sql/). Use raw_sql for joins, subqueries, CTEs and window functions. A slow query returns a query ID in place of rows.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"dataset": "<dataset>",
"description": "<description>"
},
"name": "run_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Default: 100. | |
| since | No | Required unless you pass raw_sql. | |
| until | No | End: a duration ago or ISO 8601. Default: now. | |
| where | No | A SQL condition, e.g. "resource.service.name = 'api' AND status_code = 2". | |
| select | No | Default: *. E.g. "name, count(*) AS n". | |
| dataset | Yes | A dataset name. | |
| raw_sql | No | A whole query, in place of the other clauses. Refer to the dataset as __table__. Bound time yourself: WHERE timestamp_unix_ns >= <ns> AND timestamp_unix_ns <= <ns>. | |
| group_by | No | ||
| order_by | No | ||
| description | Yes | A short label for what the query is about, e.g. "checkout errors by route, last hour". |