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. 1

    Open Integrations in your workspace

    Navigate to Integrations from the left sidebar. The catalog opens to all available tools.
  2. 2

    Find ClickHouse

    Search the catalog or filter to the Data, Databases & Storage category. Click the ClickHouse card.
  3. 3

    Connect your account

    Click Connect. Provide a service-account username and password. Stored encrypted, used only at request time.
  4. 4

    Test the connection

    Run the built-in connection test. Dezifi calls a low-impact endpoint and confirms the credential works.
  5. 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