Using dbt-index

dbt-index turns dbt artifacts into a local, queryable DuckDB database. All metadata queries run in milliseconds — no warehouse connection needed.

Works with dbt Core and dbt Fusion.

Phase 1: Ensure the index is ready

Run once per session before answering any question.

Install / update

dbt-index --version          # if not found, install:
curl -fsSL https://public.cdn.getdbt.com/fs/install/install-index.sh | sh
dbt-index system update      # always update to latest

Detect dbt flavor