dbt

Files (40)

• SKILL.md
• local.patch
• SKILL.md · skills/adding-dbt-unit-test/
• examples.md · skills/adding-dbt-unit-test/references/
• spec.md · skills/adding-dbt-unit-test/references/
• special-cases-ephemeral-dependency.md · skills/adding-dbt-unit-test/references/
• special-cases-incremental-model.md · skills/adding-dbt-unit-test/references/
• special-cases-special-case-overrides.md · skills/adding-dbt-unit-test/references/
• special-cases-versioned-model.md · skills/adding-dbt-unit-test/references/
• warehouse-bigquery-caveats.md · skills/adding-dbt-unit-test/references/
• warehouse-bigquery-data-types.md · skills/adding-dbt-unit-test/references/
• warehouse-postgres-data-types.md · skills/adding-dbt-unit-test/references/
• warehouse-redshift-caveats.md · skills/adding-dbt-unit-test/references/
• warehouse-redshift-data-types.md · skills/adding-dbt-unit-test/references/
• warehouse-snowflake-data-types.md · skills/adding-dbt-unit-test/references/
• warehouse-spark-data-types.md · skills/adding-dbt-unit-test/references/
• SKILL.md · skills/answering-natural-language-questions-with-dbt/
• SKILL.md · skills/building-dbt-semantic-layer/
• best-practices.md · skills/building-dbt-semantic-layer/references/
• latest-spec.md · skills/building-dbt-semantic-layer/references/
• legacy-spec.md · skills/building-dbt-semantic-layer/references/
• time-spine.md · skills/building-dbt-semantic-layer/references/
• SKILL.md · skills/configuring-dbt-mcp-server/
• environment-variables.md · skills/configuring-dbt-mcp-server/references/
• finding-credentials.md · skills/configuring-dbt-mcp-server/references/
• troubleshooting.md · skills/configuring-dbt-mcp-server/references/
• SKILL.md · skills/fetching-dbt-docs/
• search-dbt-docs.sh · skills/fetching-dbt-docs/scripts/
• SKILL.md · skills/running-dbt-commands/
• SKILL.md · skills/troubleshooting-dbt-job-errors/
• investigation-template.md · skills/troubleshooting-dbt-job-errors/references/
• SKILL.md · skills/using-dbt-for-analytics-engineering/
• debugging-dbt-errors.md · skills/using-dbt-for-analytics-engineering/references/
• discovering-data.md · skills/using-dbt-for-analytics-engineering/references/
• evaluating-impact-of-a-dbt-model-change.md · skills/using-dbt-for-analytics-engineering/references/
• managing-packages.md · skills/using-dbt-for-analytics-engineering/references/
• planning-dbt-models.md · skills/using-dbt-for-analytics-engineering/references/
• writing-data-tests.md · skills/using-dbt-for-analytics-engineering/references/
• writing-documentation.md · skills/using-dbt-for-analytics-engineering/references/
• review_run_results.md · skills/using-dbt-for-analytics-engineering/scripts/

SKILL.md (first lines)

# dbt Analytics Engineering Skills

A comprehensive collection of skills for analytics engineering with dbt. Covers building models, writing tests, querying the semantic layer, troubleshooting jobs, and more.

## Included 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.

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

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

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

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

### 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 compatible MCP clients.

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

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

## Source

- **Repository**: https://github.com/dbt-labs/dbt-agent-skills
- **License**: Apache-2.0
- **Author**: dbt Labs

From Kilo-Org/kilo-marketplace, Apache-2.0.

More from Kilo-Org/kilo-marketplace