DuckDB client
Open a DuckDB database or query Parquet, CSV and JSON files with SQL. No local database server is needed.
Works on Mac, iPhone and iPadDriver downloads on first use of DuckDB
Included in Free; paid plans add optional featuresOpen source (AGPL-3.0)
At a glance
- Query language
- SQL
- Driver
- Downloads on first use
- Connect with
- A file
- Built-in engine
- DuckDB 1.5.2
- iPhone and iPad
- Opens
Open a file
Open a .duckdb or .ddb file, enter a new path to create one, or use :memory: for a temporary database. Files are identified by their header, not their extension.
Open Parquet, CSV, TSV, JSON or NDJSON as read-only views named file and after the filename. The source file is unchanged. Create a table in a DuckDB database to edit its data.
Open DuckDB files from Finder. Parquet files open as DuckDB connections with File > Open File, not in the Data Files window.
Remote (Quack, experimental) connects to a quack_serve server under an alias. The first connection downloads DuckDB’s quack extension.
Query and edit
Query files directly, such as SELECT * FROM 'data.csv'. ATTACH adds another DuckDB file to the sidebar; ⌘K switches between them. Attachments do not survive reconnects.
EXPLAIN is drawn as a plan diagram. Rows in a table are edited with Preview SQL showing each statement first, while the views over a data file stay read-only.
Structure
The Structure tab edits tables and shows the DDL before it runs. There is no create or drop database action in the sidebar. To create a file, enter a new path when connecting; use ATTACH to reach a second file.
Share the file and back it up
While TablePro holds a file, the duckdb CLI, a notebook or a dbt run cannot open it. Set Release the File Lock After to hand the file back after some idle minutes and take it again on the next query, or Open the File Read-Only so several readers can share it. Database > Release File Lock hands it back at once and keeps your tabs. A release is refused, with the reason, while the session holds an open transaction, a temporary table, an attached database or a changed setting.
Backup Dump needs nothing installed, because DuckDB writes it over the open connection. Choose a .duckdb file to restore into TablePro later, or a folder holding schema.sql, load.sql and one Parquet file per table, which pandas, Spark and BigQuery read directly. Restore Dump stops at the first object whose name is already taken.
Move data
Import takes CSV, TSV, JSON, JSONL, XLSX and SQL files, and export writes tables and results as CSV, JSON, SQL, XLSX, Markdown, HTML and XML. The Parquet export plugin, installed from Settings > Plugins, adds Parquet output, one file per table. More on working with files as databases.
iPhone and iPad
DuckDB is offered when you create a connection in the iPhone and iPad app.
On iPhone and iPad, DuckDB is part of the app. A file you pick in the Files app opens where it is rather than as a copy, or choose In-Memory for a scratch database. You browse tables as cards and run SQL in the Query tab. Remote (Quack) connections are Mac only.
Limits
- One process writes to a DuckDB file at a time, for as long as the connection is open.
- The driver includes the core functions, JSON, Parquet, ICU and autocomplete extensions. Others, such as httpfs, download from DuckDB the first time a query needs them.
- Remote connections over Quack are experimental.
Questions about DuckDB
Which DuckDB version does TablePro use?
DuckDB 1.5.2, compiled into the driver. It does not depend on any DuckDB you have installed.
Should I open a CSV file in DuckDB or in the Data Files window?
Open it in the Data Files window to look through it, clean it up and save it back. Open it as DuckDB to join it with other files or tables in SQL; the file stays read-only there.
Get TablePro
Requires macOS 13 Ventura or later
Free, with no in-app purchasesRequires iOS and iPadOS 18 or later