Cloudflare Queries API
Execute SQL queries against D1 databases.
Operations 2
Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay
POST
/accounts/{account_id}/d1/database/{database_id}/query
Run a SQL query against a D1 database · Cloudflare Query D1 Database
#
Ask an LLM
“How do I run a SQL statement against my D1 database over the API?”
“Can I use bound parameters to avoid SQL injection in D1 queries?”
Tell an agent
Run the SQL {sql} on D1 database {database} in account {account}.
Execute {sql} with parameters {params} against D1 database {database}, account {account}, returning rows as objects.
POST
/accounts/{account_id}/d1/database/{database_id}/raw
Run a raw SQL query returning array rows · Cloudflare Raw Query D1 Database
#
Ask an LLM
“Is there a faster D1 query mode that returns rows as arrays instead of objects?”
“How do I get compact array results from a D1 SQL query?”
Tell an agent
Run raw SQL {sql} on D1 database {database} in account {account}, returning rows as arrays.
Execute {sql} with parameters {params} in raw array mode on D1 database {database}, account {account}.
Documentation
Documentation
https://developers.cloudflare.com/api/
GettingStarted
https://developers.cloudflare.com/fundamentals/api/get-started/
Authentication
https://developers.cloudflare.com/fundamentals/api/get-started/create-token/
RateLimits
https://developers.cloudflare.com/fundamentals/api/reference/limits/
Documentation
https://developers.cloudflare.com/api/operations/accounts-list-accounts
APIReference
https://developers.cloudflare.com/api/resources/accounts/
APIReference
https://developers.cloudflare.com/ssl/
Documentation
https://developers.cloudflare.com/api/operations/ip-access-rules-for-a-user-list-ip-access-rules
Documentation
https://developers.cloudflare.com/api/operations/user'-s-account-memberships-list-memberships
Documentation
https://developers.cloudflare.com/api/operations/radar-get-search-global
APIReference
https://developers.cloudflare.com/radar/
GettingStarted
https://developers.cloudflare.com/radar/get-started/
Documentation
https://developers.cloudflare.com/api/operations/user-user-details
APIReference
https://developers.cloudflare.com/api/resources/user/
Documentation
https://developers.cloudflare.com/api/operations/zones-get
APIReference
https://developers.cloudflare.com/api/resources/zones/
Documentation
https://developers.cloudflare.com/dns/
APIReference
https://developers.cloudflare.com/api/resources/dns/
Documentation
https://developers.cloudflare.com/workers/
APIReference
https://developers.cloudflare.com/api/resources/workers/
GettingStarted
https://developers.cloudflare.com/workers/get-started/
Documentation
https://developers.cloudflare.com/workers-ai/
GettingStarted
https://developers.cloudflare.com/workers-ai/get-started/rest-api/
APIReference
https://developers.cloudflare.com/workers-ai/configuration/open-ai-compatibility/
APIReference
https://developers.cloudflare.com/workers-ai/models/
Documentation
https://developers.cloudflare.com/ai-gateway/
APIReference
https://developers.cloudflare.com/ai-gateway/usage/providers/
GettingStarted
https://developers.cloudflare.com/ai-gateway/get-started/
Documentation
https://developers.cloudflare.com/r2/
APIReference
https://developers.cloudflare.com/r2/api/s3/api/
GettingStarted
https://developers.cloudflare.com/r2/get-started/
Documentation
https://developers.cloudflare.com/d1/
APIReference
https://developers.cloudflare.com/api/resources/d1/
GettingStarted
https://developers.cloudflare.com/d1/get-started/
Documentation
https://developers.cloudflare.com/kv/
APIReference
https://developers.cloudflare.com/api/resources/kv/
GettingStarted
https://developers.cloudflare.com/kv/get-started/
Documentation
https://developers.cloudflare.com/queues/
APIReference
https://developers.cloudflare.com/api/resources/queues/
GettingStarted
https://developers.cloudflare.com/queues/get-started/
Documentation
https://developers.cloudflare.com/durable-objects/
GettingStarted
https://developers.cloudflare.com/durable-objects/get-started/
APIReference
https://developers.cloudflare.com/durable-objects/api/
Documentation
https://developers.cloudflare.com/vectorize/
GettingStarted
https://developers.cloudflare.com/vectorize/get-started/intro/
APIReference
https://developers.cloudflare.com/vectorize/reference/client-api/
Documentation
https://developers.cloudflare.com/pages/
APIReference
https://developers.cloudflare.com/pages/configuration/api/
GettingStarted
https://developers.cloudflare.com/pages/get-started/
Documentation
https://developers.cloudflare.com/stream/
GettingStarted
https://developers.cloudflare.com/stream/get-started/
APIReference
https://developers.cloudflare.com/api/resources/stream/
Documentation
https://developers.cloudflare.com/images/
GettingStarted
https://developers.cloudflare.com/images/get-started/
APIReference
https://developers.cloudflare.com/api/resources/images/
Documentation
https://developers.cloudflare.com/turnstile/
GettingStarted
https://developers.cloudflare.com/turnstile/get-started/
APIReference
https://developers.cloudflare.com/api/resources/turnstile/
Documentation
https://developers.cloudflare.com/logs/
APIReference
https://developers.cloudflare.com/api/resources/logpush/
GettingStarted
https://developers.cloudflare.com/logs/get-started/
Documentation
https://developers.cloudflare.com/hyperdrive/
APIReference
https://developers.cloudflare.com/api/resources/hyperdrive/
GettingStarted
https://developers.cloudflare.com/hyperdrive/get-started/
Specifications
OpenAPI
https://artifacts.apis.io/cloudflare/openapi/cloudflare-queries-api-openapi.yml
AsyncAPI
https://artifacts.apis.io/cloudflare/asyncapi/cloudflare-notifications-webhooks-asyncapi.yml
AsyncAPI
https://artifacts.apis.io/cloudflare/asyncapi/cloudflare-stream-webhooks-asyncapi.yml
Schemas & Data
JSONSchema
https://artifacts.apis.io/cloudflare/json-schema/cloudflare-d1-query-response-schema.json