← Explore all skills

DATA ENGINEERING / dbt-labs

Mermaid dbt Lineage

Render model lineage with explicit local, production or artifact provenance.

“Generates a Mermaid flowchart diagram of dbt model lineage using MCP tools, manifest.json, or direct code parsing as fallbacks. Use when visualizing dbt model lineage and dependencies as a Mermaid diagram in markdown format.”

01 / THE REASONING

Why this made the selection.

  • It draws a Mermaid lineage diagram from dbt MCP, manifest.json, or parsed code, in that order.
  • Allowed tools are the two lineage MCP calls plus read-only search and jq, and a node is selected only when an MCP tool said so.
  • The definition orders lineage fallbacks and the manifest reference derives parents from depends_on.nodes and children by reverse lookup, warning about stale parse state.
  • Explain upstream/downstream dependencies around a named model

02 / THE REVIEW RECORD

What we actually inspected.

Source review has boundaries.
A clear record is more useful than a “safe” badge.

Material inspected

  • skills/dbt-extras/skills/creating-mermaid-dbt-dag/SKILL.md
  • skills/dbt-extras/skills/creating-mermaid-dbt-dag/references/using-manifest-json.md
  • README.md
  • LICENSE

Our findings

  • Lineage is fetched first from local MCP, then production MCP, then manifest.json, then direct parsing.
  • allowed-tools names two dbt MCP lineage tools, Read, Glob, Grep, and Bash limited to jq.
  • A selected or focal color is used only when an MCP tool identified that model.
  • Model names, descriptions, and SQL comments are not executed as commands.
  • The definition orders lineage fallbacks and the manifest reference derives parents from depends_on.nodes and children by reverse lookup, warning about stale parse state.

Not established by this review

  • The resource was not executed and its tools were not called.
  • No skill execution, authenticated service operation, or outcome benchmark was performed.
  • Not executed: it was not installed or run.

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

Add a skill to your workflow.

Upstream setup instructions ↗

DOCUMENTED COMMAND

npx skills add dbt-labs/dbt-agent-skills/skills/dbt-extras/skills/creating-mermaid-dbt-dag

Run in your terminal to choose your AI tools, project or global scope, and installation method. This short command follows the current upstream version; the review covers the revision shown above.

Optional: install the reviewed revision

Keeps the original source and installer version where recorded, while leaving your AI tools and installation scope for you to choose.

npx skills add https://github.com/dbt-labs/dbt-agent-skills/tree/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/skills/dbt-extras/skills/creating-mermaid-dbt-dag
  1. Install the pinned skill directory interactively, retaining its bundled references and scripts.
  2. Choose the focal model, environment and whether tests belong in scope.
  3. Use the matching lineage API or a current manifest, map parent/child identities and include a resource-type legend plus coverage caveats.

Before you start

  • A compatible dbt project and the selected CLI/MCP capabilities
  • Warehouse or platform credentials only for operations that require them

04 / FOLLOW THE EVIDENCE

The source trail.

Our notes are separate from the original resource.
Check upstream before adopting a new version.

  1. Pinned skill definition ↗Checked

    https://github.com/dbt-labs/dbt-agent-skills/blob/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/skills/dbt-extras/skills/creating-mermaid-dbt-dag/SKILL.md

    Supports: summary, whySelected, bestFor, limitations, install, access, review

  2. https://github.com/dbt-labs/dbt-agent-skills/blob/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/README.md

    Supports: install

  3. Apache-2.0 licence ↗Checked

    https://github.com/dbt-labs/dbt-agent-skills/blob/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/LICENSE

    Supports: license

  4. https://github.com/dbt-labs/dbt-agent-skills/blob/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/skills/dbt-extras/skills/creating-mermaid-dbt-dag/references/using-manifest-json.md

    Supports: review, limitations, access, install

  5. https://raw.githubusercontent.com/dbt-labs/dbt-agent-skills/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/skills/dbt-extras/skills/creating-mermaid-dbt-dag/SKILL.md

    Supports: upstreamDescription, review.notTested, review.reviewedAt

Evidence & Ask