---
title: "Settings a database"
method: PATCH
path: "/v1/databases/{id}/settings"
tags: ["Databases"]
---

# Settings a database

`PATCH /v1/databases/{id}/settings`

settings a database that user owns

## Path parameters

- `id` string, required

## Request body

- DatabasesSettings
  - `type` string
  - `options` object
    - `maxConnections` number
    - `netBufferLength` number
    - `selectLimit` number
    - `maxAllowedPacket` number
    - `connectTimeout` number
    - `maxJoinSize` number
    - `clientEncoding` string
    - `sharedBuffers` number

## Response `200`

Successful operation

## Other responses

- `400` — Bad request
- `401` — Missing authentication
- `404` — Database not found

## Changes

> 19 revisions in range; 1 not diffed.

- **2024-03-12** `1f0cf84ca7b3` — 8 warning, 1 info
  - removed the request property `clientEncoding`
  - removed the request property `connectTimeout`
  - removed the request property `maxAllowedPacket`
  - removed the request property `maxConnections`
  - …5 more
- **2024-03-11** `f2658eae9c45` — 1 info
  - endpoint added

[Change history](https://skmtc.dev/liara-cloud/apis/dbaas/changes/v1/databases/:id/settings/patch.md)

---

[API](https://skmtc.dev/liara-cloud/apis/dbaas.md) · [All operations](https://skmtc.dev/liara-cloud/apis/dbaas/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/liara-cloud/dbaas/revisions/6423b3e16f16/schema)