Update a database connection

PATCH

/api/databases/{id}

curl --request PATCH \
  --url https://gateway.example.com/api/databases/550e8400-e29b-41d4-a716-446655440000 \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{ "name": "example", "description": "example", "tags": [ "example" ], "manualSizeLimitMb": 1, "interactiveQueryBudgetSeconds": 1, "config": { "connectionString": "example", "url": "example", "host": "example", "port": 1, "database": "example", "username": "example", "password": "example", "sslEnabled": true, "db": 1, "tlsEnabled": true, "tlsVerifyCertificate": true, "tlsCaCertificate": "example" } }'

• Your Gateway instance

Authorizations

• bearerAuth

Parameters

Path Parameters

id

required

string

>= 1 characters

Example

550e8400-e29b-41d4-a716-446655440000

Request Body^required

JSON request body

Media typeapplication/json

object

name

string

>= 1 characters <= 255 characters

description

string | null

<= 10000 characters

tags

Array<string>

<= 32 items

manualSizeLimitMb

integer | null

> 0 <= 1048576

interactiveQueryBudgetSeconds

integer

>= 30 <= 600

config

object

connectionString

string

>= 1 characters <= 4096 characters

url

string

>= 1 characters <= 4096 characters

host

string

>= 1 characters <= 255 characters

port

integer

>= 1 <= 65535

database

string

>= 1 characters <= 255 characters

username

string

>= 1 characters <= 255 characters

password

string

<= 4096 characters

sslEnabled

boolean

db

integer

<= 15

tlsEnabled

boolean

tlsVerifyCertificate

Verify the server TLS certificate chain and hostname. Defaults to true for new connections; false disables verification (insecure).

boolean

tlsCaCertificate

PEM CA certificate bundle trusted instead of the public CA bundle, for servers issued by a private CA. Empty or null clears it.

string | null

<= 65536 characters

Example^generated

{
  "name": "example",
  "description": "example",
  "tags": [
    "example"
  ],
  "manualSizeLimitMb": 1,
  "interactiveQueryBudgetSeconds": 1,
  "config": {
    "connectionString": "example",
    "url": "example",
    "host": "example",
    "port": 1,
    "database": "example",
    "username": "example",
    "password": "example",
    "sslEnabled": true,
    "db": 1,
    "tlsEnabled": true,
    "tlsVerifyCertificate": true,
    "tlsCaCertificate": "example"
  }
}

Responses

200

Successful response

Media typeapplication/json

object

data

required

Resource object. Exact fields depend on the endpoint.

object

id

string

name

string

key

additional properties

Example

{
  "data": {
    "id": "550e8400-e29b-41d4-a716-446655440000",
    "name": "Production Postgres",
    "type": "postgres",
    "healthStatus": "online"
  }
}

400

Bad request

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "VALIDATION_ERROR",
  "message": "Request validation failed",
  "details": [
    {
      "path": [
        "name"
      ],
      "message": "Required"
    }
  ]
}

401

Authentication required

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "UNAUTHORIZED",
  "message": "Authentication required"
}

403

Forbidden

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "FORBIDDEN",
  "message": "Insufficient permissions"
}

404

Not found

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "NOT_FOUND",
  "message": "Resource not found"
}

409

Conflict

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "CONFLICT",
  "message": "Resource already exists"
}

422

Unprocessable entity

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "UNPROCESSABLE_ENTITY",
  "message": "Request could not be processed"
}

500

Internal server error

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "INTERNAL_ERROR",
  "message": "Internal server error"
}