New: 97,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Dbt Model Index

by warpdotdev in warpdotdev/oz-skills

Provide a lookup index of dbt models (BigQuery tables) to guide query writing against a data warehouse.

MITAuto-check passedDatabases

Install Dbt Model Index

skills CLI
$ npx skills add warpdotdev/oz-skills --skill dbt-model-index -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install warpdotdev/oz-skills dbt-model-index --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/warpdotdev/oz-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/dbt-model-index .claude/skills/dbt-model-index && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
dbt-model-index
GitHub stars
825
Token cost
~915 tokens
SKILL.md length
455 words
Files
1
Skills in repo
13
Repo updated
First seen
Licence
MIT

At a glance

Provide a lookup index of dbt models (BigQuery tables) to guide query writing against a data warehouse.

  • You need to query
  • SKILL.md covers When to Use, How to Set Up This Skill, [Domain: e.g., Users & Identity] and [Domain: e.g., Activity &…, plus 3 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
  • Look up data in a dbt-powered data warehouse

What it does

Dbt Model Index is an agent skill from warpdotdev/oz-skills. Provide a lookup index of dbt models (BigQuery tables) to guide query writing against a data warehouse. Use when you need to query, analyze, or look up data in a dbt-powered data warehouse, or when resolving a vague data question into the right BigQuery tables to query.

Its SKILL.md is about 920 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering Data warehousing and Data pipelines and ETL. It works with dbt and Google BigQuery. The licence is MIT.

When your agent uses it

  • You need to query
  • Look up data in a dbt-powered data warehouse
  • Resolving a vague data question into the right BigQuery tables to query

Example prompts

  • “/dbt-model-index”

What it can do on your machine

Read from SKILL.md and the folder at commit 6c08c49. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Dbt Model Index loads about 915 tokens when it runs. Until then it costs about 72 tokens; SKILL.md has 455 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~72
When it runs · the whole SKILL.md, loaded when a task matches
~915

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from warpdotdev/oz-skills at commit 6c08c49, republished under its MIT licence (© warpdotdev). 455 words, ~915 tokens.

Download SKILL.mdSave it as .claude/skills/dbt-model-index/SKILL.md (or your agent's skills folder).
name
dbt-model-index
description
Provide a lookup index of dbt models (BigQuery tables) to guide query writing against a data warehouse. Use when you need to query, analyze, or look up data in a dbt-powered data warehouse, or when resolving a vague data question into the right BigQuery tables to query.

dbt Model Index

When to Use

  • Before writing any BigQuery SQL against production data
  • When the task has not already explicitly stated which models/tables to query
  • When resolving a vague or ambiguous data question into the right BigQuery tables

How to Set Up This Skill

This skill is a curated index of your dbt models. Each entry describes a model (a BigQuery table), what it contains, and what types of questions it is best suited to answer.

To customize this index for your project:

  • Organize models into logical domain sections (e.g., Users, Activity, Revenue, Events)
  • For each model, include: the table name, a 1–2 sentence description of its grain and content, and "Useful for:" bullets covering common query patterns
  • Note key join keys, standard filters, and partition fields where relevant

[Domain: e.g., Users & Identity]

your_model_name

Brief description of what this model contains. One row per [entity]. Include what makes this model's grain unique and the most important fields.

Useful for:

  • [Type of question this model answers, e.g., user counts, cohort sizes]
  • [Another use case, e.g., filtering to a specific user segment]
  • [Common join pattern, e.g., joining to other tables as the canonical user dimension]
another_model_name

Description of this model and its grain.

Useful for: [Brief use case description]

[Domain: e.g., Activity & Engagement]

your_activity_model

Description of the activity signal (e.g., what counts as "active"), the grain, and the time dimension.

Useful for:

  • [Use case 1, e.g., daily/weekly active user metrics]
  • [Use case 2, e.g., retention analysis]
your_engagement_model

Description.

Useful for:

  • [Use case 1]
  • [Use case 2]

[Domain: e.g., Revenue & Subscriptions]

Show full SKILL.md (196 more words)Show less
your_revenue_model

Description of the revenue grain (e.g., one row per customer per day, or one row per subscription event).

Useful for:

  • [Use case 1, e.g., MRR/ARR reporting]
  • [Use case 2, e.g., churn analysis]
your_subscription_model

Description.

Useful for:

  • [Use case 1]
  • [Use case 2]

[Domain: e.g., Events & Telemetry]

your_events_model

Description of the event source, enrichment applied, and key fields available.

Useful for:

  • [Use case 1, e.g., raw event-level analysis]
  • [Use case 2, e.g., building domain-specific funnels]

Important Notes

  • Standard filters: Document any filters that should always be applied in user-facing queries (e.g., excluding test accounts, soft-deleted records, internal users, or flagged/fraudulent users). Example: where not is_internal_user
  • Production data: Specify your default project/dataset path. Example: your-gcp-project.prod.<model_name>
  • Cost control: For large partitioned tables, always filter on the partition field and constrain the date range to avoid full-table scans
  • Model grain: Always note the grain (one row per what?) for each model to avoid accidental fan-outs in joins
  • Plan/tier types: If your product has subscription tiers or plan types, document the valid values here so queries filter correctly
  • Sensitive datasets: If any models live in a separate dataset, call that out explicitly so queries use the right fully-qualified table reference

© warpdotdev, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .agents/skills/dbt-model-index of warpdotdev/oz-skills.

Open the folder on GitHubat commit 6c08c49

Compare with similar skills

Dbt Model Index next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Dbt Model Index compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Dbt Model Index this skillwarpdotdev/oz-skills825—~915Automated safety check: PassMIT
Data Warehouse Experimentationrampstackco/claude-skills935—~7.3kAutomated safety check: PassMIT
Airflow State Storeastronomer/agents450—~6.1kAutomated safety check: PassApache-2.0
Data Engineertheneoai/awesome-skills183—~2.5kAutomated safety check: PassMIT
Altimate Data Warehouse DelegateAltimateAI/data-engineering-skills127—~1.4kAutomated safety check: PassMIT
Snowflake Developmentsickn33/agentic-awesome-skills47k2 repos~2.1kAutomated safety check: PassMIT

Similar skills

  • Data Warehouse Experimentation

    rampstackco/claude-skills

    Running experiments out of the data warehouse instead of via dedicated experiment platforms.

    935 GitHub stars~7.3k tokensUpdated today
    DatabasesAuto-check passed

  • Airflow State Store

    astronomer/agents

    Persists task and asset state across retries and DAG runs using Airflow 3.3's AIP-103 key/value stores (taskstatestore, assetstatestore) and the crash-safe ResumableJobMixin.

    450 GitHub stars~6.1k tokensUpdated yesterday
    Data & AnalyticsAuto-check passed

  • Data Engineer

    theneoai/awesome-skills

    Expert-level Data Engineer skill covering batch and streaming pipeline design, data warehouse modeling (dbt, Kimball), orchestration (Airflow, Prefect), cloud platforms (BigQuery, Snowflake…

    183 GitHub stars~2.5k tokensUpdated 4 mo ago
    Data & AnalyticsAuto-check passed

  • Altimate Data Warehouse Delegate

    AltimateAI/data-engineering-skills

    Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back.

    127 GitHub stars~1.4k tokensUpdated 5 days ago
    DatabasesAuto-check passed

  • Snowflake Development

    sickn33/agentic-awesome-skills

    Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt…

    47k GitHub starsUsed in 2 repos~2.1k tokens
    DatabasesAuto-check passed

  • Snowflake Development

    alirezarezvani/claude-skills

    A skill your agent uses when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex Agents, writing Snowpark Python…

    28k GitHub stars~3.2k tokensUpdated 1 mo ago
    DatabasesAuto-check passed

More from warpdotdev/oz-skills

All 13 skills in this repo

  • SEO Aeo Audit

    warpdotdev/oz-skills

    Optimize for search engine visibility, ranking, and AI citations.

    825 GitHub stars~4.9k tokensUpdated 1 mo ago
    Auto-check passed

  • Web Accessibility Audit

    warpdotdev/oz-skills

    Audit web applications for WCAG accessibility compliance. An agent skill from warpdotdev/oz-skills.

    825 GitHub stars~3.1k tokensUpdated 1 mo ago
    Auto-check passed

  • Webapp Testing

    warpdotdev/oz-skills

    Test local web applications with Playwright. An agent skill from warpdotdev/oz-skills.

    825 GitHub stars~914 tokensUpdated 1 mo ago
    Auto-check passed

  • GitHub Bug Report Triage

    warpdotdev/oz-skills

    Triage GitHub bug reports for actionability. An agent skill from warpdotdev/oz-skills.

    825 GitHub stars~1.1k tokensUpdated 1 mo ago
    Auto-check passed

  • Analysis Artifacts

    warpdotdev/oz-skills

    Generate reproducible analysis artifacts — SQL queries, Python visualizations, and summary tables — as you work through a BigQuery data analysis.

    825 GitHub stars~1.1k tokensUpdated 1 mo ago
    Auto-check passed

  • CI Fix

    warpdotdev/oz-skills

    Diagnose and fix GitHub Actions CI failures. An agent skill from warpdotdev/oz-skills.

    825 GitHub stars~790 tokensUpdated 1 mo ago
    Auto-check passed

Works with

Categories

Questions about Dbt Model Index

What does Dbt Model Index do?

Provide a lookup index of dbt models (BigQuery tables) to guide query writing against a data warehouse. Dbt Model Index is an agent skill from warpdotdev/oz-skills. Provide a lookup index of dbt models (BigQuery tables) to guide query writing against a data warehouse.

When should I use Dbt Model Index?

Dbt Model Index fits situations like: you need to query; look up data in a dbt-powered data warehouse; resolving a vague data question into the right BigQuery tables to query.

How do I install Dbt Model Index in Claude Code?

Run `npx skills add warpdotdev/oz-skills --skill dbt-model-index -a claude-code`. Or copy the skill folder (.agents/skills/dbt-model-index in warpdotdev/oz-skills) into .claude/skills/dbt-model-index in your project. Claude Code loads it when a task matches its description.

How do I install Dbt Model Index in Codex?

Run `npx skills add warpdotdev/oz-skills --skill dbt-model-index -a codex`. Or copy the skill folder (.agents/skills/dbt-model-index in warpdotdev/oz-skills) into .agents/skills/dbt-model-index in your project. Codex loads it when a task matches its description.

Can I use Dbt Model Index in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add warpdotdev/oz-skills --skill dbt-model-index -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/dbt-model-index, .gemini/skills/dbt-model-index, .github/skills/dbt-model-index and .opencode/skills/dbt-model-index in your project.

What does Dbt Model Index need to run?

SKILL.md names no scripts, command-line tools or credentials: Dbt Model Index is instructions for the agent only.

Does Dbt Model Index access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Dbt Model Index safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Dbt Model Index use?

Dbt Model Index is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Dbt Model Index use?

About 915 tokens (SKILL.md is roughly 3.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Dbt Model Index?

Skills that share tags, products or a category with Dbt Model Index: Data Warehouse Experimentation (rampstackco/claude-skills, 935 stars), Airflow State Store (astronomer/agents, 450 stars), Data Engineer (theneoai/awesome-skills, 183 stars) and Altimate Data Warehouse Delegate (AltimateAI/data-engineering-skills, 127 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Dbt Model Index?

warpdotdev (a GitHub organization) maintains it in warpdotdev/oz-skills, which has 825 GitHub stars. The repository holds 13 skills in this directory. The repository was last updated on August 15, 2026.

Source: warpdotdev/oz-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.