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 5 APIs on the APIs.io network, including ClickHouse HTTP Interface API, Ping API, Play API, and 2 more. Tagged areas include Analytics, Cloud Database, Column-Oriented, Database, and OLAP.

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 46 more developer resources.

🌐 Visit website 📡 Source on GitHub

68.7/100 exemplar ▬ flat Agent 52/100 agent ready saas Full breakdown ↓
scored 2026-09-08 · rubric v0.20.0

AccessFreemiumSelf serve

2 APIs 1 MCP Servers

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

Kin Score

Kin Score How this is scored →
scored 2026-09-08 · rubric v0.20.0

Composite quality — 68.7/100 · exemplar

Contract Quality 13.5 / 23

Developer Ergonomics 15.0 / 18

Access Clarity 15.6 / 18

Operational Transparency 8.6 / 12

Contract Governance 1.7 / 11

Discoverability 6.0 / 9

Create-or-Update Ergonomics 2.2 / 10

Agent readiness — 52/100 · agent ready

Machine-Readable Contract 18 / 18

Agentic Access Contract 10 / 10

Documented Reversibility 0 / 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

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.

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 →

APIs 10

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 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 Cloud API

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 API Rules

3 rules · 3 warnings

SPECTRAL

ClickHouse API Rules

9 rules · 4 errors 5 warnings

SPECTRAL

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

OAuth 2.0 · no documented scopes

0 scopes

SCOPES

Agentic Access 1

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

Clickhouse Agentic Access

5 operations · 1 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 4

Pricing, plans, and the legal terms of use

Pricing

PrivacyPolicy

TermsOfService

Plans

Company 3

The organization behind the API

LinkedIn

Website

Website

Blog

Blog

Other 5

Properties that don't map to a standard resource type

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: saas
  open_source: false
  commercial: true
  callable_host: false
  label: Hosted service · you call their endpoint
  confidence: medium
  source:
  - openapi
  - pricing
  generated: '2026-08-28'
  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-05'
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
tags:
- Analytics
- Cloud Database
- Column-Oriented
- Database
- OLAP
- Open-Source
- Real-Time
- SQL
tags_raw:
- Analytics
- Cloud Database
- Column-Oriented
- Database
- OLAP
- Open Source
- Real-Time
- SQL
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 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-cloud-api
  name: ClickHouse Cloud API
  description: 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.
  humanURL: https://clickhouse.com/docs/cloud/manage/api/api-overview
  baseURL: https://api.clickhouse.cloud/v1
  tags:
  - Cloud
  - Control Plane
  - Provisioning
  - Billing
  - Observability
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-cloud-api-openapi.json
  - type: Overlay
    url: overlays/clickhouse-cloud-api-overlay.yaml
  - 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: 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.