1bench — Modern SQL GUI client

One GUI for all
your SQL databases

PostgreSQL, MySQL, SQLite, MariaDB, and 9 more. Write queries, design schemas, and browse data in one native app.

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.

Every SQL database, one app

Relational, distributed, analytical. Same editor and schema tools across all of them.

PostgreSQLPostgreSQLClickHouseClickHouseSQLiteSQLiteCockroachDBCockroachDBSupabaseSupabaseTimescaleDBTimescaleDBMySQLMySQLMariaDBMariaDBDuckDBDuckDBYugabyteDBYugabyteDBNeonNeonTursoTursoTiDBTiDB

Built for SQL databases

1

Cross-Engine Query Editor

Write SQL against every engine with the same editor, shortcuts, and autocomplete. Switch mid-session without losing history.

2

Visual Schema Designer

Design tables, columns, indexes, and foreign keys in one canvas. Auto-generate DDL and diff against production.

3

EXPLAIN Visualizer

See query plans as trees, not walls of text. Spot sequential scans, missing indexes, and expensive joins at a glance.

4

Multi-Database Tabs

Open parallel connections in tabs. Each tab holds its own transaction state and query history so context stays intact.

5

Inline Data Grid Editing

Click any cell to edit. Staged batch commit means no accidental writes. Undo works across the whole session.

6

Import & Export

Import from CSV, SQL dumps, and JSON. Export to CSV, SQL, JSON, or Parquet. Same UI on every engine.

10x your SQL database productivity

Stop switching between CLI and code. Manage everything visually.

Visual Query Editor

Rich autocomplete for SQL keywords and your schema. Multi-statement execution and per-statement result tabs.

EXPLAIN Visualizer

Query plans as visual trees. Identify sequential scans, missing indexes, and expensive joins at a glance.

Schema Designer

Design tables, columns, indexes, and foreign keys across engines. Auto-generate DDL and diff against production.

Multi-Database Tabs

Parallel connections in tabs. Each tab keeps its own query editor, transaction state, and browsing history.

Inline Cell Editing

Click any cell to edit. Staged batch commit prevents accidental writes and every change previews first.

Data Grid Filtering

Filter rows visually without writing WHERE clauses. Combine multiple filters, sort, and paginate large tables.

Import & Export

CSV, SQL, JSON, Parquet. Import from local files or paste directly; export whole tables or query results.

Query History

Every query you run is automatically saved per connection. Search, re-run, and bookmark past queries.

SSH Tunnel Support

Reach private-network databases through SSH tunnels. Load profiles from ~/.ssh/config with one click.

SSL/TLS Connections

Full SSL/TLS support with custom CA certificates, client cert authentication, and hostname verification.

Autocomplete

Smart suggestions for SQL keywords, table names, column names, and function signatures as you type.

Read-Only Mode

Enable read-only mode to safely explore production databases. Prevents any accidental writes or DDL.

Cloud & Self-Hosted

Connect to AWS RDS, Google Cloud SQL, Azure SQL, Supabase, Neon, PlanetScale, or any self-hosted instance.

Connection String Parser

Paste a connection string (postgres://, mysql://, jdbc:) and 1bench fills in host, port, credentials, and TLS.

Transaction Management

Explicit BEGIN/COMMIT/ROLLBACK controls per tab. See uncommitted changes and locks before committing.

Frequently asked questions

What is a SQL GUI?
A SQL GUI is a visual desktop client for connecting to relational databases, writing and running queries, browsing tables and rows, and designing schemas without living in a terminal. 1bench is a modern SQL GUI for Mac, Windows, and Linux that speaks the wire protocol of every major SQL engine, from PostgreSQL and MySQL to CockroachDB and ClickHouse.
What is the best SQL GUI for Mac, Windows, or Linux?
A good SQL GUI should run natively on your OS, connect to cloud and self-hosted databases, execute queries with rich autocomplete, and let you inspect query plans (EXPLAIN) visually. 1bench does all of these in a single download for Mac, Windows, and Linux, and works across every major SQL engine from PostgreSQL to ClickHouse to TiDB.
Do I need a separate GUI for PostgreSQL, MySQL, and SQLite?
No. Each engine has its own dedicated tool (pgAdmin for Postgres, MySQL Workbench for MySQL, DB Browser for SQLite), which works fine if you only use one engine. If you run multiple SQL databases (common in polyglot stacks), you end up learning three tools and swapping between three apps. 1bench maps every SQL engine into one consistent editor, schema browser, and data grid so the workflow stays identical across engines.
Can one SQL GUI connect to PostgreSQL, MySQL, SQLite, and MariaDB at the same time?
Yes. 1bench supports parallel tabs, so you can have connections open to PostgreSQL, MySQL, SQLite, MariaDB, and more simultaneously. Each tab keeps its own query editor, transaction state, and browse history. Write a query in one tab, browse a table in another, run an EXPLAIN in a third; no need to close or switch context.
Can one GUI work across relational, distributed, and analytical SQL?
Yes. 1bench treats every SQL engine as first-class: relational (PostgreSQL, MySQL, SQLite, MariaDB), distributed (CockroachDB, YugabyteDB, TiDB), analytical (ClickHouse, DuckDB, TimescaleDB), and cloud-hosted (Neon, Supabase, Turso). The core query editor, schema designer, and data grid work the same across all of them; per-engine specializations surface inline where relevant.

Ready to manage your SQL databases visually?

1bench connects to every SQL database we support, both cloud and self-hosted. Start your 7-day free trial today.

View Pricing