Connect ClickHouse to ZenSearch
Query your ClickHouse analytics data with natural language. Turn complex analytical questions into fast, columnar queries — no SQL expertise needed.
What ZenSearch indexes from ClickHouse
Analytics-Optimized Queries
ZenSearch generates ClickHouse-specific SQL that leverages columnar storage, materialized views, and ClickHouse functions for fast analytical queries.
Native & HTTP Protocols
Connect via ClickHouse's native TCP protocol for maximum performance or the HTTP interface for broader compatibility and firewall-friendly access.
Schema Discovery
Automatically discovers tables, columns, engines, partitions, and materialized views. Understands ClickHouse-specific data types like Array, Map, and Nested.
Natural Language to SQL
Translates business questions into ClickHouse-compatible SQL. Handles aggregations, window functions, and time-series queries common in analytics workloads.
Column Filtering
Control which tables and columns are exposed for querying. Exclude internal tracking columns or limit scope to specific analytical datasets.
Read-Only Execution
All queries are validated as read-only before execution. INSERT, ALTER, DROP, and other mutation statements are blocked.
Up and running in three steps
Authenticate your account and select the resources to index. ZenSearch handles OAuth, API keys, and enterprise SSO.
ZenSearch parses, chunks, and vectorizes your content. Incremental sync keeps everything up to date automatically.
Your team searches across all connected sources with AI-powered semantic search, chat, and agents.
Questions your team can finally answer
Once ClickHouse is connected, your team can ask natural-language questions and get cited answers instantly.
“What is the daily active user trend over the past 30 days?”
Generates a time-series aggregation query against your events table, grouped by date, and returns the DAU trend with day-over-day changes.
“Which marketing channels have the highest conversion rate this quarter?”
Queries attribution and conversion tables to calculate conversion rates by channel, returning a ranked comparison with sample sizes.
“What is the p95 API response time for the checkout endpoint?”
Uses ClickHouse's quantile functions on your request logs table to calculate the 95th percentile latency for the specified endpoint.
Explore related integrations
PostgreSQL
MySQL
MS SQL ServerReady to search your ClickHouse data?
Connect ClickHouse in minutes. No credit card required.
Start Free