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
- Find the action in the table below, or call
search_one_platform_actions with platform click-house if it is not listed.
- 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.
- 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 |
ClickPipes
| Action |
Method |
Path |
Action id |
| Get a Service’s ClickPipe |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipes/{{clickPipeId}} |
conn_mod_def::GJ1Ml7VQ2ZU::RVgA0WfaTWWeB1fIFhzZ5A |
| List a Service’s ClickPipes (Beta) |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipes |
conn_mod_def::GJ1MmSIDE9Q::7yBGs7V6R0e168um-lYEsw |
| Delete a Service’s ClickPipe |
DELETE |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipes/{{clickPipeId}} |
conn_mod_def::GJ1MlhVPAsY::KSuQdemzRPupDrxRJk1sMg |
| Update a ClickPipe's Scaling Settings |
PATCH |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipes/{{clickPipeId}}/scaling |
conn_mod_def::GJ1MmzQfZMA::MKUl41LiSGKa5orhgK9FzA |
| Update a ClickPipe’s State (Start/Stop/Resync) |
PATCH |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipes/{{clickPipeId}}/state |
conn_mod_def::GJ1MnIidzig::sW52pfWmQ8m3uhHknzOcRw |
| Update a Service’s ClickPipe |
PATCH |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipes/{{clickPipeId}} |
conn_mod_def::GJ1MmrOa5j4::2EXz6IPxRDWyarDQQAmwoA |
ClickStackAlerts
| Action |
Method |
Path |
Action id |
| Get a ClickStack Alert |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/alerts/{{clickStackAlertId}} |
conn_mod_def::GJ1Mn2_BahE::OmU4bFlxSPyj2ETUoooqBw |
| List a ClickStack Service's Alerts |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/alerts |
conn_mod_def::GJ1MoLeOXpY::a3iuLqhqR32JJP556Bcs1Q |
| ClickStack: Create an Alert for a Service |
POST |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/alerts |
conn_mod_def::GJ1MnRGtDA8::1DHldyVZQqueVm6v92aOeg |
| Delete a ClickStack Alert for a Service |
DELETE |
/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/alerts/{{clickStackAlertId}} |
conn_mod_def::GJ1MnknbgQc::Qc-46Te6TB2DjJF39rFydg |
| Update a ClickStack Alert for a Service |
PUT |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/alerts/{{clickStackAlertId}} |
conn_mod_def::GJ1MoyEaY50::h6gbVKzsQH2r19KcTBAxHA |
ClickpipesReversePrivateEndpoints
| Action |
Method |
Path |
Action id |
| Get a Service’s Reverse Private Endpoint |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipesReversePrivateEndpoints/{{reversePrivateEndpointId}} |
conn_mod_def::GJ1MmKkMsPY::oefd-2MUToqPoxCF_agxLQ |
| List a Service’s Reverse Private Endpoints |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipesReversePrivateEndpoints |
conn_mod_def::GJ1MmbDCtNc::r5QG87H4Qh67jx1uLB11WA |
| Create a Reverse Private Endpoint for a Service |
POST |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipesReversePrivateEndpoints |
conn_mod_def::GJ1MlYpNmNQ::zAcHaXqGQu-Xaj3wKoE0rA |
| Delete a Service’s Reverse Private Endpoint (Beta) |
DELETE |
/organizations/{{organizationId}}/services/{{serviceId}}/clickpipesReversePrivateEndpoints/{{reversePrivateEndpointId}} |
conn_mod_def::GJ1MlpyyOLw::-8VclKwBTRCnLDdPL-T-AA |
ClickStackDashboards
| Action |
Method |
Path |
Action id |
| Get a ClickStack Dashboard |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/dashboards/{{clickStackDashboardId}} |
conn_mod_def::GJ1MoAZVoZw::iHKChIMFTey1UbjG6PI2gg |
| Create a ClickStack Dashboard for a Service |
POST |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/dashboards |
conn_mod_def::GJ1Mna_twys::XZri1kxVSj-OUmC8OE7S6g |
| Delete a ClickStack Dashboard for a Service in an Organization |
DELETE |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/dashboards/{{clickStackDashboardId}} |
conn_mod_def::GJ1MnstdxdA::U1uKnnVeRbaCrCuTVgR5dg |
| Update a ClickStack Dashboard (Beta) |
PUT |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/dashboards/{{clickStackDashboardId}} |
conn_mod_def::GJ1Mo6j-Nxc::Gfinv32ETqWx4xwW82_vkg |
Organizations
| Action |
Method |
Path |
Action id |
| Get an Organization’s Details |
GET |
/v1/organizations/{{organizationId}} |
conn_mod_def::GJ1Mp9Pr7NQ::8wB6QfmDRA23UstM9gti0w |
| Get an Organization’s Prometheus Metrics |
GET |
/organizations/{{organizationId}}/prometheus |
conn_mod_def::GJ1Mq6CaESI::D92u8G3TSG2Bo5nFNKnUyw |
| List Organizations (Available to the API Key) |
GET |
/v1/organizations |
conn_mod_def::GJ1Mp1mJyvY::QAJPzkjtT8ulasBOKxbjmw |
| Update an Organization’s Details |
PATCH |
/organizations/{{organizationId}} |
conn_mod_def::GJ1MqyqgruY::Q8r8LRyeTZuJgA5LUUQndQ |
OrganizationInvitations
| Action |
Method |
Path |
Action id |
| Get an Organization Invitation’s Details |
GET |
/v1/organizations/{{organizationId}}/invitations/{{invitationId}} |
conn_mod_def::GJ1MtRrtv0o::7O7npdSQTnmSVPAAPSgaDw |
| List an Organization's Invitations |
GET |
/v1/organizations/{{organizationId}}/invitations |
conn_mod_def::GJ1MtgXEUVM::QEoyEMDNTACSZL3ezBmxTQ |
| Create an Organization Invitation |
POST |
/v1/organizations/{{organizationId}}/invitations |
conn_mod_def::GJ1MtDGqLZ8::mZ-u9uXyQqiH98KwcCYrAg |
| Delete an Organization Invitation |
DELETE |
/v1/organizations/{{organizationId}}/invitations/{{invitationId}} |
conn_mod_def::GJ1MtKcmNt8::gZklB1u_QRCW7MHg7oKpCQ |
OrganizationMembers
| Action |
Method |
Path |
Action id |
| Get an Organization Member’s Details |
GET |
/v1/organizations/{{organizationId}}/members/{{userId}} |
conn_mod_def::GJ1MtZKe5aI::byXWtiIOQ0WPsR73TnCSbQ |
| List an Organization’s Members |
GET |
/organizations/{{organizationId}}/members |
conn_mod_def::GJ1MtnZZsMw::R7fb-ZgXQh-FnesvNezu8w |
| Remove an Organization Member |
DELETE |
/v1/organizations/{{organizationId}}/members/{{userId}} |
conn_mod_def::GJ1Mtt-SLNk::bS1ilgUHRdGkeYhnliKmhg |
| Update an Organization Member |
PATCH |
/v1/organizations/{{organizationId}}/members/{{userId}} |
conn_mod_def::GJ1Mt1RbnyY::mQRYY2DlR4meZfo7VnFLLQ |
OrganizationApiKeys
| Action |
Method |
Path |
Action id |
| Get an Organization API Key’s Details |
GET |
/organizations/{{organizationId}}/keys/{{keyId}} |
conn_mod_def::GJ1MpTHM828::p5A2hrnRTriL6Lu9vBsY3Q |
| List an Organization's API Keys |
GET |
/v1/organizations/{{organizationId}}/keys |
conn_mod_def::GJ1Mpah1no0::tQGSB-WZT5ysan--0eqp3A |
| Delete an Organization API Key |
DELETE |
/v1/organizations/{{organizationId}}/keys/{{keyId}} |
conn_mod_def::GJ1MpLsF3L8::QLk9RvYZRQaECiDkCFayug |
ByocInfrastructure
| Action |
Method |
Path |
Action id |
| Create an Organization’s BYOC Infrastructure |
POST |
/organizations/{{organizationId}}/byocInfrastructure |
conn_mod_def::GJ1Mpr1dXZM::Wf4XALyVR_2EA8yF2DefeA |
| Remove an Organization’s BYOC Infrastructure |
DELETE |
/v1/organizations/{{organizationId}}/byocInfrastructure/{{byocInfrastructureId}} |
conn_mod_def::GJ1MqhVApF8::6-TRt5mvRTCD78SHwKh_-g |
| Update an Organization's BYOC Infrastructure |
PATCH |
/organizations/{{organizationId}}/byocInfrastructure/{{byocInfrastructureId}} |
conn_mod_def::GJ1Mqpc4VWc::lm-A_o8mRVG-2vLTEpKt7g |
ServiceQueryEndpoint
| Action |
Method |
Path |
Action id |
| Get a Service’s Query Endpoint Configuration |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/serviceQueryEndpoint |
conn_mod_def::GJ1Mr_izgio::8buSILCLQz6yhuroUfVJMQ |
| Delete a Service’s Query Endpoint (Organization + Service) |
DELETE |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/serviceQueryEndpoint |
conn_mod_def::GJ1Mro1y3Sk::S_K3rISQRwyqqPKkJs-UnA |
| Upsert a Service Query Endpoint for a Service |
POST |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/serviceQueryEndpoint |
conn_mod_def::GJ1Ms8Cjye0::B4TyiTK1TCOFsDyLOJOBgg |
BackupBuckets
| Action |
Method |
Path |
Action id |
| Get a Service’s Backup Bucket |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/backupBucket |
conn_mod_def::GJ1MkX7b5wM::o4orB09WTh-R_7UB9CuX8Q |
| Create a Service Backup Bucket |
POST |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/backupBucket |
conn_mod_def::GJ1MkApWMBM::UPdBsVA3TrSEjMxCu-Tn_g |
BackupBucket
| Action |
Method |
Path |
Action id |
| Delete a Service's Backup Bucket |
DELETE |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/backupBucket |
conn_mod_def::GJ1MkIL6fLM::LcMBQDuwTieViI0PKl5hlg |
| Update a Service’s Backup Bucket |
PATCH |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/backupBucket |
conn_mod_def::GJ1MkwkeqQE::rZKSGvCDTPGkKrewNHCaJw |
ClickpipesCdcScaling
| Action |
Method |
Path |
Action id |
| Get a Service’s CDC ClickPipes Scaling Settings |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipesCdcScaling |
conn_mod_def::GJ1Mlx5Py6E::-RVw2569Roq7JXgzWJJ8rA |
| Update a Service’s CDC ClickPipes Scaling |
PATCH |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipesCdcScaling |
conn_mod_def::GJ1MmitCTUM::KTFLESOWRaiuMU0yp92wwA |
ClickPipeSettings
| Action |
Method |
Path |
Action id |
| Get a ClickPipe’s Advanced Settings |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipes/{{clickPipeId}}/settings |
conn_mod_def::GJ1MmCywUF4::G8x3cSArSeKNEn1Tu--9KQ |
| Update a Service’s ClickPipe Settings |
PUT |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipes/{{clickPipeId}}/settings |
conn_mod_def::GJ1Mm_Jvllo::nbYLWFFkQgGBkmUJb6ZBkg |
OrganizationKeys
| Action |
Method |
Path |
Action id |
| Create an Organization API Key |
POST |
/v1/organizations/{{organizationId}}/keys |
conn_mod_def::GJ1MpD9gxkM::lP9EBxLoRF-TjIb06KKfyQ |
| Update an Organization API Key |
PATCH |
/organizations/{{organizationId}}/keys/{{keyId}} |
conn_mod_def::GJ1Mpho9hyY::XMz4gvIiTxioQdq121_ncQ |
PrivateEndpointConfig
| Action |
Method |
Path |
Action id |
| Get a Service’s Private Endpoint Configuration (Organization) |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/privateEndpointConfig |
conn_mod_def::GJ1MrwaaMJI::W0kMKmoPRPiz62klCCEIQg |
| Get an Organization’s Private Endpoint Configuration (Deprecated) |
GET |
/v1/organizations/{{organizationId}}/privateEndpointConfig |
conn_mod_def::GJ1MqHwjMXU::5S_hxTZQQUSgr05mzWd8SQ |
OrganizationActivities
| Action |
Method |
Path |
Action id |
| Get an Organization Activity |
GET |
/v1/organizations/{{organizationId}}/activities/{{activityId}} |
conn_mod_def::GJ1MqXSaPuQ::myDzs0HmSDSGkPZTAbnlXg |
| List an Organization’s Activities |
GET |
/organizations/{{organizationId}}/activities |
conn_mod_def::GJ1MqPHcSLI::CRhWqCIYTMSDNBNse9r3qw |
ServiceBackups
| Action |
Method |
Path |
Action id |
| Get a Service Backup’s Details (Organization) |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/backups/{{backupId}} |
conn_mod_def::GJ1MkPtQCIM::6PrYE8JPQtiQz2RNoxEGMw |
Backups
| Action |
Method |
Path |
Action id |
| List a Service’s Backups |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/backups |
conn_mod_def::GJ1Mko0V8HM::8pbvRWToRaqNhyoUrdeOLw |
UsageCosts
| Action |
Method |
Path |
Action id |
| Get an Organization's Usage Costs |
GET |
/organizations/{{organizationId}}/usageCost |
conn_mod_def::GJ1MlC7xHiI::hND3tGWeRC2pWwChfWoiKQ |
Clickpipes
| Action |
Method |
Path |
Action id |
| Create a Service’s ClickPipe |
POST |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickpipes |
conn_mod_def::GJ1MlMmUyrk::yZ5GDsK1TyyyybmHnx9yiA |
ClickstackDashboards
| Action |
Method |
Path |
Action id |
| List a ClickStack Service’s Dashboards |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/dashboards |
conn_mod_def::GJ1MoTPpRSI::o6rKazdxSrWtUBgkR4kGAQ |
ClickStackSources
| Action |
Method |
Path |
Action id |
| List a ClickStack Service’s Sources |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/sources |
conn_mod_def::GJ1ModY1Mwk::EA8TDb5IRN-XNBXGo7xKaA |
ClickStackWebhooks
| Action |
Method |
Path |
Action id |
| List a ClickStack Service’s Webhooks |
GET |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/clickstack/webhooks |
conn_mod_def::GJ1MopyVosc::bPjLYQ68ReqA0dVUiVdtNg |
PrivateEndpoints
| Action |
Method |
Path |
Action id |
| Create a Service Private Endpoint (Organization) |
POST |
/organizations/{{organizationId}}/services/{{serviceId}}/privateEndpoint |
conn_mod_def::GJ1MrMK_hGg::9obMjjbvQQ-dPsE-7LBURA |
ReplicaScaling
| Action |
Method |
Path |
Action id |
| Update a Service’s Replica Auto-Scaling Settings |
PATCH |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/replicaScaling |
conn_mod_def::GJ1Msaz3JuI::nE0QvLTKSDaclZrFkhWmNw |
ServicePasswords
| Action |
Method |
Path |
Action id |
| Update a Service Password (Organization) |
PATCH |
/v1/organizations/{{organizationId}}/services/{{serviceId}}/password |
conn_mod_def::GJ1MssKjIUM::eXG3CQ-oRTG6tfVa2AvLAQ |
When a call fails
The error comes from ClickHouse, not from One. A 400 or 422 means your parameters do not match the schema, so re-read the knowledge and fix the field. A 401 or 403 means the connection needs re-authorizing, which no retry will fix. A 404 means the id is not on this account. A 429 means slow down. Never retry a write more than once: the first attempt may have landed.
Full catalog: https://www.withone.ai/knowledge/click-house
Integration knowledge by One (withone.ai), licensed under One-Knowledge-1.0. Attribution must be preserved in derivative works.
withoneai