skills.rest
itsadijmbt
itsadijmbtCOMMUNITY
Explore all skills by this author →
GitHub

duckdb-en

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

1|Updated Apr 24, 2026
Search Tags:#command line#duckdb#data conversion#sql querying#csv parquet json#dot commands#export formats
One-click install
npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill duckdb-en-itsadijmbt
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: duckdb-en
Source: https://github.com/itsadijmbt/SecureMCP-Servers/tree/main/TEST_SERVERS/PORTED_TO_SECUREMCP/alibabacloud-rds-openapi-mcp-server/skill/duckdb-cli-ai-skills
Command: npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill duckdb-en-itsadijmbt

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

DuckDB CLI is powerful for analyzing and converting data files, but translating your intent into correct SQL, flags, dot-commands, and output formats can be slow and error-prone.

Core Features & Use Cases

  • SQL analysis on files: Run queries directly against CSV, Parquet, and JSON inputs without manually importing them first.
  • Conversion between data formats: Convert CSV/Parquet/JSON using DuckDB COPY operations with clear format controls.
  • CLI productivity guidance: Explain common command-line arguments, dot commands for schema/output control, and practical patterns like filtering and joins.

Use Case: You want to compute statistics from a large CSV, convert filtered results to Parquet, and export the output as JSON for a downstream system—without needing to manually handle intermediate steps.

Quick Start

Ask an AI to convert a CSV to Parquet using DuckDB CLI and include the exact command you should run.

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 DuckDB without importing them?▼

DuckDB supports direct SQL querying on CSV, Parquet, and JSON files using read functions. This file-first analytics approach allows immediate data analysis without manually importing files first.

What is the best way to convert CSV to Parquet using DuckDB CLI?▼

Converting CSV to Parquet in DuckDB uses the COPY SQL command with format controls. Specify the source file using read_csv() and output to Parquet format, creating an efficient data conversion pipeline without intermediate steps.

How do I inspect a schema and format query output in DuckDB command line?▼

DuckDB CLI uses dot commands like .schema for schema inspection and .mode for query output formatting. These commands control how results display, supporting workflows that require specific export formats from local data files.

Can I filter data and export query results to JSON using DuckDB?▼

Yes, DuckDB can filter data using SQL WHERE clauses and export results to JSON using the COPY command. This supports complete data conversion pipelines from large input files to filtered JSON outputs for downstream systems.

Does DuckDB CLI support joining multiple data files for local analytics?▼

DuckDB CLI supports SQL joins across multiple local data files like CSV, Parquet, and JSON. You can read each file with appropriate read functions and join them in a single SQL query for file-first analytics workflows.

Related Skills

Explore More Data & Analytics Skills→
antgroupantgroup
16

duckdb-en

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

Official
Intermediate
Alex1980AlexAlex1980Alex

duckdb-analytics

Analyze JSONL and Parquet logs directly with DuckDB.

Community
Advanced
wewetv1987-cellwewetv1987-cell

sql-toolkit

Create, query, migrate, and tune SQLite, PostgreSQL, and MySQL databases.

Community
Advanced
clawdataclawdata
24

duckdb

Query local DuckDB warehouses with SQL and ingest CSV, Parquet, and JSON files.

Official
Intermediate