All Integrations
ClickHouse
Database

ClickHouse

Real-time analytics database

Get started in minutes

1

Connect

Add read-only credentials in Dot. No data leaves your warehouse.

2

Enrich

Dot syncs your schema, relationships, and documentation automatically.

3

Ask

Your team asks questions in natural language and gets SQL-backed answers.

How Dot connects to ClickHouse

Connect with a read-only user over native or HTTP protocol. Dot generates ClickHouse SQL optimized for its columnar engine, MergeTree tables, and materialized views.

What you get

  • Native and HTTP protocol support
  • ClickHouse Cloud compatible
  • Handles MergeTree engine specifics
  • Natural language queries against your data
  • Full SQL audit trail for every answer
  • Automated visualizations and charts
  • Context-aware answers using your documentation
  • Scheduled reports and alerts

Trusted by 100+ top teams

Duolingo
Airbyte
BlaBlaCar
Babbel
Choco
Flix

Try Dot with ClickHouse.

Start for Free

Security & Compliance

Your data, your rules.

Security documentation

Zero Data Retention

All LLM providers are used with zero data retention policies. Your prompts are never stored or used for training.

Dot queries your warehouse in place and surfaces only the results you request. No data is copied or moved.

ZDR enforced

No training

SOC 2 Type II

Annual audits by independent assessors. Continuous monitoring of security controls.

AICPA SOC

SSO & Role-Based Access

Enterprise SSO with SAML. Granular permissions control who can access what data.

Okta

Entra ID

Google

GDPR & HIPAA

EU data processing with full DPA. BAA available for healthcare data.

GDPRHIPAA

Full Audit Logging

Every query, every answer, every user action. Complete audit trail for compliance.