Skip to content
DuckDB

DuckDB Client

Native DuckDB client for macOS

TablePro embeds DuckDB directly. Open .duckdb files or create in-memory databases. Run analytical SQL on local files (CSV, Parquet, JSON) without importing. DuckDB is designed for OLAP workloads and can query files directly from disk. TablePro gives you a visual interface to browse tables, run queries, and export results.

Download for MacRead the docs
TablePro connected to a DuckDB database showing the data grid and SQL editor

Features

Built for DuckDB.

Open .duckdb Files

Open existing DuckDB databases. Or create new in-memory databases for ad-hoc analysis.

Query Files Directly

Run SQL on CSV, Parquet, and JSON files without importing. Use read_csv(), read_parquet() functions.

Analytical SQL

Full DuckDB SQL support: window functions, CTEs, QUALIFY, PIVOT, UNPIVOT, LIST, STRUCT types.

Fast Aggregations

DuckDB is columnar and vectorized. Aggregate millions of rows in seconds on your laptop.

Data Grid

Browse query results in a sortable, filterable grid. Handle large result sets with progressive loading.

Export Results

Export to CSV, JSON, Parquet, or XLSX. Or use COPY TO for DuckDB-native exports.

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.

TablePro data grid showing DuckDB table rows with inline editing

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.

TablePro SQL editor with DuckDB query and autocomplete

Capabilities

What you can do.

  • Open .duckdb files by drag and drop
  • Query CSV, Parquet, JSON files directly with SQL
  • Create in-memory databases for ad-hoc analysis
  • Full DuckDB SQL with window functions and CTEs
  • Browse tables, views, and schemas
  • Export to CSV, JSON, Parquet, XLSX
  • Progressive loading for large result sets
  • No server process needed

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

Try TablePro for free.

Free and open-source. macOS 14+. Apple Silicon and Intel.

Download for MacSetup guide