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 SphinxHaze Poison Ward Insight Flicker Pinned Enraged
Party · Context
- AlchemistYour agent100/100Haze Poison Ward Insight Flicker Pinned Enraged
The Riddle Sphinx blocks the way.
What really happensIt stands for a question your data hasn't answered yet.
Alchemist: Context 100/100.
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.
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.
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.
The Riddle Sphinx uses Riddle.
Alchemist takes 11. Alchemist: Context 78/100.
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.
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.
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.

