← Explore all skills

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.

Upstream setup instructions ↗

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.

  1. Install the named skill.
  2. 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.

  1. 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

  2. Repository licence ↗Checked

    https://github.com/dbt-labs/dbt-agent-skills/blob/168a2b0b92da59be88866257140907c206ff0e44/LICENSE

    Supports: Redistribution terms

  3. 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

Evidence & Ask