ClickHouse · Agentic Access

ClickHouse Agentic Access

x-agentic-access generated

ClickHouse exposes 153 API operations that an AI agent could call, of which 81 are state-changing ‘acting’ operations. This is a recommended x-agentic-access execution contract — the scope, audience, consequence tier, short-lived token constraints, and escalation each action should carry before it is handed to an autonomous agent.

By consequence: 72 read, 80 write, and 1 safety-critical.

1 operation are classed safety-critical and should require human-in-the-loop approval at runtime.

Contracts are classified heuristically from the provider’s OpenAPI and refresh on every APIs.io network build; audience is bound per deployment. The model follows Curity’s Access Intelligence (apidays Munich 2026). Browse every provider’s agent contracts at agentic-access.apis.io.

ClickHouseAnalyticsCloud DatabaseColumn-OrientedDatabaseOLAPOpen SourceReal-TimeSQL
Operations: 153 Acting: 81 Human-in-the-loop: 1 Method: generated

By consequence

read 72 write 80 safety-critical 1

Highest-consequence actions

The physical and safety-critical operations an agent could invoke — the ones that most warrant scoped tokens, tight TTLs, and escalation. Full per-operation contracts are in the source below.

MethodPathConsequenceHuman-in-loop
DELETE /v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings/{settingName} safety-critical required

Source

Agentic Access

Raw ↑ 
generated: '2026-09-16'
method: generated
source: openapi/clickhouse-api-keys-api-openapi.yml, openapi/clickhouse-backup-api-openapi.yml,
  openapi/clickhouse-billing-api-openapi.yml, openapi/clickhouse-clickhouse-http-interface-api-openapi.yml,
  openapi/clickhouse-clickpipes-api-openapi.yml, openapi/clickhouse-clickstack-api-openapi.yml,
  openapi/clickhouse-organization-api-openapi.yml, openapi/clickhouse-ping-api-openapi.yml,
  openapi/clickhouse-play-api-openapi.yml, openapi/clickhouse-postgres-api-openapi.yml, openapi/clickhouse-prometheus-api-openapi.yml,
  openapi/clickhouse-replicas-status-api-openapi.yml, openapi/clickhouse-role-management-api-openapi.yml,
  openapi/clickhouse-service-api-openapi.yml, openapi/clickhouse-udf-api-openapi.yml, openapi/clickhouse-user-management-api-openapi.yml
description: Recommended x-agentic-access execution contracts, classified heuristically from
  the OpenAPI. A governance starting point for exposing this API to AI agents — review and bind
  audience per deployment. See research/curity/agentic-governance/.
summary:
  operations: 153
  by_action_class:
    connected: 72
    acting: 81
  by_consequence:
    read: 72
    write: 80
    safety-critical: 1
  human_in_the_loop_required: 1
operations:
- path: /v1/organizations/{organizationId}/keys
  method: get
  operationId: openapiKeyGetList
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/keys
  method: post
  operationId: openapiKeyCreate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/keys/{keyId}
  method: get
  operationId: openapiKeyGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/keys/{keyId}
  method: patch
  operationId: openapiKeyUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/keys/{keyId}
  method: delete
  operationId: openapiKeyDelete
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/backups
  method: get
  operationId: backupGetList
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/backups/{backupId}
  method: get
  operationId: backupGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/backupConfiguration
  method: get
  operationId: backupConfigurationGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/backupConfiguration
  method: patch
  operationId: backupConfigurationUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/backupBucket
  method: get
  operationId: backupBucketGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/backupBucket
  method: post
  operationId: backupBucketCreate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/backupBucket
  method: patch
  operationId: backupBucketUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/backupBucket
  method: delete
  operationId: backupBucketDelete
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/usageCost
  method: get
  operationId: usageCostGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/activeBalances
  method: get
  operationId: activeBalancesGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/creditBalances
  method: get
  operationId: creditBalancesGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /
  method: get
  operationId: getRoot
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /
  method: post
  operationId: postRoot
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes
  method: get
  operationId: clickPipeGetList
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes
  method: post
  operationId: clickPipeCreate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes/context
  method: get
  operationId: clickPipesServiceContextGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}
  method: get
  operationId: clickPipeGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}
  method: patch
  operationId: clickPipeUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}
  method: delete
  operationId: clickPipeDelete
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}/settings
  method: get
  operationId: clickPipeSettingsGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}/settings
  method: put
  operationId: clickPipeSettingsUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes/schemaDiscovery
  method: post
  operationId: clickPipeSchemaDiscovery
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}/scaling
  method: patch
  operationId: clickPipeScalingUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipes/{clickPipeId}/state
  method: patch
  operationId: clickPipeStateUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipesCdcScaling
  method: get
  operationId: clickPipeCdcScalingGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipesCdcScaling
  method: patch
  operationId: clickPipeCdcScalingUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipesReversePrivateEndpoints
  method: get
  operationId: clickPipeReversePrivateEndpointGetList
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipesReversePrivateEndpoints
  method: post
  operationId: clickPipeReversePrivateEndpointCreate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipesReversePrivateEndpoints/{reversePrivateEndpointId}
  method: get
  operationId: clickPipeReversePrivateEndpointGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipesReversePrivateEndpoints/{reversePrivateEndpointId}
  method: delete
  operationId: clickPipeReversePrivateEndpointDelete
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickpipesReversePrivateEndpoints/{reversePrivateEndpointId}
  method: patch
  operationId: clickPipeReversePrivateEndpointUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards
  method: get
  operationId: clickStackListDashboards
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards
  method: post
  operationId: clickStackCreateDashboard
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards/{clickStackDashboardId}
  method: get
  operationId: clickStackGetDashboard
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards/{clickStackDashboardId}
  method: put
  operationId: clickStackUpdateDashboard
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards/{clickStackDashboardId}
  method: delete
  operationId: clickStackDeleteDashboard
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/dashboards/validate
  method: post
  operationId: clickStackValidateDashboard
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/alerts
  method: get
  operationId: clickStackListAlerts
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/alerts
  method: post
  operationId: clickStackCreateAlert
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/sources
  method: get
  operationId: clickStackListSources
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/sources
  method: post
  operationId: clickStackCreateSource
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/sources/{clickStackSourceId}
  method: get
  operationId: clickStackGetSource
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/sources/{clickStackSourceId}
  method: put
  operationId: clickStackUpdateSource
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/sources/{clickStackSourceId}
  method: delete
  operationId: clickStackDeleteSource
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/alerts/{clickStackAlertId}
  method: get
  operationId: clickStackGetAlert
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/alerts/{clickStackAlertId}
  method: put
  operationId: clickStackUpdateAlert
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/alerts/{clickStackAlertId}
  method: delete
  operationId: clickStackDeleteAlert
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/webhooks
  method: get
  operationId: clickStackListWebhooks
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/webhooks
  method: post
  operationId: clickStackCreateWebhook
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/webhooks/{clickStackWebhookId}
  method: put
  operationId: clickStackUpdateWebhook
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/webhooks/{clickStackWebhookId}
  method: delete
  operationId: clickStackDeleteWebhook
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/roles
  method: get
  operationId: clickStackListRoles
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/roles
  method: post
  operationId: clickStackCreateRole
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/roles/{clickStackRoleId}
  method: get
  operationId: clickStackGetRole
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/roles/{clickStackRoleId}
  method: put
  operationId: clickStackUpdateRole
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/roles/{clickStackRoleId}
  method: delete
  operationId: clickStackDeleteRole
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/saved-searches
  method: get
  operationId: clickStackListSavedSearches
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/saved-searches
  method: post
  operationId: clickStackCreateSavedSearch
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/saved-searches/{clickStackSavedSearchId}
  method: get
  operationId: clickStackGetSavedSearch
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/saved-searches/{clickStackSavedSearchId}
  method: put
  operationId: clickStackUpdateSavedSearch
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/services/{serviceId}/clickstack/saved-searches/{clickStackSavedSearchId}
  method: delete
  operationId: clickStackDeleteSavedSearch
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations
  method: get
  operationId: organizationGetList
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}
  method: get
  operationId: organizationGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}
  method: patch
  operationId: organizationUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/quotas
  method: get
  operationId: organizationQuotasGetList
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/quotas/{quotaCode}
  method: get
  operationId: organizationQuotaGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/activities
  method: get
  operationId: activityGetList
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/activities/{activityId}
  method: get
  operationId: activityGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/privateEndpointConfig
  method: get
  operationId: organizationPrivateEndpointConfigGetList
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/byocInfrastructure
  method: post
  operationId: organizationByocInfrastructureCreate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/byocInfrastructure/{byocInfrastructureId}
  method: delete
  operationId: organizationByocInfrastructureDelete
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/byocInfrastructure/{byocInfrastructureId}
  method: patch
  operationId: organizationByocInfrastructureUpdate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /ping
  method: get
  operationId: getPing
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /play
  method: get
  operationId: getPlay
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/postgres
  method: post
  operationId: postgresServiceCreate
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/postgres
  method: get
  operationId: postgresServiceGetList
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/postgres/{postgresId}
  method: get
  operationId: postgresServiceGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/postgres/{postgresId}
  method: delete
  operationId: postgresServiceDelete
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/postgres/{postgresId}
  method: patch
  operationId: postgresServicePatch
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/postgres/{postgresId}/caCertificates
  method: get
  operationId: postgresServiceCertsGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/postgres/{postgresId}/restoredService
  method: post
  operationId: postgresInstanceRestore
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/postgres/{postgresId}/password
  method: patch
  operationId: postgresServiceSetPassword
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/postgres/{postgresId}/state
  method: patch
  operationId: postgresServicePatchState
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/postgres/{postgresId}/readReplica
  method: post
  operationId: postgresInstanceCreateReadReplica
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/postgres/{postgresId}/config
  method: get
  operationId: postgresInstanceConfigGet
  x-agentic-access:
    action-class: connected
    consequence: read
    subject: optional
    token:
      max-ttl: 3600
    audit: none
- path: /v1/organizations/{organizationId}/postgres/{postgresId}/config
  method: post
  operationId: postgresInstanceConfigPost
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required
- path: /v1/organizations/{organizationId}/postgres/{postgresId}/config
  method: patch
  operationId: postgresInstanceConfigPatch
  x-agentic-access:
    action-class: acting
    consequence: write
    subject: required
    audience: null
    token:
      max-ttl: 900
    escalation:
      human-in-the-loop: conditional
      triggers:
      - abnormal
      - high-value
    audit: required


# --- truncated at 32 KB (50 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/clickhouse/refs/heads/main/agentic-access/clickhouse-agentic-access.yml

Work with this as data

Every access contract here is available over the APIs.io API and to AI agents over MCP. Agentic Access is not yet its own endpoint on the v1 API. Reach it through catalog search and the tag graph, or the MCP server.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for agentic access

3 MCP tools reach this
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
Search the catalog 
curl "https://apis.io/api/v1/search?q=clickhouse-agentic-access&limit=10"
Everything under a tag 
curl "https://apis.io/api/v1/tags/clickhouse-agentic-access"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.