ClickHouse

Category: SQL, Timeseries Status: base

Connects to a ClickHouse columnar analytical database. Optimized for OLAP queries on large datasets and time-series data.

Connection Settings

Field	Default	Description
host	localhost	Server hostname or IP
port	8123	HTTP interface port
user	(empty)	Username
password	(empty)	Password (1–128 chars, no spaces/quotes)
dbname	(empty)	Database name
url	(empty)	Full connection URL (overrides above fields)
authentication	no_auth	no_auth or user_password

Authentication

Two modes: no_auth or user_password.

Supported Actions

• execute — run SQL queries
• download — export table or query result
• delete — drop tables
• transfer_table — copy table to another connector
• create_user — add a database user
• search_by_value — search within fetched table data

Required Setup

Requires the aiochclient Python package:

pip install aiochclient

External Links

• https://clickhouse.com/docs/