1bench, modern PostgreSQL GUI client

PostgreSQLPostgreSQL GUI client

Browse databases, schemas, and tables. Run queries, edit data inline, and manage your database visually. Connect to PostgreSQL on localhost or self-hosted.

Apple Silicon. Also available for 7-day free trial · No credit card required
PostgreSQL GUI Client - 1bench

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 PostgreSQL

1

Full Database Hierarchy

See all databases, schemas, and tables in one expandable tree. Browse across schemas without switching connections, with row counts at a glance.

2

Visual Query Builder

Build SQL visually by picking columns, adding filters, and setting sort and limit. See the generated SQL as you go, or switch to the raw editor for full control.

3

Browse, Edit & Manage

Browse table data as a paginated table or as row-detail cards for long text and wide schemas. Edit cells inline, insert rows visually, view schema details.

4

Server Overview

Instant health snapshot on connect with version, uptime, active connections, cache hit ratio, database sizes, and replication status. No setup needed.

5

Create Tables, Indexes, Schemas & Databases

Visual wizards for tables (columns, keys, FKs, checks), secondary indexes (btree, gin, gist, brin, hash), schemas, and databases, all with live SQL preview.

6

Native pgvector Support

Embedding columns render inline as compact vector cells. Visualize 2D projections, right-click any row for Find Similar. No custom queries needed.

10x your PostgreSQL productivity

Stop switching between CLI and code. Manage everything visually.

SQL Query Execution

Write and run SQL queries with syntax highlighting. View results instantly in a sortable, paginated table.

Inline Data Editing

Click any cell to edit its value directly. Stage multiple changes across rows and save them all at once.

Row Insertion

Insert new rows through a clean visual form. Skip writing INSERT statements by hand every single time.

Table Operations

Truncate or drop tables with built-in confirmation dialogs. Prevent accidental data loss in production.

Schema Inspector

View column types, nullable flags, default values, primary keys, and constraints for any selected table.

SSH Tunnels

Connect to remote PostgreSQL servers securely through SSH tunnels. Access private databases with ease.

Cloud Support

Connect to any managed PostgreSQL service or your own self-hosted deployment. TLS, SNI, and SSH tunnels supported.

Read-Only Mode

Toggle read-only mode to safely browse production databases. Eliminate any risk of accidental writes.

Production Safe

Confirmation dialogs guard all destructive operations. Always review before executing DROP or TRUNCATE.

Export & Import

Export full tables or filtered query results as CSV or JSON files. Import data from files just as easily.

Favorites

Pin your most-used tables, saved queries, and database connections for instant access from the sidebar.

Query History

Every query you run is saved automatically per connection. Search, re-run, or favorite past queries anytime.

Multiple Tabs

Work across multiple databases and connections in parallel using a clean and intuitive tabbed interface.

Keyboard Shortcuts

Navigate between tables, run queries, and switch tabs entirely from the keyboard. No mouse required.

Dark & Light Mode

Choose between polished dark and light themes. Matches your system preference or set it on your own.

Not just PostgreSQL

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

RedisRedisElasticsearchElasticsearchClickHouseClickHouseSQLiteSQLiteCockroachDBCockroachDBSupabaseSupabaseTimescaleDBTimescaleDBQdrantQdrantTypesenseTypesenseMongoDBMongoDBMySQLMySQLMariaDBMariaDBDuckDBDuckDBMilvusMilvusYugabyteDBYugabyteDBNeonNeonValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMeilisearchMeilisearchWeaviateWeaviateChromaChromaTursoTursoEloqKVEloqKVTiDBTiDB

Don't see yours? Request it →

Frequently asked questions

What is a PostgreSQL GUI?
A PostgreSQL GUI is a visual desktop client that lets you browse databases, schemas, and tables, run SQL queries, and edit data without using the psql command line. 1bench is a modern PostgreSQL GUI for Mac, Windows, and Linux.
Does PostgreSQL have a GUI?
PostgreSQL itself ships only with psql, the command-line client. For a visual interface, you install a third-party PostgreSQL GUI like 1bench, a desktop app that lets you explore databases, edit rows inline, and run queries from one interface.
What is the best PostgreSQL GUI for Mac, Windows, or Linux?
A good PostgreSQL GUI should run natively on your OS, support SSH tunnels and SSL connections, and let you browse schemas, edit rows, and manage queries without leaving the app. 1bench delivers all of this with a single download for Mac, Windows, and Linux.
Can I use a PostgreSQL GUI with Postgres-compatible databases?
Yes. Any database that speaks the PostgreSQL wire protocol (distributed engines, managed Postgres services, and Postgres-compatible forks) works with a standard PostgreSQL GUI. 1bench connects using the same connection string, so you don't need a separate client per flavor.
What is the difference between a PostgreSQL client and server?
The PostgreSQL server is the database process that stores data and runs queries; the client is the tool you use to connect and send queries to it. A GUI client like 1bench is one kind of client that talks to a local or remote PostgreSQL server over TCP (port 5432 by default).

Ready to manage PostgreSQL visually?

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

View Pricing

1bench is not affiliated with or endorsed by The PostgreSQL Global Development Group. PostgreSQL is a trademark of The PostgreSQL Global Development Group.