Is there a timeout for query execution?

The skill utilizes the 'dbt show' command which typically has a default timeout (often 2 minutes). It is best suited for analytical queries rather than long-running ETL processes.

Does this skill work with any SQL database?

This skill is specifically optimized for dbt (data build tool) projects. It uses dbt's model structure, YAML definitions, and CLI commands to locate and query data within your existing dbt ecosystem.

Does it modify my database schema?

No, this skill is primarily for data exploration and retrieval. It uses read-only patterns and 'dbt show' to fetch results without altering your underlying tables or dbt models.

Can I use it to join multiple dbt models?

Yes. The skill can explore multiple model files and schema definitions to understand relationships, allowing it to generate complex JOIN queries across different layers of your dbt project.

How does it handle large datasets?

The skill is designed with safety limits in mind. It automatically applies LIMIT clauses to queries and focuses on summary statistics to prevent excessive data overhead and ensure fast performance.

Dbt Text-to-SQL Expert

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

bynerver111

0•

データベース管理

Generates and executes high-performance SQL queries directly from natural language using your dbt project schema.

This skill transforms natural language prompts into executable SQL queries by intelligently exploring dbt project structures. It navigates staging and marts layers, identifies relevant columns through schema inspection, and executes queries using dbt commands to provide immediate data insights. It is particularly useful for data analysts and developers who need to perform ad-hoc data exploration, calculate aggregations, or verify dbt model outputs without manual SQL drafting, ensuring that queries are always context-aware and schema-accurate.

主な機能

01Direct execution of inline SQL queries via integrated dbt show commands

02Automated dbt project exploration to identify relevant models and schemas

030 GitHub stars

04Automatic result formatting into readable tables and natural language summaries

05Capability to export query results to JSON artifacts for further processing

06Natural language to SQL transformation following dbt-specific syntax and standards

ユースケース

01Performing ad-hoc joins between dbt marts to identify top-performing segments or products

02Quickly calculating business metrics like daily active users or revenue growth from staging tables

03Debugging and verifying data integrity within dbt models during the development lifecycle

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

主な機能

01Direct execution of inline SQL queries via integrated dbt show commands

02Automated dbt project exploration to identify relevant models and schemas

030 GitHub stars

04Automatic result formatting into readable tables and natural language summaries

05Capability to export query results to JSON artifacts for further processing

06Natural language to SQL transformation following dbt-specific syntax and standards

ユースケース

01Performing ad-hoc joins between dbt marts to identify top-performing segments or products

02Quickly calculating business metrics like daily active users or revenue growth from staging tables

03Debugging and verifying data integrity within dbt models during the development lifecycle

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