Managed Databases API

API endpoints for creating and managing PostgreSQL, Redis, and ClickHouse instances.

PostgreSQL

List databases


GET /v1/databases

Returns all PostgreSQL instances for the authenticated user.

Example


curl https://api.redu.cloud/v1/databases \
  -H "x-api-key: YOUR_API_KEY"

Create database


POST /v1/databases

Request body

Field	Type	Required	Description
`name`	string	✓	Identifier (lowercase, hyphens)
`db_name`	string		Database name (default: `app`)
`db_user`	string		Database user (default: `appuser`)
`db_password`	string		Password, auto-generated if omitted
`version`	`"16"` \| `"15"` \| `"14"`		PostgreSQL version (default: `"16"`)
`flavor_id`	string	✓	Server size ID, use List flavors
`network_id`	string	✓	Private network ID, use List networks
`keypair_name`	string	✓	SSH keypair name, use List keypairs
`security_group_names`	string[]		Defaults to `["default"]`
`extensions`	string[]		PostgreSQL extensions to install at provision time. Allowlist: `pgvector` (alias `vector`), `postgis`, `pgaudit`, `pg_stat_statements`, `hstore`, `pg_trgm`, `uuid-ossp`, `citext`, `pgcrypto`, `ltree`, `btree_gin`, `btree_gist`
`superuser`	boolean		Grant the database user superuser privileges (default `false`)

Response, the password is returned once and not stored in plain text.


{
  "id": 1,
  "name": "my-db",
  "db_name": "app",
  "db_user": "appuser",
  "db_password": "the-plaintext-password-shown-once",
  "db_version": "16",
  "status": "provisioning",
  "floating_ip": null,
  "port": 5432,
  "created_at": "2026-05-30T12:00:00Z"
}

Get database


GET /v1/databases/:id

Delete database


DELETE /v1/databases/:id

Returns 204 No Content.

Redis

List Redis instances


GET /v1/redis

Create Redis instance


POST /v1/redis

Request body

Field	Type	Required	Description
`name`	string	✓	Identifier (lowercase, hyphens)
`password`	string		Auto-generated if omitted
`version`	`"7"` \| `"6"`		Redis version (default: `"7"`)
`flavor_id`	string	✓	Server size ID
`network_id`	string	✓	Private network ID
`keypair_name`	string	✓	SSH keypair name
`security_group_names`	string[]		Defaults to `["default"]`

Response


{
  "id": 1,
  "name": "my-cache",
  "version": "7",
  "password": "the-plaintext-password-shown-once",
  "status": "provisioning",
  "floating_ip": null,
  "port": 6379,
  "created_at": "2026-05-30T12:00:00Z"
}

Get Redis instance


GET /v1/redis/:id

Delete Redis instance


DELETE /v1/redis/:id

Returns 204 No Content.

ClickHouse

ClickHouse is a column-oriented database for analytics (OLAP). It is a distinct managed resource, HTTP on port 8123.

List ClickHouse instances


GET /v1/clickhouse

Create ClickHouse instance


POST /v1/clickhouse

Request body

Field	Type	Required	Description
`name`	string	✓	Identifier (lowercase, hyphens)
`db_name`	string		Database name (default: `analytics`)
`db_user`	string		Database user (default: `appuser`)
`db_password`	string		Password, auto-generated if omitted
`flavor_id`	string	✓	Server size ID, use List flavors
`network_id`	string	✓	Private network ID, use List networks
`keypair_name`	string	✓	SSH keypair name, use List keypairs
`security_group_names`	string[]		Defaults to `["default"]`

Response, the password is returned once.


{
  "id": 1,
  "name": "my-analytics",
  "db_name": "analytics",
  "db_user": "appuser",
  "db_password": "the-plaintext-password-shown-once",
  "status": "provisioning",
  "floating_ip": null,
  "port": 8123,
  "created_at": "2026-05-30T12:00:00Z"
}

Get ClickHouse instance


GET /v1/clickhouse/:id

Delete ClickHouse instance


DELETE /v1/clickhouse/:id

Returns 204 No Content.

Status values

Status	Meaning
`provisioning`	Server is being created. Poll every 15–30s.
`ready`	Server is up and accepting connections.
`error`	Provisioning failed.