DuckDB
AvailableDatabases
An in-process analytical database. Point dex at a local DuckDB file with zero credentials required.
Why connect DuckDB?
Connecting DuckDB means your team stops exporting it by hand and starts working with it directly inside Dex.
- Query live data in DuckDB without exporting it or standing up a new pipeline
- Keep dashboards and dbt models in sync with DuckDB instead of a stale nightly copy
- Give teams governed, self-serve access to DuckDB under the same RBAC and audit trail as everything else
Works with Dex
DuckDB connects to the Exmergo products your team already uses.
How it works
Connecting DuckDB to
Exmergo DexZero-credential on-rampPoint Dex at DuckDB
Install Dex in Claude Code by running /plugin marketplace add exmergo/exmergo-agent-plugins and /plugin install dex@exmergo, then run /dex:explore against DuckDB. Dex connects with your DuckDB credentials directly, so they, and your raw data, never enter the model's context.
$ /plugin marketplace add exmergo/exmergo-agent-plugins
$ /plugin install dex@exmergo
$ /dex:explore
Explore before touching anything
/dex:explore profiles the schema it finds in DuckDB and proposes what to model before writing a single line of dbt.
$ /dex:explore
Author governed dbt models
/dex:transform writes and maintains the dbt models and tests that turn raw DuckDB data into trusted, reusable tables in your project.
$ /dex:transform
Stay inside a cost guard
Dex enforces a cost guard on every query it runs against DuckDB, so exploration never turns into a surprise bill.
Catch drift automatically
/dex:maintain flags it when DuckDB's schema changes and proposes the fix, instead of letting your dbt project silently drift out of sync.
$ /dex:maintain