DuckDB Client
The DuckDB GUI Client for Mac.
A fast, native DuckDB GUI client for Mac. Open any .duckdb file or query Parquet, CSV, JSON, and Iceberg tables in place. Browse tables, edit rows, run analytical SQL with autocomplete. Streams billion-row queries. Free and open source.
Features
Built for DuckDB.
Open Any DuckDB File
Drag a .duckdb file onto the app. Read-only or read-write. Multiple files at once.
Query Parquet, CSV, JSON in Place
Run SELECT directly against files on disk or S3. No import step needed.
Schema-Aware Autocomplete
Suggests tables, columns, DuckDB functions, including read_parquet, read_csv_auto.
Streaming Result Sets
Million-row queries open in a streaming grid. Memory stays flat.
Iceberg and Delta Support
Query Iceberg and Delta Lake tables with the official DuckDB extensions, pre-loaded.
AI SQL Assistant
Ask in English, get DuckDB SQL. Explain analytical queries, suggest window function tweaks.
Data Grid
Browse and edit data.
Sort, filter, and edit DuckDB data in a spreadsheet-like grid. Click any cell to edit. Insert and delete rows. Review changes before saving.
SQL Editor
Write queries faster.
Tree-sitter syntax highlighting, schema-aware autocomplete, multi-tab, Vim mode, and full-text query history. AI assistant can write, explain, or optimize your SQL.
Capabilities
What you can do.
- Open .duckdb, .db files
- Query Parquet, CSV, JSON, Iceberg, Delta in place
- Edit rows in MergeTree-equivalent tables
- Run analytical SQL with streaming results
- Export results to CSV, JSON, Parquet
- View query plan with EXPLAIN
- Full-text search across query history
- Safe mode for read-only browsing
Connect
Get connected in seconds.
# Open in TablePro
File > Open > select your .duckdb file
# Or query files directly
SELECT * FROM read_csv('data.csv')
SELECT * FROM read_parquet('data.parquet')Supported versions
DuckDB 0.9+
Connection types
- Local file (.duckdb)
- In-memory
How to
Connect to DuckDB in four steps.
- 1
Install TablePro and the DuckDB plugin
brew install --cask tablepro. Open Settings > Plugins, install DuckDB from the registry.
- 2
Open a DuckDB file
File > Open, or drag the .duckdb file onto the app icon.
- 3
Browse and query
Tables appear in the sidebar. Cmd+T opens a query tab.
- 4
Query files in place
Run SELECT * FROM 'path/to/data.parquet' to query without import.
FAQ
Common DuckDB questions.
Can I query Parquet files directly?
Yes. SELECT * FROM 'data.parquet' works out of the box. S3 paths too.
Does it support Iceberg and Delta Lake?
Yes. The official DuckDB extensions ship pre-loaded.
Is TablePro free for DuckDB?
Yes. AGPLv3 open source. The DuckDB driver is a separate plugin from the registry.
Can I open multiple files at once?
Yes. Each .duckdb opens in its own tab.
Does it work on Apple Silicon?
Yes. arm64 native. Same DuckDB binary the CLI ships.
Try TablePro for free.
Free and open-source. macOS 14+. Apple Silicon and Intel.