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