Query databases
Runs one SQL statement against a D1 database. It executes on the org's OWN Cloudflare account and relays D1's result set.
POST /v1/cloudflare/d1/databases/{database}/query
| Address | https://api.hanzo.ai/v1/cloudflare/d1/databases/{database}/query |
| Method | POST |
| Operation | post_cloudflare_d1_databases_by_database_query |
| Auth | Authorization: Bearer $HANZO_API_KEY |
Runs one SQL statement against a D1 database. It executes on the org's
OWN Cloudflare account and relays D1's result set. The body is checked for a
non-empty sql and then forwarded VERBATIM, so every field D1 accepts reaches D1
even though only two are named here.
Requires ORG ADMIN — a statement may INSERT, UPDATE or DROP, so a query takes the
write gate rather than the read one — and a caller who is only an org member is
refused 403. A missing sql is 400; 503 if the org has never connected a
Cloudflare token.
Request
3 fields, body application/json (required).
| Field | In | Type | Required | Description |
|---|---|---|---|---|
database | path | string | yes | |
params | body | any[] | — | Params are the statement's bound values, in the order its ? placeholders appear — a string, a number, a boolean or null, whatever the column takes. |
sql | body | string | — | SQL is the statement to run. |
Response
| Status | Body | Meaning |
|---|---|---|
200 | ok |
200 body — 1 field.
| Field | In | Type | Always | Description |
|---|---|---|---|---|
(body) | body | any | yes |
Failure carries the platform error shape — see Errors.
Examples
hanzo cloudflare d1 databases query <database>import { Configuration, CloudflareApi } from 'hanzoai';
const api = new CloudflareApi(new Configuration({ accessToken: process.env.HANZO_API_KEY }));
const { data } = await api.postCloudflareD1DatabasesByDatabaseQuery({ database: 'database', params: ["<params>"], sql: "<sql>" });from hanzoai.cloud import ApiClient, Configuration
from hanzoai.cloud.api import CloudflareApi
client = ApiClient(Configuration(access_token=os.environ["HANZO_API_KEY"]))
result = CloudflareApi(client).post_cloudflare_d1_databases_by_database_query(database='database', params=["<params>"], sql="<sql>")cfg := cloud.NewConfiguration()
cfg.AddDefaultHeader("Authorization", "Bearer "+os.Getenv("HANZO_API_KEY"))
client := cloud.NewAPIClient(cfg)
resp, _, err := client.CloudflareAPI.PostCloudflareD1DatabasesByDatabaseQuery(context.Background()).Execute()
if err != nil {
return err
}use hanzo_cloud::apis::{configuration::Configuration, cloudflare_api};
let mut cfg = Configuration::new();
cfg.bearer_access_token = std::env::var("HANZO_API_KEY").ok();
let result = cloudflare_api::post_cloudflare_d1_databases_by_database_query(&cfg, Default::default()).await?;import ai.hanzo.cloud.ApiClient;
import ai.hanzo.cloud.api.CloudflareApi;
ApiClient client = new ApiClient();
client.setRequestInterceptor(b -> b.header("Authorization", "Bearer " + System.getenv("HANZO_API_KEY")));
var result = new CloudflareApi(client).postCloudflareD1DatabasesByDatabaseQuery();curl -X POST https://api.hanzo.ai/v1/cloudflare/d1/databases/<database>/query \
-H "Authorization: Bearer $HANZO_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"params": [
"<params>"
],
"sql": "<sql>"
}'MCP reaches cloudflare through the cloudflare tool, which names its 33 operations with its own verbs — this one among them, under a name only MCP declares. describe explains any of them:
curl -X POST https://api.hanzo.ai/v1/mcp \
-H "Content-Type: application/json" \
-d '{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "describe",
"arguments": {
"op": "list_cloudflare_d1_databases"
}
}
}'How is this guide?