Drivers and Interfaces

ClickHouse provides two network interfaces (they can be optionally wrapped in TLS for additional security):

• HTTP, which is documented and easy to use directly.
• Native TCP, which has less overhead.

In most cases it is recommended to use an appropriate tool or library instead of interacting with those directly. The following are officially supported by ClickHouse:

• Command-line client
• JDBC driver
• ODBC driver
• C++ client library

ClickHouse also supports two RPC protocols:

• gRPC protocol specially designed for ClickHouse.
• Apache Arrow Flight.

ClickHouse server provides embedded visual interfaces for power users:

• Play UI: open /play in the browser;
• Advanced Dashboard: open /dashboard in the browser;
• Binary symbols viewer for ClickHouse engineers: open /binary in the browser;

There are also a wide range of third-party libraries for working with ClickHouse:

• Client libraries
• Integrations
• Visual interfaces