ClickHouse

Connect a ClickHouse Database to Wobby

Connect ClickHouse to Wobby

To connect your ClickHouse instance to Wobby, follow these steps:

• Create a read-only user account.

• Grant read-only access to the necessary databases.

• Allow Wobby's IP address through your firewall or network rules.

• Set up the connection in the Wobby interface.

⚠️ Wobby's agents only run read-only queries on your data. No write or administrative privileges are required.

---

1. Create a Read-Only User in ClickHouse

Create a dedicated ClickHouse user that Wobby will use to query your data.

-- Replace with your chosen username and a secure password
CREATE USER wobby_user IDENTIFIED BY 'your_secure_password';

✅ Use a strong password and avoid reusing credentials from other systems.

---

2. Grant Read-Only Access to Data

Grant the user read-only (SELECT) access to the databases Wobby should be able to analyze.

-- Grant SELECT on all tables in a specific database
GRANT SELECT ON your_database.* TO wobby_user;

🔐 Repeat for each database Wobby should have access to. If you want finer control, you can grant access on a per-table basis:

GRANT SELECT ON your_database.orders TO wobby_user;
GRANT SELECT ON your_database.customers TO wobby_user;

✅ Wobby will only query data the user has access to—if the user doesn't have access, Wobby won't either.

---

3. Allow Wobby's IP Address

If your ClickHouse server is protected by firewall or network rules, allow inbound traffic from Wobby's static IP:

34.77.172.158

This is required for Wobby's agents to connect to your ClickHouse instance.

---

4. Set Up the Connection in Wobby

1. Click Connections → Plus button → Select ClickHouse.

2. Fill in the following details:

   • Host: your ClickHouse server hostname or IP address

   • Port: default is 8123 (HTTP) or 8443 (HTTPS/SSL) — leave as default unless your instance uses a custom port

   • Database: the default database Wobby should connect to

   • Database schemas: select the databases Wobby is allowed to query

   • Username: wobby_user

   • Password: the secure password you set

   • SSL: enable if your ClickHouse instance requires encrypted connections

3. Test the connection and click Save.

📌 ClickHouse Cloud users: If your host ends in .clickhouse.cloud, Wobby will automatically enable SSL and switch the port to 8443.

---

That's It!

Wobby is now connected to ClickHouse. You can start asking questions in natural language—no dashboards, no SQL—just insights.