Gives the agent your dbt project: model lineage, Semantic Layer metrics, model health and dbt build, compile and docs commands.

How it works

Foe: Riddle Sphinx, a question your data hasn't answered yet.

Foes

  • Riddle Sphinx

Party · Context

  • AlchemistYour agent100/100
  1. Riddle Sphinx

    The Riddle Sphinx blocks the way.

    What really happensIt stands for a question your data hasn't answered yet.

    Alchemist: Context 100/100.

  2. Riddle

    The sphinx asks a riddle. A wrong guess costs dearly.

    What really happensAn answer guessed from a hunch instead of a query sends the work the wrong way.

    Alchemist takes 11. Alchemist: Context 89/100.

  3. dbt MCP

    The dbt orb binds to your project folder.

    What really happensClaude Code starts dbt-mcp with uvx. DBT_PROJECT_DIR points at the folder with dbt_project.yml and DBT_PATH at the dbt binary.

    Riddle Sphinx takes 35.

  4. dbt MCP

    The orb traces each model back to its sources.

    What really happensget_lineage and get_node_details show parents, children and details for models, sources and tests. get_model_health adds run status and freshness.

    Riddle Sphinx takes 16.

  5. Riddle

    The Riddle Sphinx uses Riddle.

    Alchemist takes 11. Alchemist: Context 78/100.

  6. dbt MCP

    A metric question meets the Semantic Layer.

    What really happenslist_metrics and query_metrics answer with metrics already defined in dbt instead of hand-written SQL. These tools need dbt platform.

    Riddle Sphinx takes 39.

  7. dbt MCP

    The build runs in order before anyone trusts it.

    What really happensbuild runs models, tests, snapshots and seeds in DAG order. It can change warehouse objects, so only allow it for a client you trust.

    Riddle Sphinx takes 10. Alchemist: Ward. Riddle Sphinx falls.

  8. Victory

    The Riddle Sphinx falls.

Learn this spell

Claude Code

{"mcpServers":{"dbt":{"command":"uvx","args":["dbt-mcp"],"env":{"DBT_PROJECT_DIR":"/path/to/your/dbt/project","DBT_PATH":"/path/to/your/dbt/executable"}}}}

Notes

Latest release v2.8.0. dbt documents Claude Code and Claude Desktop, not Codex. The config shown goes in .mcp.json at the project root and is CLI only; add DBT_HOST for dbt platform tools with OAuth (Starter, Enterprise or Enterprise+). A remote server runs at https://YOUR_DBT_HOST_URL/api/ai/v1/mcp. CLI tools such as build can change models and warehouse objects. execute_sql over a token needs a personal access token.

This spell has no recorded sessions in the curator's logs. Tried it? Send a spell report.