[BETA] List DBaaS ClickHouse roles

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}/role

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
- roles array[object]
  
  Hide roles attributes Show roles attributes object
  
  name string Required
  
  Role name
  
  Minimum length is 1, maximum length is 64.
  
  uuid string
  
  privileges array[object]
  
  Hide privileges attributes Show privileges attributes object
  
  name string Required
  
  Access type
  
  Minimum length is 1, maximum length is 64.
  
  database string
  
  Database
  
  table string
  
  Table
  
  grant-option boolean
  
  column string
  
  Column
  
  is-partial-revoke boolean
  
  granted-roles array[object]
  
  Hide granted-roles attributes Show granted-roles attributes object
  
  name string Required
  
  Granted role name
  
  uuid string
  
  is-default boolean
  
  with-admin-option boolean

GET /dbaas-clickhouse/{service-name}/role

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

Response examples (200)

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