ClickHouse

ClickHouse Postgres API

The Postgres API from ClickHouse — 12 operation(s) for postgres.

GitHub OpenAPI

Operations 17

POST /v1/organizations/{organizationId}/postgres Create new Postgres service #
GET /v1/organizations/{organizationId}/postgres List of organization Postgres services #
GET /v1/organizations/{organizationId}/postgres/{postgresId} Get PostgreSQL service details #
DELETE /v1/organizations/{organizationId}/postgres/{postgresId} Delete a PostgreSQL service #
PATCH /v1/organizations/{organizationId}/postgres/{postgresId} Update a PostgreSQL service #
GET /v1/organizations/{organizationId}/postgres/{postgresId}/caCertificates Get Postgres CA certs #
POST /v1/organizations/{organizationId}/postgres/{postgresId}/restoredService Restore a Postgres service #
PATCH /v1/organizations/{organizationId}/postgres/{postgresId}/password Update Postgres superuser password #
PATCH /v1/organizations/{organizationId}/postgres/{postgresId}/state Update Postgres service state #
POST /v1/organizations/{organizationId}/postgres/{postgresId}/readReplica Create a read replica for a Postgres service #
GET /v1/organizations/{organizationId}/postgres/{postgresId}/config Get PostgreSQL service configuration #
POST /v1/organizations/{organizationId}/postgres/{postgresId}/config Replace Postgres service configuration #
PATCH /v1/organizations/{organizationId}/postgres/{postgresId}/config Update Postgres service configuration #
GET /v1/organizations/{organizationId}/postgres/{postgresId}/metrics Get Postgres time-series metrics #
GET /v1/organizations/{organizationId}/postgres/{postgresId}/slowQueryPatterns List Postgres slow query patterns #
GET /v1/organizations/{organizationId}/postgres/{postgresId}/slowQueryPatterns/{queryId} Get a Postgres slow query pattern with recent executions #
GET /v1/organizations/{organizationId}/postgres/{postgresId}/logs List Postgres server logs #

Documentation

📖
Documentation
https://clickhouse.com/docs/cloud/manage/api/api-overview
📖
APIReference
https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/clickhouse/refs/heads/main/openapi/clickhouse-postgres-api-openapi.yml

Other Resources

🔗
ToolCrosswalk
https://raw.githubusercontent.com/api-evangelist/clickhouse/refs/heads/main/mcp/clickhouse-tool-crosswalk.yml
🔗
Swagger
https://clickhouse.com/docs/cloud/manage/api/swagger

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/clickhouse-postgres-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

clickhouse-postgres-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: OpenAPI spec for ClickHouse Cloud Postgres API
  version: '1.0'
  contact:
    name: ClickHouse Support
    url: https://clickhouse.com/docs/en/cloud/manage/openapi?referrer=openapi-1107336
    email: support@clickhouse.com
servers:
- url: https://api.clickhouse.cloud
security:
- basicAuth: []
tags:


# --- truncated at 32 KB (90 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/clickhouse/refs/heads/main/openapi/clickhouse-postgres-api-openapi.yml