skills.rest
drbobber
drbobberCOMMUNITY
Explore all skills by this author →
GitHub

duckdb-en

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

Updated Feb 2, 2026
Search Tags:#cli#json#data analysis#sql#csv#parquet#duckdb
One-click install
npx skills add https://github.com/drbobber/superdiscount-deals --skill duckdb-en-drbobber
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: duckdb-en
Source: https://github.com/drbobber/superdiscount-deals/tree/main/skills/duckdb-cli-ai-skills
Command: npx skills add https://github.com/drbobber/superdiscount-deals --skill duckdb-en-drbobber

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill empowers users to efficiently interact with the DuckDB command-line interface for complex data analysis, SQL querying, and seamless file format conversions without needing to memorize intricate commands.

Core Features & Use Cases

  • SQL Querying: Execute SQL queries directly on various file formats (CSV, Parquet, JSON) or persistent databases.
  • Data Conversion: Transform data between CSV, Parquet, and JSON formats with simple commands.
  • Database Operations: Inspect schemas, manage tables, and perform data import/export operations.
  • Use Case: Quickly analyze sales data stored in a CSV file by running SQL queries to aggregate and filter information, then export the results as a Parquet file for further processing.

Quick Start

Use the duckdb skill to convert the attached file 'input.csv' to 'output.parquet'.

Frequently Asked Questions about duckdb-en

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

FAQPage Schema
How do I run SQL queries directly on CSV or Parquet files?▼

The DuckDB CLI executes SQL queries directly on CSV, Parquet, and JSON files without requiring a separate database setup. You can query, aggregate, and filter file data immediately from the command line.

What is the best way to convert CSV data to Parquet format?▼

The DuckDB CLI transforms CSV data into Parquet format using simple SQL commands. You read the CSV file, select the data, and export the results directly as a Parquet file for optimized storage.

Can I inspect database schemas and manage tables using the command line?▼

Yes, you can inspect database schemas and manage tables using DuckDB CLI dot commands. The CLI supports viewing table structures, managing data import/export, and performing comprehensive database analysis operations.

Does DuckDB CLI support querying JSON files for data analysis?▼

DuckDB CLI fully supports querying JSON files for data analysis alongside CSV and Parquet formats. You can execute SQL queries directly on JSON files to extract, filter, and aggregate structured data.

How do I format command-line output when analyzing data with DuckDB?▼

You format command-line output when analyzing data with DuckDB using built-in dot commands and command-line arguments. These control output formatting for query results, allowing tailored display for your specific analysis needs.

Related Skills

Explore More Data & Analytics Skills→
xukrutdonutxukrutdonut

duckdb-en

Run SQL queries on CSV, Parquet, and JSON files using the DuckDB CLI.

Community
Advanced
Alex1980AlexAlex1980Alex

duckdb-analytics

Analyze JSONL and Parquet logs directly with DuckDB.

Community
Advanced
xashggxashgg
1

data-analysis

Automates end-to-end R data analysis workflows from loading to publication-ready outputs.

Community
Advanced
antgroupantgroup
16

duckdb-en

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

Official
Intermediate