Create Mermaid Diagram in Markdown from dbt DAG

How to use this skill

Step 1: Determine the model name

1. If name is provided, use that name
2. If user is focused on a file, use that name
3. If you don't know the model name: ask immediately, prompt the user to specify it
   • If the user needs to know what models are available, query the list of models
4. Ask the user if they want to include tests in the diagram (if not specified)

Step 2: Fetch the dbt model lineage (hierarchical approach)

Follow this hierarchy. Use the first available method:

1. Primary: Use get_lineage_dev MCP tool (if available)

   • See using-get-lineage-dev.md for detailed instructions
   • Preferred method, provides most accurate local lineage. If the user asks specifically for production lineage, this may not be suitable.

2. Fallback 1: Use get_lineage MCP tool (if get_lineage_dev not available)

   • See using-get-lineage.md for detailed instructions
   • Provides production lineage from dbt Cloud. If the user asks specifically for local lineage, this may not be suitable.

3. Fallback 2: Parse manifest.json (if no MCP tools available)

   • See using-manifest-json.md for detailed instructions
   • Works offline but requires manifest file
   • Check file size first, if too large (>10MB), skip to next method

4. Last Resort: Parse code directly (if manifest.json too large or missing)

   • See parsing-code-directly.md for detailed instructions
   • Labor intensive but always works
   • Provides best-effort incomplete lineage

Step 3: Generate the mermaid diagram

1. Use the formatting guidelines below to create the diagram
2. Include all nodes from the lineage (parents and children)
3. Add appropriate colors based on node types