Connect to your ClickHouse® instance, explore EDB-specific capabilities, and find resources for going further.
Connecting to ClickHouse®
Once ClickHouse is installed and running, connect using clickhouse-client:
clickhouse-client
Verify you're running an EDB-packaged build:
SELECT version();
The output includes the EDB release, for example 26.8.15.10+1edb1.
Integrations
- Connecting to WarehousePG: read from and write to WarehousePG tables using the
PostgreSQLtable engine - Reading Apache Iceberg® tables: query Iceberg tables stored in Amazon S3 or Azure Blob Storage
- Connecting AI agents with MCP: let AI agents and LLM-based tools query ClickHouse using the MCP server
- Monitoring Postgres with pg_stat_ch: capture per-query execution telemetry from Postgres and analyze it in ClickHouse
- Querying ClickHouse from Postgres with pg_clickhouse: run analytics queries on ClickHouse from Postgres without rewriting SQL
See also
For SQL reference, configuration, and operational guidance beyond what's covered here, refer to the upstream ClickHouse documentation: