Clickhouse

Give an agent read-only access to ClickHouse schemas and server metrics through the ilert MCP connector.

Required permissions

Tool	Required Permission	Description
list_databases	read	List all databases in the ClickHouse cluster. Useful for discovering available databases.
list_tables	read	List all tables in a specific database. Useful for discovering available tables and their structure.
describe_table	read	Get detailed schema information about a table including columns, data types, and table engine settings.
get_metrics	read	Get ClickHouse metrics including system metrics, events, replicas, processes, merges, and mutations. Useful for spotting replication lag, stuck mutations, and long-running queries.

The ClickHouse integration is read-only and does not expose an arbitrary SQL query tool. The agent can inspect schemas and read server metrics, but it cannot access your data.

Deploy the ilert MCP connector

ilert does not connect to your ClickHouse cluster directly. The ClickHouse MCP server calls the ilert MCP connector, a service you deploy in your own network and expose over a public HTTPS URL. Deployment, the auth token and all configuration options are on its own page:

ilert MCP connector

Enable ClickHouse on the connector with these variables:

CLICKHOUSE_ENABLED=true
CLICKHOUSE_HOST=clickhouse.internal
CLICKHOUSE_PORT=9000
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=your_password
CLICKHOUSE_DATABASE=default

CLICKHOUSE_PORT is the native protocol port, not the HTTP one.

Connect ClickHouse with agent

To connect ClickHouse with your AI SRE agent:

1

Navigate to Agents in the ilert navigation menu

2

Open the agent detail view for the agent you want to configure

3

Go to the Tools tab

4

Under the ilert hosted MCP servers section, locate the ClickHouse card

5

Click Connect on the ClickHouse card

6

In the connection dialog that appears:

• Select connector: Choose "Create new connector" (or select an existing connector if you have one)
• Type: Select Bearer Token from the dropdown
• Secret name: Enter a name for your connector (e.g., "ClickHouse Production" or "ClickHouse Main")
• Secret value: Enter the AUTH_TOKEN value from your connector deployment
• Host URL: Enter the public URL where your connector is reachable (e.g., https://ilert-mcp-connector.example.com)

7

Click Connect to complete the connection

8

After connecting, you can enable or disable specific tools needed for alert investigation, such as:

• list_databases - List all databases in the ClickHouse cluster
• list_tables - List all tables in a specific database
• describe_table - Get detailed schema information about a table
• get_metrics - Get system metrics, events, replicas, processes, merges, and mutations

The ClickHouse integration is now connected and ready to use for root cause analysis.