---
title: "ClickHouse integration for LuumenAI"
url: "https://www.luumen.ai/integrations/clickhouse/"
entity: SoftwareIntegration
category: "Databases & data platforms"
audience: "SRE, DevOps, platform engineering, IT operations"
---

# ClickHouse integration for LuumenAI

Query ClickHouse and read its schemas without leaving the terminal

## What LuumenAI can do with ClickHouse

LuumenAI connects to ClickHouse with Basic auth and exposes 6 tools (6 read-only). Every tool is read-only, so it can answer questions from ClickHouse but cannot change anything in it. Read actions still follow the configured access and approval policy.

## Key facts

- Authentication: Basic auth
- Tools available: 6 tools (6 read-only)
- Deployment: scoped as part of your Pilot, Platform, or Managed rollout
- Category: Databases & data platforms

## About ClickHouse with LuumenAI

Point Luumen at your ClickHouse instance and ask questions in plain terms. It can list databases and tables, pull a full database or single table schema, and run SQL with CLICKHOUSE_EXECUTE_QUERY when you need the numbers behind an incident. Connection uses basic auth. Every tool here is read-only.

## Example tools

Read-only (6 in total):

- `CLICKHOUSE_EXECUTE_QUERY` — Execute a SQL query in ClickHouse and return the results.
- `CLICKHOUSE_GET_DATABASE_SCHEMA` — Get comprehensive schema overview of an entire database including all tables and optionally their column definitions.
- `CLICKHOUSE_GET_PLAY_INTERFACE` — Get the ClickHouse Play web user interface for interactive query execution.
- `CLICKHOUSE_GET_TABLE_SCHEMA` — Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data.
- `CLICKHOUSE_LIST_DATABASES` — List all databases in the ClickHouse instance.
- `CLICKHOUSE_LIST_TABLES` — List tables in ClickHouse databases.

## Frequently asked questions

### How does LuumenAI connect to ClickHouse?

Authorize once with Basic auth. Luumen lists the scopes each action needs before you approve the connection, and credentials never appear in the chat.

### Can LuumenAI change things in ClickHouse on its own?

No. Every one of the 6 tools is read-only, so LuumenAI can answer questions from ClickHouse but cannot change anything in it. Read actions still follow the configured access and approval policy.

### Is there an audit trail?

Every call to ClickHouse is recorded with the actor, the input, and the result.

Full page: https://www.luumen.ai/integrations/clickhouse/