Agents Lookup

Use cases / Data & analytics

Give coding agents access to dbt lineage and metrics

Connect the dbt MCP server so agents can look up models, lineage and metric definitions before writing SQL or changes.

DifficultyIntermediate
Setup time1-2 hours
CategoryData & analytics

The use case

Agents writing SQL against a warehouse do not know which model is the trusted one or how a metric is defined. The dbt MCP server exposes project metadata, lineage, the semantic layer and dbt commands to agents such as Claude or Cursor. An analyst can ask which models feed a dashboard, or have the agent pull a governed metric instead of writing raw SQL. Engineers can have it check downstream impact before changing a model. Keep command execution limited; let people run builds against production.

Example workflow

  1. Install the dbt MCP server and connect your project
  2. Allow metadata and semantic layer tools
  3. Ask about lineage, models or metrics
  4. Use governed metrics instead of hand-written SQL
  5. Run builds yourself after reviewing changes

Tools

Risks and guardrails

Sources

Written by Agents Lookup. Credits and official pages for the tools this use case names: