ClickHouse integration

What the ClickHouse package does

ClickHouse is the fastest and most resource efficient open-source database for real-time apps and analytics.

ClickHouse database integration for executing SQL queries and commands. Provides connection management (Connect/Disconnect), SQL SELECT queries (Execute Query) that return row arrays, non-query SQL execution (Execute Non Query) for INSERT/UPDATE/DELETE, and batch transactions (Create Batch/Send Batch) for executing multiple commands atomically. SQL templates support {{variable}} placeholders resolved from message context. Query and NonQuery nodes can connect via either a shared connection ID from the Connect node or directly via credentials. Authenticates with server, port, database, username, and password.

Namespace

Robomotion.ClickHouse

Latest version

0.3.0 (9 versions published)

Written in

Go

Categories

Database

ClickHouse nodes (7)

These are the node IDs an agentic flow or an RPA bot uses, exactly as they appear in the Flow Designer and in flow code. An agent tool node can also be called by an AI agent on its own. The Toolkit node hands an agent several of the package operations at once.

Platforms

The ClickHouse package runs on Windows, macOS and Linux robots. Any Robomotion robot on these operating systems can run a flow that uses it.

How to install the ClickHouse package

1. Open Packages in the Robomotion Flow Designer.
2. Search for ClickHouse or Robomotion.ClickHouse, then click Install on its card.
3. The ClickHouse nodes appear in the node palette for everyone in the workspace, because installation is per workspace.

From a terminal, the Robomotion CLI installs the same package:

robomotion install Robomotion.ClickHouse

Related integrations

Packages that share a category or keywords with ClickHouse. It is filed under Database.

• BadgerDBBadgerDB is an embeddable, persistent and fast key-value (KV) database.
• BaserowConnect to Baserow and manage rows, tables, and fields. Baserow is an open-source no-code database platform.
• Bika AIConnect to Bika AI and manage spaces, database records, and attachments
• LanceDBStore and search embeddings in LanceDB - the embedded vector database. Works against a local directory, S3/GCS/Azure object storage or LanceDB Cloud. Vector, full-text and hybrid search, SQL filters, upserts, indexing, plus a Toolkit that hands the whole database to an AI agent.
• Microsoft SQL ServerMSSQL (a relational database management system developed by Microsoft) package for performing database operations such as execute query or non queries.
• MongoDBMongoDB (a source-available cross-platform document-oriented database program. Classified as a NoSQL database program) package for performing document or database operations.

ClickHouse documentation

The ClickHouse package reference on docs.robomotion.io documents each node and its properties.