Connecting to ClickHouse
- Open the connections page in preferences, see managing connections for more information.
- Click the
Add new Connectionbutton at the top of the connections page.

- Select
ClickHousefrom the list.

- Give a
Connection namefor your own internal reference. - For
Hostname, enter the hostname of your database server. - For
Port, use the default8123, or enter the HTTP port used by your server.- Note: for HTTPS,
SSL optionsneed to be toggled on.
- Note: for HTTPS,
- For
Database, enter the name of your database. - For
UsernameandPassword, enter the username and password for ClickHouse. These are optional. - Toggle connection type for direct or cloud.
- Share the connection with your team.
- Configure
SSHandSSLsettings. These are optional. - Hit
Connectand you're all set!
Happy querying! 🍭
Updated about 1 month ago
