dbt Model Lineage Extractor
Extracts and visualizes dbt model dependency lineage using the dbt Core manifest.json artifact API. Parses ref() and source() calls to build DAG representations via the dbt Cloud API v2.
Extracts and visualizes dbt model dependency lineage using the dbt Core manifest.json artifact API. Parses ref() and source() calls to build DAG representations via the dbt Cloud API v2.
npx skills add agentskillexchange/skills --skill dbt-model-lineage-extractor-2
The dbt Model Lineage Extractor parses dbt project artifacts to build comprehensive data model dependency graphs. It reads the manifest.json artifact generated by dbt compile to extract model nodes, source definitions, and ref() dependency chains. The extractor uses the dbt Cloud API v2 /accounts/{id}/runs endpoint to fetch latest run artifacts and lineage metadata. DAG visualization is generated using the nodes and edges from the manifest, with support for filtering by tag, schema, and materialization type. The skill analyzes source() declarations to map external data dependencies and validates freshness configurations against the dbt source freshness API. It identifies circular dependencies, orphaned models, and overly deep lineage chains that impact build performance. Model documentation is extracted from schema.yml files and enriched with column-level lineage using the dbt catalog.json artifact, providing end-to-end data flow visibility from source tables to final mart models.