Data, Databases & Storage
ClickHouse AI agent integration
ClickHouse integration for queries, databases, tables, system info, processes, and table stats
Category
Data, Databases & Storage
Authentication
Username & password
Protocol
MCP-compatible
What you can do with the ClickHouse integration
Give your AI agents authenticated access to ClickHouse so they can read, act, and update records on your behalf — inside a governed, observable workflow.
- Let agents read data from ClickHouse as part of a workflow.
- Let agents take typed actions inside ClickHouse with allow/deny policies.
- Combine ClickHouse with other tools to automate cross-system workflows.
- Audit every tool call in Monitor — agent, action, input, response, latency, cost.
How to connect ClickHouse
Provide a service-account username and password. Stored encrypted, used only at request time.
- 1
Open Integrations in your workspace
Navigate to Integrations from the left sidebar. The catalog opens to all available tools. - 2
Find ClickHouse
Search the catalog or filter to the Data, Databases & Storage category. Click the ClickHouse card. - 3
Connect your account
Click Connect. Provide a service-account username and password. Stored encrypted, used only at request time. - 4
Test the connection
Run the built-in connection test. Dezifi calls a low-impact endpoint and confirms the credential works. - 5
Grant access to an agent
Open an agent in the builder, go to Tool Selection, check ClickHouse, save. The agent can now invoke ClickHouse actions during runs.
Governance and safety
ClickHouse is a tool like any other in Dezifi — its actions are governed by your policies, inspected by guardrails, and recorded in every run trace.
- Tool allow / deny — restrict which agents can invoke which actions.
- Approval gates — require human sign-off before destructive operations.
- Rate limits — cap how often an agent can call the integration.
- Audit trail — every call, input, response, and identity is logged.
Frequently asked questions
- How do I connect ClickHouse to Dezifi?
- Open Integrations in your workspace, search for ClickHouse, click Connect, and follow the username & password flow. Once connected, the integration becomes available as a tool for any agent.
- Which AI agents can use the ClickHouse integration?
- Any agent in your Dezifi workspace can be granted access to ClickHouse. You scope which agents see it via tool allow-lists on policies.
- Is the ClickHouse integration secure?
- Yes. Credentials are encrypted at rest, scoped to your workspace, and never shared across tenants. Every tool call is logged in the run trace.
- Can I limit what the agent can do in ClickHouse?
- Yes. Policies let you allow or deny specific actions and require human approval for high-risk operations. The principle of least privilege is enforced at runtime.
Other Data, Databases & Storage integrations
Integration
Airtable
Airtable integration for bases, tables, records, fields, views, and webhooks
Integration
Amazon DynamoDB
Amazon DynamoDB integration for tables, items, queries, scans, and batch operations
Integration
Amazon Redshift
Amazon Redshift integration for SQL execution, clusters, databases, schemas, tables, and statement management
Integration
Amazon S3
Amazon S3 integration for buckets, objects, multipart uploads, presigned URLs, and tagging
Integration
Apache Cassandra
Apache Cassandra integration for queries, keyspaces, tables, cluster info, and data operations
Integration
Azure Blob Storage
Azure Blob Storage integration for containers, blobs, metadata, and account operations