Added on Nov 15,2026

Dex is an open-source, agent-native analytics engine from Exmergo that lets your AI coding agent build and maintain your analytics models and metrics.
It installs as a set of skills into coding agents such as Claude Code, and works with Codex, Gemini CLI, Cursor and others through AGENTS.md. You point it at your data and it works through a loop Exmergo calls ETM: Explore, Transform and Maintain.
In the Explore step, Dex profiles columns, infers relationships between tables and builds a draft map of your warehouse that is cached locally. Personal information is flagged automatically and not surfaced.
In the Transform step, you ask for a metric and Dex writes reviewable diffs: dependency-aware dbt SQL models, schema tests and a semantic layer on top. Changes are validated against development targets with built-in cost guards before anything runs.
In the Maintain step, Dex compares your project against a saved snapshot to detect schema, grain and semantic drift, and proposes the exact edits needed to keep models correct. Its Dex Semantics feature stores the meaning of your data as code, so the next agent session can read it.
It connects to BigQuery, Snowflake, Databricks, Redshift, ClickHouse, PostgreSQL, Trino and DuckDB, and authors semantic layers in the dbt Semantic Layer (MetricFlow), Apache Ossie, SLayer, Cube, Snowflake Semantic Views and Databricks Metric Views. Dex is read-only against your data and does not route it through Exmergo.
Pricing: the single-player Dex is free and open source under Apache 2.0, with no account or credit card required. Dex Enterprise, a team deployed on your own infrastructure with scheduled drift checks and draft pull requests, is in development with custom pricing.
It is suited to analytics engineers and data teams who use dbt and want their coding agents to build reliable models and metrics.
Popular alternatives to Dex include Research Studio, ChartGPT and IBM Watson. Compare their pricing and what each is best for below.
| Tool | Pricing | Best for |
|---|---|---|
| Research Studio | Free Trial | UX researchers, product managers and marketers who need to pull personas and themes from interview recordings and resear... |
| ChartGPT | Free | Students and analysts who need a quick chart from a written description without opening a spreadsheet. |
| IBM Watson | Free Trial | Enterprise IT and data teams who build, govern or deploy AI models and virtual agents on IBM's platform. |
| ExcelDashboard AI | Freemium | Analysts, consultants and reporting teams who turn spreadsheet data into dashboards and slide decks for clients or manag... |
| UXsniff | Freemium | Product and growth teams who want rage clicks and post-change behaviour shifts flagged for them instead of watching reco... |
Leave a review for the community
No Review Found