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 25 API contracts indexed on the APIs.io network, including HTTP Interface API, Ping API, Play API, and 22 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

76.9/100 exemplar ▬ flat Agent 58/100 agent ready Front door AI 5/6 prominent Heartbeat 96/100 alive open core · Apache-2.0 Full breakdown ↓
scored 2026-11-06 · rubric v0.27.0 · Show this score on your site →

AccessPaid

3 published contracts 1 MCP Servers 11 Agent Skills

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 Get a presigned URL to upload UDF code “Where do I upload the zip archive containing my UDF source code?” List the organization's UDFs “What user-defined functions exist in my ClickHouse Cloud organization?” Create a new UDF “How do I create a brand-new user-defined function in ClickHouse Cloud?” Delete a UDF and all its versions “How do I delete a user-defined function everywhere it's used?”

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-11-06 · rubric v0.27.0

Composite quality — 76.9/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.4 / 8

Regulatory Posture 6.8 / 15

Create-or-Update Ergonomics 5.0 / 10

Agent readiness — 58/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

Pagination 0 / 5

Distinct Operations 3 / 3

MCP Tool Quality 6 / 6

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

Show this score on your site.

It updates itself when the score changes. Paste this where you link to your API docs:

<a href="https://apis.io/providers/clickhouse/"><img src="https://apis.io/badge/clickhouse/card.svg" alt="ClickHouse on APIs.io — Kin Score by API Evangelist"></a>

Other styles, a README pill and a shields.io endpoint are on the badge page.

Raise your score.

Agent readiness — checks not met, largest first (exact, from this profile):

Idempotency +9 pts — OpenAPI mutating operations declare an idempotency key — a header, a request-body property, or a named de-duplication token whose own description says so (verified); else common[].type matches /idempoten/i (documented)
A2A Agent Card +8 pts — a2a/-a2a.yml manifest, graded on conformance.grade against A2A 1.0.0
Pagination +5 pts — share of collection GETs (an array, or one wrapped in data/items/results ...) that declare a page/limit/offset/cursor parameter, a Link header or a next/cursor field; na with no collection GETs
Agentic Commerce Well-Known Document +5 pts — a parsing /.well-known/ucp.json or acp.json declaring a version and at least one service, OR (0.27) a live x402 payment challenge from _data/x402-adoption.json — `self` when its endpoints are on the provider's own domain, `platform` when they are on a vendor's
Dry-Run / Simulate Mode +4 pts — OpenAPI: destructive operations expose a dry_run / simulate / preview / validate_only parameter
Consent & Bot Identity +3 pts — common[].type includes AIPREF, ContentSignal, WebBotAuth, or HTTPMessageSignatures

Kin Score — facets with the most composite points still available (weight × headroom):

Contract Governance scores 15.9 — up to +10.1 composite points
Contract Quality scores 61.9 — up to +9.5 composite points
Operational Transparency scores 73.7 — up to +3.4 composite points

Each check links to what satisfies it. Publish the artifact, or tell us where it already lives, and the score moves on the next scoring run.

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 the provider profile at artifacts.apis.io/clickhouse/apis.yml: open an issue on github.com/api-evangelist/clickhouse to ask a question or point us at an artifact you publish. 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	55.9	-	2
Retrieval, Vector and RAG	mixed	55.9	-	2
Agent Skills (SKILL.md packages)	mixed	55.9	-	2
VC Portfolios (a16z, Battery Ventures, Sequoia Capital, Index Ventures participation)	mixed	55.9	-	2
Infrastructure-as-Code Provider Registries (Terraform, OpenTofu, Pulumi)	mixed	55.9	-	2
Stripe App Marketplace and Partner Ecosystem (builders on Stripe)	mixed	55.9	-	2
Cisco DevNet Ecosystem (builders on Meraki, Catalyst, ISE, ThousandEyes, Splunk)	mixed	55.9	-	2
Vulnerability Disclosure (CVE Numbering Authorities, FIRST member teams; CISA KEV exposure)	mixed	55.9	-	2
OpenSSF Best Practices Badge Holders	mixed	55.9	-	2
Docker Hub Verified Publishers + Official Images	mixed	55.9	-	2

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.

Standards implemented 6

Standards this provider implements or carries. De facto ones are profiled and measured by the API Commons; formal ones come from the standards directory and are linked by the provider's own tags. The evidence column says how each claim was established — not that it was made.

Model Context Protocol (MCP)

measured — observed by APIs.io (verified)

Agent Skills

measured — observed by APIs.io (published)

OAuth 2.0 Protected Resource Metadata

measured — observed by APIs.io (verified)

Dynamic Client Registration

measured — observed by APIs.io (published)

OpenAPI

measured — observed by APIs.io (published)

OAuth 2.0

measured — observed by APIs.io (declared)

APIs 25

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

The User management API from ClickHouse — 4 operation(s) for user management.

ClickHouse Notifications API

The Notifications API from ClickHouse — 2 operation(s) for notifications.

ClickHouse Query API endpoints API

The Query API endpoints API from ClickHouse — 2 operation(s) for query api endpoints.

ClickHouse Saved queries API

The Saved queries API from ClickHouse — 2 operation(s) for saved queries.

ClickHouse Snapshot API

The Snapshot API from ClickHouse — 3 operation(s) for snapshot.

Scroll for all 25

Postman Collections 4

Ready-to-run Postman collections for exercising this provider's APIs.

ClickHouse HTTP Interface API

POSTMAN

ClickHouse HTTP Interface Ping API

POSTMAN

ClickHouse HTTP Interface Play API

POSTMAN

ClickHouse HTTP Interface Replicas Status API

POSTMAN

Open Collections 5

Open, tool-agnostic API collections (OpenAPI-derived and Bruno).

ClickHouse HTTP Interface API

OPEN COLLECTION

ClickHouse HTTP Interface Ping API

OPEN COLLECTION

ClickHouse HTTP Interface Play API

OPEN COLLECTION

ClickHouse HTTP Interface Replicas Status API

OPEN COLLECTION

ClickHouse HTTP Interface

OPEN COLLECTION

MCP Servers 1

Model Context Protocol servers that expose these APIs to AI agents.

ClickHouse MCP Server

Remote MCP server at mcp.clickhouse.cloud requiring OAuth; 13 tools listed.

MCP SERVER

Agent Skills 11

Packaged agent skills for driving this provider's APIs from an AI assistant.

clickhouse-architecture-advisor

AGENT SKILL

clickhouse-best-practices

AGENT SKILL

chdb-datastore

AGENT SKILL

chdb-sql

AGENT SKILL

clickstack-otel-collector

AGENT SKILL

infra-clickhouse

AGENT SKILL

infra-postgres

AGENT SKILL

clickhouse-js-node-coding

AGENT SKILL

clickhouse-js-node-rowbinary

AGENT SKILL

clickhouse-js-node-troubleshooting

AGENT SKILL

clickhouse-managed-postgres-rca

AGENT SKILL

Scroll for all 11

ClickHouse API pricing

Prices published by ClickHouse, read 2026-10-28 from clickhouse.com/pricing.

Plan	Price
Basic	$0.2181 Per unit/ hr Includes: Up to 1 TB storage, 8-12 GiB total memory, backups every 24h retained 1 day, 1 availability zone
Scale	$0.2985 Per unit/ hr Includes: Unlimited storage, configurable memory, compute-compute separation, 2+ availability zones
Enterprise	$0.3903 Per unit/ hr Includes: Everything in Scale, plus SAML SSO, private regions, CMEK, HIPAA and PCI compliance
ClickHouse Managed Postgres (Beta)	from $0.125 Per unit/ hr Includes: Available in Beta on all three plans; 50% off during beta
Bring Your Own Cloud	Get a custom quote Includes: Deployment within your own VPC

Plan details, limits and sources →

Rate limits

Cloud API key request rate: 10 requests

Rate-limit details →

Billed by: compute unit / hr · FinOps profile →

Pricing Plans 2

Published pricing tiers and plan structures.

Clickhouse Plans Pricing

5 plans

PLANS

Clickhouse Price Estimates

0 plans

PLANS

Rate Limits 1

Documented rate limits and quota policies.

Clickhouse Rate Limits

1 limits

RATE LIMITS

Service Levels 1

Uptime the provider promises or reports, as SLA4OAI. Read from its own pages; APIs.io runs no monitors.

ClickHouse

SLA

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

OpenAPI Overlays 17

Overlays applied on top of this provider's contracts. Each card says who wrote it: a document the provider publishes, or one API Evangelist derived or generated.

Clickhouse Api Keys Api Phrasing Overlay

6 actions · phrasing · clickhouse-api-keys-api-openapi.yml

GENERATED

Clickhouse Backup Api Phrasing Overlay

9 actions · phrasing · clickhouse-backup-api-openapi.yml

GENERATED

Clickhouse Billing Api Phrasing Overlay

4 actions · phrasing · clickhouse-billing-api-openapi.yml

GENERATED

Clickhouse Clickhouse Http Interface Api Phrasing Overlay

3 actions · phrasing · clickhouse-clickhouse-http-interface-api-openapi.yml

GENERATED

Clickhouse Clickpipes Api Phrasing Overlay

19 actions · phrasing · clickhouse-clickpipes-api-openapi.yml

GENERATED

Clickhouse Clickstack Api Phrasing Overlay

31 actions · phrasing · clickhouse-clickstack-api-openapi.yml

GENERATED

Clickhouse Cloud Api Overlay

4 actions · update

DERIVED

Clickhouse Organization Api Phrasing Overlay

12 actions · phrasing · clickhouse-organization-api-openapi.yml

GENERATED

Clickhouse Ping Api Phrasing Overlay

2 actions · phrasing · clickhouse-ping-api-openapi.yml

GENERATED

Clickhouse Play Api Phrasing Overlay

2 actions · phrasing · clickhouse-play-api-openapi.yml

GENERATED

Clickhouse Postgres Api Phrasing Overlay

18 actions · phrasing · clickhouse-postgres-api-openapi.yml

GENERATED

Clickhouse Prometheus Api Phrasing Overlay

6 actions · phrasing · clickhouse-prometheus-api-openapi.yml

GENERATED

Clickhouse Replicas Status Api Phrasing Overlay

2 actions · phrasing · clickhouse-replicas-status-api-openapi.yml

GENERATED

Clickhouse Role Management Api Phrasing Overlay

6 actions · phrasing · clickhouse-role-management-api-openapi.yml

GENERATED

Clickhouse Service Api Phrasing Overlay

27 actions · phrasing · clickhouse-service-api-openapi.yml

GENERATED

Clickhouse Udf Api Phrasing Overlay

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: paid
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Paid
  confidence: high
  source:
  - plans
  - authentication
  - scopes
  - rate-limits
  - security
  - sandbox
  generated: '2026-11-06'
  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
- aid: clickhouse:clickhouse-notifications-api
  name: ClickHouse Notifications API
  description: The Notifications API from ClickHouse — 2 operation(s) for notifications.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://api.clickhouse.cloud
  tags:
  - Notifications
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-notifications-api-openapi.yml
- aid: clickhouse:clickhouse-query-api-endpoints-api
  name: ClickHouse Query API endpoints API
  description: The Query API endpoints API from ClickHouse — 2 operation(s) for query api endpoints.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://api.clickhouse.cloud
  tags:
  - Query API endpoints
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-query-api-endpoints-api-openapi.yml
- aid: clickhouse:clickhouse-saved-queries-api
  name: ClickHouse Saved queries API
  description: The Saved queries API from ClickHouse — 2 operation(s) for saved queries.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://api.clickhouse.cloud
  tags:
  - Saved queries
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-saved-queries-api-openapi.yml
- aid: clickhouse:clickhouse-snapshot-api
  name: ClickHouse Snapshot API
  description: The Snapshot API from ClickHouse — 3 operation(s) for snapshot.
  humanURL: https://clickhouse.com/docs/en/interfaces/http
  baseURL: https://api.clickhouse.cloud
  tags:
  - Snapshot
  properties:
  - type: OpenAPI
    url: openapi/clickhouse-snapshot-api-openapi.yml
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

ClickHouse API — frequently asked questions

Does ClickHouse have an API?

Yes. APIs.io lists 25 APIs from ClickHouse, including ClickHouse HTTP Interface, ClickHouse Native TCP Interface and ClickHouse MySQL Interface, and 22 more.

Is there an OpenAPI specification for the ClickHouse API?

Yes. APIs.io indexes 20 OpenAPI specifications for ClickHouse, each linked for download from this page.

How do I authenticate with the ClickHouse API?

ClickHouse documents its authentication (http/apiKey/oauth2 · 0 schemes). The details are profiled on APIs.io as Clickhouse Authentication.

How much does the ClickHouse API cost?

ClickHouse publishes its prices; its Basic plan is $0.2181 Per unit/ hr as of 2026-10-28. APIs.io lists 5 pricing plans for ClickHouse, with each plan's price, limits and inclusions under Pricing on this page.

Does ClickHouse have an MCP server?

Yes. APIs.io lists 1 MCP server for ClickHouse: Remote MCP server at mcp.clickhouse.cloud requiring OAuth; 13 tools listed.

Is the ClickHouse API ready for AI agents?

ClickHouse has a Kin Score of 76.9 out of 100 (exemplar) and an Agent Readiness score of 58.4 (agent-ready), scored by API Evangelist on 2026-11-06.

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"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

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.