Connecting ClickHouse
Integrate your ClickHouse database with Greppilot to enable AI-driven insights, natural language querying, and automated data analysis.
Connection
To connect ClickHouse, provide a valid connection string. Greppilot will use this string to introspect your database schema and execute read-only queries.
- Navigate to Integrations in your Greppilot dashboard.
- Select ClickHouse from the list of available database integrations.
- Provide the
connectionStringin the configuration.
| Parameter | Type | Required | Description |
|---|---|---|---|
connectionString | string | Yes | The URL-formatted connection string for your ClickHouse database. Example: clickhouse://user:password@host:port/database_name |
Greppilot expects a standard URL format beginning with clickhouse://. Connections to internal cloud metadata addresses (e.g., 169.254.x.x) are blocked for security.
Available Tools
Once connected, Greppilot can interact with your ClickHouse database using the following tools.
query
Executes read-only SQL SELECT queries against your ClickHouse database. The AI agent generates appropriate SQL based on your prompts.
Find the total number of events from yesterday
schema
Retrieves the currently cached schema for your ClickHouse database, used by the agent to understand your data structure.
refresh_schema
Forces Greppilot to re-introspect your ClickHouse database and update its cached schema. Use this when your schema has changed.
For security and data integrity, Greppilot only executes SELECT queries. Write operations (INSERT, UPDATE, DELETE) are not supported.