Home / Servers / Cloudflare API / sql_api_query_post_account_scoped
Query analytics datasets
An MCP tool from the Cloudflare API server, hosted on mcp.hjlabs.in.
Query analytics datasets Executes a SQL query scoped to the account in the request path. API Gateway preserves the account… [POST /accounts/{account_id}/analytics/sql]
Name on the gateway: cloudflare_api__sql_api_query_post_account_scoped · may change things.
Parameters
| Name | Type | Description |
|---|---|---|
account_id required | string | account_id parameter |
params | array | Positional array values for $1, $2, and similar… |
query required | string | SQL query to execute. A trailing FORMAT selects… |
scope | object | Account or zone scope applied to the query.… |
time_range | object | Time bounds applied to the dataset's timestamp… |
How to call it
Through the Smart Gateway, any client can run it by name with call_tool, or let the gateway find it with search_tools:
{
"name": "cloudflare_api__sql_api_query_post_account_scoped",
"arguments": {
"account_id": "…",
"query": "…"
}
}Or connect the Cloudflare API server directly, which lists 3,127 tools including this one:
claude mcp add --transport http hj-cloudflare-api https://mcp.hjlabs.in/mcp/cloudflare-api \
--header "Authorization: Bearer YOUR_API_KEY"Try asking
Use the query analytics datasets tool with account_id set to ….