CmdID

CmdID / Commands

duckdb

Client for DuckDB, an in-process analytical SQL engine. tldr-pages

On several platforms

Opens CmdID with your command. It is read in your browser and sent nowhere.

Several platforms

from tldr-pages, CC BY 4.0

Start an interactive shell with a transient in-memory database

duckdbIdentify

Start an interactive shell on a database file. If the file does not exist, a new database is created

duckdb path/to/dbfileIdentify

Query a CSV, JSON, or Parquet file using SQL

duckdb -c "SELECT * FROM 'data_source.ext'"Identify

Directly query a CSV, JSON, or Parquet file using the file view

duckdb data_source.ext -c " SELECT * FROM file "Identify

Run an SQL script

duckdb -f path/to/script.sqlIdentify

Run query on database file and keep the interactive shell open

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

Read CSV from stdin and write CSV to stdout

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

Start the DuckDB UI, a web interface with notebooks

duckdb -uiIdentify