How does it detect relationships between models?

It uses multiple algorithms such as checking dbt relationship tests, analyzing ref/source dependencies, and entity relationship detection.

Can I visualize only specific parts of my dbt project?

Yes, you can filter the visualization by node name, resource path, or specific dbt layers like staging, intermediate, or marts.

What formats can this skill generate for ER diagrams?

The skill supports a wide range of formats including Mermaid, DBML, PlantUML, GraphViz, D2, and DrawDB.

Does it require pre-generated dbt artifacts?

While it can use existing ones, the skill is capable of running 'dbt docs generate' automatically to create the necessary manifest and catalog files.

dbt Model Visualizer

Name: dbt Model Visualizer
Author: nerver111

bynerver111

0•

数据库管理

Generates automated ER diagrams, data lineage maps, and metadata reports for dbt projects.

This skill empowers dbt developers to automatically visualize their data models by generating Entity Relationship (ER) diagrams, analyzing data lineage, and exploring metadata. It leverages tools like dbterd to produce diagrams in various formats such as Mermaid, DBML, and PlantUML directly from dbt artifacts. By automating the extraction of relationships from manifest and catalog files, it helps teams understand complex project structures, track dependencies from source to target, and maintain up-to-date documentation of their data architecture without manual effort.

主要功能

01Comprehensive metadata exploration including column types and statistics

02Support for multiple relationship detection algorithms (test-based, entity-based)

03Selective visualization by model layer, path, or specific nodes

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

050 GitHub stars

06End-to-end data lineage analysis using dbt manifest artifacts

使用场景

01Generating architectural documentation for onboarding new data team members

02Auditing project health by visualizing model layers and cross-layer relationships

03Debugging complex data dependencies and identifying bottlenecks in data lineage

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

主要功能

01Comprehensive metadata exploration including column types and statistics

02Support for multiple relationship detection algorithms (test-based, entity-based)

03Selective visualization by model layer, path, or specific nodes

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

050 GitHub stars

06End-to-end data lineage analysis using dbt manifest artifacts

使用场景

01Generating architectural documentation for onboarding new data team members

02Auditing project health by visualizing model layers and cross-layer relationships

03Debugging complex data dependencies and identifying bottlenecks in data lineage

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