API Reference

Projects

Copy Markdown

Open in Claude

Open in ChatGPT

Open in Cursor

---

Copy Markdown

View as Markdown

Services

Manage services and their associated actions.

List All Services

GET/projects/{project_id}/services

Create a Service

POST/projects/{project_id}/services

Get a Service

GET/projects/{project_id}/services/{service_id}

Delete a Service

DELETE/projects/{project_id}/services/{service_id}

Start a Service

POST/projects/{project_id}/services/{service_id}/start

Stop a Service

POST/projects/{project_id}/services/{service_id}/stop

Attach Service to VPC

POST/projects/{project_id}/services/{service_id}/attachToVPC

Detach Service from VPC

POST/projects/{project_id}/services/{service_id}/detachFromVPC

Resize a Service

POST/projects/{project_id}/services/{service_id}/resize

Enable Connection Pooler for a Service

POST/projects/{project_id}/services/{service_id}/enablePooler

Disable Connection Pooler for a Service

POST/projects/{project_id}/services/{service_id}/disablePooler

Fork a Service

POST/projects/{project_id}/services/{service_id}/forkService

Update Service Password

POST/projects/{project_id}/services/{service_id}/updatePassword

Set Environment for a Service

POST/projects/{project_id}/services/{service_id}/setEnvironment

Get service logs

GET/projects/{project_id}/services/{service_id}/logs

Change HA configuration for a Service

POST/projects/{project_id}/services/{service_id}/setHA

ModelsExpand Collapse

ConnectionPooler object { endpoint }

Connection pooler configuration for a service.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

Endpoint object { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

EnvironmentTag = "DEV" or "PROD"

The environment tag for the service.

One of the following:

"DEV"

"PROD"

ResizeInput object { cpu_millis, memory_gbs }

Parameters for resizing a service.

cpu_millis: string

The new CPU allocation in milli-cores.

memory_gbs: string

The new memory allocation in gigabytes.

Service object { created, name, project_id, 14 more }

A database service and its current configuration.

created: string

Creation timestamp.

formatdate-time

name: string

The name of the service.

project_id: string

The project this service belongs to.

region_code: string

The cloud region where the service is hosted.

resources: array of object { id, spec }

List of resources allocated to the service.

id: optional string

Resource identifier.

spec: optional object { cpu_millis, memory_gbs, volume_type }

Resource specification.

cpu_millis: optional number

CPU allocation in millicores.

memory_gbs: optional number

Memory allocation in gigabytes.

volume_type: optional string

Type of storage volume.

service_id: string

The unique identifier for the service.

service_type: "TIMESCALEDB" or "POSTGRES" or "VECTOR"

The type of the service.

One of the following:

"TIMESCALEDB"

"POSTGRES"

"VECTOR"

status: "QUEUED" or "DELETING" or "CONFIGURING" or 8 more

The current deployment status of the service.

One of the following:

"QUEUED"

"DELETING"

"CONFIGURING"

"READY"

"DELETED"

"UNSTABLE"

"PAUSING"

"PAUSED"

"RESUMING"

"UPGRADING"

"OPTIMIZING"

connection_pooler: optional ConnectionPooler { endpoint }

Connection pooler configuration for a service.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

forked_from: optional object { is_standby, project_id, service_id }

The service this service was forked from.

is_standby: optional boolean

Whether this service is a standby of the parent service.

project_id: optional string

The project of the parent service.

service_id: optional string

The ID of the parent service.

ha_replicas: optional object { replica_count, sync_replica_count }

High-availability replica configuration for a service.

replica_count: optional number

Number of high-availability replicas (all replicas are asynchronous by default).

sync_replica_count: optional number

Number of synchronous high-availability replicas.

initial_password: optional string

The initial password for the service.

formatpassword

metadata: optional object { environment }

Additional metadata for the service.

environment: optional string

Environment tag for the service.

metrics: optional object { memory_mb, milli_cpu, storage_mb }

Resource usage metrics for the service.

memory_mb: optional number

Memory usage in megabytes.

milli_cpu: optional number

CPU usage in millicores.

storage_mb: optional number

Storage usage in megabytes.

read_replica_sets: optional array of ReadReplicaSet { id, cpu_millis, memory_gbs, 6 more }

The read replica sets attached to the service.

id: string

The unique identifier for the read replica set.

cpu_millis: number

CPU allocation in milli-cores.

memory_gbs: number

Memory allocation in gigabytes.

name: string

The name of the read replica set.

nodes: number

Number of nodes in the replica set.

status: "creating" or "active" or "resizing" or 2 more

The current status of the read replica set.

One of the following:

"creating"

"active"

"resizing"

"deleting"

"error"

connection_pooler: optional ConnectionPooler { endpoint }

Connection pooler configuration for a service.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

metadata: optional object { environment }

Additional metadata for the read replica set.

environment: optional string

Environment tag for the read replica set.

vpcEndpoint: optional object { host, port, vpc_id }

VPC endpoint configuration for connecting to a service over VPC peering.

host: optional string

The hostname for connecting to the service over VPC peering.

port: optional number

The port for connecting to the service over VPC peering.

vpc_id: optional string

The ID of the VPC the endpoint is associated with.

ServiceVpcInput object { vpc_id }

Parameters for attaching a service to a VPC.

vpc_id: string

The ID of the VPC to attach the service to.

SetEnvironmentInput object { environment }

Parameters for setting a service’s environment.

environment: "PROD" or "DEV"

The target environment for the service.

One of the following:

"PROD"

"DEV"

ServiceListResponse = array of Service { created, name, project_id, 14 more }

created: string

Creation timestamp.

formatdate-time

name: string

The name of the service.

project_id: string

The project this service belongs to.

region_code: string

The cloud region where the service is hosted.

resources: array of object { id, spec }

List of resources allocated to the service.

id: optional string

Resource identifier.

spec: optional object { cpu_millis, memory_gbs, volume_type }

Resource specification.

cpu_millis: optional number

CPU allocation in millicores.

memory_gbs: optional number

Memory allocation in gigabytes.

volume_type: optional string

Type of storage volume.

service_id: string

The unique identifier for the service.

service_type: "TIMESCALEDB" or "POSTGRES" or "VECTOR"

The type of the service.

One of the following:

"TIMESCALEDB"

"POSTGRES"

"VECTOR"

status: "QUEUED" or "DELETING" or "CONFIGURING" or 8 more

The current deployment status of the service.

One of the following:

"QUEUED"

"DELETING"

"CONFIGURING"

"READY"

"DELETED"

"UNSTABLE"

"PAUSING"

"PAUSED"

"RESUMING"

"UPGRADING"

"OPTIMIZING"

connection_pooler: optional ConnectionPooler { endpoint }

Connection pooler configuration for a service.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

forked_from: optional object { is_standby, project_id, service_id }

The service this service was forked from.

is_standby: optional boolean

Whether this service is a standby of the parent service.

project_id: optional string

The project of the parent service.

service_id: optional string

The ID of the parent service.

ha_replicas: optional object { replica_count, sync_replica_count }

High-availability replica configuration for a service.

replica_count: optional number

Number of high-availability replicas (all replicas are asynchronous by default).

sync_replica_count: optional number

Number of synchronous high-availability replicas.

initial_password: optional string

The initial password for the service.

formatpassword

metadata: optional object { environment }

Additional metadata for the service.

environment: optional string

Environment tag for the service.

metrics: optional object { memory_mb, milli_cpu, storage_mb }

Resource usage metrics for the service.

memory_mb: optional number

Memory usage in megabytes.

milli_cpu: optional number

CPU usage in millicores.

storage_mb: optional number

Storage usage in megabytes.

read_replica_sets: optional array of ReadReplicaSet { id, cpu_millis, memory_gbs, 6 more }

The read replica sets attached to the service.

id: string

The unique identifier for the read replica set.

cpu_millis: number

CPU allocation in milli-cores.

memory_gbs: number

Memory allocation in gigabytes.

name: string

The name of the read replica set.

nodes: number

Number of nodes in the replica set.

status: "creating" or "active" or "resizing" or 2 more

The current status of the read replica set.

One of the following:

"creating"

"active"

"resizing"

"deleting"

"error"

connection_pooler: optional ConnectionPooler { endpoint }

Connection pooler configuration for a service.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

metadata: optional object { environment }

Additional metadata for the read replica set.

environment: optional string

Environment tag for the read replica set.

vpcEndpoint: optional object { host, port, vpc_id }

VPC endpoint configuration for connecting to a service over VPC peering.

host: optional string

The hostname for connecting to the service over VPC peering.

port: optional number

The port for connecting to the service over VPC peering.

vpc_id: optional string

The ID of the VPC the endpoint is associated with.

ServiceAttachToVpcResponse object { message }

message: optional string

ServiceDetachFromVpcResponse object { message }

message: optional string

ServiceEnablePoolerResponse object { message }

message: optional string

ServiceDisablePoolerResponse object { message }

message: optional string

ServiceSetEnvironmentResponse object { message }

message: optional string

ServiceLogsResponse object { logs, entries, lastCursor }

The logs for a service.

logs: array of string

Array of log message strings. Preserved for backwards compatibility.

entries: optional array of object { message, severity, timestamp }

Structured log entries with timestamp and severity metadata. Entries are in the same order as logs and can be used in place of it by callers that need structured data.

message: string

Log message text.

severity: string

PostgreSQL severity level (e.g. LOG, WARNING, ERROR, FATAL).

timestamp: string

Timestamp of the log entry (RFC3339 format).

formatdate-time

lastCursor: optional string

Opaque cursor for the next page of results. Present when more log entries exist older than the last entry in this response. Pass this value as the cursor query parameter to retrieve the next page. Absent when there are no further results.

ServicesReplica Sets

Manage read replica sets and their associated actions.

Get Read Replica Sets

GET/projects/{project_id}/services/{service_id}/replicaSets

Create a Read Replica Set

POST/projects/{project_id}/services/{service_id}/replicaSets

Delete a Read Replica Set

DELETE/projects/{project_id}/services/{service_id}/replicaSets/{replica_set_id}

Resize a Read Replica Set

POST/projects/{project_id}/services/{service_id}/replicaSets/{replica_set_id}/resize

Enable Connection Pooler for a Read Replica

POST/projects/{project_id}/services/{service_id}/replicaSets/{replica_set_id}/enablePooler

Disable Connection Pooler for a Read Replica

POST/projects/{project_id}/services/{service_id}/replicaSets/{replica_set_id}/disablePooler

Set Environment for a Read Replica

POST/projects/{project_id}/services/{service_id}/replicaSets/{replica_set_id}/setEnvironment

ModelsExpand Collapse

ReadReplicaSet object { id, cpu_millis, memory_gbs, 6 more }

A set of read replicas for a service.

id: string

The unique identifier for the read replica set.

cpu_millis: number

CPU allocation in milli-cores.

memory_gbs: number

Memory allocation in gigabytes.

name: string

The name of the read replica set.

nodes: number

Number of nodes in the replica set.

status: "creating" or "active" or "resizing" or 2 more

The current status of the read replica set.

One of the following:

"creating"

"active"

"resizing"

"deleting"

"error"

connection_pooler: optional ConnectionPooler { endpoint }

Connection pooler configuration for a service.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

metadata: optional object { environment }

Additional metadata for the read replica set.

environment: optional string

Environment tag for the read replica set.

ReplicaSetRetrieveReplicaSetsResponse = array of ReadReplicaSet { id, cpu_millis, memory_gbs, 6 more }

id: string

The unique identifier for the read replica set.

cpu_millis: number

CPU allocation in milli-cores.

memory_gbs: number

Memory allocation in gigabytes.

name: string

The name of the read replica set.

nodes: number

Number of nodes in the replica set.

status: "creating" or "active" or "resizing" or 2 more

The current status of the read replica set.

One of the following:

"creating"

"active"

"resizing"

"deleting"

"error"

connection_pooler: optional ConnectionPooler { endpoint }

Connection pooler configuration for a service.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

endpoint: optional Endpoint { host, port }

A network endpoint for connecting to a service.

host: optional string

The hostname of the endpoint.

port: optional number

The port of the endpoint.

metadata: optional object { environment }

Additional metadata for the read replica set.

environment: optional string

Environment tag for the read replica set.

ReplicaSetResizeResponse object { message }

message: optional string

ReplicaSetEnablePoolerResponse object { message }

message: optional string

ReplicaSetDisablePoolerResponse object { message }

message: optional string

ReplicaSetSetEnvironmentResponse object { message }

message: optional string