Does it support complex queries like YoY growth?

Absolutely. It includes built-in patterns for trend analysis, year-over-year growth, rankings, and moving averages, translating simple requests into complex SQL.

Is the data fetched in real-time?

The skill includes a data refresh strategy that checks the project state and can be configured to periodically fetch the latest metrics to ensure data freshness.

Can it generate charts automatically?

Yes, it automatically selects the most appropriate visualization type (line chart, bar chart, or table) based on the data structure and generates the configuration for you.

How does dbt-semantic-query handle filters?

It uses context-aware management to remember filters like date ranges or regions across multiple turns in a conversation, so you do not have to repeat them in every prompt.

How does it find the right metrics in my dbt project?

It utilizes semantic search against a vector store of your metrics and dimensions, allowing it to map synonyms like 'income' or 'sales' to the correct dbt 'revenue' metric.

DBT Semantic Query Expert

Name: DBT Semantic Query Expert
Author: nerver111

bynerver111

0•

分析と監視

Enables natural language querying of dbt semantic layer metrics with context-aware filtering and automated data visualization.

The dbt-semantic-query skill transforms complex data exploration into a conversational experience by allowing users to query dbt semantic layer metrics using natural language. It intelligently manages conversation context to apply persistent filters across multiple queries, performs semantic searches to map user intent to technical dimensions, and automatically generates SQL for trends, comparisons, and rankings. This skill is ideal for data analysts and developers who need to quickly extract insights, visualize trends, and perform drill-down analysis without manual SQL coding.

主な機能

01Natural language to SQL translation for dbt semantic layers

020 GitHub stars

03Semantic search for accurate metric and dimension mapping

04Real-time data refresh and query history management

05Context-aware filtering that persists across conversation turns

06Automated data visualization with smart chart type selection

ユースケース

01Performing ad-hoc business metric analysis using conversational English

02Generating automated trend reports and year-over-year growth comparisons

03Drilling down into specific data dimensions like region or segment without repeating filters

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test dbt-semantic-query

For use in Claude.ai and ChatGPT

主な機能

01Natural language to SQL translation for dbt semantic layers

020 GitHub stars

03Semantic search for accurate metric and dimension mapping

04Real-time data refresh and query history management

05Context-aware filtering that persists across conversation turns

06Automated data visualization with smart chart type selection

ユースケース

01Performing ad-hoc business metric analysis using conversational English

02Generating automated trend reports and year-over-year growth comparisons

03Drilling down into specific data dimensions like region or segment without repeating filters

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test dbt-semantic-query

For use in Claude.ai and ChatGPT