duckdb
Verified for current stable LTS
Duckdb Commands
Duckdb command syntax with verified terminal examples.
Commands
8 commands for Duckdb
duckdb Archive
Duckdb Command: Start Interactive Shell In Memory
duckdb duckdb Archive
Duckdb Command: Start Interactive Shell On Database File
duckdb <path/to/dbfile> duckdb HTTP
Duckdb Command: Query File Using Sql
duckdb -c "<SELECT * FROM 'data_source.[csv|csv.gz|json|json.gz|parquet]'>" duckdb HTTP
Duckdb Command: Query File Using File View
duckdb <data_source.[csv|csv.gz|json|json.gz|parquet]> -c "< SELECT * FROM file >" duckdb Operations
Duckdb Command: Run Sql Script
duckdb -f <path/to/script.sql> duckdb Operations
Duckdb Command: Run Query On Database File Keeping Shell Open
duckdb <path/to/dbfile> -cmd "<SELECT DISTINCT * FROM tbl>" duckdb HTTP
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 Archive
Duckdb Command: Start Duckdb Ui
duckdb -ui 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.