Desktop app for Mac, Windows & Linux

PostgreSQLPostgreSQL GUI Client

Browse databases, schemas, and tables. Run queries, edit data inline, and manage your database visually. Connect to PostgreSQL on localhost, self-hosted, or cloud (Supabase, Neon, AWS RDS).

7-day free trial · No sign-up required
Also works with:
CockroachDBCockroachDB
YugabyteDBYugabyteDB
PostgreSQL GUI Client - 1bench
1

Full Database Hierarchy

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

2

Visual Query Builder

Build SQL queries visually — pick columns, add filters with operators, set sort and limit. See the generated SQL and run it with one click, or switch to the raw editor for full control.

3

Browse, Edit & Manage

Browse table data with pagination and sorting. Edit cells inline, insert rows visually, and view schema details — column types, primary keys, defaults, and constraints.

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 Supabase, Neon, AWS RDS, Google Cloud SQL, and other PostgreSQL-compatible cloud services.

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.

Frequently Asked Questions

What is the best PostgreSQL GUI client?
Popular options include pgAdmin (official, free), DBeaver (open source, multi-database), DataGrip (JetBrains, paid), and 1bench (cross-platform, multi-database). 1bench stands out for teams that also use Redis, Elasticsearch, ClickHouse, or SQLite, since it supports them all in one app.
How do I connect to a PostgreSQL database with a GUI?
Download a PostgreSQL GUI client like 1bench. Enter your connection details — host, port, username, password, and database name. For remote servers, you can connect through SSH tunnels directly from the app. 1bench supports both local and cloud PostgreSQL instances including Supabase, Neon, and AWS RDS.
Can I use a PostgreSQL GUI with CockroachDB or YugabyteDB?
Yes. CockroachDB and YugabyteDB are PostgreSQL-compatible, so GUI clients that support PostgreSQL typically work with them as well. 1bench connects to all three using the same PostgreSQL adapter.
Does 1bench support multiple schemas and databases?
Yes. 1bench shows the full hierarchy — databases, schemas, and tables — in one expandable tree. You can browse across schemas without switching connections, and work with multiple databases in parallel using tabs.
Can I edit PostgreSQL data directly in the GUI?
Yes. 1bench supports inline editing — click any cell to edit its value, stage multiple changes, then save them all at once. You can also insert new rows through a visual form and delete rows from the context menu.

Not Just PostgreSQL

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

RedisRedisElasticsearchElasticsearchClickHouseClickHouseSQLiteSQLiteTimescaleDBTimescaleDB
NeonNeon
SupabaseSupabaseAmazon RedshiftAmazon Redshift
GreenplumGreenplum
ValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMongoDBMongoDBMySQLMySQLMariaDBMariaDBDuckDBDuckDBSQL ServerSQL ServerCassandraCassandraNeo4jNeo4jQdrantQdrantTypesenseTypesenseMilvusMilvus

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.