​

Before you connect

• SELECT privilege on the target database and tables

​

Connection fields

Port note — Supaboard connects over the native TCP protocol on port 9000. This is different from the HTTP interface (port 8123) and the HTTPS interface (port 8443). ClickHouse Cloud uses port 9440 for secure native TCP — check your Cloud service details if 9000 does not connect.

​

Finding your connection details

​

ClickHouse Cloud

1. Open clickhouse.cloud and select your service.
2. On the service detail page, go to Connect.
3. Select Native as the connection method.
4. Copy the Host (format: xxxxx.clickhouse.cloud) and Port (typically 9440 for secure native TCP on ClickHouse Cloud).
5. Use the default user or a custom user you have created.
6. Under Security → IP Access List, add each Supaboard egress IP to allow connections.

ClickHouse Cloud uses port 9440 (TLS-enabled native TCP), not 9000. Update the Port field accordingly.

​

Self-hosted ClickHouse

1. Your Host is the server’s IP address or hostname.
2. The default native TCP Port is 9000.
3. Check /etc/clickhouse-server/config.xml (or config.d/) for any custom port configuration.
4. Ensure the server’s firewall allows inbound TCP on port 9000 from Supaboard egress IPs.

​

IPsec Site-to-Site VPN

• Your VPN gateway has one IKEv2 + pre-shared-key tunnel per Supaboard IP (the IPs shown under Whitelist IPs)
• The gateway allows UDP 500, UDP 4500, and ESP (IP protocol 50) from those IPs
• The Host field is the database’s private IP address — private DNS names don’t resolve from Supaboard
• Enter the database name manually — auto-discovery doesn’t run through the VPN before the connection is saved

​

Recommended database user permissions

-- Create a read-only user
CREATE USER supaboard IDENTIFIED BY 'strong_password_here';

-- Grant SELECT on a specific database
GRANT SELECT ON your_database.* TO supaboard;

-- Optionally allow database discovery
GRANT SHOW DATABASES ON *.* TO supaboard;
GRANT SHOW TABLES ON your_database.* TO supaboard;

​

Troubleshooting