1bench — Modern TiDB GUI client

TiDBTiDB GUI client

Browse databases, run SQL queries, and edit rows in TiDB visually via MySQL wire. Connect to TiDB on localhost, self-hosted, or cloud (TiDB Cloud).

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 TiDB

1

Server Overview

Instant on-connect snapshot: TiDB version, cluster mode, uptime, active connections, per-database sizes, and node topology. HTAP status at a glance.

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. Cells edit 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 TiDB productivity

Stop switching between CLI and code. Manage everything visually.

SQL Editor

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

Visual Query Builder

Build SELECT, INSERT, UPDATE, DELETE queries visually with a searchable field picker. Live SQL preview.

Table Browser

Browse table data with filtering, sorting, and inline editing. 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 TiDB Cloud (Serverless + Dedicated), self-hosted clusters, or via SSH tunnels with TLS by default.

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 TiDB databases and clusters 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 TiDB

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

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchClickHouseClickHouseSQLiteSQLiteCockroachDBCockroachDBSupabaseSupabaseTimescaleDBTimescaleDBQdrantQdrantTypesenseTypesenseMongoDBMongoDBMySQLMySQLMariaDBMariaDBDuckDBDuckDBMilvusMilvusYugabyteDBYugabyteDBNeonNeonValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMeilisearchMeilisearchWeaviateWeaviateChromaChromaTursoTursoEloqKVEloqKV

Don't see yours? Request it →

Frequently asked questions

What is a TiDB GUI?
A TiDB GUI is a visual desktop client that lets you browse schemas, run SQL, and edit rows without using the MySQL command-line client. 1bench is a modern TiDB GUI for Mac, Windows, and Linux.
Does TiDB have a GUI?
TiDB ships TiDB Dashboard, a web-based cluster monitoring UI, but no official desktop SQL editor. TiDB speaks the MySQL wire protocol, so a modern SQL GUI like 1bench connects to it directly for browsing schemas, editing rows, and running queries on Mac, Windows, and Linux.
What is the best TiDB GUI for Mac, Windows, or Linux?
A good TiDB GUI should run natively on your OS, speak the MySQL wire protocol that TiDB exposes, support TLS and SSH tunnels, and let you browse schemas, edit rows, and run SQL. 1bench delivers all of this with a single download for Mac, Windows, and Linux.
Can I use a TiDB GUI with TiDB Cloud and self-hosted clusters?
Yes. Any TiDB GUI that speaks the MySQL wire protocol can connect to TiDB Cloud (Serverless and Dedicated) and self-hosted clusters. 1bench supports TLS by default and SSH tunnels for private VPC deployments.
What is the difference between a TiDB client and server?
The TiDB server is the distributed database that stores data and runs queries across TiKV nodes; the client is the tool you use to connect and send queries. A GUI client like 1bench is one kind of client — it talks to a TiDB SQL endpoint over TCP (port 4000 by default).

Ready to manage TiDB visually?

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

View Pricing

1bench is not affiliated with or endorsed by PingCAP, Inc.. TiDB is a trademark of PingCAP, Inc..