1bench, modern MySQL GUI client

MySQLMySQL GUI client

Browse schemas, edit rows, and run queries with a visual editor for MySQL. Connect to MySQL on localhost or self-hosted.

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 MySQL

1

Server Overview

Instant on-connect snapshot: version, uptime, connections, per-database sizes, storage engine defaults, InnoDB buffer stats. All in one view.

2

Visual Query Builder

Build SELECT, INSERT, UPDATE queries visually with a searchable schema tree. Live SQL preview so you learn the syntax, then switch to raw when you want.

3

Row-Level Editing

Browse table data as a paginated grid or as row-detail cards for long text and wide schemas. Edit cells inline, changes stage before commit.

4

Create Tables, Indexes & Databases

Visual wizards for tables (columns, keys, FKs, checks), secondary indexes (BTREE, FULLTEXT, SPATIAL, UNIQUE), and databases, all with live SQL preview.

10x your MySQL productivity

Stop switching between CLI and code. Manage everything visually.

SQL Editor

Write and execute SQL with syntax highlighting, autocomplete, and inline results as you type.

Visual Query Builder

Build SELECT, INSERT, and UPDATE queries visually with a searchable field picker. Learn SQL with live preview.

Table Browser

Browse, filter, and sort table data. Edit cells inline and jump between related rows using FK navigation.

Create & Alter Table

Create and alter tables with columns, types, defaults, indexes, and foreign keys through a visual wizard.

Row Insertion

Insert new rows through a visual dialog that respects defaults, NOT NULL, foreign keys, and check constraints.

Drop Table

Remove tables safely with typed confirmation, dependency warnings, and staged batch delete with undo.

Import Data

Import from CSV, JSON, or SQL files with field mapping. Preview the first 50 rows before committing.

Export Data

Export tables or query results to CSV, JSON, or SQL. Filter, project, and rename columns from the dialog.

Index Management

Create, view, and drop indexes with BTREE, FULLTEXT, SPATIAL, or UNIQUE. Analyze usage with explain plans.

Table Schema

Inspect columns, types, defaults, constraints, and indexes. See FK relationships and jump to related tables.

Cloud Support

Connect to any managed MySQL service or self-hosted instance. TLS and SSH tunnels supported.

Production Safe

Read-only mode, destructive-action confirmations, and per-connection ACL checks keep production safe.

Query History

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

Multiple Tabs

Work across MySQL databases and connections in parallel. Each tab keeps its own browsing and query state.

Keyboard Shortcuts

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

Not just MySQL

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

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchClickHouseClickHouseSQLiteSQLiteCockroachDBCockroachDBSupabaseSupabaseTimescaleDBTimescaleDBQdrantQdrantTypesenseTypesenseMongoDBMongoDBMariaDBMariaDBDuckDBDuckDBMilvusMilvusYugabyteDBYugabyteDBNeonNeonValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMeilisearchMeilisearchWeaviateWeaviateChromaChromaTursoTursoEloqKVEloqKVTiDBTiDB

Don't see yours? Request it →

Frequently asked questions

What is a MySQL GUI?
A MySQL GUI (also called a MySQL viewer, editor, or query browser) is a visual desktop client that lets you browse schemas, run SQL, and edit rows without using the mysql command-line tool. 1bench is a modern MySQL GUI for Mac, Windows, and Linux.
Does MySQL have a GUI?
MySQL ships two official clients: mysql (the command-line) and MySQL Workbench (Oracle's desktop GUI). Workbench covers standard workflows well. For teams that want a modern native app on Mac, Windows, and Linux with cross-database tabs and unified UX, 1bench is a strong option.
What is the best MySQL GUI for Mac, Windows, or Linux?
A good MySQL 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 MySQL GUI with MySQL-compatible databases?
Yes. Any database that speaks the MySQL wire protocol (forks, distributed engines, and managed MySQL services) works with a standard MySQL GUI. 1bench connects using the same connection string, so you don't need a separate client per flavor.
What is the difference between a MySQL client and server?
The MySQL 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 MySQL server over TCP (port 3306 by default).

Ready to manage MySQL visually?

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

View Pricing

1bench is not affiliated with or endorsed by Oracle Corporation. MySQL is a trademark of Oracle Corporation.