1bench, modern DuckDB GUI client

DuckDBDuckDB GUI client

Run analytical SQL, browse tables, and query Parquet and CSV files visually. Connect to DuckDB on localhost, self-hosted, or cloud (MotherDuck).

Apple Silicon. Also available for 7-day free trial · No credit card required

Your data stays yours

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

100% Local

Credentials and data never leave your machine.

Zero Telemetry

No usage tracking, no query logging, no analytics.

Direct Connection

Straight to your database, nothing in between.

Built for DuckDB

1

File-First Workflow

Open .duckdb files from Finder or Explorer. Drag in Parquet, CSV, or JSON files to query them as tables. No server, no setup, no config.

2

Attach Files as Tables

Parquet, CSV, JSON. Attach any of them as full tables and query with SQL. Filter, aggregate, join across files without loading them into memory.

3

Analytical SQL Editor

Full SQL editor with syntax highlighting, schema-aware autocomplete, and streaming results. Multi-statement queries return as they run.

4

Full Schema & Query Export

Export any table or query result to CSV, JSON, or Parquet. Full schema export to SQL for backup, migration, or dbt-style workflows.

10x your DuckDB productivity

Stop switching between CLI and code. Manage everything visually.

SQL Editor

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

Visual Query Builder

Build SELECT, JOIN, and aggregate queries visually with a searchable schema tree. Live SQL preview.

Table Browser

Browse tables, views, and schemas. Inspect columns, types, row counts, and storage size at a glance.

Parquet File Support

Open and query Parquet files directly. Explore columnar data as tables without loading into memory.

CSV Import

Import CSV files into DuckDB tables with automatic type detection, field mapping, and preview.

Export Data

Export query results or full tables to CSV, JSON, or Parquet. Filter and project from the dialog.

Create Table

Create new tables with columns, types, and constraints through a visual wizard with live SQL preview.

Create Index

Create, view, and drop secondary indexes with a visual dialog. Analyze usage with explain plans.

Query History

Every query you run is saved per connection. Search, filter, and re-run previous queries instantly.

Keyboard Shortcuts

Navigate tables, run queries, switch tabs, and manage connections without ever reaching for the mouse.

Multiple Tabs

Work across DuckDB databases and queries in parallel tabs. Each tab keeps its own browsing state.

Production Safe

Read-only mode, destructive-action confirmations, and staged commits keep production data safe.

Autocomplete

Smart suggestions for table names, columns, and SQL keywords as you type. Learns from your schema.

MotherDuck Support

Connect to MotherDuck for cloud-hosted DuckDB with hybrid local and cloud query execution.

Remote File Queries

Query Parquet, CSV, and JSON files directly from S3 and HTTP URLs without downloading first.

Not just DuckDB

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

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchClickHouseClickHouseSQLiteSQLiteCockroachDBCockroachDBSupabaseSupabaseTimescaleDBTimescaleDBQdrantQdrantTypesenseTypesenseMongoDBMongoDBMySQLMySQLMariaDBMariaDBMilvusMilvusYugabyteDBYugabyteDBNeonNeonValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMeilisearchMeilisearchWeaviateWeaviateChromaChromaTursoTursoEloqKVEloqKVTiDBTiDB

Don't see yours? Request it →

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.

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