DuckDB Basic Usage
Installation
The DuckDB adapter ships with Harlequin; you do not need to do anything else to install it.
If you want to control the version of DuckDB that Harlequin uses, see the Troubleshooting page.
Using Harlequin with DuckDB
To open an in-memory DuckDB session, run Harlequin with no arguments:
$Â harlequinTo open one or more DuckDB database files, pass in relative or absolute paths as connection strings (Harlequin will create DuckDB databases if they do not exist):
$Â harlequin "path/to/duck.db" "another_duck.db"Connection Options
Read-Only
You can open a database in read-only mode using the --read-only or -r flag:
$Â harlequin -r "path/to/duck.db"