DATA AND ANALYTICS / dbt Labs
Querying the dbt information schema
Answers from the project metadata, with two routes, instead of guessing the DAG.
“Use when answering questions about a dbt v2 project's own metadata — which models, sources, tests, columns, configs, tags, packages or lineage exist …”
01 / THE REASONING
Why this made the selection.
- The description limits the skill to a dbt v2 project's own metadata.
- Headings name Route A dbt show and Route B DuckDB on parquet.
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/skills/querying-the-dbt-information-schema/SKILL.md
- LICENSE
Our findings
- Headings include Prerequisites.
- The definition documents default row truncation, string null versions, distinct data/unit-test join keys and command-dependent view population.
- Inline queries must contain a literal info_schema call, must not use ref or source, and must ignore the stale target/index and target/metadata directories.
Not established by this review
- The skill was not executed inside a host agent.
- 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.
DOCUMENTED COMMAND
npx skills add dbt-labs/dbt-agent-skills --skill querying-the-dbt-information-schema 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.
- Install the named skill.
- Use the route the skill names. Do not invent a model list.
Before you start
- A dbt v2 project
04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
- Skill definition ↗Checked
https://github.com/dbt-labs/dbt-agent-skills/blob/168a2b0b92da59be88866257140907c206ff0e44/skills/dbt/skills/querying-the-dbt-information-schema/SKILL.md
Supports: Workflow and stated scope
- Repository licence ↗Checked
https://github.com/dbt-labs/dbt-agent-skills/blob/168a2b0b92da59be88866257140907c206ff0e44/LICENSE
Supports: Redistribution terms
https://raw.githubusercontent.com/dbt-labs/dbt-agent-skills/168a2b0b92da59be88866257140907c206ff0e44/skills/dbt/skills/querying-the-dbt-information-schema/SKILL.md
Supports: upstreamDescription, review.notTested, review.reviewedAt