What diagram formats does this skill support?

It supports Mermaid, DBML, PlantUML, GraphViz (DOT), D2, and DrawDB formats for comprehensive data visualization.

Can I visualize only specific layers like staging or marts?

Yes, you can filter the output using node selection, exclusion patterns, or specific resource paths to focus on relevant model segments.

Does this skill require third-party tools?

Yes, it utilizes the dbterd CLI tool and requires standard DBT artifacts (manifest.json and catalog.json) to generate visualizations.

What happens if the DBT manifest file is missing?

The skill includes robust error handling that attempts to locate artifacts in alternative paths or falls back to schema.yml analysis.

How does it determine relationships between models?

It offers multiple detection algorithms including test-based (foreign keys), entity-based, and standard DBT ref/source dependencies.

DBT Model Visualizer

Name: DBT Model Visualizer
Author: nerver111

bynerver111

0•

Database Management

Automates the generation of ER diagrams, lineage charts, and metadata reports for DBT projects using dbterd and Mermaid.

The DBT Model Visualizer skill transforms complex data transformation projects into clear, actionable visual assets. By integrating directly with DBT artifacts like manifest and catalog files, it automatically generates Entity Relationship (ER) diagrams in multiple formats (Mermaid, DBML, PlantUML), performs deep lineage analysis, and creates comprehensive metadata reports. This skill is essential for data engineers who need to document architecture, audit data flows, or communicate complex model relationships to stakeholders without manual diagramming.

Key Features

01Metadata exploration and reporting based on manifest.json and catalog.json

020 GitHub stars

03Filtered visualization capabilities by model layer, resource path, or specific nodes

04Support for multiple relationship detection algorithms including entity and test-based

05Automated ER diagram generation in Mermaid, DBML, and PlantUML formats

06Deep lineage analysis of upstream and downstream model dependencies

Use Cases

01Documenting a complex DBT project's architecture for onboarding and knowledge sharing

02Generating professional DBML files for database design reviews and stakeholder presentations

03Visualizing end-to-end data flow from raw sources to marts for impact analysis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test dbt-model-visualizer

For use in Claude.ai and ChatGPT

Key Features

01Metadata exploration and reporting based on manifest.json and catalog.json

020 GitHub stars

03Filtered visualization capabilities by model layer, resource path, or specific nodes

04Support for multiple relationship detection algorithms including entity and test-based

05Automated ER diagram generation in Mermaid, DBML, and PlantUML formats

06Deep lineage analysis of upstream and downstream model dependencies

Use Cases

01Documenting a complex DBT project's architecture for onboarding and knowledge sharing

02Generating professional DBML files for database design reviews and stakeholder presentations

03Visualizing end-to-end data flow from raw sources to marts for impact analysis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test dbt-model-visualizer

For use in Claude.ai and ChatGPT