skills.rest
chrishuffman5
chrishuffman5COMMUNITY
Explore all skills by this author →
GitHub

query

Execute SQL queries on DuckDB databases with file-based data sources.

Updated Mar 23, 2026
Search Tags:#data query#data analysis#sql#duckdb#natural language processing
One-click install
npx skills add https://github.com/chrishuffman5/skills --skill query-chrishuffman5
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query
Source: https://github.com/chrishuffman5/skills/tree/main/query
Command: npx skills add https://github.com/chrishuffman5/skills --skill query-chrishuffman5

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill simplifies the process of querying data using DuckDB, allowing users to run SQL queries directly or using natural language, eliminating the need for complex syntax.

Core Features & Use Cases

  • SQL Query Execution: Execute raw SQL queries or queries phrased in natural language.
  • File-based Queries: Run queries against data stored in files directly.
  • DuckDB Friendly SQL: Utilize DuckDB's idiomatic SQL for efficient querying.
  • Use Case: Suppose you need to analyze sales data from a CSV file. You can run a natural language query like "Show sales for the last month" or a raw SQL query to retrieve the information you need.

Quick Start

Use the query skill to run a SQL query against the 'sales_data.csv' file.

Frequently Asked Questions about query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run SQL queries on CSV files using natural language?▼

You can run SQL queries on CSV files using natural language by leveraging DuckDB's ecosystem, which translates plain English requests into efficient idiomatic SQL for direct file-based data retrieval.

Can I execute raw SQL queries directly against data stored in files?▼

Yes, you can execute raw SQL queries directly against data stored in files. The system supports ad-hoc and session modes, allowing efficient data retrieval using DuckDB's syntax without complex setup.

Do I need DuckDB installed to query data from natural language inputs?▼

Yes, you need DuckDB installed to query data from natural language inputs. The system operates within DuckDB's ecosystem and requires a state file for context to process and execute your data analysis requests.

What is the best way to analyze sales data from a CSV without writing complex SQL syntax?▼

The best way to analyze sales data from a CSV without complex SQL syntax is using natural language processing. You can phrase queries conversationally, like asking to show sales for the last month, and retrieve results instantly.

Does this natural language data query tool support ad-hoc and session modes?▼

Yes, this natural language data query tool supports both ad-hoc and session modes. It accommodates file-driven or state-driven data sources, allowing flexible data analysis within the DuckDB environment for various use cases.

What are the limitations of using DuckDB for natural language data analysis?▼

Limitations of using DuckDB for natural language data analysis include the requirement of having DuckDB installed and a state file for context. It operates strictly within DuckDB's ecosystem, relying on its specific syntax and features.

Related Skills

Explore More Data & Analytics Skills→
kyirexykyirexy

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and export results.

Community
Intermediate
gman-roboticsgman-robotics

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and export results.

Official
Intermediate
saeed-vayghansaeed-vayghan
30

data-analyst

Analyzes raw data using SQL, Python, and BI tools for actionable insights and dashboard development.

Community
Advanced
silvainfmsilvainfm
2

duckdb

Run SQL analytics directly on CSV, Parquet, and JSON files and Pandas or Polars DataFrames.

Community
Advanced