ClickHouse Cloud API
The ClickHouse Cloud control-plane REST API — 148 operations across 86 paths for organizations, services, users and roles, API keys, backups, ClickPipes, ClickStack observability, Managed Postgres, UDFs, Prometheus metrics and billing. Authenticated with HTTP Basic using an API key ID and secret. The OpenAPI 3.1.2 description is served live and unauthenticated from the API root itself, and is advertised as service-desc in the RFC 9727 api-catalog at https://clickhouse.com/.well-known/api-catalog.
Operations 148
GET
/v1/organizations/{organizationId}/services/{serviceId}/privateEndpointConfig
Get private endpoint configuration
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/serviceQueryEndpoint
Get the service query endpoint for a given instance
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/serviceQueryEndpoint
Delete the service query endpoint for a given instance
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/serviceQueryEndpoint
Upsert the service query endpoint for a given instance
#
PATCH
/v1/organizations/{organizationId}/services/{serviceId}/scaling
Update service auto scaling settings
#
PATCH
/v1/organizations/{organizationId}/services/{serviceId}/replicaScaling
Update service auto scaling settings
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/privateEndpoint
Create a private endpoint
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/scalingSchedule
Get service autoscaling schedule
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/scalingSchedule
Create or replace service autoscaling schedule
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/scalingSchedule
Delete service scheduled scaling
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/upgradeWindow
Get service upgrade window
#
PUT
/v1/organizations/{organizationId}/services/{serviceId}/upgradeWindow
Set service upgrade window
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/upgradeWindow
Delete service upgrade window
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings
List ClickHouse settings
#
PATCH
/v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings
Update ClickHouse settings
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings/schema
Get ClickHouse settings schema
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings/{settingName}
Get ClickHouse setting
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings/{settingName}
Reset ClickHouse setting to default
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/backupConfiguration
Get service backup configuration
#
PATCH
/v1/organizations/{organizationId}/services/{serviceId}/backupConfiguration
Update service backup configuration
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/backupBucket
Get service backup bucket
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/backupBucket
Create service backup bucket
#
PATCH
/v1/organizations/{organizationId}/services/{serviceId}/backupBucket
Update service backup bucket
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/backupBucket
Delete service backup bucket
#
DELETE
/v1/organizations/{organizationId}/invitations/{invitationId}
Delete organization invitation
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickpipes/context
Get ClickPipes service context
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}
Get ClickPipe
#
PATCH
/v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}
Update ClickPipe
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}
Delete ClickPipe
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}/settings
Get ClickPipe settings
#
PUT
/v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}/settings
Update ClickPipe settings
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/clickpipes/schemaDiscovery
Discover ClickPipe source schema
#
PATCH
/v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}/scaling
Update ClickPipe scaling
#
PATCH
/v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}/state
Update ClickPipe state
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickpipesCdcScaling
Get CDC ClickPipes scaling
#
PATCH
/v1/organizations/{organizationId}/services/{serviceId}/clickpipesCdcScaling
Update CDC ClickPipes scaling
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards
ClickStack: List Dashboards
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards
ClickStack: Create Dashboard
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards/{clickStackDashboardId}
ClickStack: Get Dashboard
#
PUT
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards/{clickStackDashboardId}
ClickStack: Update Dashboard
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards/{clickStackDashboardId}
ClickStack: Delete Dashboard
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards/validate
ClickStack: Validate Dashboard
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/alerts
ClickStack: List Alerts
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/alerts
ClickStack: Create Alert
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/sources
ClickStack: List Sources
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/sources
ClickStack: Create Source
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/sources/{clickStackSourceId}
ClickStack: Get Source
#
PUT
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/sources/{clickStackSourceId}
ClickStack: Update Source
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/sources/{clickStackSourceId}
ClickStack: Delete Source
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/alerts/{clickStackAlertId}
ClickStack: Get Alert
#
PUT
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/alerts/{clickStackAlertId}
ClickStack: Update Alert
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/alerts/{clickStackAlertId}
ClickStack: Delete Alert
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/webhooks
ClickStack: List Webhooks
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/webhooks
ClickStack: Create Webhook
#
PUT
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/webhooks/{clickStackWebhookId}
ClickStack: Update Webhook
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/webhooks/{clickStackWebhookId}
ClickStack: Delete Webhook
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/roles
ClickStack: List Roles
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/roles
ClickStack: Create Role
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/roles/{clickStackRoleId}
ClickStack: Get Role
#
PUT
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/roles/{clickStackRoleId}
ClickStack: Update Role
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/roles/{clickStackRoleId}
ClickStack: Delete Role
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/saved-searches
ClickStack: List Saved Searches
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/saved-searches
ClickStack: Create Saved Search
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/saved-searches/{clickStackSavedSearchId}
ClickStack: Get Saved Search
#
PUT
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/saved-searches/{clickStackSavedSearchId}
ClickStack: Update Saved Search
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/clickstack/saved-searches/{clickStackSavedSearchId}
ClickStack: Delete Saved Search
#
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}/prometheus
Get PostgreSQL service metrics
#
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}/privateEndpointConfig
Get private endpoint configuration for region within cloud provider for an organization
#
DELETE
/v1/organizations/{organizationId}/byocInfrastructure/{byocInfrastructureId}
Remove a BYOC infrastructure
#
PATCH
/v1/organizations/{organizationId}/byocInfrastructure/{byocInfrastructureId}
Update BYOC Infrastructure
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickpipesReversePrivateEndpoints
List reverse private endpoints
#
POST
/v1/organizations/{organizationId}/services/{serviceId}/clickpipesReversePrivateEndpoints
Create reverse private endpoint
#
GET
/v1/organizations/{organizationId}/services/{serviceId}/clickpipesReversePrivateEndpoints/{reversePrivateEndpointId}
Get reverse private endpoint
#
DELETE
/v1/organizations/{organizationId}/services/{serviceId}/clickpipesReversePrivateEndpoints/{reversePrivateEndpointId}
Delete reverse private endpoint
#
PATCH
/v1/organizations/{organizationId}/services/{serviceId}/clickpipesReversePrivateEndpoints/{reversePrivateEndpointId}
Update reverse private endpoint
#
PUT
/v1/organizations/{organizationId}/udfs/{functionName}/attachments/{serviceId}
Attach UDF to service
#
GET
/v1/organizations/{organizationId}/udfs/{functionName}/attachments/{serviceId}
Get UDF attachment
#
DELETE
/v1/organizations/{organizationId}/udfs/{functionName}/attachments/{serviceId}
Detach UDF from service
#
DELETE
/v1/organizations/{organizationId}/udfs/{functionName}/versions/{version}
Delete UDF version
#
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
Other Resources
🔗
Overlay
https://raw.githubusercontent.com/api-evangelist/clickhouse/refs/heads/main/overlays/clickhouse-cloud-api-overlay.yaml
🔗
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