ClickHouse (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.

APIs.json: https://raw.githubusercontent.com/api-evangelist/clickhouse/refs/heads/main/apis.yml

Scope

• Type: Index
• Position: Consumer
• Access: 3rd-Party

Tags

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

Timestamps

• Created: 2024-01-01
• Modified: 2026-04-26

APIs

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, TabSeparated), and authentication via HTTP Basic, URL parameters, or X-ClickHouse-User/X-ClickHouse-Key headers. Helper paths include /ping and /replicas_status.

• Human URL: https://clickhouse.com/docs/en/interfaces/http
• Base URL: http://localhost:8123

Tags

• Database
• HTTP
• SQL

Properties

• Documentation
• Postman Collection — Postman Collection 2.1
• Open Collection — Open Collection 1.0

ClickHouse Cloud API

OpenAPI 3.1-described REST API for managing ClickHouse Cloud organizations, services, API keys, members, backups, private endpoints, and ClickHouse settings. Endpoints under /v1 with consistent envelope responses (status, requestId, result, error) and authentication via API key.

• Human URL: https://clickhouse.com/docs/en/cloud/manage/api/api-overview
• Base URL: https://api.clickhouse.cloud

Tags

• Cloud
• Management
• REST

Properties

• Documentation
• Swagger
• OpenAPI — OpenAPI Specification
• Postman Collection — Postman Collection 2.1
• Open Collection — Open Collection 1.0

ClickHouse Native TCP Interface

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

• Human URL: https://clickhouse.com/docs/en/interfaces/tcp

Tags

• Native
• TCP

Properties

• Documentation
• Postman Collection — Postman Collection 2.1
• Open Collection — Open Collection 1.0

ClickHouse MySQL Interface

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

• Human URL: https://clickhouse.com/docs/en/interfaces/mysql

Tags

• MySQL
• Wire Protocol

Properties

• Documentation
• Postman Collection — Postman Collection 2.1
• Open Collection — Open Collection 1.0

ClickHouse PostgreSQL Interface

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

• Human URL: https://clickhouse.com/docs/en/interfaces/postgresql

Tags

• PostgreSQL
• Wire Protocol

Properties

• Documentation
• Postman Collection — Postman Collection 2.1
• Open Collection — Open Collection 1.0

ClickHouse gRPC Interface

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

• Human URL: https://clickhouse.com/docs/en/interfaces/grpc

Tags

• gRPC
• Protocol Buffers

Properties

• Documentation
• Protocol Buffers
• Postman Collection — Postman Collection 2.1
• Open Collection — Open Collection 1.0

Common Properties

• LinkedIn
• Website
• Documentation
• Getting Started
• Git Hub
• Blog
• Community
• Slack
• Pricing
• Support
• Status Page
• Privacy Policy
• Terms of Service
• JSON-LD — JSON-LD
• Spectral Rules — Spectral
• Integrations

Maintainers

FN: Kin Lane Email: kinlane@gmail.com