Desktop app for Mac, Windows & Linux

CockroachDBCockroachDB GUI Client

Browse databases and tables, run SQL queries, edit data inline, and manage your distributed SQL database visually. Connect to CockroachDB on localhost, self-hosted, or cloud (CockroachDB Cloud).

7-day free trial · No sign-up required

10x Your CockroachDB Productivity

Stop switching between CLI and code. Manage everything visually.

SQL Query Execution

Write and run SQL queries against your CockroachDB cluster with syntax highlighting and instant results.

Database Discovery

Automatically discover and browse all databases in your CockroachDB cluster. Switch between them with a click.

Table Discovery

Browse all tables within a database. View column details, row counts, and table statistics at a glance.

Column Information

Inspect column names, data types, and constraints for any table in your CockroachDB database.

Data Viewer with Pagination

Browse table data with built-in pagination and sorting. Handle large distributed tables without loading everything at once.

Column Sorting

Sort query results and table data by any column to quickly find the rows you need.

Inline Data Editing

Edit cell values directly in the table view and save changes back to CockroachDB with a single action.

Row Insertion

Insert new rows into CockroachDB tables through a visual form. No need to write INSERT statements manually.

Table Operations

Truncate or drop tables with confirmation dialogs to prevent accidental data loss in production.

Export to SQL, CSV & JSON

Export query results and table data to SQL, CSV, or JSON for sharing, backups, or migration between environments.

Data Import

Import data into CockroachDB tables from external files without writing INSERT statements by hand.

SSH Tunnel Support

Connect securely to remote CockroachDB clusters through SSH tunnels. Ideal for private or firewalled deployments.

Multiple Tabs

Work across databases and connections in parallel with a tabbed interface.

Keyboard Shortcuts

Navigate and execute queries without reaching for the mouse.

Dark & Light Mode

Switch between dark and light themes to match your preference and reduce eye strain.

Frequently Asked Questions

What is the best CockroachDB GUI client?
1bench provides a native CockroachDB GUI for Mac (Apple Silicon and Intel), Windows, and Linux. It connects via the PostgreSQL wire protocol that CockroachDB supports, offering database browsing, SQL query execution, inline data editing, and export. Other options include the built-in DB Console and DBeaver.
How is a CockroachDB GUI different from the built-in DB Console?
The CockroachDB DB Console focuses on cluster monitoring — node status, replication, and performance metrics. A GUI client like 1bench is designed for day-to-day database work: browsing tables, writing queries, editing data inline, inserting rows, and exporting results. They complement each other.
Can I use PostgreSQL tools with CockroachDB?
Yes. CockroachDB implements the PostgreSQL wire protocol, so most PostgreSQL GUI clients work with it. 1bench uses its PostgreSQL adapter to connect to CockroachDB, supporting schema discovery, SQL queries, data editing, import, and export. Most standard SQL works, though some PostgreSQL-specific features may differ.
How do I connect a GUI client to CockroachDB Cloud?
In CockroachDB Cloud (Serverless or Dedicated), go to your cluster's Connection page to get the host, port, and connection string. Enter these in 1bench along with your credentials. CockroachDB Cloud uses TLS by default, which 1bench handles automatically. For Dedicated clusters in a private VPC, use the SSH tunnel option.
Can I export data from CockroachDB?
Yes. 1bench lets you export query results and table data from CockroachDB to SQL, CSV, or JSON formats. This works for any SELECT query or full table export, making it easy to share data, create backups of specific tables, or move data between environments.

Not Just CockroachDB

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

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchClickHouseClickHouseSQLiteSQLite
YugabyteDBYugabyteDB
TimescaleDBTimescaleDB
NeonNeon
SupabaseSupabaseAmazon RedshiftAmazon Redshift
GreenplumGreenplum
ValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMongoDBMongoDBMySQLMySQLMariaDBMariaDBDuckDBDuckDBSQL ServerSQL ServerCassandraCassandraNeo4jNeo4jQdrantQdrantTypesenseTypesenseMilvusMilvus

Ready to manage CockroachDB visually?

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

View Pricing

1bench is not affiliated with or endorsed by Cockroach Labs, Inc.. CockroachDB is a trademark of Cockroach Labs, Inc..