Can this skill be used to build or modify dbt models?

No, this skill is specifically optimized for answering business questions. It should not be used for refactoring models, running tests, or managing development workflows.

What happens if I don't have a database connection active?

The skill can still analyze your local manifest and catalog files to provide the SQL query you would need to run, though it won't be able to return the final data results.

Does this skill require an active dbt Semantic Layer?

No, while it prioritizes the dbt Semantic Layer for the highest accuracy, it can fall back to model discovery and manifest analysis to write standard SQL.

How does the skill handle queries that the Semantic Layer doesn't support?

If a query requires logic not currently in the Semantic Layer, the skill retrieves the compiled SQL, applies the necessary modifications, and executes it directly against the warehouse.

dbt Natural Language Analytics

Name: dbt Natural Language Analytics
Author: dbt-labs

bydbt-labs

•

304

•

分析与监控

Answers business and analytics questions by querying data warehouses using the dbt Semantic Layer and SQL discovery.

This skill empowers Claude to act as a data analyst within dbt projects, translating natural language business questions into accurate data insights. It follows a rigorous multi-step priority flow: querying the dbt Semantic Layer first for consistency, modifying compiled SQL for custom requirements, and falling back to model discovery or manifest analysis when necessary. By leveraging dbt metadata, it ensures that answers are derived from the most reliable 'mart' models rather than raw staging data, while providing proactive suggestions to improve your semantic definitions.

主要功能

01Automated discovery of business-ready 'mart' models for SQL generation

02304 GitHub stars

03Query metrics and dimensions directly via the dbt Semantic Layer

04Proactive suggestions for improving semantic layer definitions based on user queries

05Offline analysis of dbt manifest and catalog files to understand schemas

06Modify and execute compiled SQL for advanced custom aggregations and filters

使用场景

01Analyzing trend data like 'Monthly active user growth over the last year'

02Identifying specific segments such as 'Top 10 customers by lifetime value'

03Calculating complex business KPIs like 'Total revenue by region last quarter'

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dbt-labs/dbt-agent-skills answering-natural-language-questions-with-dbt

For use in Claude.ai and ChatGPT

Download Skill

主要功能

01Automated discovery of business-ready 'mart' models for SQL generation

02304 GitHub stars

03Query metrics and dimensions directly via the dbt Semantic Layer

04Proactive suggestions for improving semantic layer definitions based on user queries

05Offline analysis of dbt manifest and catalog files to understand schemas

06Modify and execute compiled SQL for advanced custom aggregations and filters

使用场景

01Analyzing trend data like 'Monthly active user growth over the last year'

02Identifying specific segments such as 'Top 10 customers by lifetime value'

03Calculating complex business KPIs like 'Total revenue by region last quarter'

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dbt-labs/dbt-agent-skills answering-natural-language-questions-with-dbt

For use in Claude.ai and ChatGPT

Download Skill