ClickHouse
Inspect schema and run bounded read-only SQL over HTTPS
Connect ClickHouse for analytics apps that need live warehouse data. Swarmz pins requests to the configured HTTPS origin and accepts only read-only SELECT, SHOW, DESCRIBE, and EXPLAIN statements.
Connect ClickHouse
Create a ClickHouse user with read access only. In Settings > Integrations, select ClickHouse, then enter the HTTPS endpoint, username, password, and optional default database.
The connector can list databases, tables, and columns, and run bounded read-only SQL.
Example prompt:
Use ClickHouse to inspect the events table, then return daily active users for the last 14 days. Limit the result to 100 rows.
Verify and recover
List databases, inspect one table's columns, and run SELECT 1. Confirm the query reaches the intended ClickHouse instance and user.
If the endpoint fails, check TLS, network reachability, the configured path, and user grants. Swarmz rejects private-network and non-HTTPS origins. Rotate the ClickHouse password before updating an exposed connection.