ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support
ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support On Nagent, ClickHouse is exposed as a fully-configurable databases integration that any agent can call — 6 actions, and BASIC authentication. No code is required to wire ClickHouse into your workflow — connect it once via the External Integrations panel and reuse it across every agent you build.
Agent builders use ClickHouse to automate the kinds of tasks databases teams previously handled manually. Concrete examples — each one is a single agent step in Nagent — include:
Every action and trigger is paired with a structured input/output schema (visible in the sections below), so when you wire ClickHouse into Helix — our agentic agent builder — the editor knows exactly what each step expects and produces. Configure once, deploy anywhere across your Nagent agents.
Every operation an agent can call against ClickHouse, with input parameters and output schema. Drop these into any step of an agent built in Helix.
CLICKHOUSE_EXECUTE_QUERYExecute a SQL query in ClickHouse and return the results. This is the primary action for querying data from ClickHouse databases.
Input parameters
The SQL query to execute in ClickHouse
Output format for the query results. Common formats: JSONEachRow, JSON, CSV, TSV
Database to use for the query (overrides connection default)
Additional ClickHouse settings for the query execution
Maximum query execution time in seconds
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
CLICKHOUSE_GET_DATABASE_SCHEMAGet comprehensive schema overview of an entire database including all tables and optionally their column definitions. Essential for AI agents to understand the complete database structure in a single call.
Input parameters
Database name (overrides connection default). If not specified, uses connection default or 'default'
Whether to include full column schemas for all tables. Set to false for quick overview, true for complete schema details.
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
CLICKHOUSE_GET_PLAY_INTERFACEGet the ClickHouse Play web user interface for interactive query execution. Returns HTML page with Monaco Editor for writing queries and visualizing results.
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
CLICKHOUSE_GET_TABLE_SCHEMAGet detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. This is essential for AI agents to understand table structure before constructing queries.
Input parameters
Database name (overrides connection default)
Name of the table to describe
Number of sample rows to return (only if include_sample_data is true)
Whether to include sample rows from the table
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
CLICKHOUSE_LIST_DATABASESList all databases in the ClickHouse instance. Useful for discovering available databases before querying tables.
Input parameters
Optional LIKE pattern to filter databases (e.g., 'prod_%' or '%test')
Whether to include list of table names for each database
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
CLICKHOUSE_LIST_TABLESList tables in ClickHouse databases. Returns information about tables including their engine, size, and row count.
Input parameters
Optional LIKE pattern to filter table names (e.g., 'user_%' or '%_log')
Database name to list tables from. If not provided, lists tables from all databases
Whether to include views in the results
Whether to include column names for each table
Whether to include primary key information for each table
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
No publicly available marketplace agent is found using this tool yet. There are 64 agents privately built on Nagent that already use ClickHouse.
Build on Nagent
Connect ClickHouse to any Nagent agent in minutes — no API key management, no boilerplate. Just configure and deploy.
The five questions agent builders ask before adopting a new integration.
Open the External Integrations panel inside Nagent (app.nagent.ai/externalIntegration), find ClickHouse, and click "Connect Now." You'll authenticate with BASIC — Nagent handles credential storage and refresh automatically. Once connected, ClickHouse is available to any agent in your workspace.
No. Nagent provides no-code integration for every tool. Once ClickHouse is connected, you configure its 6 actions directly in the agent builder UI — no API calls, no boilerplate, no schema management.
Helix — Nagent's agentic agent builder — lets you drop ClickHouse steps into any workflow visually. Pick an action (e.g., one of those listed above), fill in the inputs (Helix knows the required vs. optional schema for each parameter), and connect it to upstream/downstream steps. Triggers run as the entry point of an agent, so when a ClickHouse event fires, the agent kicks off automatically.
Every ClickHouse action and trigger ships with a fully-typed schema — input parameters with name, type, required flag, and description, plus the output payload shape. The schemas are documented in the sections above. Helix uses these schemas to validate your configuration at build time and to type-check the data flowing between steps.
Yes. While ClickHouse ships with 6 pre-built databases actions, you can layer custom logic around them inside Helix — pre/post-processing steps, conditional branches, retries, or stitching ClickHouse together with other connected tools. For deeper customization, talk to our team about Nagent's Agentic AI Lab — forward-deployed engineers who build ClickHouse-based workflows tailored to your business.