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.

What makes OpenCode different here?

OpenCode is open and model-agnostic, so you have flexibility over the underlying model. NoClick handles running it and connecting your apps as tools.

How do I give OpenCode tools?

Connect an integration node to the agent's tools handle and choose the operations to allow. Each becomes a tool the agent can call.

Do I manage any infrastructure?

No. NoClick runs the OpenCode harness in a hosted sandbox and resolves credentials for the apps you connect.

Can it combine several apps?

Yes. Add as many integrations as you need and the agent can use them together in one run.

Connect OpenCode 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 OpenCode, 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 OpenCode first calls in.
1. Run this in your terminal
$opencode mcp add
2. Choose Remote and paste your server URL
https://mcp.noclick.app/s/<your-link>
3. Choose No when asked about OAuth authentication — the link itself is the key
<your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools OpenCode 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 OpenCode

OpenCode is an open, model-agnostic command-line coding agent. In NoClick it runs hosted and gains your apps as tools, so it can act on real systems rather than just edit files. Wire an integration into the agent and OpenCode can use that app’s operations directly while it works. It is a flexible choice when you want an open agent with broad model support and real tool access.

Open and model-agnostic

Flexible across many underlying models

Good general-purpose tool use

Lightweight to point at a focused task

Good to know