[BETA] Get DBaaS ClickHouse ACL configuration

Add MCP server to your AI tool

Allow AI tools and LLMs to interact with the API documentation portal through MCP.

MCP server URL


        
          
            https://openapi-v2.exoscale.com/mcp

Standard setup for AI tools providing an mcp.json file

{
  "Exoscale APIv2 MCP server": {
    "url": "https://openapi-v2.exoscale.com/mcp"
  }
}

GET /dbaas-clickhouse/{service-name}/acl-config

Path parameters

service-name string Required

Minimum length is 0, maximum length is 63.

Responses

200 application/json

200
Hide response attribute Show response attribute object
- users array[object]
  
  Hide users attributes Show users attributes object
  
  username string Required
  
  Username
  
  Minimum length is 1, maximum length is 64.
  
  uuid string(uuid)
  
  roles array[object]
  
  Hide roles attributes Show roles attributes object
  
  default boolean
  
  name string
  
  uuid string(uuid)
  
  with-admin-option boolean
  
  privileges array[object]
  
  Hide privileges attributes Show privileges attributes object
  
  access-type string
  
  column string
  
  database string
  
  grant-option boolean
  
  partial-revoke boolean
  
  table string

GET /dbaas-clickhouse/{service-name}/acl-config

curl \
 --request GET 'https://api-ch-gva-2.exoscale.com/v2/dbaas-clickhouse/{service-name}/acl-config'

Response examples (200)

{
  "users": [
    {
      "username": "string",
      "uuid": "string",
      "roles": [
        {
          "default": true,
          "name": "string",
          "uuid": "string",
          "with-admin-option": true
        }
      ],
      "privileges": [
        {
          "access-type": "string",
          "column": "string",
          "database": "string",
          "grant-option": true,
          "partial-revoke": true,
          "table": "string"
        }
      ]
    }
  ]
}