Cloudflare Queries API

Execute SQL queries against D1 databases.

Documentation GitHub OpenAPI

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}.

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this

find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/cloudflare:cloudflare-queries-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

openapi: 3.2.0
info:
  title: Cloudflare D1 Queries API
  description: The Cloudflare D1 API provides endpoints for managing serverless SQL databases on Cloudflare's network. Developers can create, list, and delete databases, execute raw queries, import and export database contents, and use time travel to restore databases to previous states.
  version: '4.0'
  contact:
    name: Cloudflare Support
    url: https://support.cloudflare.com/
  termsOfService: https://www.cloudflare.com/terms/
servers:
- url: https://api.cloudflare.com/client/v4
  description: Cloudflare API v4 Production Server
security:
- bearerAuth: []
tags:
- name: Queries
  description: Execute SQL queries against D1 databases.
paths:
  /accounts/{account_id}/d1/database/{database_id}/query:
    post:
      operationId: queryD1Database
      summary: Cloudflare Query D1 Database
      description: Execute a SQL query against the D1 database. Returns results with metadata about the execution.
      tags:
      - Queries
      parameters:
      - $ref: '#/components/parameters/AccountId'
      - $ref: '#/components/parameters/DatabaseId'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              required:
              - sql
              properties:
                sql:
                  type: string
                  description: The SQL query to execute.
                params:
                  type: array
                  items:
                    oneOf:
                    - type: string
                    - type: number
                    - type: boolean
                    - type: 'null'
                  description: Bound parameters for the query.
            examples:
              Queryd1databaseRequestExample:
                summary: Default queryD1Database request
                x-microcks-default: true
                value:
                  sql: example_value
                  params:
                  - {}
      responses:
        '200':
          description: Query executed successfully.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/D1QueryResponse'
              examples:
                Queryd1database200Example:
                  summary: Default queryD1Database 200 response
                  x-microcks-default: true
                  value:
                    result:
                    - results:
                      - {}
                      success: true
                      meta:
                        changed_db: true
                        changes: 10
                        duration: 42.5
                        last_row_id: '500123'
                        rows_read: 10
                        rows_written: 10
                        size_after: 10
                    success: true
        '400':
          description: Bad request or SQL error.
        '401':
          description: Unauthorized.
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /accounts/{account_id}/d1/database/{database_id}/raw:
    post:
      operationId: rawQueryD1Database
      summary: Cloudflare Raw Query D1 Database
      description: Execute a raw SQL query optimized for performance. Returns results as arrays instead of objects.
      tags:
      - Queries
      parameters:
      - $ref: '#/components/parameters/AccountId'
      - $ref: '#/components/parameters/DatabaseId'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              required:
              - sql
              properties:
                sql:
                  type: string
                  description: The SQL query to execute.
                params:
                  type: array
                  items:
                    oneOf:
                    - type: string
                    - type: number
                    - type: boolean
                    - type: 'null'
                  description: Bound parameters for the query.
            examples:
              Rawqueryd1databaseRequestExample:
                summary: Default rawQueryD1Database request
                x-microcks-default: true
                value:
                  sql: example_value
                  params:
                  - {}
      responses:
        '200':
          description: Raw query executed successfully.
        '400':
          description: Bad request or SQL error.
        '401':
          description: Unauthorized.
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
components:
  parameters:
    AccountId:
      name: account_id
      in: path
      required: true
      description: The unique identifier of the Cloudflare account.
      schema:
        type: string
    DatabaseId:
      name: database_id
      in: path
      required: true
      description: The unique identifier of the D1 database.
      schema:
        type: string
  schemas:
    D1QueryResponse:
      type: object
      properties:
        result:
          type: array
          items:
            type: object
            properties:
              results:
                type: array
                items:
                  type: object
              success:
                type: boolean
              meta:
                type: object
                properties:
                  changed_db:
                    type: boolean
                  changes:
                    type: integer
                  duration:
                    type: number
                    description: Query duration in milliseconds.
                  last_row_id:
                    type: integer
                  rows_read:
                    type: integer
                  rows_written:
                    type: integer
                  size_after:
                    type: integer
          example: []
        success:
          type: boolean
          example: true
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      description: API token with D1 permissions.
externalDocs:
  description: Cloudflare D1 API Documentation
  url: https://developers.cloudflare.com/api/resources/d1/
x-provenance:
  method: harvested
  publisher: Cloudflare
  source: https://developers.cloudflare.com/openapi.json
  note: split by refine-openapis from the provider's own published document, verified by fetch (openapi/_original/*.fetch.json);
    stamped by stamp-openapi-provenance.py (roadmap#793)

Cloudflare Queries API

Operations 2

Documentation

Specifications

Schemas & Data

Other Resources