ClickHouse

ClickHouse is a fast open-source column-oriented database management system that enables real-time analytical reporting using SQL. ClickHouse exposes multiple interfaces - an HTTP interface for SQL queries, native TCP, MySQL and PostgreSQL wire-compatible interfaces, and a gRPC interface - and the ClickHouse Cloud management plane offers a public OpenAPI-described REST API for provisioning and managing services, organizations, members, API keys, backups, and private endpoints.

ClickHouse publishes 21 API contracts indexed on the APIs.io network, including HTTP Interface API, Ping API, Play API, and 18 more. Tagged areas include ClickHouse, Analytics, Cloud Database, Column-Oriented, and Database.

The ClickHouse catalog on APIs.io includes 2 event-driven AsyncAPI specifications, 1 JSON-LD context, and 2 Spectral governance rulesets.

ClickHouse’s developer surface includes authentication, documentation, getting-started guide, GitHub presence, engineering blog, pricing, support, and 48 more developer resources.

🌐 Visit website 📡 Profile data on GitHub

72.0/100 exemplar ▬ flat Agent 60/100 agent ready Front door AI 5/6 prominent open core · Apache-2.0 Full breakdown ↓
scored 2026-10-17 · rubric v0.24.0

AccessFreemiumSelf serve

2 published contracts 1 MCP Servers

ClickHouse Analytics Cloud DatabaseColumn-OrientedDatabase OLAP Open Source Real-Time SQL

What this lets a business do 4

Business capabilities this provider's published APIs can perform, derived from its own contracts. Browse all capabilities →

SaaS Platform Operations Management

BC-4220

BackupClickStackPrometheus

GET /v1/organizations/{organizationId}/services/{serviceId}/backups GET /v1/organizations/{organizationId}/services/{serviceId}/prometheus

Cybersecurity Management

BC-620

Role ManagementUser Management

POST /v1/organizations/{organizationId}/roles GET /v1/organizations/{organizationId}/members POST /v1/organizations/{organizationId}/invitations

Information Technology Management

BC-600

PostgresService

POST /v1/organizations/{organizationId}/postgres POST /v1/organizations/{organizationId}/postgres/{postgresId}/readReplica POST /v1/organizations/{organizationId}/services PATCH /v1/organizations/{organizationId}/services/{serviceId}/scaling

Subscription Billing & Revenue Management

BC-4250

Billing

GET /v1/organizations/{organizationId}/usageCost

What people ask ClickHouse 16

The questions people put to an LLM, and the jobs they hand an agent, that ClickHouse's APIs answer — each one linked to the operation that does it. Generated by API Evangelist

ClickHouse Click Stack API List ClickStack dashboards “Which observability dashboards exist in ClickStack for my service?” Create a ClickStack dashboard “How do I build a new observability dashboard with chart tiles in ClickStack?” Get one ClickStack dashboard “What tiles and filters are on a specific ClickStack dashboard?” Update an existing ClickStack dashboard “How do I change the tiles on a dashboard I already built?”

ClickHouse Service API List instance profiles available in a region “Which custom instance profiles can I use for a new service in a region?” List ClickHouse services in the organization “What ClickHouse services are running in my organization?” Create a new ClickHouse service “How do I spin up a new ClickHouse Cloud service?” Get a ClickHouse service's details “What state is my ClickHouse service in right now?”

ClickHouse Click Pipes API List a service's ClickPipes “Which ClickPipes are ingesting data into my ClickHouse service?” Create a ClickPipe to ingest data “How do I start streaming data from a source into a ClickHouse table?” Get a service's ClickPipes capabilities and identity “Which GCP service account do I need to grant access to my source for ClickPipes?” Get details of one ClickPipe “What is the current state and source of a specific ClickPipe?”

ClickHouse Postgres API Create a managed Postgres service “How do I spin up a new managed Postgres database?” List managed Postgres services “Which managed Postgres databases do we run in ClickHouse Cloud?” Get a Postgres service's details “What's the current status of one of my Postgres databases?” Delete a Postgres service “How do I permanently delete a managed Postgres database?”

ClickHouse UDF API Attach a UDF version to a service “How do I make a user-defined function available on one of my services?” Check a UDF's attachment to one service “Which version of a user-defined function is attached to a particular service?” Detach a UDF from a service “How do I remove a user-defined function from just one service?” List the services a UDF is attached to “Which services is a given user-defined function attached to?”

ClickHouse Organization API Find the organization tied to my API key “Which ClickHouse Cloud organization does my API key belong to?” Get organization details “What are the name and settings of my organization?” Rename or reconfigure the organization “How do I rename our organization?” List organization resource quotas and usage “What resource limits apply to my organization and how close am I to them?”

ClickHouse Backup API List a service's backups “What backups exist for my ClickHouse service, newest first?” Get details of one backup “What are the details of one particular backup?” Get a service's backup schedule and retention “How often is my service backed up and how long are backups kept?” Change a service's backup schedule and retention “Can I take backups every 12 hours and keep them longer?”

ClickHouse User management API List organization members “Who are the members of my ClickHouse Cloud organization?” Get one member's details “What role does a specific member have in our organization?” Change a member's role “How do I promote a member to admin?” Remove a member from the organization “How do I remove someone who left the company from our organization?”

ClickHouse Role Management API List the organization's roles “Which system and custom roles are available in my ClickHouse Cloud organization?” Create a custom organization role “How do I create a custom role with its own permission policies?” Get a role's policies and actors “What permissions does a particular role grant?” Update a custom organization role “How do I add or remove actors from an existing custom role?”

ClickHouse Prometheus API Get org-wide Prometheus metrics (deprecated) “Can I still scrape all my services' metrics from the older single org-wide Prometheus endpoint?” List Prometheus scrape targets for every service “How do I point Prometheus http_sd service discovery at all my ClickHouse services?” Get Prometheus metrics for one ClickHouse service “How do I scrape Prometheus metrics from a single ClickHouse service?” Get Prometheus metrics for all Postgres services “How do I scrape metrics for every managed Postgres service in my org at once?”

ClickHouse API keys API List an organization's API keys “Which API keys exist in my ClickHouse Cloud organization?” Create a new API key “How do I generate a new API key for automation?” Get details of one API key “What roles and expiry does a specific API key have?” Update an existing API key “How do I disable an existing API key without deleting it?”

ClickHouse Billing API Get daily usage costs for the organization “How much did my ClickHouse Cloud organization spend last month, broken down by day?” List prepaid balances (deprecated endpoint) “What prepaid balances does my org have, using the older deprecated balances endpoint?” Get the organization's remaining credits “How many credits do we have left, and which balance expires first?”

Showing 12 of 16 APIs with phrasing — see every API.

Kin Score

Kin Score How this is scored →
scored 2026-10-17 · rubric v0.24.0

Composite quality — 72.0/100 · exemplar

Contract Quality 11.6 / 19

Developer Ergonomics 12.5 / 15

Access Clarity 11.8 / 15

Operational Transparency 7.2 / 10

Contract Governance 1.4 / 9

Discoverability 5.0 / 8

Regulatory Posture 6.8 / 15

Create-or-Update Ergonomics 2.2 / 10

Agent readiness — 60/100 · agent ready

Machine-Readable Contract 18 / 18

Agentic Access Contract 10 / 10

Documented Reversibility 6 / 6

MCP Server 12 / 12

Machine-Readable Auth 10 / 10

Idempotency 0 / 9

Stable Error Semantics 8 / 8

Request/Response Examples 7 / 7

Rate-Limit Signaling 7 / 7

Typed Event Surface 6 / 6

Agent Skills 5 / 5

Well-Known Catalog 4 / 4

Consent & Bot Identity 0 / 3

A2A Agent Card 0 / 8

Dry-Run / Simulate Mode 0 / 4

Delegated User Identity 6 / 6

Protected Resource Metadata 5 / 5

Registration Without a Human 6 / 6

Agentic Commerce Well-Known Document 0 / 5

Regulatory Posture applies to this provider. Its tags matched the Horizontal (data, software, accessibility, platform) regime, so Regulatory Posture carries 15 points of the composite. If this regime is wrong for your business, say so on your provider repo — the applicability map is public and we will correct it.

Create-or-Update Ergonomics applies to this provider. This API accepts writes, so it carries 10 points of the composite. It is scored from the published contracts themselves: whether a caller can create-or-update in one call, whether the write accepts a key the caller already holds, and whether the response says which branch ran. Without that, every write needs a search-and-branch in front of it, and the first time that check is skipped a duplicate record is created. Scored against the observed mean rather than raw — a provider at the catalog average is unchanged by this facet, not penalised by it.

The six quality facets above are damped to 75 points between them, because the conditional facet above carries the other 25. That is why each facet's contribution is shown against a damped maximum: raising a quality facet moves the composite by 75% of its nominal weight, not 100%. The full arithmetic is at apis.io/rating/.

Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. Every facet and dimension name above is a link: it opens that measurement's own page — what it means, the exact checks that feed it, how the whole catalog distributes on it, and the providers at the top of it. This rating is computed from github.com/api-evangelist/clickhouse: open an issue to ask a question, or submit a pull request to add artifacts. Submit an artifact on GitHub — free → Manage your own listing — the Influence plan, $499/mo →

Markets this provider is in provisional

The Kin Score Market layer reads a provider inside its market: its position, and how deep its integrations go. Depth is only comparable within a position. Provisional and unweighted: not part of the Kin Score or agent readiness.

Market	Position	Depth	Registered MCP server	Declares compatibility
Databases (PostgreSQL wire)	mixed	43.0	-	1
Retrieval, Vector and RAG	mixed	43.0	-	1

Registered MCP server and declares compatibility are report only — not weighted. Undeclared means we found nothing we can read, so there is no number: we never infer integrations.

APIs 21

Individual APIs this provider publishes, each with its own machine-readable definition.

ClickHouse HTTP Interface

HTTP interface (default port 8123, HTTPS 8443) for executing SQL queries against ClickHouse. Supports SELECT via GET, mutations via POST, multiple output formats (JSON, CSV, XML...

ClickHouse Native TCP Interface

Native binary TCP protocol used by ClickHouse client libraries for maximum throughput between client and server (default port 9000).

ClickHouse MySQL Interface

MySQL wire protocol compatibility allowing existing MySQL clients and BI tools to query ClickHouse without driver changes.

ClickHouse PostgreSQL Interface

PostgreSQL wire protocol compatibility for connecting psql, JDBC and other PostgreSQL clients to ClickHouse.

ClickHouse gRPC Interface

gRPC interface defined by clickhouse_grpc.proto for efficient binary communication.

ClickHouse HTTP Interface API

The ClickHouse HTTP Interface API from ClickHouse — 1 operation(s) for clickhouse http interface.

ClickHouse Ping API

The Ping API from ClickHouse — 1 operation(s) for ping.

ClickHouse Play API

The Play API from ClickHouse — 1 operation(s) for play.

ClickHouse Replicas Status API

The Replicas Status API from ClickHouse — 1 operation(s) for replicas status.

ClickHouse API keys API

The API keys API from ClickHouse — 2 operation(s) for api keys.

ClickHouse Backup API

The Backup API from ClickHouse — 4 operation(s) for backup.

ClickHouse Billing API

The Billing API from ClickHouse — 3 operation(s) for billing.

ClickHouse Click Pipes API

The ClickPipes API from ClickHouse — 10 operation(s) for clickpipes.

ClickHouse Click Stack API

The ClickStack API from ClickHouse — 13 operation(s) for clickstack.

ClickHouse Organization API

The Organization API from ClickHouse — 9 operation(s) for organization.

ClickHouse Postgres API

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

ClickHouse Prometheus API

The Prometheus API from ClickHouse — 5 operation(s) for prometheus.

ClickHouse Role Management API

The Role Management API from ClickHouse — 2 operation(s) for role management.

ClickHouse Service API

The Service API from ClickHouse — 15 operation(s) for service.

ClickHouse UDF API

The UDF API from ClickHouse — 7 operation(s) for udf.

ClickHouse User management API

MCP SERVER

Pricing Plans 1

Published pricing tiers and plan structures.

Clickhouse Plans Pricing

4 plans

PLANS

Rate Limits 1

Documented rate limits and quota policies.

Clickhouse Rate Limits

1 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Clickhouse Finops

FINOPS

Event Specifications 2

AsyncAPI definitions for this provider's event-driven and streaming APIs.

ClickHouse Kafka Table Engine (Consumer-Side Streaming)

AsyncAPI description of the documented streaming surface that ClickHouse offers through the Kafka table engine. ClickHouse itself does NOT publish a public WebSocket, Server-Sen...

ASYNCAPI

Clickhouse Webhooks

ASYNCAPI

Semantic Vocabularies 1

JSON-LD contexts and semantic vocabularies used across these APIs.

Clickhouse Context

0 classes · 5 properties

JSON-LD

Spectral Rules 2

Spectral governance rulesets for linting and validating these APIs.

ClickHouse — asyncapi rules

3 rules · 3 warnings

SPECTRAL

ClickHouse API Rules

9 rules · 4 errors 5 warnings

SPECTRAL

13 actions · phrasing · clickhouse-udf-api-openapi.yml

GENERATED

Clickhouse User Management Api Phrasing Overlay

9 actions · phrasing · clickhouse-user-management-api-openapi.yml

GENERATED

Scroll for all 17

Security Posture 4

Authentication, domain security, vulnerability disclosure, and trust-center signals.

Clickhouse Authentication

http/apiKey/oauth2 · 0 schemes

SECURITY

Clickhouse Domain Security

TLSv1.3 · HSTS · DMARC

SECURITY

Clickhouse Vulnerability Disclosure

security.txt · contact published

SECURITY

Clickhouse Trust Center

SOC 2, ISO 27001, PCI DSS, HIPAA, GDPR

SECURITY

Scopes 1

OAuth scopes governing access to this provider's APIs.

Clickhouse Scopes

5 scopes

SCOPES

Agentic Access 1

Recommended x-agentic-access execution contracts for AI agents.

Clickhouse Agentic Access

153 operations · 81 acting · 1 human-in-the-loop

153 operations · 81 acting

AGENTIC

Resources

Get Started 5

Portal, sign-up, and the first successful call

GettingStarted

Sandbox

DeveloperPortal

SignUp

Quickstart

Documentation 2

Reference material describing how the API behaves

Documentation

Documentation

APIReference

APIReference

Agent Surfaces 5

MCP servers, agent skills, and machine-readable catalogs

AgenticAccess

WellKnown

MCPServer

LLMsTxt

AgentSkill

Design & Contract 8

Pagination, idempotency, versioning, errors, and events

JSONLD

Spectral

Conformance

ErrorCatalog

Lifecycle

Conventions

DataModel

Webhooks

Scroll for all 8

Build 7

SDKs, sample code, and the tooling you integrate with

PostmanWorkspace

GitHub

Packages

SDKs

CLI

ToolCrosswalk

GitHubOrganization

GitHubOrganization

Scroll for all 7

Access & Security 8

Authentication, authorization, and security posture

VulnerabilityDisclosure

VulnerabilityDisclosure

TrustCenter

DomainSecurity

Authentication

SecurityTxt

Security

Compliance

OAuthScopes

Scroll for all 8

Operate 6

Status, limits, changes, and where to get help

Community

Slack

Support

StatusPage

ChangeLog

RateLimits

Commercial 5

Pricing, plans, and the legal terms of use

FinOps

Pricing

PrivacyPolicy

TermsOfService

Plans

Company 3

The organization behind the API

LinkedIn

Website

Website

Blog

Blog

Other 6

Properties that don't map to a standard resource type

CapabilityMap

AICatalog

APICatalog

Protobuf

Overlay

Playground

Source (apis.yml)

aid: clickhouse
name: ClickHouse
url: https://raw.githubusercontent.com/api-evangelist/clickhouse/refs/heads/main/apis.yml
deliveryModel:
  model: open-core
  license: Apache-2.0
  license_evidence:
    repo: clickhouse/clickhouse
    spdx: Apache-2.0
    stars: 50068
  open_source: true
  commercial: true
  callable_host: true
  label: Open core · an OSS project plus a commercial hosted product
  confidence: medium
  source:
  - openapi
  - pricing
  - repository-license
  generated: '2026-09-25'
  method: derived
accessModel:
  pricing: freemium
  onboarding: self-serve
  trial: false
  try_now: false
  public: false
  label: Freemium · Self-serve signup
  confidence: medium
  try_now_blocked_by: loopback
  source:
  - plans
  - authentication
  - security
  generated: '2026-09-03'
  method: derived
created: '2024-01-01'
modified: '2026-09-16'
type: Index
access: 3rd-Party
position: Consuming
specificationVersion: '0.23'
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/clickhouse.png
kind: opensource
x-docs-platform: redocly
x-docs-platform-confidence: medium
x-docs-platform-checked: 2026-09-24
tags:
- ClickHouse
- Analytics
- Cloud Database
- Column-Oriented
- Database
- OLAP
- Open Source
- Real-Time
- SQL
tags_raw:
- ClickHouse
- Analytics
- Cloud Database
- Column-Oriented
- Database
- OLAP
- Open Source
- Real-Time
- SQL
- Open-Source
description: ClickHouse is a fast open-source column-oriented database management system that enables real-time analytical
  reporting using SQL. ClickHouse exposes multiple interfaces - an HTTP interface for SQL queries, native TCP, MySQL and PostgreSQL
  wire-compatible interfaces, and a gRPC interface - and the ClickHouse Cloud management plane offers a public OpenAPI-described
  REST API for provisioning and managing services, organizations, members, API keys, backups, and private endpoints.
apis:
- aid: clickhouse:clickhouse-http-interface
  name: ClickHouse HTTP Interface
  tags:
  - Database
  - HTTP
  - SQL
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  properties:
  - url: https://clickhouse.com/docs/en/interfaces/http
    type: Documentation
  description: HTTP interface (default port 8123, HTTPS 8443) for executing SQL queries against ClickHouse. Supports SELECT
    via GET, mutations via POST, multiple output formats (JSON, CSV, XML, TabSeparated), and authentication via HTTP Basic,
    URL parameters, or X-ClickHouse-User/X-ClickHouse-Key headers. Helper paths include /ping and /replicas_status.
- aid: clickhouse:clickhouse-native
  name: ClickHouse Native TCP Interface
  tags:
  - Native
  - TCP
  humanURL: https://clickhouse.com/docs/en/interfaces/tcp
  properties:
  - url: https://clickhouse.com/docs/en/interfaces/tcp
    type: Documentation
  description: Native binary TCP protocol used by ClickHouse client libraries for maximum throughput between client and server
    (default port 9000).
- aid: clickhouse:clickhouse-mysql
  name: ClickHouse MySQL Interface
  tags:
  - MySQL
  - Wire Protocol
  humanURL: https://clickhouse.com/docs/en/interfaces/mysql
  properties:
  - url: https://clickhouse.com/docs/en/interfaces/mysql
    type: Documentation
  description: MySQL wire protocol compatibility allowing existing MySQL clients and BI tools to query ClickHouse without
    driver changes.
- aid: clickhouse:clickhouse-postgresql
  name: ClickHouse PostgreSQL Interface
  tags:
  - PostgreSQL
  - Wire Protocol
  humanURL: https://clickhouse.com/docs/en/interfaces/postgresql
  properties:
  - url: https://clickhouse.com/docs/en/interfaces/postgresql
    type: Documentation
  description: PostgreSQL wire protocol compatibility for connecting psql, JDBC and other PostgreSQL clients to ClickHouse.
- aid: clickhouse:clickhouse-grpc
  name: ClickHouse gRPC Interface
  tags:
  - gRPC
  - Protocol Buffers
  humanURL: https://clickhouse.com/docs/en/interfaces/grpc
  properties:
  - url: https://clickhouse.com/docs/en/interfaces/grpc
    type: Documentation
  - url: https://github.com/ClickHouse/ClickHouse/blob/master/src/Server/grpc_protos/clickhouse_grpc.proto
    type: Protocol Buffers
  description: gRPC interface defined by clickhouse_grpc.proto for efficient binary communication.
- aid: clickhouse:clickhouse-clickhouse-http-interface-api
  name: ClickHouse HTTP Interface API
  description: The ClickHouse HTTP Interface API from ClickHouse — 1 operation(s) for clickhouse http interface.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - ClickHouse HTTP Interface
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-clickhouse-http-interface-api-openapi.yml
  - type: Documentation
    url: https://clickhouse.com/docs/en/cloud/manage/api/api-overview
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-ping-api
  name: ClickHouse Ping API
  description: The Ping API from ClickHouse — 1 operation(s) for ping.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - Ping
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-ping-api-openapi.yml
  - type: Documentation
    url: https://clickhouse.com/docs/en/cloud/manage/api/api-overview
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-play-api
  name: ClickHouse Play API
  description: The Play API from ClickHouse — 1 operation(s) for play.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - Play
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-play-api-openapi.yml
  - type: Documentation
    url: https://clickhouse.com/docs/en/cloud/manage/api/api-overview
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-replicas-status-api
  name: ClickHouse Replicas Status API
  description: The Replicas Status API from ClickHouse — 1 operation(s) for replicas status.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - Replicas Status
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-replicas-status-api-openapi.yml
  - type: Documentation
    url: https://clickhouse.com/docs/en/cloud/manage/api/api-overview
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-api-keys-api
  name: ClickHouse API keys API
  description: The API keys API from ClickHouse — 2 operation(s) for api keys.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - APIKeys
  tags_raw:
  - API keys
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-api-keys-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-backup-api
  name: ClickHouse Backup API
  description: The Backup API from ClickHouse — 4 operation(s) for backup.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - Backup
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-backup-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-billing-api
  name: ClickHouse Billing API
  description: The Billing API from ClickHouse — 3 operation(s) for billing.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - Billing
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-billing-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-clickpipes-api
  name: ClickHouse Click Pipes API
  description: The ClickPipes API from ClickHouse — 10 operation(s) for clickpipes.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - ClickPipes
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-clickpipes-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-clickstack-api
  name: ClickHouse Click Stack API
  description: The ClickStack API from ClickHouse — 13 operation(s) for clickstack.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - ClickStack
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-clickstack-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-organization-api
  name: ClickHouse Organization API
  description: The Organization API from ClickHouse — 9 operation(s) for organization.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - Organization
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-organization-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-postgres-api
  name: ClickHouse Postgres API
  description: The Postgres API from ClickHouse — 12 operation(s) for postgres.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - PostgreSQL
  tags_raw:
  - Postgres
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-postgres-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-prometheus-api
  name: ClickHouse Prometheus API
  description: The Prometheus API from ClickHouse — 5 operation(s) for prometheus.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - Prometheus
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-prometheus-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-role-management-api
  name: ClickHouse Role Management API
  description: The Role Management API from ClickHouse — 2 operation(s) for role management.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - Role Management
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-role-management-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-service-api
  name: ClickHouse Service API
  description: The Service API from ClickHouse — 15 operation(s) for service.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - Services
  tags_raw:
  - Service
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-service-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-udf-api
  name: ClickHouse UDF API
  description: The UDF API from ClickHouse — 7 operation(s) for udf.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - UDF
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-udf-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
- aid: clickhouse:clickhouse-user-management-api
  name: ClickHouse User management API
  description: The User management API from ClickHouse — 4 operation(s) for user management.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://{clickhouse-host}:8443
  tags:
  - User Management
  tags_raw:
  - User management
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-user-management-api-openapi.yml
  - type: ToolCrosswalk
    url: mcp/clickhouse-tool-crosswalk.yml
  - type: Documentation
    url: https://clickhouse.com/docs/cloud/manage/api/api-overview
  - type: APIReference
    url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
  - type: Swagger
    url: https://clickhouse.com/docs/cloud/manage/api/swagger
common:
- type: FinOps
  url: finops/clickhouse-finops.yml
- type: CapabilityMap
  url: capabilities/clickhouse-capability-edges.yml
  name: ClickHouse Business Capability Map
- type: VulnerabilityDisclosure
  url: security/clickhouse-vulnerability-disclosure.yml
- type: PostmanWorkspace
  url: https://www.postman.com/kinlaneapi/clickhouse/overview
- type: AgenticAccess
  url: agentic-access/clickhouse-agentic-access.yml
- type: TrustCenter
  url: security/clickhouse-trust-center.yml
- type: DomainSecurity
  url: security/clickhouse-domain-security.yml
- type: Authentication
  url: authentication/clickhouse-authentication.yml
- type: LinkedIn
  url: https://www.linkedin.com/company/clickhouseinc
- type: Website
  url: https://clickhouse.com/
- type: Documentation
  url: https://clickhouse.com/docs
- type: GettingStarted
  url: https://clickhouse.com/docs/quick-start
- type: GitHub
  url: https://github.com/ClickHouse/ClickHouse
- type: Blog
  url: https://clickhouse.com/blog
- type: Community
  url: https://clickhouse.com/community
- type: Slack
  url: https://clickhouse.com/slack
- type: Pricing
  url: https://clickhouse.com/pricing
- type: Support
  url: https://clickhouse.com/support
- type: StatusPage
  url: https://status.clickhouse.com/
- type: PrivacyPolicy
  url: https://clickhouse.com/legal/privacy-policy
- type: TermsOfService
  url: https://clickhouse.com/legal/clickhouse-general-terms-and-conditions
- type: JSONLD
  url: json-ld/clickhouse-context.jsonld
- type: Spectral
  url: rules/clickhouse-rules.yml
- type: Integrations
  url: https://clickhouse.com/integrations
- type: AICatalog
  url: ai-catalog/clickhouse-ai-catalog.yml
- type: Packages
  url: packages/clickhouse-packages.yml
- type: SDKs
  url: packages/clickhouse-packages.yml
- type: CLI
  url: cli/clickhouse-cli.yml
- type: WellKnown
  url: well-known/clickhouse-well-known.yml
- type: SecurityTxt
  url: well-known/clickhouse-security.txt
- type: APICatalog
  url: well-known/clickhouse-api-catalog.json
- type: Security
  url: security/clickhouse-vulnerability-disclosure.yml
- type: Compliance
  url: security/clickhouse-trust-center.yml
- type: MCPServer
  url: mcp/clickhouse-mcp.yml
- type: ToolCrosswalk
  url: mcp/clickhouse-tool-crosswalk.yml
- type: LLMsTxt
  url: llms/clickhouse-llms.txt
- type: Protobuf
  url: grpc/clickhouse-grpc.proto
- type: Conformance
  url: conformance/clickhouse-conformance.yml
- type: ErrorCatalog
  url: errors/clickhouse-problem-types.yml
- type: Lifecycle
  url: lifecycle/clickhouse-lifecycle.yml
- type: OAuthScopes
  url: scopes/clickhouse-scopes.yml
- type: Conventions
  url: conventions/clickhouse-conventions.yml
- type: Sandbox
  url: sandbox/clickhouse-sandbox.yml
- type: ChangeLog
  url: changelog/clickhouse-changelog.yml
- type: DataModel
  url: data-model/clickhouse-data-model.yml
- type: Webhooks
  url: asyncapi/clickhouse-webhooks.yml
- type: AgentSkill
  url: skills/_index.yml
- type: Plans
  url: plans/clickhouse-plans-pricing.yml
- type: RateLimits
  url: rate-limits/clickhouse-rate-limits.yml
- type: Overlay
  url: overlays/clickhouse-cloud-api-overlay.yaml
- type: DeveloperPortal
  url: https://clickhouse.com/docs/cloud/manage/api/api-overview
- type: APIReference
  url: https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
- type: GitHubOrganization
  url: https://github.com/ClickHouse
- type: SignUp
  url: https://console.clickhouse.cloud/signUp
- type: Quickstart
  url: https://clickhouse.com/docs/quick-start
- type: Playground
  url: https://sql.clickhouse.com
integrations:
- name: Airbyte
- name: Amazon S3
- name: CloudQuery
- name: Confluent Cloud
- name: Google Cloud Storage (GCS)
- name: Kafka
- name: MySQL
- name: PostgreSQL
- name: Prequel
- name: new Streamkap
- name: Vector
- name: Deepnote
- name: Grafana
- name: Hex
- name: Metabase
- name: Splunk
- name: Superset
- name: Tableau
- name: DataGrip
- name: DBeaver
- name: C#
- name: Java
- name: Node.js
- name: Python
- name: dbt
- name: Microsoft Azure Data Factory
- name: Microsoft Azure Synapse
- name: pg_clickhouse
- name: AWS
- name: Azure
- name: Google Cloud
maintainers:
- FN: Kin Lane
  email: kinlane@gmail.com
x-enrichment:
  date: '2026-09-05'
  status: enriched
  artifacts_added: 35
  pass: local-v3

Work with this as data

Every provider 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 providers

9 MCP tools reach this

find_providersBrowse and filter every provider in the catalog.
get_provider_artifactsEvery artifact this provider publishes, grouped by type.
get_provider_operationsEvery operation across all of their OpenAPIs — one call instead of parsing every spec.
get_provider_toolsEvery MCP tool they ship, with the operation each wraps.
get_provider_evidenceHow each part of their score was established. Free — the basis for a claim should not sit behind it.
get_provider_ratingPRO — composite, band, trend and facet scores.
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 provider

curl "https://apis.io/api/v1/providers/clickhouse"

All providers

curl "https://apis.io/api/v1/providers?limit=25"

Every operation they expose

curl "https://apis.io/api/v1/providers/clickhouse/operations?limit=25"

How their score was established

curl "https://apis.io/api/v1/providers/clickhouse/evidence"

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.