Skip to main content
ZenSearch
clickhouse

Connect ClickHouse to your coworker.

Query your ClickHouse analytics data with natural language. Turn complex analytical questions into fast, columnar queries — no SQL expertise needed.

What It Reads

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.

Setup

Up and running in three steps.

01

Connect

Authenticate your account and select the resources to index. ZenSearch handles OAuth, API keys, and enterprise SSO.

02

Index

ZenSearch parses, chunks, and vectorizes your content. Incremental sync keeps everything up to date automatically.

03

Delegate

Your coworker searches, answers, and acts across this source — with permission-aware results and governed actions.

In Practice

Questions your team can finally ask.

Once ClickHouse is connected, your team asks in natural language and gets cited answers — and governed action — 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.

Get Started

Put ClickHouse
to work.

Connect ClickHouse in minutes and let your coworker read, answer, and act on it.

Try it