Desktop app for Mac, Windows & Linux

DuckDBDuckDB GUI ClientBeta

Run analytical queries, browse tables, and explore Parquet and CSV files visually. A desktop GUI for DuckDB. Connect to DuckDB on localhost, self-hosted, or cloud (MotherDuck).

Request Beta Access

10x Your DuckDB Productivity

Stop switching between CLI and code. Manage everything visually.

SQL Editor

Write and run analytical SQL queries with syntax highlighting and instant results.

Visual Query Builder

Build SELECT, JOIN, and aggregate queries visually without writing SQL.

Table Browser

Browse tables, views, and schemas. Inspect columns, types, and row counts.

Parquet File Support

Open and query Parquet files directly. Explore columnar data visually.

CSV Import

Import CSV files into DuckDB tables with automatic type detection.

Export Data

Export query results to CSV, JSON, or Parquet for downstream analysis.

Create Table

Define new tables with columns, types, and constraints through a visual interface.

Query History

Access and re-run your previous queries instantly.

Dark Mode

Easy on the eyes during late-night data analysis sessions.

Keyboard Shortcuts

Navigate and execute commands without the mouse.

Multiple Tabs

Work across databases and queries in parallel tabs.

Production Safe

Read-only mode and confirmation dialogs protect your data.

Autocomplete

Smart suggestions for table names, columns, and SQL keywords as you type.

MotherDuck Support

Connect to MotherDuck for cloud-hosted DuckDB with seamless hybrid queries.

Frequently Asked Questions

What is the best DuckDB GUI client?
Popular DuckDB GUI clients include DBeaver (free, general-purpose), Harlequin (terminal-based), and 1bench (modern desktop GUI with multi-database support). 1bench provides a native desktop experience on Mac, Windows, and Linux with features like visual query building, Parquet file browsing, and MotherDuck cloud support — all without needing a separate server process since DuckDB runs in-process.
Is there a DuckDB GUI for Mac?
Yes, 1bench is a native DuckDB GUI client for Mac that supports both Apple Silicon and Intel. Since DuckDB is an in-process analytical database, 1bench embeds the engine directly — no server setup needed. Just open a .duckdb file or create a new in-memory database to start running analytical queries, exploring Parquet files, or importing CSVs.
Is there a DuckDB GUI for Windows?
Yes, 1bench runs natively on Windows and provides a full-featured GUI for DuckDB. You can browse tables, write SQL queries with autocomplete, and work with Parquet and CSV files visually. DuckDB requires no server installation — 1bench handles everything in-process, making it easy to get started with analytical workloads on Windows.
What is the best GUI tool for DuckDB analytics?
For analytical workflows, 1bench offers a modern DuckDB GUI with a built-in SQL editor, visual query builder, and support for Parquet and CSV files. DuckDB excels at OLAP queries on local data, and 1bench makes it easy to explore datasets, preview query results, and export data. It also supports MotherDuck for cloud-based DuckDB analytics.
Can I use a DuckDB GUI with Docker?
DuckDB is an embedded, in-process database — it doesn't run as a server, so there's no Docker container to connect to like with PostgreSQL or MySQL. Instead, you work with .duckdb database files directly. With 1bench, simply open a DuckDB file from your filesystem, or attach to Parquet and CSV files for instant analytical queries without any Docker setup.

Not Just DuckDB

One tool for all your databases. No more juggling apps.

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchClickHouseClickHouseSQLiteSQLiteCockroachDBCockroachDB
YugabyteDBYugabyteDB
TimescaleDBTimescaleDB
NeonNeon
SupabaseSupabaseAmazon RedshiftAmazon Redshift
GreenplumGreenplum
ValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMongoDBMongoDBMySQLMySQLMariaDBMariaDBSQL ServerSQL ServerCassandraCassandraNeo4jNeo4jQdrantQdrantTypesenseTypesenseMilvusMilvus

Ready to manage DuckDB visually?

1bench connects to DuckDB Cloud and self-hosted instances. Start your 7-day free trial today.

View Pricing

1bench is not affiliated with or endorsed by DuckDB Labs B.V.. DuckDB is a trademark of DuckDB Labs B.V..