1bench — Modern DuckDB GUI Client

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

Your Data Stays Yours

1bench runs entirely on your machine. Nothing is ever sent to us.

100% Local

Your credentials and data never leave your machine. No cloud sync, no account required.

Zero Telemetry

No usage tracking, no query logging, no analytics. What you do in 1bench stays in 1bench.

Direct Connection

1bench connects straight to your database. No proxy servers, no middleware in between.

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 a DuckDB GUI?
A DuckDB GUI is a visual desktop client that opens .duckdb files and lets you browse tables, run analytical SQL, and query Parquet or CSV files without using the DuckDB CLI. 1bench is a modern DuckDB GUI for Mac, Windows, and Linux.
Does DuckDB have a GUI?
DuckDB ships with a command-line shell and offers a built-in local UI extension for running queries in a browser tab. For a full desktop experience — attaching files, inspecting schemas, editing rows, and exporting results — you install a third-party DuckDB GUI like 1bench.
What is the best DuckDB GUI for Mac, Windows, or Linux?
A good DuckDB GUI should run natively on your OS, open .duckdb files directly, attach Parquet and CSV files instantly, and let you run analytical SQL with syntax highlighting. 1bench delivers all of this with a single download for Mac, Windows, and Linux.
Can a DuckDB GUI query Parquet, CSV, and remote data?
Yes. DuckDB can attach Parquet, CSV, and JSON files as tables and query cloud storage like S3 with the right extensions. 1bench surfaces this in the UI — drag in a file, attach it as a table, and run analytical queries over it immediately.
What is the difference between the DuckDB CLI and a DuckDB GUI?
The DuckDB CLI is a terminal shell that runs SQL and prints text results. A DuckDB GUI like 1bench adds a visual file opener, schema browser, SQL editor with autocomplete, inline row editing, and instant previews for Parquet and CSV data.

Not Just DuckDB

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

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchClickHouseClickHouseSQLiteSQLiteCockroachDBCockroachDBSupabaseSupabaseTimescaleDBTimescaleDBQdrantQdrantYugabyteDBYugabyteDBNeonNeonValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchSpacetimeDBSpacetimeDBAmazon RedshiftAmazon RedshiftTypesenseTypesenseMongoDBMongoDBMySQLMySQLMariaDBMariaDBSQL ServerSQL ServerCassandraCassandraNeo4jNeo4jFirestoreFirestoreMilvusMilvus
MeilisearchMeilisearch
WeaviateWeaviate
ChromaChroma
TursoTurso
InfluxDBInfluxDB
TiDBTiDB
Coming soon

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..