Skip to content
Dex

ClickHouse

ClickHouse Cloud and self-hosted ClickHouse. Dex profiles your tables and authors dbt models, with every scan capped by max_execution_time and max_bytes_to_read.

← All connectors
  • Warehouse
  • Cost guard: Compute seconds
View Dex on GitHubRead the docs

Why connect ClickHouse?

Connecting ClickHouse means your team stops exporting it by hand and starts working with it directly inside Dex.

What you get
  1. 1Query live data in ClickHouse without exporting it or standing up a new pipeline
  2. 2Keep dashboards and dbt models in sync with ClickHouse instead of a stale nightly copy
  3. 3Give teams governed, self-serve access to ClickHouse under the same RBAC and audit trail as everything else
In your repositoryDex

Agent-native analytics engineering for your dbt project.

  • staging/stg_clickhouse.sql
  • semantic/clickhouse_metrics.yml

How it works

Explore, transform, maintain: the Dex loop on ClickHouse.

  1. 1

    Point Dex at ClickHouse

    Install Dex in Claude Code by running /plugin marketplace add exmergo/exmergo-agent-plugins and /plugin install dex@exmergo, then run /dex:explore against ClickHouse. Dex connects with your ClickHouse credentials directly, so they, and your raw data, never enter the model's context.

    clickhouse
    • /plugin marketplace add exmergo/exmergo-agent-plugins
    • /plugin install dex@exmergo
    • /dex:explore
  2. 2

    Explore before touching anything

    /dex:explore profiles the schema it finds in ClickHouse and proposes what to model before writing a single line of dbt.

    clickhouse
    • /dex:explore
  3. 3

    Author governed dbt models

    /dex:transform writes and maintains the dbt models and tests that turn raw ClickHouse data into trusted, reusable tables in your project.

    clickhouse
    • /dex:transform
  4. 4

    Stay inside a cost guard

    Dex enforces a cost guard on every query it runs against ClickHouse, so exploration never turns into a surprise bill.

  5. 5

    Catch drift automatically

    /dex:maintain flags it when ClickHouse's schema changes and proposes the fix, instead of letting your dbt project silently drift out of sync.

    clickhouse
    • /dex:maintain

Other warehouses

Dex brings the same loop and the same guardrails to each of these.

Waitlist

Need a connector we don't support yet?

Tell us about your data source and we'll let you know as soon as the connector is available.

Join the connector waitlist