How does this skill handle schema discovery?

It uses specialized tool calls like ls, grep, and read_file to inspect your dbt models and YAML configuration files, ensuring generated queries match your specific database structure exactly.

Are there limits on the amount of data retrieved?

The skill is programmed to automatically include LIMIT clauses in queries to prevent performance issues and avoid overwhelming the AI's context with excessive data.

What dbt command does it use to run queries?

It primarily uses the 'dbt show --inline' command to execute generated SQL and retrieve results directly within the Claude Code terminal environment.

Can I use this for complex multi-table joins?

Yes, the skill is designed to explore multiple dbt models to identify relationships and generate complex JOIN queries across your staging and marts layers.

Can I export the results of a query?

Yes, the workflow includes an integrated step to write query results to a JSON file in your artifacts directory for use in other tools or documentation.

Dbt Text-to-SQL Assistant

Name: Dbt Text-to-SQL Assistant
Author: nerver111

bynerver111

0•

Database Management

Translates natural language queries into executable SQL within dbt environments to analyze data and aggregate statistics.

This skill empowers Claude to act as a dbt schema specialist, capable of exploring project structures, understanding model relationships, and generating precise SQL queries from natural language. It streamlines the data analysis workflow by automating schema discovery, validating table structures, and executing queries directly through dbt commands, providing immediate insights and summaries without manual SQL drafting or schema memorization.

Key Features

01Automated dbt project structure exploration using ls and grep

02Persistent storage of results to JSON files for downstream visualization and reporting

03Context-aware SQL generation based on actual model schemas and YAML definitions

04Direct execution of SQL queries using the dbt show command

050 GitHub stars

06Automatic parsing and summarization of query results into readable tables

Use Cases

01Quickly calculating business metrics like daily new user counts or rolling revenue growth

02Extracting and saving specific datasets from staging models for external analysis or visualization

03Identifying top-performing products or customers through complex multi-table joins in dbt marts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test run-text-to-sql

For use in Claude.ai and ChatGPT

Key Features

01Automated dbt project structure exploration using ls and grep

02Persistent storage of results to JSON files for downstream visualization and reporting

03Context-aware SQL generation based on actual model schemas and YAML definitions

04Direct execution of SQL queries using the dbt show command

050 GitHub stars

06Automatic parsing and summarization of query results into readable tables

Use Cases

01Quickly calculating business metrics like daily new user counts or rolling revenue growth

02Extracting and saving specific datasets from staging models for external analysis or visualization

03Identifying top-performing products or customers through complex multi-table joins in dbt marts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test run-text-to-sql

For use in Claude.ai and ChatGPT