ClickHouse · OpenAPI Overlay 1.0.0

API Evangelist conversational phrasing for OpenAPI spec for ClickHouse Cloud Service API

27 actions 27 updates phrasing extends openapi/clickhouse-service-api-openapi.yml
Generated by API Evangelist Written by API Evangelist tooling for ClickHouse's API. It is a proposal applied on top of the contract, not a document ClickHouse publishes.
View Overlay File View on GitHub Overlay Specification

What the actions change

x-apievangelist-phrasing

Targets 27 · first 16 shown; the file carries all of them

$.info
$.paths['/v1/organizations/{organizationId}/serviceProfiles'].get
$.paths['/v1/organizations/{organizationId}/services'].get
$.paths['/v1/organizations/{organizationId}/services'].post
$.paths['/v1/organizations/{organizationId}/services/{serviceId}'].get
$.paths['/v1/organizations/{organizationId}/services/{serviceId}'].delete
$.paths['/v1/organizations/{organizationId}/services/{serviceId}'].patch
$.paths['/v1/organizations/{organizationId}/services/{serviceId}/privateEndpointConfig'].get
$.paths['/v1/organizations/{organizationId}/services/{serviceId}/serviceQueryEndpoint'].get
$.paths['/v1/organizations/{organizationId}/services/{serviceId}/serviceQueryEndpoint'].post
$.paths['/v1/organizations/{organizationId}/services/{serviceId}/serviceQueryEndpoint'].delete
$.paths['/v1/organizations/{organizationId}/services/{serviceId}/state'].patch
$.paths['/v1/organizations/{organizationId}/services/{serviceId}/scaling'].patch
$.paths['/v1/organizations/{organizationId}/services/{serviceId}/replicaScaling'].patch
$.paths['/v1/organizations/{organizationId}/services/{serviceId}/password'].patch
$.paths['/v1/organizations/{organizationId}/services/{serviceId}/privateEndpoint'].post

OpenAPI Overlay

Raw ↑
# Generated by API Evangelist (build-phrasing.py). Our phrasing, not observed demand.
overlay: 1.0.0
info:
  title: API Evangelist conversational phrasing for OpenAPI spec for ClickHouse Cloud Service API
  version: 1.0.0
extends: openapi/clickhouse-service-api-openapi.yml
actions:
- target: $.info
  update:
    x-apievangelist-phrasing:
      method: generated
      generated: '2026-09-26'
      generator: build-phrasing.py
      label: Generated by API Evangelist
      operations: 26
- target: $.paths['/v1/organizations/{organizationId}/serviceProfiles'].get
  update:
    x-apievangelist-phrasing:
      intent: List instance profiles available in a region
      effect: read
      questions:
      - Which custom instance profiles can I use for a new service in a region?
      - What profiles are configured for my BYOC infrastructure?
      instructions:
      - text: List service profiles for org {org} in region {region_id}.
        slots:
          org: path.organizationId
          region_id: query.region_id
      - text: Show the instance profiles on BYOC infrastructure {byoc_id} in region {region_id} for organization {org}.
        slots:
          byoc_id: query.byoc_id
          region_id: query.region_id
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services'].get
  update:
    x-apievangelist-phrasing:
      intent: List ClickHouse services in the organization
      effect: read
      questions:
      - What ClickHouse services are running in my organization?
      - Can I narrow the list of services with a filter?
      instructions:
      - text: List all ClickHouse services in org {org}.
        slots:
          org: path.organizationId
      - text: Show services in organization {org} matching filter {filter}.
        slots:
          org: path.organizationId
          filter: query.filter
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services'].post
  update:
    x-apievangelist-phrasing:
      intent: Create a new ClickHouse service
      effect: write
      questions:
      - How do I spin up a new ClickHouse Cloud service?
      - Can I create a service from an existing backup?
      - Can I make a read-only service that shares a data warehouse with another one?
      instructions:
      - text: Create a ClickHouse service named {name} on {provider} in region {region} in org {org}.
        slots:
          name: requestBody.name
          provider: requestBody.provider
          region: requestBody.region
          org: path.organizationId
      - text: Launch a new service {name} in organization {org} restored from backup {backupId}.
        slots:
          name: requestBody.name
          org: path.organizationId
          backupId: requestBody.backupId
      - text: Create read-only service {name} in org {org} attached to data warehouse {dataWarehouseId}.
        slots:
          name: requestBody.name
          org: path.organizationId
          dataWarehouseId: requestBody.dataWarehouseId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}'].get
  update:
    x-apievangelist-phrasing:
      intent: Get a ClickHouse service's details
      effect: read
      questions:
      - What state is my ClickHouse service in right now?
      - Which endpoints and region does a particular service use?
      instructions:
      - text: Show ClickHouse service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Get the state and endpoints of service {service} in organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}'].delete
  update:
    x-apievangelist-phrasing:
      intent: Delete a stopped ClickHouse service
      effect: destructive
      questions:
      - How do I permanently delete a ClickHouse service?
      - Does a service have to be stopped before I can delete it?
      instructions:
      - text: Delete ClickHouse service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Permanently remove stopped service {service} from organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}'].patch
  update:
    x-apievangelist-phrasing:
      intent: Rename a service or change its IP access list
      effect: write
      questions:
      - How do I rename a ClickHouse service?
      - Can I restrict which IP addresses can connect to my service?
      - How do I move a service to a different release channel?
      instructions:
      - text: Rename service {service} in org {org} to {name}.
        slots:
          service: path.serviceId
          org: path.organizationId
          name: requestBody.name
      - text: Set the IP access list of service {service} in organization {org} to {ipAccessList}.
        slots:
          service: path.serviceId
          org: path.organizationId
          ipAccessList: requestBody.ipAccessList
      - text: Switch service {service} in org {org} to release channel {releaseChannel}.
        slots:
          service: path.serviceId
          org: path.organizationId
          releaseChannel: requestBody.releaseChannel
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/privateEndpointConfig'].get
  update:
    x-apievangelist-phrasing:
      intent: Get the info needed to set up a private endpoint
      effect: read
      questions:
      - What endpoint service name do I need to set up PrivateLink to my ClickHouse service?
      - Where do I find the private DNS host for a service's private endpoint?
      instructions:
      - text: Get the private endpoint configuration for service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Show what I need to connect privately to service {service} in organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/serviceQueryEndpoint'].get
  update:
    x-apievangelist-phrasing:
      intent: Get a service's query-over-API endpoint config
      effect: read
      questions:
      - Is the query API endpoint enabled on my ClickHouse service?
      - Which roles and allowed origins are set on a service's query endpoint?
      instructions:
      - text: Show the service query endpoint for service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Check which API keys can run queries over HTTP against service {service} in organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/serviceQueryEndpoint'].post
  update:
    x-apievangelist-phrasing:
      intent: Enable or configure the query-over-API endpoint
      effect: write
      questions:
      - How do I let an app run SQL queries against my service over an HTTP API?
      - Can I restrict the query endpoint to certain API keys and browser origins?
      instructions:
      - text: Enable the query endpoint on service {service} in org {org} for API keys {openApiKeys}.
        slots:
          service: path.serviceId
          org: path.organizationId
          openApiKeys: requestBody.openApiKeys
      - text: Configure the query endpoint of service {service} in organization {org} with roles {roles} and allowed origins {allowedOrigins}.
        slots:
          service: path.serviceId
          org: path.organizationId
          roles: requestBody.roles
          allowedOrigins: requestBody.allowedOrigins
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/serviceQueryEndpoint'].delete
  update:
    x-apievangelist-phrasing:
      intent: Disable the query-over-API endpoint
      effect: destructive
      questions:
      - How do I turn off running queries over HTTP against my service?
      - Can I remove the query API endpoint from a service?
      instructions:
      - text: Delete the service query endpoint on service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Disable query-over-API access for service {service} in organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/state'].patch
  update:
    x-apievangelist-phrasing:
      intent: Start, stop or wake a ClickHouse service
      effect: write
      questions:
      - How do I stop a ClickHouse service to save money overnight?
      - Can I wake an idle service without manage permissions?
      - Does the awake command start a service that was stopped?
      instructions:
      - text: Stop ClickHouse service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Send state command {command} to service {service} in organization {org}.
        slots:
          command: requestBody.command
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/scaling'].patch
  update:
    x-apievangelist-phrasing:
      intent: Set total memory limits and idle scaling
      effect: write
      questions:
      - How do I set the minimum and maximum total memory for a production service?
      - Can I make my service idle after a number of minutes of inactivity?
      instructions:
      - text: Scale service {service} in org {org} between {minTotalMemoryGb} and {maxTotalMemoryGb} GB total memory.
        slots:
          service: path.serviceId
          org: path.organizationId
          minTotalMemoryGb: requestBody.minTotalMemoryGb
          maxTotalMemoryGb: requestBody.maxTotalMemoryGb
      - text: Let service {service} in organization {org} go idle after {idleTimeoutMinutes} minutes using total-memory scaling settings.
        slots:
          service: path.serviceId
          org: path.organizationId
          idleTimeoutMinutes: requestBody.idleTimeoutMinutes
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/replicaScaling'].patch
  update:
    x-apievangelist-phrasing:
      intent: Set per-replica memory and replica autoscaling
      effect: write
      questions:
      - How do I set per-replica memory limits for vertical autoscaling?
      - Can I autoscale horizontally between a minimum and maximum number of replicas?
      instructions:
      - text: Set per-replica memory on service {service} in org {org} between {minReplicaMemoryGb} and {maxReplicaMemoryGb} GB.
        slots:
          service: path.serviceId
          org: path.organizationId
          minReplicaMemoryGb: requestBody.minReplicaMemoryGb
          maxReplicaMemoryGb: requestBody.maxReplicaMemoryGb
      - text: Autoscale service {service} in organization {org} in mode {autoscalingMode} from {minReplicas} to {maxReplicas} replicas.
        slots:
          service: path.serviceId
          org: path.organizationId
          autoscalingMode: requestBody.autoscalingMode
          minReplicas: requestBody.minReplicas
          maxReplicas: requestBody.maxReplicas
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/password'].patch
  update:
    x-apievangelist-phrasing:
      intent: Change a ClickHouse service's password
      effect: write
      questions:
      - How do I reset the default user password on my ClickHouse service?
      - Can I set the service password by sending a hash instead of plain text?
      instructions:
      - text: Set a new password on service {service} in org {org} using hash {newPasswordHash}.
        slots:
          service: path.serviceId
          org: path.organizationId
          newPasswordHash: requestBody.newPasswordHash
      - text: Reset the ClickHouse service password for {service} in organization {org} with double SHA1 hash {newDoubleSha1Hash}.
        slots:
          service: path.serviceId
          org: path.organizationId
          newDoubleSha1Hash: requestBody.newDoubleSha1Hash
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/privateEndpoint'].post
  update:
    x-apievangelist-phrasing:
      intent: Add a private endpoint to a service
      effect: write
      questions:
      - How do I register my cloud private endpoint with a ClickHouse service?
      - Can I add a description to a private endpoint when I create it?
      instructions:
      - text: Create private endpoint {endpointId} for service {service} in org {org}.
        slots:
          endpointId: requestBody.id
          service: path.serviceId
          org: path.organizationId
      - text: Associate private endpoint {endpointId} described as {description} with service {service} in organization {org}.
        slots:
          endpointId: requestBody.id
          description: requestBody.description
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/scalingSchedule'].get
  update:
    x-apievangelist-phrasing:
      intent: Get a service's scheduled autoscaling
      effect: read
      questions:
      - Does my service have a time-based scaling schedule?
      - What scaling changes are scheduled for this service?
      instructions:
      - text: Show the autoscaling schedule for service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Get the scheduled scaling entries on service {service} in organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/scalingSchedule'].post
  update:
    x-apievangelist-phrasing:
      intent: Set a service's scheduled autoscaling
      effect: write
      questions:
      - How do I scale a service up during business hours and down at night on a schedule?
      - Can I clear a scaling schedule by sending no entries?
      instructions:
      - text: Set the autoscaling schedule for service {service} in org {org} to {entries}.
        slots:
          service: path.serviceId
          org: path.organizationId
          entries: requestBody.entries
      - text: Replace the scheduled scaling on service {service} in organization {org} with entries {entries}.
        slots:
          service: path.serviceId
          org: path.organizationId
          entries: requestBody.entries
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/scalingSchedule'].delete
  update:
    x-apievangelist-phrasing:
      intent: Remove a service's scheduled autoscaling
      effect: destructive
      questions:
      - How do I delete the scaling schedule on a service?
      - What happens to the current scaling when I remove an active schedule?
      instructions:
      - text: Delete the scaling schedule for service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Remove scheduled autoscaling from service {service} in organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/upgradeWindow'].get
  update:
    x-apievangelist-phrasing:
      intent: Get a service's upgrade window
      effect: read
      questions:
      - When is my ClickHouse service scheduled to receive upgrades?
      - Which day and hour is the upgrade window set to?
      instructions:
      - text: Show the upgrade window for service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Get the configured maintenance upgrade slot of service {service} in organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/upgradeWindow'].put
  update:
    x-apievangelist-phrasing:
      intent: Set a service's upgrade window
      effect: write
      questions:
      - How do I make upgrades happen on the weekend instead of during business hours?
      - Which start hours are allowed for an upgrade window, and how long does it last?
      instructions:
      - text: Set the upgrade window of service {service} in org {org} to weekday {weekday} starting at {startHourUtc} UTC.
        slots:
          service: path.serviceId
          org: path.organizationId
          weekday: requestBody.weekday
          startHourUtc: requestBody.startHourUtc
      - text: Schedule upgrades for primary service {service} in organization {org} on day {weekday} at hour {startHourUtc} UTC.
        slots:
          service: path.serviceId
          org: path.organizationId
          weekday: requestBody.weekday
          startHourUtc: requestBody.startHourUtc
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/upgradeWindow'].delete
  update:
    x-apievangelist-phrasing:
      intent: Remove a service's upgrade window
      effect: destructive
      questions:
      - How do I go back to the default upgrade scheduling for a service?
      - Can I delete a custom upgrade window?
      instructions:
      - text: Delete the upgrade window on service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Restore default upgrade scheduling for service {service} in organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings'].get
  update:
    x-apievangelist-phrasing:
      intent: List ClickHouse settings explicitly set on a service
      effect: read
      questions:
      - Which ClickHouse server settings have been customized on my service?
      - What settings did we override from the platform defaults?
      instructions:
      - text: List the configured ClickHouse settings for service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Show every setting overridden on service {service} in organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings'].patch
  update:
    x-apievangelist-phrasing:
      intent: Change ClickHouse settings on a service
      effect: write
      questions:
      - How do I change a ClickHouse server setting on my service?
      - Can I update several ClickHouse settings in one call?
      instructions:
      - text: Apply ClickHouse settings {settings} to service {service} in org {org}.
        slots:
          settings: requestBody.settings
          service: path.serviceId
          org: path.organizationId
      - text: Update the server settings on service {service} in organization {org} to {settings}.
        slots:
          service: path.serviceId
          org: path.organizationId
          settings: requestBody.settings
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings/schema'].get
  update:
    x-apievangelist-phrasing:
      intent: Get the schema of configurable ClickHouse settings
      effect: read
      questions:
      - Which ClickHouse settings am I allowed to configure, and what values are valid?
      - Where can I see types and descriptions for every tunable setting?
      instructions:
      - text: Get the ClickHouse settings schema for service {service} in org {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      - text: Show all configurable settings and their valid values for service {service} in organization {org}.
        slots:
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings/{settingName}'].get
  update:
    x-apievangelist-phrasing:
      intent: Get one ClickHouse setting's value
      effect: read
      questions:
      - What is the current value of a specific ClickHouse setting on my service?
      - Is one particular setting still at its default?
      instructions:
      - text: Get ClickHouse setting {settingName} on service {service} in org {org}.
        slots:
          settingName: path.settingName
          service: path.serviceId
          org: path.organizationId
      - text: Show the current value of {settingName} for service {service} in organization {org}.
        slots:
          settingName: path.settingName
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'
- target: $.paths['/v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings/{settingName}'].delete
  update:
    x-apievangelist-phrasing:
      intent: Reset a ClickHouse setting to its default
      effect: destructive
      questions:
      - How do I undo a custom ClickHouse setting and return it to the platform default?
      - Can I remove one override without touching my other settings?
      instructions:
      - text: Reset ClickHouse setting {settingName} on service {service} in org {org} to default.
        slots:
          settingName: path.settingName
          service: path.serviceId
          org: path.organizationId
      - text: Remove the override for {settingName} from service {service} in organization {org}.
        slots:
          settingName: path.settingName
          service: path.serviceId
          org: path.organizationId
      method: generated
      generated: '2026-09-26'