--- title: Export D1 Database as SQL --- [Skip to content](#_top) [API Reference](https://developers.cloudflare.com/api/go) [D1](https://developers.cloudflare.com/api/go/resources/d1) [Database](https://developers.cloudflare.com/api/go/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 client.D1.Database.Export(ctx, databaseID, params) (\*[DatabaseExportResponse](), error) 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
##### ParametersExpand Collapse databaseID 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)>)
params DatabaseExportParams AccountID param.Field\[string] Path param: Account identifier tag. maxLength32 Link to this property
OutputFormat param.Field\[DatabaseExportParamsOutputFormat] Body param: Specifies that you will poll this endpoint until the export completes const DatabaseExportParamsOutputFormatPolling DatabaseExportParamsOutputFormat = "polling" Link to this property
Link to this property CurrentBookmark param.Field\[string]Optional Body param: To poll an in-progress export, provide the current bookmark (returned by your first polling response) Link to this property
DumpOptions param.Field\[DatabaseExportParamsDumpOptions]Optional Body param NoData boolOptional Export only the table definitions, not their contents Link to this property NoSchema boolOptional Export only each table’s contents, not its definition Link to this property Tables \[]stringOptional 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
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20export%20%3E%20(params)%20default>) ##### ReturnsExpand Collapse
type DatabaseExportResponse struct{…} AtBookmark stringOptional 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 stringOptional Only present when status = ‘error’. Contains the error message. Link to this property Messages \[]stringOptional Logs since the last time you polled Link to this property
Result DatabaseExportResponseResultOptional Only present when status = ‘complete’ Filename stringOptional The generated SQL filename. Link to this property SignedURL stringOptional The URL to download the exported SQL. Available for one hour. Link to this property
Link to this property
Status DatabaseExportResponseStatusOptional One of the following: const DatabaseExportResponseStatusComplete DatabaseExportResponseStatus = "complete" Link to this property const DatabaseExportResponseStatusError DatabaseExportResponseStatus = "error" Link to this property
Link to this property Success boolOptional Link to this property Type DatabaseExportResponseTypeOptional Link to this property
[Link to this property](<#(resource)%20d1.database%20%3E%20(model)%20DatabaseExportResponse%20%3E%20(schema)>) ### Export D1 Database as SQL Go HTTPTypeScriptPythonGoTerraform ``` package main import ( "context" "fmt" "github.com/cloudflare/cloudflare-go" "github.com/cloudflare/cloudflare-go/d1" "github.com/cloudflare/cloudflare-go/option" ) func main() { client := cloudflare.NewClient( option.WithAPIToken("Sn3lZJTBX6kkg7OdcBUAxOO963GEIyGQqnFTOFYY"), ) response, err := client.D1.Database.Export( context.TODO(), "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx", d1.DatabaseExportParams{ AccountID: cloudflare.F("023e105f4ecef8ad9ca31a8372d0c353"), OutputFormat: cloudflare.F(d1.DatabaseExportParamsOutputFormatPolling), }, ) if err != nil { panic(err.Error()) } fmt.Printf("%+v\n", response.AtBookmark) } ``` 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 } ```