ClickHouse is a fast open-source column-oriented database management system that enables real-time analytical reporting using SQL. ClickHouse exposes multiple interfaces (HTTP, native TCP, MySQL/PostgreSQL wire protocols, gRPC) and the ClickHouse Cloud management plane offers a public OpenAPI-described REST API for provisioning services, organizations, members, API keys, backups, and private endpoints.
APIs.json: apis.yml
- Type: Index
- x-type: opensource
Analytics, Cloud Database, Column-Oriented, Database, OLAP, Open Source, Real-Time, SQL
HTTP interface (port 8123 / HTTPS 8443) for executing SQL queries. SELECT via GET, mutations via POST, multiple output formats and authentication via HTTP Basic, URL parameters, or X-ClickHouse-User/X-ClickHouse-Key headers.
OpenAPI 3.1-described REST API for managing ClickHouse Cloud organizations, services, API keys, members, backups, private endpoints, and ClickHouse settings.
Native binary TCP protocol used by ClickHouse client libraries for maximum throughput (port 9000).
MySQL wire protocol compatibility for existing MySQL clients and BI tools.
PostgreSQL wire protocol compatibility for psql, JDBC and other PostgreSQL clients.
gRPC interface defined by clickhouse_grpc.proto for efficient binary communication.
- FN: Kin Lane
- Email: kinlane@gmail.com