Release Note

You can now configure your MySQL, PostgreSQL, and Redis managed databases by making a PATCH request to /v2/databases/{database_cluster_uuid}/config. For example:

{
  "config": {
    "sql_mode": "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES",
    "sql_require_primary_key": true
  }
}

For more details, see the full reference documentation for the managed databases API.