clickhouse dataops mcp for VS Code

io.github.aguantar/clickhouse-dataops-mcp

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

client:VS Code transport:stdio runtime:pypi

Install clickhouse dataops mcp in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "clickhouse-host",
      "description": "CLICKHOUSE_HOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "clickhouse-port",
      "description": "CLICKHOUSE_PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "clickhouse-password",
      "description": "CLICKHOUSE_PASSWORD",
      "password": true
    }
  ],
  "servers": {
    "clickhouse-dataops-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "clickhouse-dataops-mcp"
      ],
      "env": {
        "CLICKHOUSE_HOST": "${input:clickhouse-host}",
        "CLICKHOUSE_PORT": "${input:clickhouse-port}",
        "CLICKHOUSE_PASSWORD": "${input:clickhouse-password}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

clickhouse dataops mcp in other clients

clickhouse dataops mcp MCP server