DuckDB

Docs · SQL Reference · Python API

CLI

Can be installed via uv add duckdb-cli>=1.5 --group dev

uv run duckdb                        # in-memory session
uv run duckdb mydb.duckdb            # persistent database
uv run duckdb mydb.duckdb -c "SELECT 42"   # run one statement
uv run duckdb mydb.duckdb < script.sql     # run a file

Useful dot-commands inside the shell: