skills.rest
PovertyAction
PovertyActionOFFICIAL
Explore all skills by this author →
WebsiteGitHub

duckdb

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

3|2|Updated Dec 11, 2024
Search Tags:#cli#sql#data-analysis#etl#csv#parquet#duckdb
One-click install
npx skills add https://github.com/PovertyAction/ipa-research-data-science-hub --skill duckdb-povertyaction
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: duckdb
Source: https://github.com/PovertyAction/ipa-research-data-science-hub/tree/main/.claude/skills/duckdb
Command: npx skills add https://github.com/PovertyAction/ipa-research-data-science-hub --skill duckdb-povertyaction

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The DuckDB CLI enables users to interact with data directly from the command line to run SQL queries, perform analyses, and transform data without needing a full database server setup.

Core Features & Use Cases

  • SQL analytics: full SQL support within a fast, in-process database engine.
  • Direct data access: read CSV, Parquet, JSON, and Excel files without importing.
  • Flexible data workflows: create ephemeral or persistent databases and export results to common formats.

Quick Start

Start a DuckDB session by running duckdb in your terminal and then execute SQL commands against your data.

Frequently Asked Questions about duckdb

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?▼

You can run SQL queries directly on CSV and Parquet files by using the DuckDB CLI to read files without importing, enabling fast ad-hoc data analysis from your terminal.

Can I perform lightweight ETL workflows without setting up a database server?▼

Yes, you can perform lightweight ETL workflows without a database server by using the DuckDB CLI, which operates as an in-process engine to transform and export data directly.

Does the DuckDB CLI support reading JSON and Excel files for ad-hoc analysis?▼

The DuckDB CLI supports ad-hoc analysis by directly reading JSON and Excel files, allowing you to query and transform data immediately without a formal import process.

What is the best way to manage ephemeral versus persistent data sessions in the CLI?▼

You can manage ephemeral or persistent data sessions in the CLI by starting DuckDB to create an in-memory database for temporary analysis or specifying a file for persistent storage.

Are there limitations to using in-process SQL engines for scripting workflows?▼

When using this in-process SQL engine for scripting workflows, you must have a standalone DuckDB CLI binary installed locally, as it operates without a separate server setup.

How do I export SQL query results to common formats from the command line?▼

You can export SQL query results to common formats from the command line by executing your queries in the DuckDB CLI and using its built-in SQL features and dot commands.

Related Skills

Explore More Data & Analytics Skills→
chrishuffman5chrishuffman5

read-file

Read and query local or remote data files using DuckDB.

Community
Advanced
bytedancebytedance
79.6k

data-analysis

Analyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.

Official
Intermediate
borgheiborghei
467

data-analyst

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

Community
Intermediate
AradotsoAradotso
5

harvard-art-museum-data-engineering

Automate ETL from the Harvard Art Museums API into SQL databases with Streamlit dashboards.

Official
Advanced