How do I connect to my ClickHouse server?

1. In the panel, open My servers and click your server.
2. On the Overview tab, wait for the App row to say "ClickHouse is ready". The page refreshes itself.
3. Copy the details from the Connection address, Login and Password rows.

Connecting

Try it over HTTP:

curl -u default:PASSWORD 'http://IP:8123/?query=SELECT%201'

Connect with the native client on port 9000: clickhouse-client --host IP --password PASSWORD

Security

• Database port 8123 is open to the internet. To let only your own servers connect, limit it in the firewall: ufw delete allow 8123/tcp, then ufw allow from YOUR_IP to any port 8123.
• Port 9000 is open too, so limit it the same way. Connections come without TLS.
• If the server has less than 16 GB, installation turns on the low memory settings the official docs recommend: one query thread, small caches, system logs off. When you resize, delete /etc/clickhouse-server/config.d/seturack-dusuk-bellek.xml and /etc/clickhouse-server/users.d/seturack-dusuk-bellek.xml and run systemctl restart clickhouse-server.

No server yet? Order a server with ClickHouse installed: you choose the size and pay for what you choose.