Update database settings
Authorization
A service token or OAuth token must have at least one of the following access or scopes in order to use this API endpoint:
Service Token Accesses write_database
OAuth Scopes
| Resource | Scopes |
|---|---|
| Organization | write_databases |
| Database | write_database |
Path parameters
Organization name slug from list_organizations. Example: acme.
Database name slug from list_databases. Example: app-db.
Request body
The name to update the database to
Whether or not to copy migration data to new branches and in deploy requests. (Vitess only)
A migration framework to use on the database. (Vitess only)
Name of table to use as migration table for the database. (Vitess only)
Whether or not deploy requests must be approved by a database administrator other than the request creator
Whether or not to limit branch creation to the same region as the one selected during database creation.
Whether or not data branching is allowed on the database. (Vitess only)
Whether or not foreign key constraints are allowed on the database. (Vitess only)
Whether or not full queries should be collected from the database
Whether or not the web console can be used on the production branch of the database
The default branch of the database
Response
Returns the updated database
The ID of the database
The URL to the database API endpoint
The URL to retrieve this database's branches via the API
The total number of database branches
The total number of schema recommendations
The total number of database development branches
The total number of database production branches
The total number of ongoing issues within a database
If the database requires multiple admins for deletion
If the database is ready to be used
If the database has reached its backup restored branch limit
If the database has reached its development branch limit
The URL to see this database's branches in the web UI
Name of the database
State of the database
If the database is sharded
Number of shards in the default branch
Number of read only regions in the default branch
Number of tables in the default branch schema
The default branch for the database
Whether an approval is required to deploy schema changes to this database
True if a branch is currently resizing
True if a branch has a queued resize request
True if a config change is in progress
True if a config change is queued for maintenance window
Whether seeding branches with data is enabled for all branches
Whether foreign key constraints are enabled
Whether to automatically manage Rails migrations during deploy requests.
Whether to restrict branch creation to one region
Whether raw SQL queries are collected
The database plan
True if query insights is enabled for the database
Whether web console is enabled for production branches
Table name to use for copying schema migration data.
Framework used for applying migrations.
When the database was created
When the database was last updated
When the default branch schema was last changed.
The kind of database