---
title: "Update database settings"
method: PATCH
path: "/organizations/{organization}/databases/{database}"
tags: ["Databases"]
---

# Update database settings

`PATCH /organizations/{organization}/databases/{database}`

### 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` string, required
- `database` string, required

## Request body

- object
  - `new_name` string — The name to update the database to
  - `automatic_migrations` boolean — Whether or not to copy migration data to new branches and in deploy requests. (Vitess only)
  - `migration_framework` string — A migration framework to use on the database. (Vitess only)
  - `migration_table_name` string — Name of table to use as migration table for the database. (Vitess only)
  - `require_approval_for_deploy` boolean — Whether or not deploy requests must be approved by a database administrator other than the request creator
  - `restrict_branch_region` boolean — Whether or not to limit branch creation to the same region as the one selected during database creation.
  - `allow_data_branching` boolean — Whether or not data branching is allowed on the database. (Vitess only)
  - `allow_foreign_key_constraints` boolean — Whether or not foreign key constraints are allowed on the database. (Vitess only)
  - `insights_raw_queries` boolean — Whether or not full queries should be collected from the database
  - `production_branch_web_console` boolean — Whether or not the web console can be used on the production branch of the database
  - `default_branch` string — The default branch of the database

## Response `200`

Returns the updated database

- object
  - `id` string, required — The ID of the database
  - `url` string, required — The URL to the database API endpoint
  - `branches_url` string, required — The URL to retrieve this database's branches via the API
  - `branches_count` integer, required — The total number of database branches
  - `open_schema_recommendations_count` integer, required — The total number of schema recommendations
  - `development_branches_count` integer, required — The total number of database development branches
  - `production_branches_count` integer, required — The total number of database production branches
  - `issues_count` integer, nullable — The total number of ongoing issues within a database
  - `multiple_admins_required_for_deletion` boolean, required — If the database requires multiple admins for deletion
  - `ready` boolean, required — If the database is ready to be used
  - `at_backup_restore_branches_limit` boolean, required — If the database has reached its backup restored branch limit
  - `at_development_branch_usage_limit` boolean, required — If the database has reached its development branch limit
  - `data_import` object, nullable
    - `state` string, required — State of the data import
    - `import_check_errors` string, required — Errors encountered during the import check
    - `started_at` string, nullable, required — When the import started
    - `finished_at` string, nullable, required — When the import finished
    - `data_source` object, required
      - `hostname` string, required — Hostname of the data source
      - `port` integer, required — Port of the data source
      - `database` string, required — Database name of the data source
  - `region` object, required
    - `id` string, required — The ID of the region
    - `provider` string, required — Provider for the region (ex. AWS)
    - `enabled` boolean, required — Whether or not the region is currently active
    - `public_ip_addresses` string[], required — Public IP addresses for the region
    - `display_name` string, required — Name of the region
    - `location` string, required — Location of the region
    - `slug` string, required — The slug of the region
    - `current_default` boolean, required — True if the region is the default for new branch creation
    - `mysql_supported` boolean, required — Whether the region supports MySQL/Vitess databases
    - `postgresql_supported` boolean, required — Whether the region supports PostgreSQL databases
  - `html_url` string, required — The URL to see this database's branches in the web UI
  - `name` string, required — Name of the database
  - `state` 'pending' | 'importing' | 'sleep_in_progress' | 'sleeping' | 'awakening' | 'import_ready' | 'ready', required — State of the database
  - `sharded` boolean, required — If the database is sharded
  - `default_branch_shard_count` integer, required — Number of shards in the default branch
  - `default_branch_read_only_regions_count` integer, required — Number of read only regions in the default branch
  - `default_branch_table_count` integer, required — Number of tables in the default branch schema
  - `default_branch` string, required — The default branch for the database
  - `require_approval_for_deploy` boolean, required — Whether an approval is required to deploy schema changes to this database
  - `resizing` boolean, required — True if a branch is currently resizing
  - `resize_queued` boolean, required — True if a branch has a queued resize request
  - `config_changing` boolean, required — True if a config change is in progress
  - `config_change_queued` boolean, required — True if a config change is queued for maintenance window
  - `allow_data_branching` boolean, required — Whether seeding branches with data is enabled for all branches
  - `foreign_keys_enabled` boolean, required — Whether foreign key constraints are enabled
  - `automatic_migrations` boolean, nullable — Whether to automatically manage Rails migrations during deploy requests.
  - `restrict_branch_region` boolean, required — Whether to restrict branch creation to one region
  - `insights_raw_queries` boolean, required — Whether raw SQL queries are collected
  - `plan` string, required — The database plan
  - `insights_enabled` boolean, required — True if query insights is enabled for the database
  - `production_branch_web_console` boolean, required — Whether web console is enabled for production branches
  - `migration_table_name` string, nullable — Table name to use for copying schema migration data.
  - `migration_framework` string, nullable — Framework used for applying migrations.
  - `created_at` string, required — When the database was created
  - `updated_at` string, required — When the database was last updated
  - `schema_last_updated_at` string, nullable, required — When the default branch schema was last changed.
  - `kind` 'mysql' | 'postgresql', required — The kind of database

## Other responses

- `401` — Unauthorized
- `403` — Forbidden
- `404` — Not Found
- `500` — Internal Server Error

---

[API](https://skmtc.net/planetscale/apis/planetscale-api.md) · [All operations](https://skmtc.net/planetscale/apis/planetscale-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/planetscale/planetscale-api/versions/fa19f3305241/schema)