exmergo-dex-core 0.1.0a1

Analytics engineering for Claude Code and any agent: data warehouse exploration, data transformation, and semantic model maintenance, emitting governed-ready dbt and OSI semantic models.

exmergo-dex-core

The portable, Apache-2.0 analytics-engineering engine behind dex. All non-trivial logic lives here; the Claude Code skills and the cross-agent AGENTS.md are thin wrappers that drive it through one stable command contract.

dex is the agent-native analytics engineering toolkit: explore an unfamiliar warehouse, transform raw data into clean dbt models, and maintain a semantic model on top, then keep all three in sync as the data underneath changes. Read-only against your data; every change is a reviewable diff.

Install

pip install "exmergo-dex-core[duckdb]"

Connector client libraries live behind extras, so the zero-credential DuckDB on-ramp installs only duckdb and sqlglot:

exmergo-dex-core[duckdb]       # the on-ramp and the eval/benchmark engine
exmergo-dex-core[snowflake]
exmergo-dex-core[bigquery]
exmergo-dex-core[databricks]
exmergo-dex-core[postgres]

The command contract

Every subcommand prints exactly one sanitized JSON envelope to stdout and nothing else; credentials and raw rows never cross that boundary. State persists in .dex/, so subcommands are stateless and the agent orchestrates multi-step flows.

dex connect test --path data.duckdb

See references/command-contract.md for the full surface and the envelope spec.

Status

Early and under active development; expect pre-release versions. Today the engine runs the Explore loop on DuckDB end to end: it ranks what matters in an unfamiliar warehouse, profiles columns selectively, flags PII, and infers joins, all read-only. Transform, Model, and Reconcile, and the cloud connectors (BigQuery, Snowflake, Databricks, PostgreSQL), are in progress and report not_implemented until they land. The foundations are in place: the command contract, the canonical model and .dex/ layout, the OSI validator against a pinned schema, and the eval and safety spine.

License

Apache-2.0.