Skip to main content

ClickHouse Integration

Connect ClickHouse to enable agents to run analytics queries during investigations.

Capabilities​

CapabilityDescription
Run QueriesExecute SQL queries
Analyze DataAccess analytics and metrics
Browse TablesView available tables

Setup​

1
Get Connection Details

You'll need:

  • ClickHouse host URL
  • Database name
  • Username and password
2
Add Integration in Autoheal
  1. Go to Integrations → ClickHouse
  2. Enter connection details
  3. Specify the database to query
3
Test and Save

Click Test Connection then Save.

Security​

warning

Use a read-only user for Autoheal. The integration should not have write access to your data.

Example Queries​

What's the request count by status code for the last hour?
Show me the top 10 slowest endpoints