click-house

ClickHouse through One

ClickHouse is an ultra-fast, column-oriented database designed for real-time analytics at scale, enabling teams to query massive datasets with high performance and low latency.

One exposes ClickHouse through four MCP tools. The table below carries real action ids from One's knowledge base, so for a common operation you can skip search and go straight to reading the action's parameters.

How to run an action

1. Find the action in the table below, or call search_one_platform_actions with platform click-house if it is not listed.
2. Call get_one_action_knowledge with the action id. Do this every time, including for actions in this table. The table gives you the id, not the parameters.
3. Call execute_one_action with parameters copied from that knowledge.

Never guess a parameter name, a body field, or an enum value. The knowledge has the real schema, and a guessed field is either a 400 or a silent write of the wrong thing.

Before you start

Call list_one_integrations once and confirm ClickHouse is connected. If it is missing, the user has not connected it: say so and point them at https://app.withone.ai rather than reaching for raw HTTP.

Each connection carries an access field. If it reports {"policy": "methods", "methods": ["GET"]} the agent is read-only here, so plan a read-only answer instead of attempting a write that will be refused.

Before a write

Creates, updates, deletes and sends land on a real ClickHouse account and cannot be recalled. State the action and the specific target in one line before the first write in a task, and let the user stop you. Reads need no confirmation.

Actions

Services

Action	Method	Path	Action id
Get a Service’s Backup Configuration	GET	/v1/organizations/{{organizationId}}/services/{{serviceId}}/backupConfiguration	conn_mod_def::GJ1MkfkgRY8::y26OXOt9TgOSsGMt8SJKuw
Get a Service’s Prometheus Metrics	GET	/v1/organizations/{{organizationId}}/services/{{serviceId}}/prometheus	conn_mod_def::GJ1MrBoYkSQ::Qsz4nxxMTiaBpw0bN3O1hA
Get an Organization’s Service Details	GET	/v1/organizations/{{organizationId}}/services/{{serviceId}}	conn_mod_def::GJ1Mr3mNZ1k::8IxPus77QVi4zslp6Fw03A
List an Organization’s Services	GET	/v1/organizations/{{organizationId}}/services	conn_mod_def::GJ1MsHVYd2M::Vp6iIOVmQxqd30PjAtHVoA
Create a Service in an Organization	POST	/v1/organizations/{{organizationId}}/services	conn_mod_def::GJ1MrUMc-IA::CZOmZxe4SSi3YllqvYgT5Q
Delete an Organization’s Service	DELETE	/organizations/{{organizationId}}/services/{{serviceId}}	conn_mod_def::GJ1MrbQbA60::nVn1u23STZeZGwcm2IHKGA
Update a Service’s Auto-Scaling Settings (Organization)	PATCH	/v1/organizations/{{organizationId}}/services/{{serviceId}}/scaling	conn_mod_def::GJ1MsQhtEME::zH8HDgf1TkCfWunuMJU7TA
Update a Service’s Backup Configuration	PATCH	/v1/organizations/{{organizationId}}/services/{{serviceId}}/backupConfiguration	conn_mod_def::GJ1Mk5841o0::NUJlfgzjRjmHqo9HtxGrZw
Update a Service’s State (Start/Stop) in an Organization	PATCH	/v1/organizations/{{organizationId}}/services/{{serviceId}}/state	conn_mod_def::GJ1Msz_glgo::qANOJ5uGQgS0X6p_pJrLBw
Update an Organization Service’s Basic Details	PATCH	/v1/organizations/{{organizationId}}/services/{{serviceId}}	conn_mod_def::GJ1MsjCCHi4::h5sbpzDFSZORjrl0ggsGeg