ClickHouse
Run ClickHouse queries and manage ClickHouse Cloud resources.
Tools
| Name | Description |
|---|---|
pingCheck the ClickHouse HTTPS endpoint health. | Check the ClickHouse HTTPS endpoint health. |
execute_queryRun a ClickHouse SQL query over the HTTPS interface. | Run a ClickHouse SQL query over the HTTPS interface. |
list_databasesList ClickHouse databases visible to the authenticated user. | List ClickHouse databases visible to the authenticated user. |
list_tablesList tables in a ClickHouse database. | List tables in a ClickHouse database. |
describe_tableList columns and types for a ClickHouse table. | List columns and types for a ClickHouse table. |
show_create_tableReturn the CREATE TABLE statement for a ClickHouse table. | Return the CREATE TABLE statement for a ClickHouse table. |
kill_queryCancel a running ClickHouse query by query_id. | Cancel a running ClickHouse query by query_id. |
cloud_api_callCall the ClickHouse Cloud Management API with the optional Cloud API key fields from the connection. | Call the ClickHouse Cloud Management API with the optional Cloud API key fields from the connection. |
Quick Start
import { WeavzClient } from '@weavz-io/sdk'
const weavz = new WeavzClient({ apiKey: 'wvz_...' })
const result = await weavz.actions.execute('clickhouse', 'ping', {
workspaceId: '550e8400-e29b-41d4-a716-446655440000',
integrationAlias: 'clickhouse',
input: { /* ... */ },
})Related Integrations
Works well with
Frequently Asked Questions
How do I connect ClickHouse to my app?
Use Weavz Hosted Connect for Custom authentication. Install the SDK, create a connection through the connect portal or API, then execute tools programmatically.
What tools does ClickHouse support?
ClickHouse supports 8 tools including Ping, Execute Query, List Databases, List Tables, Describe Table, and more.
Can I use ClickHouse with AI agents?
Yes. Add ClickHouse to an MCP server in Tool Mode or Code Mode. Code Mode provides 3 meta-tools with on-demand API discovery so agents can compose stateful workflows without loading every action schema up front.
Can ClickHouse be used in stateful agent workflows?
Yes. Agents can combine ClickHouse tools with Filesystem, State KV, Human Gates, input partials, and other workspace integrations while keeping execution scoped to the selected workspace or end user.
What authentication does ClickHouse use?
ClickHouse uses Custom. Weavz stores credentials securely and uses them for authorized action execution.
How much does the ClickHouse integration cost?
The ClickHouse integration is included on all Weavz plans including the free tier with 20,000 actions per month. No credit card required.
Connect ClickHouse in minutes
Get 20,000 free action executions every month. No credit card required.