Skip to content
ClickHouse

ClickHouse Client

Native ClickHouse client for macOS

TablePro connects to ClickHouse via the HTTP interface. It supports ClickHouse 21+ including ClickHouse Cloud. You get a SQL editor optimized for ClickHouse syntax (WITH, ARRAY JOIN, SAMPLE, FINAL), a data grid for browsing large result sets, and export to CSV, JSON, or XLSX. Works with self-hosted ClickHouse and ClickHouse Cloud.

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

Features

Built for ClickHouse.

ClickHouse SQL Editor

Syntax highlighting for ClickHouse-specific SQL (WITH, ARRAY JOIN, SAMPLE BY, FINAL, PREWHERE). Autocomplete for table and column names.

Large Result Sets

Browse millions of rows with progressive loading. Sort and filter without re-running the query.

System Tables

Browse system.parts, system.query_log, system.metrics. Monitor cluster health and query performance.

HTTP Protocol

Connects via HTTP/HTTPS. No native driver to install. Works through firewalls and reverse proxies.

ClickHouse Cloud

Connect to ClickHouse Cloud with username and password over HTTPS. No extra configuration.

Export Results

Export query results to CSV, JSON, SQL, or XLSX. Stream large exports without memory limits.

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, views, and dictionaries
  • Run ClickHouse SQL with syntax highlighting
  • Progressive loading for large result sets
  • Browse system tables for monitoring
  • Connect via HTTP or HTTPS
  • Export to CSV, JSON, SQL, XLSX
  • Query history with full-text search
  • Works with ClickHouse Cloud

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

Try TablePro for free.

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

Download for MacSetup guide