[BETA] Create a DBaaS ClickHouse user

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

mcp.json 
{
  "Exoscale APIv2 MCP server": {
    "url": "https://openapi-v2.exoscale.com/mcp"
  }
}
Close
POST /dbaas-clickhouse/{service-name}/user

Path parameters

  • service-name string Required

    Minimum length is 0, maximum length is 63.

application/json

Body Required

  • username string Required

    Username

    Minimum length is 1, maximum length is 64.

  • password string

    Password

    Minimum length is 8, maximum length is 256.

  • roles array[object]

    ClickHouse roles to grant to the user

    Hide roles attribute Show roles attribute object
    • uuid string(uuid) Required

      Role UUID

Responses

  • 200 application/json

    200

    Hide response attributes Show response attributes object
    • username string

      ClickHouse username

    • password string

      ClickHouse password
POST /dbaas-clickhouse/{service-name}/user 
curl \
 --request POST 'https://api-ch-gva-2.exoscale.com/v2/dbaas-clickhouse/{service-name}/user' \
 --header "Content-Type: application/json" \
 --data '{"username":"string","password":"string","roles":[{"uuid":"string"}]}'
Request examples 
{
  "username": "string",
  "password": "string",
  "roles": [
    {
      "uuid": "string"
    }
  ]
}
Response examples (200) 
{
  "username": "string",
  "password": "string"
}