Integrations
ClickHouse
Connect Castrel to ClickHouse for high-performance columnar database log and analytics queries.
Overview
- Connector name:
clickhouse - Supported API version: ClickHouse HTTP API v1
- Supported server version: ClickHouse 22.0 and above
- Official docs: ClickHouse HTTP Interface
Configuration
To use ClickHouse tools, create a Connector with the following fields:
| Field | Required | Description |
|---|---|---|
base_url | Yes | ClickHouse HTTP API address (e.g., http://localhost:8123) |
username | Yes | ClickHouse username (defaults to default) |
password | Yes | User password |
timeout | No | Request timeout in seconds (default: 30) |
verify_ssl | No | Verify SSL certificates (default: true) |
Available Tools
This connector provides a comprehensive set of tools for ClickHouse data querying and exploration.
- SQL queries: Execute any SELECT query using ClickHouse dialect and functions
- Database exploration: List databases, tables, and column schemas
- Log retrieval: Filter log-type data by time range and conditions
- Aggregation analysis: Perform high-performance aggregate statistics and time-series queries
- Table metadata: Query table row counts, storage sizes, and other metadata