[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
    • id string(uuid)

      Operation ID

    • reason string

      Operation failure reason

      Values are incorrect, unknown, unavailable, forbidden, busy, fault, partial, not-found, interrupted, unsupported, or conflict.

    • reference object

      Related resource reference

      Hide reference attributes Show reference attributes object
      • id string(uuid)

        Reference ID

      • link string

        Link to the referenced resource

      • command string

        Command name

    • message string

      Operation message

    • state string

      Operation status

      Values are failure, pending, success, or timeout.
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) 
{
  "id": "string",
  "reason": "incorrect",
  "reference": {
    "id": "string",
    "link": "string",
    "command": "string"
  },
  "message": "string",
  "state": "failure"
}