Skip to main content

Connect to ClickHouse

ClickHouse has several options for connecting to it (depending on what you are trying to accomplish), including:

  • The SQL console is a core component of ClickHouse Cloud used to explore your databases and tables, run and save queries, and create charts.
  • The Play UI is handy for running the occasional SQL query
  • The clickhouse-client is a powerful command-line tool that allows you to run multiple commands in a session from your favorite terminal application
  • clickhouse-local opens up the world of ClickHouse features and functions without requiring a connection to a running ClickHouse service

If you are looking to connect a BI tool like Grafana, Tableau and others, check out the Visualize category of the docs.