Rocketgraph can query your ClickHouse database directly. You create a read-only user in ClickHouse, then add the connection details in Rocketgraph.

​
Prerequisites

  • A running ClickHouse instance (self-hosted or ClickHouse Cloud)
  • Admin access to create users and grant privileges
  • A Rocketgraph account — sign up here

​
1. Create a read-only user

Connect to your ClickHouse instance and run the following SQL: 
-- Create the user
CREATE USER rocketgraph_readonly
  IDENTIFIED BY 'a-strong-password'
  HOST ANY;

-- Grant read-only access to the databases you want to expose
GRANT SELECT ON your_database.* TO rocketgraph_readonly;
Replace your_database with the database(s) you want Rocketgraph to access. Repeat the GRANT statement for each additional database.
Using HOST ANY is convenient but you can restrict it to Rocketgraph’s IP ranges for tighter security. Contact support for the current egress IPs.

​
2. Allow external connections (self-hosted only)

If you are running ClickHouse yourself, ensure the HTTP or native interface is accessible from outside your network and that your firewall allows inbound traffic on the relevant port (default 8123 for HTTP, 9000 for native TCP). ClickHouse Cloud instances are accessible by default — skip this step.

​
3. Add ClickHouse as a datasource in Rocketgraph

  1. Log in to Rocketgraph
  2. Navigate to the Datasources tab
  3. Click Add datasource and select ClickHouse
  4. Enter your:
    • Host (e.g. my-instance.clickhouse.cloud or your server IP)
    • Port (default 8443 for HTTPS, 8123 for HTTP)
    • Database
    • Username — rocketgraph_readonly
    • Password
  5. Click Save — Rocketgraph will verify the connection
Once connected, your ClickHouse tables will be available for querying and analysis in Rocketgraph.