1bench — Modern ClickHouse GUI Client

ClickHouse GUI Client

Name: 1bench ClickHouse GUI Client
Author: 1bench

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

Your Data Stays Yours

1bench runs entirely on your machine. Nothing is ever sent to us.

100% Local

Your credentials and data never leave your machine. No cloud sync, no account required.

Zero Telemetry

No usage tracking, no query logging, no analytics. What you do in 1bench stays in 1bench.

Direct Connection

1bench connects straight to your database. No proxy servers, no middleware in between.

Built for ClickHouse

SQL Editor with Visual Query Builder

Write ClickHouse SQL with syntax highlighting or build visually — pick columns, filters, sort, limit. See the generated SQL and run with one click.

Browse Analytics at Scale

Paginate through millions of rows without breaking a sweat. Page views, events, API logs — column sorting, inline editing, fast pagination.

Full Database Hierarchy

See all databases, tables, and columns in one expandable tree. Table engines, row counts, and storage sizes at a glance — no dropdown switching.

Server Overview

Health snapshot on connect — version, uptime, running queries, active merges, parts and storage sizes, replica status. ClickHouse internals, surfaced.

Create Tables & Databases

Visual CREATE TABLE wizard with engine, ORDER BY, PARTITION BY, SETTINGS — plus Nullable() auto-wrapping. Create databases too, with live SQL preview.

Vector Search Built In

Array(Float32) embedding columns render inline as compact vector cells. 2D projections, right-click Find Similar via cosineDistance — no extras needed.

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 a ClickHouse GUI?

A ClickHouse GUI is a visual desktop client that lets you browse databases, run analytical SQL, and inspect tables without using clickhouse-client on the terminal. 1bench is a modern ClickHouse GUI for Mac, Windows, and Linux.

Does ClickHouse have a GUI?

ClickHouse ships with clickhouse-client (CLI) and a minimal built-in Play web UI for running queries. For a full desktop experience — browsing databases, inspecting tables, editing rows, and managing clusters — you install a third-party ClickHouse GUI like 1bench.

What is the best ClickHouse GUI for Mac, Windows, or Linux?

A good ClickHouse GUI should run natively on your OS, connect over HTTP and HTTPS, and let you browse databases, run analytical SQL with syntax highlighting, and inspect query results. 1bench delivers all of this with a single download for Mac, Windows, and Linux.

Can a ClickHouse GUI connect to ClickHouse Cloud or on-prem clusters?

Yes. Any ClickHouse GUI that speaks the HTTP interface works with ClickHouse Cloud and self-hosted clusters — you just point it at the host, port, and credentials. 1bench also supports SSH tunnels for clusters inside private networks.

What is the difference between a ClickHouse client and server?

The ClickHouse server is the database process that stores data and runs analytical 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 — it talks to a local or remote ClickHouse server over HTTP (port 8123 or 8443 by default).