Desktop app for Mac, Windows & Linux

ClickHouseClickHouse GUI Client

Run analytical SQL queries, browse databases and tables, and edit data inline. Connect to ClickHouse on localhost, self-hosted, or cloud (ClickHouse Cloud).

7-day free trial · No sign-up required
ClickHouse GUI Client - 1bench
1

SQL Editor with Visual Query Builder

Write ClickHouse SQL with syntax highlighting, or build queries visually with column pickers, filters, sort, and limit. See the generated SQL as you build, then run with one click.

2

Browse Analytics at Scale

Paginate through millions of rows without breaking a sweat. Browse page views, events, and API logs with column sorting, inline editing, and fast pagination.

3

Full Database Hierarchy

See all databases, tables, and columns in one expandable tree. View table engines, row counts, and storage sizes at a glance. No more switching between databases in a dropdown.

10x Your ClickHouse Productivity

Stop switching between CLI and code. Manage everything visually.

SQL Query Execution

Write and run ClickHouse SQL queries with syntax highlighting. View structured results in an instant.

Inline Data Editing

Click any cell to edit values directly in the results table. Save all changes back to ClickHouse at once.

Row Insertion

Add new rows through a clean visual form with field validation. No need to write INSERT statements by hand.

Table Operations

Truncate or drop tables safely with confirmation dialogs. Built-in safeguards prevent accidental data loss.

Schema Inspector

Inspect column names, data types, default expressions, and table engine info. View row counts and statistics.

HTTP / HTTPS Protocol

Connect to ClickHouse over HTTP or HTTPS protocols. Works with self-hosted instances and ClickHouse Cloud.

SSH Tunnel Support

Reach remote ClickHouse servers securely through SSH tunnels. Perfect for private or firewalled deployments.

Read-Only Mode

Enable read-only mode to safely browse production analytics data. Prevents any accidental writes or changes.

Export & Import

Export query results or full tables as CSV or JSON files. Import data from local files back into ClickHouse.

Favorites

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

Query History

Every query you execute is automatically saved per connection. Search, re-run, or bookmark your past queries.

Column Sorting

Sort query results and table data by clicking any column header. Quickly locate the exact rows you are after.

Multiple Tabs

Open multiple tabs to work across different databases and connections in parallel within a single app window.

Keyboard Shortcuts

Use keyboard shortcuts to navigate the interface, run queries, and switch tabs without reaching for the mouse.

Dark & Light Mode

Choose between dark and light themes to match your workspace preference. Reduces eye strain in any lighting.

Frequently Asked Questions

What is ClickHouse and when should I use it?
ClickHouse is an open-source, column-oriented database designed for real-time analytical queries (OLAP). It excels at aggregating large volumes of data with sub-second response times. Use it when you need fast analytics on billions of rows, log analysis, time-series data, or real-time dashboards.
What is the best ClickHouse GUI client for Mac, Windows, and Linux?
1bench offers a native ClickHouse GUI for Mac (Apple Silicon and Intel), Windows, and Linux. It lets you browse databases and tables, run SQL queries, edit data inline, and manage table operations visually. Other options include the built-in ClickHouse Play web UI and DBeaver.
Does ClickHouse have a built-in web UI?
Yes, ClickHouse includes a minimal web UI called ClickHouse Play accessible via the HTTP interface (typically at port 8123/play). It supports running queries but lacks features like inline editing, table management, and multi-connection support. For a more complete experience, a dedicated GUI client like 1bench is recommended.
How do I connect a ClickHouse GUI to a Docker container?
When running ClickHouse in Docker, expose the HTTP port with -p 8123:8123. Then connect your GUI client to localhost:8123 using the HTTP protocol. If you also need the native protocol, expose port 9000. 1bench connects via HTTP/HTTPS, so you only need port 8123 mapped.
Can I connect to ClickHouse Cloud from a GUI client?
Yes. ClickHouse Cloud provides an HTTPS endpoint that any compatible GUI client can connect to. In 1bench, enter your ClickHouse Cloud hostname, port 8443, and your credentials. HTTPS is used automatically for secure connections. SSH tunnels are also supported for private deployments.

Not Just ClickHouse

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

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchSQLiteSQLiteCockroachDBCockroachDB
YugabyteDBYugabyteDB
TimescaleDBTimescaleDB
NeonNeon
SupabaseSupabaseAmazon RedshiftAmazon Redshift
GreenplumGreenplum
ValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMongoDBMongoDBMySQLMySQLMariaDBMariaDBDuckDBDuckDBSQL ServerSQL ServerCassandraCassandraNeo4jNeo4jQdrantQdrantTypesenseTypesenseMilvusMilvus

Ready to manage ClickHouse visually?

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

View Pricing

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