duckdb

Verified for current stable LTS

Duckdb Commands

Duckdb command syntax with verified terminal examples.

Commands

15 commands for Duckdb

Duckdb Command: Direct Query File View

duckdb <data_source.[csv|csv.gz|json|json.gz|parquet]> -c "< SELECT * FROM file >"

Duckdb Command: Query Csv Json Parquet File

duckdb -c "<SELECT * FROM 'data_source.[csv|csv.gz|json|json.gz|parquet]'>"

Duckdb Command: Query File Using File View

duckdb <data_source.[csv|csv.gz|json|json.gz|parquet]> -c "< SELECT * FROM file >"

Duckdb Command: Query File Using Sql

duckdb -c "<SELECT * FROM 'data_source.[csv|csv.gz|json|json.gz|parquet]'>"

Duckdb Command: Read Csv From Stdin Write To Stdout

cat <path/to/source.csv> | duckdb -c "<COPY (FROM read_csv('/dev/stdin')) TO '/dev/stdout' WITH (FORMAT CSV, HEADER)>"

Duckdb Command: Read Csv Stdin Write Csv Stdout

cat <path/to/source.csv> | duckdb -c "<COPY (FROM read_csv('/dev/stdin')) TO '/dev/stdout' WITH (FORMAT CSV, HEADER)>"

duckdb Operations

Duckdb Command: Run Query Keep Shell Open

duckdb <path/to/dbfile> -cmd "<SELECT DISTINCT * FROM tbl>"

duckdb Operations

Duckdb Command: Run Query On Database File Keeping Shell Open

duckdb <path/to/dbfile> -cmd "<SELECT DISTINCT * FROM tbl>"

duckdb Operations

Duckdb Command: Run Sql Script

duckdb -f <path/to/script.sql>

Duckdb Command: Start Duckdb Ui

Duckdb Command: Start Duckdb Ui Web Interface

Duckdb Command: Start Interactive Shell Database File

duckdb <path/to/dbfile>

Duckdb Command: Start Interactive Shell In Memory

Duckdb Command: Start Interactive Shell Memory Database

Duckdb Command: Start Interactive Shell On Database File

duckdb <path/to/dbfile>

Suggest a Duckdb Command

Submit missing workflows, corrections, or verified alternatives for this tool.

FAQ

Coverage: Focused examples for common Duckdb workflows.

Verified version: current stable LTS.

Verification: Test commands in a disposable workspace and submit notes for edge cases.