# ClickHouse

**Canonical:** https://apis.io/providers/clickhouse/  
**Website:** https://clickhouse.com/  
**APIs profiled:** 9

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.

## Kin Score — 41.4 / 100 (developing)

Scored 2026-08-20 under rubric 0.12.0. Trend: flat (+0.0 from 41.4).

| Facet | Score |
|---|---|
| Discoverability | 64.8 |
| Contract Quality | 56.6 |
| Governance | 11.4 |
| Contract Governance | 11.4 |
| Operational Transparency | 28.9 |
| Developer Ergonomics | 33.3 |
| Commercial Clarity | 44.7 |
| Access Clarity | 44.7 |

## Agent readiness — 30.3 (agent-aware)

| Dimension | Value |
|---|---|
| Spec Presence | yes |
| Agentic Access | derived |
| Reversibility Documented | no |
| MCP Server | no |
| Auth Clarity | yes |
| Idempotency | no |
| Error Semantics | no |
| OpenAPI Examples | no |
| Rate Limit Signal | documented |
| Event Surface Described | derived |
| Agent Skills | no |
| Well Known Catalog | no |
| Consent Identity | no |
| Agent Card | no |
| Dry Run Mode | no |

## Access

Freemium · Self-serve signup — onboarding: self-serve, pricing: freemium, trial: no (confidence: high).

## APIs (9)

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

## Agentic access (1)

- **Clickhouse Agentic Access** — 5 operations · 1 acting

## Security (3)

- **Clickhouse Authentication** — apiKey/http · 2 schemes
- **Clickhouse Domain Security** — TLSv1.3 · HSTS · DMARC
- **Clickhouse Trust Center** — SOC 2, ISO 27001, PCI DSS, HIPAA, GDPR

## Plans (1)

- **Clickhouse Plans Pricing**

## Tags

Analytics, Cloud Database, Column-Oriented, Database, OLAP, Open-Source, Real-Time, SQL

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/providers/clickhouse/). Scores are computed from the provider's own public artifacts under a published rubric.