clickhouse.com

ClickHouse is a column-oriented database for real-time analytics, available as open-source software and as the managed ClickHouse Cloud service. The company also offers related cloud products such as ClickPipes, ClickStack, and managed Postgres.

2 integrations · REST · CLI

ClickHouse exposes a documented REST Cloud API at `https://api.clickhouse.cloud/v1` authenticated with ClickHouse-issued API keys over Basic Auth, plus the `clickhousectl` CLI authenticated either by interactive OAuth login or ClickHouse API keys. ClickHouse also publishes MCP documentation, but the documented MCP server surfaced here is an open-source GitHub project rather than a `clickhouse.com`/subdomain connect endpoint.

discovered 2mo ago

REST · OpenAPI1

ClickHouse Cloud APIdiscoveredrest

CLI1

clickhousectldiscoveredclickhousectl

Credentials

ClickHouse Cloud API key and secretbasicGet credentials ↗

In the ClickHouse Cloud console, open your organization's API key management from the Cloud API docs / Swagger reference. Create an API key for the organization; ClickHouse returns a keyId and keySecret. Use them together as HTTP Basic Auth username/password. The query-endpoints guide notes API keys are required and recommends creating a scoped key with only the permissions you need.

clickhousectl OAuth login tokenoauth2$ clickhousectl cloud auth login

Acquired by the CLI — running clickhousectl cloud auth login opens the auth flow and stores the credential.

conventions · 3/8 published

integrations.json✗/.well-known/integrations.json
llms.txt✓https://clickhouse.com/llms.txt
API catalog✓https://clickhouse.com/.well-known/api-catalog
OpenAPI document✗/api/schema/, /openapi.json, /swagger.json, /api/openapi.json, or /v1/openapi.json
MCP server card✗/.well-known/mcp/server-card.json
OAuth protected resource✗/.well-known/oauth-protected-resource
Agent card✗/.well-known/agent-card.json
Agent skills✓https://clickhouse.com/.well-known/agent-skills/index.json

Publish these signals → /publishing