---
title: Update D1 Database
---
[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**
# Update D1 Database
PUT/accounts/{account\_id}/d1/database/{database\_id}
Update a D1 database’s configuration.
##### 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 Write`
##### P ath ParametersExpand Collapse
account\_id: string
Account identifier tag.
maxLength32
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20update%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)%20update%20%3E%20(params)%20default%20%3E%20(param)%20database_id%20%3E%20(schema)>)
##### Body ParametersJSONExpand Collapse
read\_replication: object {mode }
Configuration for D1 read replication.
mode: "auto"or "disabled"
The read replication mode for the database. Use ‘auto’ to create replicas and allow D1 automatically place them around the world, or ‘disabled’ to not use any database replicas (it can take a few hours for all replicas to be deleted).
One of the following:
"auto"
Link to this property
"disabled"
Link to this property
Link to this property
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20update%20%3E%20(params)%200%20%3E%20(param)%20read_replication%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)%20update%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)%20update%20%3E%20(network%20schema)%20%3E%20(property)%20messages>)
result: D1 { created\_at, file\_size, jurisdiction, 5 more }
The details of the D1 database.
created\_at: optional string
Specifies the timestamp the resource was created as an ISO8601 string.
formatdate-time
Link to this property
file\_size: optional number
The D1 database’s size, in bytes.
Link to this property
jurisdiction: optional "eu"or "fedramp"or "us"
Specify the location to restrict the D1 database to run and store data. If this option is present, the location hint is ignored.
One of the following:
"eu"
Link to this property
"fedramp"
Link to this property
"us"
Link to this property
Link to this property
name: optional string
D1 database name.
Link to this property
Deprecatednum\_tables: optional number
The number of tables in the D1 database. This count is no longer accurate and should not be relied upon.
Link to this property
read\_replication: optional object {mode }
Configuration for D1 read replication.
mode: "auto"or "disabled"
The read replication mode for the database. Mode ‘auto’ denotes that D1 creates replicas and automatically places them around the world. Mode ‘disabled’ denotes that no database replicas are used.
One of the following:
"auto"
Link to this property
"disabled"
Link to this property
Link to this property
Link to this property
uuid: optional string
D1 database identifier (UUID).
Link to this property
version: optional string
Link to this property
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20update%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)%20update%20%3E%20(network%20schema)%20%3E%20(property)%20success>)
### Update D1 Database
HTTP
HTTPTypeScriptPythonGoTerraform
```
curl https://api.cloudflare.com/client/v4/accounts/$ACCOUNT_ID/d1/database/$DATABASE_ID \
-X PUT \
-H 'Content-Type: application/json' \
-H "Authorization: Bearer $CLOUDFLARE_API_TOKEN" \
-d '{
"read_replication": {
"mode": "auto"
}
}'
```
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": {
"created_at": "2022-11-15T18:25:44.442097Z",
"file_size": 12,
"jurisdiction": "eu",
"name": "my-database",
"num_tables": 12,
"read_replication": {
"mode": "auto"
},
"uuid": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"version": "production"
},
"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": {
"created_at": "2022-11-15T18:25:44.442097Z",
"file_size": 12,
"jurisdiction": "eu",
"name": "my-database",
"num_tables": 12,
"read_replication": {
"mode": "auto"
},
"uuid": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"version": "production"
},
"success": true
}
```