Exmergo logoExmergo

Explore.Transform.Maintain.

The agent-native analytics engineering toolkit.

Point it at your warehouse and your dbt project. It learns the landscape, authors your transformations, and tells you exactly what to fix when the schema drifts.

1/plugin marketplace add exmergo/exmergo-agent-plugins
2/plugin install dex@exmergo

Run each command in Claude Code, one at a time.

View on GitHub
Works with
Claude Code logoOpenAI Codex logoCursor logo
and more
dex: thelook_ecommerce
❯
ranked inventory
order_items181K rows
inventory_items490K rows
users100K rows
products29K rows
PIIusers.email flagged PII (email) · never surfaced
SELECT product_id, COUNT(*) AS units_sold, SUM(sale_price) AS revenue FROM order_items JOIN inventory_items ON …
needs confirmation · est. 49.3 MB scanned
allowed · 10 rows returned
Draft map cached to .dex/ · fully read-only

Connects to your warehouse

Snowflake logoSnowflake
BigQuery logoBigQuery
DuckDB logoDuckDB
PostgreSQL logoPostgreSQL

Builds

dbt logodbt

The analytics engineer's weekly loop, automated.

ETL ends at Load. dex is built for what comes after.

01Explore

Make sense of the warehouse.

Stop running SELECT * LIMIT 10 by hand. dex intelligently profiles columns, infers relationships, and builds a comprehensive draft map of your tables, cached locally. PII is automatically flagged, never surfaced.

inferred relationships

order_itemsusersproducts
primary key verified · joins probed
02Transform

Author dbt and semantic models.

Ask for a metric, and dex writes the reviewable diffs. It authors dependency-aware dbt SQL models, schema tests, and full MetricFlow YAML. Validate against dev targets with built-in cost guards before anything runs.

dbt

thelook_semantic.yml

+ semantic_models:

+ - name: order_items

+ metrics:

+ - name: revenue

+ - name: return_rate

validated · cost-guarded
03Maintain

Detect drift before it breaks.

Warehouses change. Business definitions drift. Run /dex:maintain against your .dex/ snapshot to instantly detect schema, grain, and semantic drift. dex proposes the exact edits needed to keep your project correct.

drift check

Semantic drift · medium

dim_products.brand narrowed 2757 → 2756

reconciling edit proposed
Security

Your data never leaves the warehouse.

dex is read-only against your data and never routes it through Exmergo. Security is architectural, not a setting.

Data stays in the warehouse.

dex is read-only, and understanding is built from SQL aggregates, never raw rows. Nothing is copied out, so your data never leaves your warehouse.

Your agent, your keys.

You run dex through your own coding agent, on your own API key or subscription. Exmergo never sits between your data and a model.

Credentials never reach the LLM.

dex connects with your warehouse credentials directly (for example, BigQuery Application Default Credentials). Those credentials, and your raw data, never enter the model's context.

Single-player is free. The living organization is Enterprise.

Seamlessly bridge the gap between analytics engineering and business consumption.

dex

Open · Free · Apache 2.0
  • Full ETM loop (explore, transform, maintain)
  • Manual, on-demand drift detection
View on GitHub

Exmergo Enterprise Platform

Everything in free, plus:

  • Continuous, scheduled drift detection & automated PRs
  • Live, governed author-to-serve loop uniting dex and Exmergo Viz
  • Cross-team governance, PII policy, and access audit
Contact Sales

Ready to turn maintenance into an automated habit?

Install the open-source toolkit today.

1/plugin marketplace add exmergo/exmergo-agent-plugins
2/plugin install dex@exmergo

Run each command in Claude Code, one at a time.