Skip to content
ClickHouse

ClickHouse Client

The ClickHouse GUI Client for Mac.

A fast, native ClickHouse GUI client for Mac. Connect to local ClickHouse, ClickHouse Cloud, or any HTTP/native endpoint. Browse databases, edit rows where allowed, run analytical queries with autocomplete. Streams billion-row results without OOM. Free and open source.

Download for MacRead the docs
TablePro connected to a ClickHouse database showing the data grid and SQL editor

Features

Built for ClickHouse.

Streaming Result Sets

Billion-row queries open in a streaming grid. Scroll, cancel, export without loading the full result.

ClickHouse Cloud Native

Connect to ClickHouse Cloud with HTTPS and JWT. SSL on by default.

Schema-Aware Autocomplete

Suggests tables, columns, MergeTree settings, ClickHouse functions, and array operations.

Type-Rich Cell View

Tuple, Array, Nested, Decimal, LowCardinality. All shown in their native form, not flattened.

Query Cost Insight

After each query, see rows read, bytes read, time spent. Spot expensive scans before they hit prod.

AI Query Assistant

Ask in English, get ClickHouse SQL. Explain query plans, suggest array joins.

Data Grid

Browse and edit data.

Sort, filter, and edit ClickHouse data in a spreadsheet-like grid. Click any cell to edit. Insert and delete rows. Review changes before saving.

TablePro data grid showing ClickHouse table rows with inline editing

SQL Editor

Write queries faster.

Tree-sitter syntax highlighting, schema-aware autocomplete, multi-tab, Vim mode, and full-text query history. AI assistant can write, explain, or optimize your SQL.

TablePro SQL editor with ClickHouse query and autocomplete

Capabilities

What you can do.

  • Browse databases, tables, MergeTree engines, dictionaries
  • Run analytical queries with streaming results
  • Connect over HTTP, HTTPS, or native TCP
  • Edit rows where the engine allows
  • View query stats: rows read, bytes, duration
  • Stream-export billion-row results
  • Full-text search across query history
  • Safe mode for production clusters

Connect

Get connected in seconds.

# Connect with TablePro Host: 127.0.0.1 Port: 8123 User: default Database: default # ClickHouse Cloud Host: abc123.clickhouse.cloud Port: 8443 (HTTPS) User: default

Supported versions

ClickHouse 21+, ClickHouse Cloud

Connection types

  • HTTP
  • HTTPS
  • SSH Tunnel (via port forwarding)

Default port

8123

How to

Connect to ClickHouse in four steps.

  1. 1

    Install TablePro

    brew install --cask tablepro, or grab the DMG from tablepro.app/download.

  2. 2

    Open New Connection

    Click New Connection. Pick ClickHouse.

  3. 3

    Fill in the credentials

    Host or Cloud endpoint, port 8123 (HTTP) or 9000 (native), user, password.

  4. 4

    Connect

    Click Connect. Databases appear in the sidebar.

FAQ

Common ClickHouse questions.

Does it work with ClickHouse Cloud?

Yes. Paste the HTTPS endpoint and the user/password from the cloud console. TLS is on by default.

Can I open billion-row tables?

Yes. The data grid streams. Memory stays flat. Scroll without lag.

Is TablePro free?

Yes. AGPLv3 open source. The ClickHouse driver ships built in.

Does it support Tuple, Array, and Nested?

Yes. Each shows in its native form. Click to expand nested structures.

Can I see query cost?

Yes. After every query, TablePro shows rows read, bytes read, and elapsed time.

Try TablePro for free.

Free and open-source. macOS 14+. Apple Silicon and Intel.

Download for MacSetup guide