Can NoClick create and delete Clickhouse services automatically?

Yes. The node creates services, deletes them, and reads a service back to check its status, all through the ClickHouse Cloud API. You can wire these to a form, a schedule, or an inbound message, so a request can provision a real database instance and tear it down when it is done.

How do I connect Clickhouse to NoClick?

The node authenticates with a ClickHouse Cloud API key, which you generate in your organization settings. Paste the key ID and secret into the node's credential and it can manage services, ClickPipes, keys, invitations, and query endpoints on your behalf.

Can a workflow react when a scheduled query produces results?

Yes. The On Scheduled Query Results trigger starts a workflow whenever a scheduled query returns rows, so you can route the output to a notification, an AI summary, or another system without polling. The rest of the workflow runs the moment the results arrive.

Can it manage ClickPipes and data ingestion?

It can. The node creates ClickPipes, reads an existing pipe, and deletes pipes you no longer need. That lets a workflow stand up ingestion for a new source and retire it later without manual steps in the console.

Can I track ClickHouse spend and health from a workflow?

Yes. The node reads usage cost, backup and backup configuration details, and Prometheus metrics, so you can build a scheduled report or an alert on top of them. Pair Get Usage Cost with a daily schedule to catch cost jumps early.

How does OpenClaw act on my apps?

You connect an integration to the agent's tools handle and select operations. OpenClaw calls those operations as tools while it runs.

Is there anything to install?

No. NoClick runs the OpenClaw harness for you in a hosted sandbox.

Can I run it on a schedule?

Yes. A hosted agent can be started from a schedule, a webhook, or another app event.

Which apps can it use?

Any of NoClick’s tool-provider integrations across communication, CRM, developer tools, databases, and more.

Connect OpenClaw to ClickHouse

Give an AI agent your Clickhouse account as a tool and it can act on your cloud infrastructure while it works, not just report on it. It can spin up or delete services, create and remove ClickPipes, rotate API keys, send invitations, and pull backups, usage cost, and Prometheus metrics on its own, calling each as a tool. Wired into a coding agent in NoClick, it can provision a service, set up ingestion, and hand back the connection details in one pass.

Loading preview…

Opens a workflow with 40 tools ready to use.

What happens next

Set up in minutes

The open button drops you into a guided setup. It asks exactly this, nothing else:

Choose where it runs
On your computer through your own OpenClaw, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in ClickHouse
A preset of real ClickHouse operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Connect ClickHouse
One sign-in. The agent acts through your account, scoped to the operations you picked.
Add your personal MCP link
The last step mints a private MCP URL for this agent and walks you through exactly this, with your real link filled in. The page flips to Connected the moment your OpenClaw first calls in.
Run this in your terminal
$openclaw mcp add noclick --url https://mcp.noclick.app/s/<your-link>
<your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools OpenClaw gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

ClickHouse

40 tools

List Organizations

List organizations the API key can access.

Get Organization

Get details of a single organization.

Update Organization

Update organization settings (e.g. name).

List Activities

List the audit log of organization activities.

Get Usage Cost

Retrieve usage/cost data for a date range.

List Services

List all ClickHouse services in an organization.

Create Service

Provision a new ClickHouse service.

Get Service

Get details of a single service.

Update Service

Update service basics (name, etc.).

Delete Service

Delete a service.

Start / Stop Service

Start or stop a service.

Update Service Scaling

Update service autoscaling min/max replica memory.

Update Service Replica Scaling

Update service autoscaling — new endpoint replacing the deprecated /scaling path.

Update Service Password

Reset the service's default database user password.

Get Private Endpoint Config

Get the private endpoint configuration info needed to connect via VPC.

Get Query Endpoint

Get the SQL query endpoint config for a service.

Create / Update Query Endpoint

Create or update a query endpoint to run SQL against the service over HTTPS.

Delete Query Endpoint

Delete the service's query endpoint.

List Backups

List backups for a service.

Get Backup Configuration

Read the backup schedule/retention configuration for a service.

Get Backup

Get details of a single backup.

Update Backup Configuration

Update a service's backup schedule and retention settings.

List ClickPipes

List ingestion pipelines (ClickPipes) for an organization.

Create ClickPipe

Create a ClickPipe data-ingestion pipeline.

Update ClickPipe State

Start, stop, or pause a ClickPipe.

Get ClickPipe

Get details of a single ClickPipe.

Delete ClickPipe

Delete a ClickPipe.

List Roles

List custom roles defined in the organization (for orgs that have migrated to Custom Roles).

List API Keys

List organization API keys.

Create API Key

Create a new organization API key (returns Key ID + Secret).

Delete API Key

Delete/revoke an organization API key.

List Members

List organization members.

Remove Member

Remove a member from the organization.

Get Member

Get a single organization member.

Update Member Role

Update a member's role in the organization.

List Invitations

List pending organization invitations.

Create Invitation

Invite a user to the organization.

Delete Invitation

Revoke a pending invitation.

Get Invitation

Get a single pending invitation.

Get Prometheus Metrics

Scrape service metrics in Prometheus exposition format.

Starting points

What you can build

When a scheduled query returns new results, forward the rows to Slack or an AI step so the right people see the number without opening the console.

Provision a fresh Clickhouse service from a form submission, then create an API key and return the connection details to the requester automatically.

Set up a ClickPipe to start ingesting from a new data source, and delete stale pipes on a schedule to keep the account tidy.

Pull usage cost every morning and post a spend summary, flagging any service that jumped since the day before.

Rotate API keys on a fixed cadence by creating a new key and deleting the old one, so credentials never go stale.

When a new teammate joins, send a Clickhouse organization invitation and read it back to confirm it landed.

Meet the runner

About OpenClaw

OpenClaw is an open command-line agent. NoClick runs it hosted and lets you connect your apps to it as tools, so it can take real actions across your systems. Wire an integration into the agent and OpenClaw can call that app’s operations directly. It is a good fit when you want an open, no-fuss agent with real tool access and nothing to install.

Open and approachable

Simple to point at a task

Solid general tool use

Hosted, with nothing to install

Good to know