---
title: Export D1 Database as SQL
---
[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**
# Export D1 Database as SQL
POST/accounts/{account\_id}/d1/database/{database\_id}/export
Export the SQL contents of a D1 database and return a URL where they can be downloaded. Note: this process may take some time for larger DBs, during which your D1 will be unavailable to serve queries. To avoid blocking your DB unnecessarily, an in-progress export must be continually polled or will automatically cancel.
##### 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
##### P ath ParametersExpand Collapse
account\_id: string
Account identifier tag.
maxLength32
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20export%20%3E%20(params)%20default%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)%20export%20%3E%20(params)%20default%20%3E%20(param)%20database_id%20%3E%20(schema)>)
##### Body ParametersJSONExpand Collapse
output\_format: "polling"
Specifies that you will poll this endpoint until the export completes
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20export%20%3E%20(params)%200%20%3E%20(param)%20output_format%20%3E%20(schema)>)
current\_bookmark: optional string
To poll an in-progress export, provide the current bookmark (returned by your first polling response)
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20export%20%3E%20(params)%200%20%3E%20(param)%20current_bookmark%20%3E%20(schema)>)
dump\_options: optional object {no\_data, no\_schema, tables }
no\_data: optional boolean
Export only the table definitions, not their contents
Link to this property
no\_schema: optional boolean
Export only each table’s contents, not its definition
Link to this property
tables: optional array of string
Filter the export to just one or more tables. Passing an empty array is the same as not passing anything and means: export all tables.
Link to this property
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20export%20%3E%20(params)%200%20%3E%20(param)%20dump_options%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)%20export%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)%20export%20%3E%20(network%20schema)%20%3E%20(property)%20messages>)
result: object {at\_bookmark, error, messages, 4 more }
at\_bookmark: optional string
The current time-travel bookmark for your D1, used to poll for updates. Will not change for the duration of the export task.
Link to this property
error: optional string
Only present when status = ‘error’. Contains the error message.
Link to this property
messages: optional array of string
Logs since the last time you polled
Link to this property
result: optional object {filename, signed\_url }
Only present when status = ‘complete’
filename: optional string
The generated SQL filename.
Link to this property
signed\_url: optional string
The URL to download the exported SQL. Available for one hour.
Link to this property
Link to this property
status: optional "complete"or "error"
One of the following:
"complete"
Link to this property
"error"
Link to this property
Link to this property
success: optional boolean
Link to this property
type: optional "export"
Link to this property
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20export%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)%20export%20%3E%20(network%20schema)%20%3E%20(property)%20success>)
### Export D1 Database as SQL
HTTP
HTTPTypeScriptPythonGoTerraform
```
curl https://api.cloudflare.com/client/v4/accounts/$ACCOUNT_ID/d1/database/$DATABASE_ID/export \
-H 'Content-Type: application/json' \
-H "Authorization: Bearer $CLOUDFLARE_API_TOKEN" \
-d '{
"output_format": "polling"
}'
```
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": {
"at_bookmark": "at_bookmark",
"error": "error",
"messages": [
"string"
],
"result": {
"filename": "filename",
"signed_url": "signed_url"
},
"status": "complete",
"success": true,
"type": "export"
},
"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": {
"at_bookmark": "at_bookmark",
"error": "error",
"messages": [
"string"
],
"result": {
"filename": "filename",
"signed_url": "signed_url"
},
"status": "complete",
"success": true,
"type": "export"
},
"success": true
}
```