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

🌐 Visit website 📡 Source on GitHub

73.5/100 exemplar ▬ flat Agent 60/100 agent ready Front door AI 5/6 prominent open core · Apache-2.0 Full breakdown ↓
scored 2026-09-25 · rubric v0.23.0

AccessFreemiumSelf serve

2 APIs 1 MCP Servers

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

Kin Score

Kin Score How this is scored →
scored 2026-09-25 · rubric v0.23.0

Composite quality — 73.5/100 · exemplar

Contract Quality 11.6 / 19

Developer Ergonomics 12.5 / 15

Access Clarity 13.0 / 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 →

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

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

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 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: 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: 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.