--- title: Raw D1 Database query --- [Skip to content](#_top) [API Reference](https://developers.cloudflare.com/api) [D1](https://developers.cloudflare.com/api/resources/d1) [Database](https://developers.cloudflare.com/api/resources/d1/subresources/database) Copy Markdown Open in **Claude**Open in **ChatGPT**Open in **Cursor** --- **Copy Markdown****View as Markdown** # Raw D1 Database query POST/accounts/{account\_id}/d1/database/{database\_id}/raw Execute a SQL query against a D1 database and return result rows as arrays rather than objects. This is a performance-optimized version of the /query endpoint. ##### Security

API Token

The preferred authorization scheme for interacting with the Cloudflare API. Create a token. **Example:**Authorization: Bearer Sn3lZJTBX6kkg7OdcBUAxOO963GEIyGQqnFTOFYY

API Email + API Key

The previous authorization scheme for interacting with the Cloudflare API, used in conjunction with a Global API key. **Example:**X-Auth-Email: user@example.com The previous authorization scheme for interacting with the Cloudflare API. When possible, use API tokens instead of Global API keys. **Example:**X-Auth-Key: 144c9defac04969c7bfad8efaa8ea194

##### Accepted Permissions (at least one required) `D1 Read``D1 Write` ##### P ath ParametersExpand Collapse account\_id: string Account identifier tag. maxLength32 [Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20raw%20%3E%20(params)%200%20%3E%20(param)%20account_id%20%3E%20(schema)>) database\_id: string D1 database identifier (UUID). [Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20raw%20%3E%20(params)%200%20%3E%20(param)%20database_id%20%3E%20(schema)>) ##### Body ParametersJSONExpand Collapse

body: object {sql, params } or object {batch } A single query object or a batch query object

One of the following:

D1SingleQuery object {sql, params } A single query with or without parameters

sql: string Your SQL query. Supports multiple statements, joined by semicolons, which will be executed as a batch. Link to this property params: optional array of string Link to this property

Link to this property

MultipleQueries object {batch }

batch: array of object {sql, params }

sql: string Your SQL query. Supports multiple statements, joined by semicolons, which will be executed as a batch. Link to this property params: optional array of string Link to this property

Link to this property

[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20raw%20%3E%20(params)%200%20%3E%20(param)%20body%20%3E%20(schema)>) ##### ReturnsExpand Collapse

errors: array of ResponseInfo { code, message, documentation\_url, source }

code: number minimum1000 Link to this property message: string Link to this property documentation\_url: optional string Link to this property

source: optional object {pointer }

pointer: optional string Link to this property

Link to this property

[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20raw%20%3E%20(network%20schema)%20%3E%20(property)%20errors>)

messages: array of ResponseInfo { code, message, documentation\_url, source }

code: number minimum1000 Link to this property message: string Link to this property documentation\_url: optional string Link to this property

source: optional object {pointer }

pointer: optional string Link to this property

Link to this property

[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20raw%20%3E%20(network%20schema)%20%3E%20(property)%20messages>)

result: array of object {meta, results, success }

meta: optional object {changed\_db, changes, duration, 8 more }

changed\_db: optional boolean Denotes if the database has been altered in some way, like deleting rows. Link to this property changes: optional number Rough indication of how many rows were modified by the query, as provided by SQLite’s sqlite3_total_changes(). Link to this property duration: optional number The duration of the SQL query execution inside the database. Does not include any network communication. Link to this property last\_row\_id: optional number The row ID of the last inserted row in a table with an INTEGER PRIMARY KEY as provided by SQLite. Tables created with WITHOUT ROWID do not populate this. Link to this property rows\_read: optional number Number of rows read during the SQL query execution, including indices (not all rows are necessarily returned). Link to this property rows\_written: optional number Number of rows written during the SQL query execution, including indices. Link to this property served\_by\_colo: optional string The three letters airport code of the colo that handled the query. Link to this property served\_by\_primary: optional boolean Denotes if the query has been handled by the database primary instance. Link to this property

served\_by\_region: optional "WNAM"or "ENAM"or "WEUR"or 3 more Region location hint of the database instance that handled the query.

One of the following: "WNAM" Link to this property "ENAM" Link to this property "WEUR" Link to this property "EEUR" Link to this property "APAC" Link to this property "OC" Link to this property

Link to this property size\_after: optional number Size of the database after the query committed, in bytes. Link to this property

timings: optional object {sql\_duration\_ms } Various durations for the query.

sql\_duration\_ms: optional number The duration of the SQL query execution inside the database. Does not include any network communication. Link to this property

Link to this property

results: optional object {columns, rows }

columns: optional array of string Link to this property

rows: optional array of array of numberor stringor unknown

One of the following: number Link to this property string Link to this property unknown Link to this property

Link to this property

Link to this property success: optional boolean Link to this property

[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20raw%20%3E%20(network%20schema)%20%3E%20(property)%20result>) success: true Whether the API call was successful [Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20raw%20%3E%20(network%20schema)%20%3E%20(property)%20success>) ### Raw D1 Database query HTTP HTTPTypeScriptPythonGoTerraform ``` curl https://api.cloudflare.com/client/v4/accounts/$ACCOUNT_ID/d1/database/$DATABASE_ID/raw \ -H 'Content-Type: application/json' \ -H "Authorization: Bearer $CLOUDFLARE_API_TOKEN" \ -d '{ "sql": "SELECT * FROM myTable WHERE field = ? OR field = ?;", "params": [ "firstParam", "secondParam" ] }' ``` 200 example ``` { "errors": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "messages": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "result": [ { "meta": { "changed_db": true, "changes": 0, "duration": 0, "last_row_id": 0, "rows_read": 0, "rows_written": 0, "served_by_colo": "LHR", "served_by_primary": true, "served_by_region": "EEUR", "size_after": 0, "timings": { "sql_duration_ms": 0 } }, "results": { "columns": [ "string" ], "rows": [ [ 0 ] ] }, "success": true } ], "success": true } ``` ##### Returns Examples 200 example ``` { "errors": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "messages": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "result": [ { "meta": { "changed_db": true, "changes": 0, "duration": 0, "last_row_id": 0, "rows_read": 0, "rows_written": 0, "served_by_colo": "LHR", "served_by_primary": true, "served_by_region": "EEUR", "size_after": 0, "timings": { "sql_duration_ms": 0 } }, "results": { "columns": [ "string" ], "rows": [ [ 0 ] ] }, "success": true } ], "success": true } ```