cheatcode_
Demo data

Ladder / Analytics / dbt Skills

Rank 14 of 30 · indexed from open source

dbt Skills

dbt Labs' official skills: answer questions through the semantic layer, build semantic models, write and document models, run and troubleshoot dbt, unit tests, state, mesh.

GitHub ↗

What it does

The core dbt plugin from dbt Labs' dbt-agent-skills repository. Twelve skills for analytics engineering work in a dbt project: answering natural-language questions with dbt, building the semantic layer, using dbt for analytics engineering, maintaining documentation, running commands, troubleshooting job errors, unit tests, state, mesh, the MCP server, docs fetching and DAG diagrams. Requires a dbt project; several skills expect the dbt MCP server or dbt platform. Apache 2.0.

How this listing got here. Packaged from the public repository dbt-labs/dbt-agent-skills at commit 0d09416, under its Apache-2.0 license, bundled verbatim. New upstream releases are repackaged after review, never synced from HEAD. If this is your project, you can claim it or have it removed.

Skills in this package 11

  • adding-dbt-unit-test

    Creates unit test YAML definitions that mock upstream model inputs and validate expected outputs. Use when adding unit tests for a dbt model or practicing test-driven development (TDD) in dbt.

  • answering-natural-language-questions-with-dbt

    Writes and executes SQL queries against the data warehouse using dbt's Semantic Layer or ad-hoc SQL to answer business questions. Use when a user asks about analytics, metrics, KPIs, or data (e.g., "What were total sales last quarter?", "Show me top customers by revenue"). NOT for validating, testing, or building dbt models during development.

  • building-dbt-semantic-layer

    Use when creating or modifying dbt Semantic Layer components — semantic models, metrics, dimensions, entities, measures, or time spines. Covers MetricFlow configuration, metric types (simple, derived, cumulative, ratio, conversion), and validation for both latest and legacy YAML specs.

  • configuring-dbt-mcp-server

    Generates MCP server configuration JSON, resolves authentication setup, and validates server connectivity for dbt. Use when setting up, configuring, or troubleshooting the dbt MCP server for AI tools like Claude Desktop, Claude Code, Cursor, or VS Code.

  • fetching-dbt-docs

    Retrieves and searches dbt documentation pages in LLM-friendly markdown format. Use when fetching dbt documentation, looking up dbt features, or answering questions about dbt Cloud, dbt Core, or the dbt Semantic Layer.

  • maintaining-dbt-documentation

    Audits dbt documentation coverage and drafts missing model/column descriptions in the project's own house style, one folder at a time, for human review. Use when documenting undocumented models, backfilling missing YAML descriptions, auditing doc coverage, or keeping schema YAML in sync with model SQL — especially on multi-contributor projects where new models routinely land undocumented.

  • running-dbt-commands

    Formats and executes dbt CLI commands, selects the correct dbt executable, and structures command parameters. Use when running models, tests, builds, compiles, or show queries via dbt CLI. Use when unsure which dbt executable to use or how to format command parameters.

  • troubleshooting-dbt-job-errors

    Diagnoses dbt Cloud/platform job failures by analyzing run logs, querying the Admin API, reviewing git history, and investigating data issues. Use when a dbt Cloud/platform job fails and you need to diagnose the root cause, especially when error messages are unclear or when intermittent failures occur. Do not use for local dbt development errors.

Show all 11 skills
  • using-dbt-for-analytics-engineering

    Builds and modifies dbt models, writes SQL transformations using ref() and source(), creates tests, and validates results with dbt show. Use when doing any dbt work - building or modifying models, debugging errors, exploring unfamiliar data sources, writing tests, or evaluating impact of changes.

  • using-dbt-state

    Use when a user is enabling, configuring, optimizing, or debugging dbt State (the server-backed reuse mechanism that clones or skips nodes instead of rebuilding them). Use when they conflate dbt State with the `state:modified` selector or `--state` deferral. Use when asked about models rebuilding unexpectedly, views with `select *` rebuilding, volatile SQL (`current_timestamp()`, `random()`) rebuilding or not, cross-developer cloning, lag_tolerance.

  • working-with-dbt-mesh

    Use when changing a dbt model in a way that could break its consumers — renaming, removing, or retyping a column, or changing a model that downstream models, exposures, dashboards, or BI tools depend on — to judge whether the change is breaking and who it affects. Also use when versioning a model (model versions, latest_version, latest_version_pointer, deprecation_date, migration windows), enforcing contracts, setting access or groups, or doing multi-project dbt Mesh work (cross-project refs via dependencies.yml, disambiguating similarly-named models, splitting a monolith). Covers single- and multi-project, and planning or advising as well as implementing.

Certification not run

No certification run yet for this version. The runner is not built; install integrity is the one check that runs today, as the installer verifies the archive's sha256 before writing any file.

Reviews none yet

No reviews yet. Reviews answer the question that decides adoption: does this work for my case.

Discussion quiet

No threads yet.

Versions

v1.5.1+0d09416Indexed from dbt-labs/dbt-agent-skills at 0d09416 · 2026-09-24