skills.rest
CamelSprout
CamelSproutCOMMUNITY
Explore all skills by this author →
GitHub

duckdb-en

Run SQL queries and convert CSV, Parquet, and JSON files via the DuckDB CLI.

1|Updated Jan 24, 2026
Search Tags:#cli#json#sql#csv#parquet#duckdb
One-click install
npx skills add https://github.com/CamelSprout/duckdb_cli_ai_skills --skill duckdb-en-camelsprout
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: duckdb-en
Source: https://github.com/CamelSprout/duckdb_cli_ai_skills/tree/main
Command: npx skills add https://github.com/CamelSprout/duckdb_cli_ai_skills --skill duckdb-en-camelsprout

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill consolidates knowledge and practical guidance to help Claude perform SQL queries, data transformations, and file conversions using the DuckDB CLI, reducing the learning curve and speeding up data tasks across CSV, Parquet, and JSON workflows.

Core Features & Use Cases

  • SQL analytics: Run ad-hoc SQL queries against CSV, Parquet, and JSON data directly from the DuckDB CLI.
  • Data conversion: Convert between CSV, Parquet, JSON formats and export results for downstream tools.
  • CLI navigation & output control: Use dot commands, format outputs (table, CSV, JSON), and configure safe mode and editing workflows for robust analysis.
  • Quick use cases: Analyze a dataset to summarize statistics, join files, and export results for reporting.

Quick Start

Run a sample query against a CSV, Parquet, or JSON file using the DuckDB CLI.

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 and Parquet files without loading them into a database?▼

You can run ad-hoc SQL queries directly on CSV and Parquet files using the DuckDB CLI. This skill enables quick data transformations, schema exploration, and statistical summaries without requiring a separate database loading step.

What is the best way to convert CSV to Parquet or JSON formats from the command line?▼

The best way to convert CSV to Parquet or JSON formats is via the DuckDB CLI. This skill provides practical guidance for file conversion and exporting query results directly for downstream analysis tools.

Can I use DuckDB CLI to explore the schema of a JSON file before writing a full query?▼

Yes, you can use the DuckDB CLI to explore JSON file schemas. The skill covers CLI navigation, dot commands, and output formatting to help you inspect data structures and prepare accurate SQL queries.

Does DuckDB CLI support safe mode configurations for running local data analysis workflows?▼

Yes, the DuckDB CLI supports safe mode configurations. This skill guides you through setting up safe-mode and editing workflows to ensure robust and secure local data analysis across your development tasks.

How do I format DuckDB CLI output as a CSV table for downstream reporting?▼

You can format DuckDB CLI output as a CSV table using its built-in output format controls. This skill details how to use dot commands to switch between table, CSV, and JSON outputs for reporting.

Related Skills

Explore More Data & Analytics Skills→
benjaminwesternbenjaminwestern
3

duckdb

Query, transform, and analyze CSV, Parquet, and JSON files with SQL.

Community
Intermediate
itsadijmbtitsadijmbt
1

duckdb-en

Translate user intent into DuckDB CLI SQL, flags, dot commands, and export formats.

Community
Intermediate
DingTalk-Real-AIDingTalk-Real-AI
2.1k

dws-cli

Script DingTalk operations and batch-manage organizational data via CLI commands.

Official
Intermediate
dotlab-hqdotlab-hq

cudf-analytics

Perform GPU-accelerated groupby aggregations and statistical summaries on large CSV datasets.

Official
Intermediate