⚡

ClickHouse

High-performance OLAP for analytics at scale

Connection Settings

Field	Description	Example
Host	ClickHouse server hostname	clickhouse.example.com
Port	Native protocol: 9000, HTTP: 8123	8123
Database	Database name	analytics
Protocol	Connection protocol	HTTP / Native
Username	Database user	default
Password	User password (optional)	••••••••

Features

Native Protocol

High-performance binary protocol for fastest queries

HTTP Interface

REST API support for flexible integrations

Distributed Queries

Query across clusters and shards seamlessly

Materialized Views

Explore pre-aggregated data for instant insights

Protocol Comparison

Protocol	Port	Best For
Native (TCP)	9000 / 9440 (TLS)	Best performance, large result sets
HTTP	8123 / 8443 (TLS)	Firewall-friendly, load balancers

Recommended Permissions

Create a read-only user for analytics:

CREATE USER dbcraft_reader IDENTIFIED BY 'secure_password';
GRANT SELECT ON analytics.* TO dbcraft_reader;
GRANT SHOW TABLES ON analytics.* TO dbcraft_reader;