ClawKit Logo
ClawKitReliability Toolkit
Back to Registry
Official Verified

duckdb-en

DuckDB CLI specialist for SQL analysis, data processing and file conversion. Use for SQL queries, CSV/Parquet/JSON analysis, database queries, or data conversion. Triggers on "duckdb", "sql", "query", "data analysis", "parquet", "convert data".

skill-install — Terminal

Install via CLI (Recommended)

clawhub install openclaw/skills/skills/camelsprout/duckdb-cli-ai-skills
Or

DuckDB CLI Specialist

Helps with data analysis, SQL queries and file conversion via DuckDB CLI.

Quick Start

Read data files directly with SQL

# CSV
duckdb -c "SELECT * FROM 'data.csv' LIMIT 10"

# Parquet
duckdb -c "SELECT * FROM 'data.parquet'"

# Multiple files with glob
duckdb -c "SELECT * FROM read_parquet('logs/*.parquet')"

# JSON
duckdb -c "SELECT * FROM read_json_auto('data.json')"

Open persistent databases

# Create/open database
duckdb my_database.duckdb

# Read-only mode
duckdb -readonly existing.duckdb

Command Line Arguments

Output formats (as flags)

FlagFormat
-csvComma-separated
-jsonJSON array
-tableASCII table
-markdownMarkdown table
-htmlHTML table
-lineOne value per line

Execution arguments

ArgumentDescription
-c COMMANDRun SQL and exit
-f FILENAMERun script from file
-init FILEUse alternative to ~/.duckdbrc
-readonlyOpen in read-only mode
-echoShow commands before execution
-bailStop on first error
-header / -noheaderShow/hide column headers
-nullvalue TEXTText for NULL values
-separator SEPColumn separator

Data Conversion

CSV to Parquet

duckdb -c "COPY (SELECT * FROM 'input.csv') TO 'output.parquet' (FORMAT PARQUET)"

Parquet to CSV

duckdb -c "COPY (SELECT * FROM 'input.parquet') TO 'output.csv' (HEADER, DELIMITER ',')"

JSON to Parquet

duckdb -c "COPY (SELECT * FROM read_json_auto('input.json')) TO 'output.parquet' (FORMAT PARQUET)"

Convert with filtering

duckdb -c "COPY (SELECT * FROM 'data.csv' WHERE amount > 1000) TO 'filtered.parquet' (FORMAT PARQUET)"

Dot Commands

Schema inspection

CommandDescription
.tables [pattern]Show tables (with LIKE pattern)
.schema [table]Show CREATE statements
.databasesShow attached databases

Output control

CommandDescription
.mode FORMATChange output format
.output fileSend output to file
.once fileNext output to file
.headers on/offShow/hide column headers
.separator COL ROWSet separators

Queries

CommandDescription
.timer on/offShow execution time
.echo on/offShow commands before execution
.bail on/offStop on error
.read file.sqlRun SQL from file

Editing

CommandDescription
.edit or \eOpen query in external editor
.help [pattern]Show help

Output Formats (18 available)

Data export

  • csv - Comma-separated for spreadsheets
  • tabs - Tab-separated
  • json - JSON array
  • jsonlines - Newline-delimited JSON (streaming)
Read Full Documentation on GitHub

Metadata

Author@camelsprout
Stars4072
Views0
Updated2026-04-13
View Author Profile
AI Skill Finder

Not sure this is the right skill?

Describe what you want to build — we'll match you to the best skill from 16,000+ options.

Find the right skill
Add to Configuration

Paste this into your clawhub.json to enable this plugin.

{
  "plugins": {
    "official-camelsprout-duckdb-cli-ai-skills": {
      "enabled": true,
      "auto_update": true
    }
  }
}
Safety NoteClawKit audits metadata but not runtime behavior. Use with caution.