query_clickhouse
Run read-only SQL queries against ClickHouse telemetry data to analyze product usage, version distribution, deployment types, and cluster metrics.
Instructions
Run a read-only SQL query against ClickHouse (telemetry data).
Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed. Results are capped at 500 rows by default.
Use this for product telemetry: active instances, version distribution, storage engines, deployment types, CPU architecture, cluster metrics.
Args: sql: A read-only SQL statement.
Examples: - SELECT count() FROM telemetry WHERE product = 'MySQL' - SELECT version, count() as n FROM telemetry GROUP BY version ORDER BY n DESC - SHOW TABLES
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": {
"sql": "<sql>"
},
"name": "query_clickhouse"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |