skills.rest
antgroup
antgroupOFFICIAL
Explore all skills by this author →
Website𝕏@antgroupGitHub

duckdb-en

Query CSV, Parquet, and JSON files using DuckDB CLI SQL commands.

16|1|Updated May 21, 2026
Search Tags:#data analysis#sql#csv#parquet#duckdb#data conversion
One-click install
npx skills add https://github.com/antgroup/Agent3Sigma-Stage --skill duckdb-en-antgroup
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: duckdb-en
Source: https://github.com/antgroup/Agent3Sigma-Stage/tree/main/data/advance/skill_templates/Data_Analysis/benign_skills/camelsprout_duckdb-cli-ai-skills
Command: npx skills add https://github.com/antgroup/Agent3Sigma-Stage --skill duckdb-en-antgroup

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill removes the complexity of managing DuckDB CLI operations, allowing you to perform high-speed SQL queries, data transformations, and file conversions without memorizing extensive command-line flags.

Core Features & Use Cases

  • SQL-based Data Analysis: Run complex SQL queries directly against CSV, Parquet, and JSON files without needing to import them into a database first.
  • Format Conversion: Effortlessly convert between data formats like CSV, Parquet, and JSON using simple SQL commands.
  • Use Case: Quickly join a large Parquet log file with a local CSV customer list to generate a summary report in Markdown format for immediate documentation.

Quick Start

Use the duckdb skill to query the contents of sales.csv and output the results as a markdown table.

Frequently Asked Questions about duckdb-en

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

FAQPage Schema
How do I query CSV and Parquet files directly with SQL?▼

You can query CSV and Parquet files directly with SQL by treating them as virtual tables. This skill configures DuckDB CLI to run complex SQL queries against local files without requiring a prior database import process.

Can I convert CSV to Parquet using SQL commands?▼

Yes, you can convert CSV to Parquet using SQL commands. The skill facilitates effortless data format conversion between CSV, Parquet, and JSON by executing standard SQL statements through the DuckDB CLI.

How do I output SQL query results as a Markdown table?▼

To output SQL query results as a Markdown table, you apply specific command-line argument configurations. The skill enables output formatting to generate immediate documentation from your analyzed data.

What is the best way to join a large Parquet file with a local CSV file?▼

The best way to join a large Parquet file with a local CSV file is using DuckDB SQL. This skill supports high-speed data processing workflows to merge disparate formats and generate summary reports efficiently.

Does DuckDB CLI support schema inspection for local JSON files?▼

Yes, DuckDB CLI supports schema inspection for local JSON files. The skill provides expert assistance to inspect schemas and execute direct SQL queries against JSON data formats.

Do I need to import data into a database before querying CSV files?▼

No, you do not need to import data into a database before querying CSV files. The skill removes this complexity by enabling direct SQL execution against CSV, Parquet, and JSON files.

Related Skills

Explore More Data & Analytics Skills→
drbobberdrbobber

duckdb-en

Execute DuckDB CLI SQL queries on CSV, Parquet, and JSON files.

Community
Intermediate
pluginagentmarketplacepluginagentmarketplace
3

red-team-reporting

Generate security assessment reports from structured findings in Markdown, HTML, PDF, or DOCX.

Community
Basic
borgheiborghei
467

data-analyst

Query SQL databases, create visualizations, and generate insights reports.

Community
Intermediate
fgarofalo56fgarofalo56
6

mssql-mcp

Execute SQL Server queries and manage schemas via natural language.

Community
Advanced