​

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.

​

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