---
title: "Querying the dbt information schema: review, setup & limitations · Undominated.ai"
canonical: https://undominated.ai/skills/dbt-labs-querying-the-dbt-information-schema/
description: "Answers from the project metadata, with two routes, instead of guessing the DAG."
---

# Querying the dbt information schema: review, setup & limitations · Undominated.ai

> Answers from the project metadata, with two routes, instead of guessing the DAG.

[← Explore all skills](/skills/)

DATA AND ANALYTICS / dbt Labs

# Querying the dbt information schema

Answers from the project metadata, with two routes, instead of guessing the DAG.

 [See setup guidance ↓](#setup)[Original source ↗](https://github.com/dbt-labs/dbt-agent-skills/tree/168a2b0b92da59be88866257140907c206ff0e44/skills/dbt/skills/querying-the-dbt-information-schema)

SOURCE REVIEW

 Reviewed 2026-10-15
 Evidence 3 linked sources
 Publisher dbt Labs
 Licence [Apache-2.0 ↗](https://github.com/dbt-labs/dbt-agent-skills/blob/168a2b0b92da59be88866257140907c206ff0e44/LICENSE)
 Revision 168a2b0b92da
 [Read what was—and wasn’t—checked ↓](#review)

“Use when answering questions about a dbt v2 project's own metadata — which models, sources, tests, columns, configs, tags, packages or lineage exist …”

 [dbt Labs · upstream description ↗](https://github.com/dbt-labs/dbt-agent-skills/blob/168a2b0b92da59be88866257140907c206ff0e44/skills/dbt/skills/querying-the-dbt-information-schema/SKILL.md) Our analysis follows below.

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.

### A good fit for

 - Asking which models are untested
- Refusing a lineage claim that was not read from the project
- Count enabled model/test metadata without truncating default query results

### Weigh up before choosing

 - A metadata query is not a production build.
- No dbt project was queried in this review.
- Empty views can reflect the last command rather than missing project resources: parse lacks run results and column lineage. Internal views are outside the public contract.

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 ↗](https://github.com/dbt-labs/dbt-agent-skills/blob/168a2b0b92da59be88866257140907c206ff0e44/README.md)

DOCUMENTED COMMAND

 npx skills add dbt-labs/dbt-agent-skills --skill querying-the-dbt-information-schema Copy command ↗

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

### Compatibility

Agent Skills-compatible hosts · dbt v2

### Local Markdown instructions

 - Read the installed skill files
- Read local DuckDB metadata/parquet and regenerate parse metadata; warehouse build is a separate operation and is not required merely to query metadata.

### Cost model

Source is free to read under the stated licence. A host agent may charge for use.

04 / FOLLOW THE EVIDENCE

## The source trail.

Our notes are separate from the original resource. Check upstream before adopting a new version.

 - [Skill definition ↗](https://github.com/dbt-labs/dbt-agent-skills/blob/168a2b0b92da59be88866257140907c206ff0e44/skills/dbt/skills/querying-the-dbt-information-schema/SKILL.md) Checked 2026-10-14 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 ↗](https://github.com/dbt-labs/dbt-agent-skills/blob/168a2b0b92da59be88866257140907c206ff0e44/LICENSE) Checked 2026-10-07 https://github.com/dbt-labs/dbt-agent-skills/blob/168a2b0b92da59be88866257140907c206ff0e44/LICENSE Supports: Redistribution terms
- [2026-10-15 C2-W13 source re-review at the existing pin ↗](https://raw.githubusercontent.com/dbt-labs/dbt-agent-skills/168a2b0b92da59be88866257140907c206ff0e44/skills/dbt/skills/querying-the-dbt-information-schema/SKILL.md) Checked 2026-10-15 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

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### Adding a dbt unit test ↗ Writes a dbt unit test that mocks upstream inputs instead of querying production.](/skills/dbt-labs-adding-dbt-unit-test/)[### Upgrading dbt ↗ Plans a dbt v1 migration to 1.12 using adapter-specific issue bundles and a recorded verification gate.](/skills/dbt-labs-upgrading-dbt/)[### Working with dbt Mesh ↗ Judges a dbt change by who consumes it, and states that cross-project refs require dbt Cloud Enterprise.](/skills/dbt-labs-working-with-dbt-mesh/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Choose a toolkit](/tools/)
- [Inspect execution hosts](/agents/)
- [Check tool access](/mcp-servers/)
- [Check project dependencies](/check-repo/)
