ClickHouse

aid: clickhouse
name: ClickHouse
url: https://raw.githubusercontent.com/api-evangelist/clickhouse/refs/heads/main/apis.yml
accessModel:
  pricing: freemium
  onboarding: self-serve
  trial: false
  try_now: true
  public: false
  label: Freemium · Self-serve signup
  confidence: high
  source:
  - plans
  - authentication
  generated: '2026-07-22'
  method: derived
created: '2024-01-01'
modified: '2026-04-26'
type: Index
access: 3rd-Party
position: Consumer
specificationVersion: '0.19'
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/clickhouse.png
kind: opensource
tags:
- Analytics
- Cloud Database
- Column-Oriented
- Database
- OLAP
- Open Source
- Real-Time
- SQL
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: http://localhost:8123
  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 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: http://localhost:8123
  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: http://localhost:8123
  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: http://localhost:8123
  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: http://localhost:8123
  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
common:
- 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/en/getting-started
- 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/terms-of-service
- type: JSONLD
  url: json-ld/clickhouse-context.jsonld
- type: Spectral
  url: rules/clickhouse-rules.yml
- type: Integrations
  url: https://clickhouse.com/integrations
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