opencode

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.

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.

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.

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

Frequently asked questions

Build a custom OpenCode agentClickHouse integration

Open your OpenCode agent in one click

NoClick runs OpenCode for you with ClickHouse wired in as tools. Connect your account and run.