DuckDB
A DuckDB client that belongs on a Mac.
DuckDB is built in. Open a DuckDB file, or point the app at a CSV, TSV, Parquet or JSON file — or a folder of them — and query it with SQL. Files on your own Mac are local, so it is free.
Free for a month, then one price. Pricing
What DuckDB gets.
The kinds of object that exist on an engine are the kinds the app shows. This is DuckDB's row of the features table, and what stands behind it.
| Engine | Editable grid | Designers | Users & Roles | Diagram |
|---|---|---|---|---|
| DuckDB and CSV files | ✓ | ✓tables, sequences | — | ✓ |
Query a file as a table
Point the Data File tile at a CSV, TSV, Parquet or JSON file, or at a folder of them, and query it with SQL. The file is read again on every query, so an edit to it shows up on the next run.
Guide: opening filesA file is a connection
The app reads the first bytes before it trusts the name, so a DuckDB file called backup.db opens as DuckDB. Opening the same file again selects its connection rather than making a second one.
Tables and sequences, designed
The table designer retypes a column with ALTER COLUMN … TYPE … USING, so values are cast, and its script runs in a transaction. DuckDB cannot add or drop foreign keys, and the designer says so.
Copy tables in from a server
Drag a table from another connection onto a DuckDB database and the app writes the CREATE in DuckDB's dialect and copies the rows, listing every column type that had to change.
Guide: copy objects between enginesConnect to DuckDB.
Drop a DuckDB file on the window or on the Dock icon, double-click it in Finder, or use File ▸ Open… (⌘O). For a CSV, TSV, Parquet or JSON file, click Add Connection under the sidebar, pick the Data File tile and click Choose… to pick it. The Connection String field reads duckdb:// addresses and a bare path.
- Connects to
- A DuckDB file, or a Data File: a CSV, TSV, Parquet or JSON file, or a folder of them.
- Files
- DuckDB 1.1.3 is built in. It opens files written by DuckDB 0.9, 0.10, 1.0 and 1.1; a file from a newer release may not open.
- Console
- None. A DuckDB file allows one process at a time, and the app is it.
- Notes
- A DuckDB file is opened once; every tab, and every other connection to the same file, gets a connection to that one instance. A data file is opened as a view through an in-memory DuckDB and read again on every query, so an edit to the file shows up on the next run. The view is named for the file, every character but an ASCII letter or digit written as
_. In a folder, two files whose names come out alike get their extensions appended, then a number:a.csvanda.parquetareaanda_parquet. Alike means as DuckDB reads a name, without regard to letter case, soOrders.csvbesideorders.jsonareOrdersandorders_json. ATIMESTAMP_NScolumn shows every one of its nine digits in a browse, in Export Data… and in a copy, which read it as text; a query you type arrives at microseconds, where the built-in DuckDB hands the value over, and a result keyed by such a column is read-only, since an edit could land on another row. TypeCAST(col AS VARCHAR) AS col, the browse's own spelling, to edit it.
One app for the rest of your databases, too.
Every feature is built against one driver contract, so the grid, the designers and the assistant work the same whichever server you open next.
Try it on your own database.
Free for a month, then one price, and never asking you to sign in.
$brew install --cask az-code-lab/taps/dbclient