Java Client：

1. clickhouse-jdbc 官方驱动、基于http https://github.com/ClickHouse/clickhouse-jdbc
2. clickhouse4j 基于http、增加CopyManager https://github.com/blynkkk/clickhouse4j
3. ClickHouse-Native-JDBC 基于TCP、性能更好 https://github.com/housepower/ClickHouse-Native-JDBC

其他 Client

1. clickhouse-cli Python 开发的客户端基于http，类似mycli https://github.com/hatarist/clickhouse-cli

Web UI

1. https://tabix.io/

Cheatsheet

1. https://gist.github.com/shved/41d2be3f8fc3678ae437284e254c0e1b
2. https://docs.hydrolix.io/reference/sql/compatability/clickhouse

Mac brew 安装

1. Add homebrew tap:

brew tap lisun/clickhouse

2. Install ClickHouse :

   brew upgrade brew install clickhouse

3. start server:

brew services start clickhouse