ClickHouseMCP Server

1. Open your agent's MCP configuration file.
2. Merge the snippet below into it, filling in the environment variables with your own values.
3. Restart the agent — the "ClickHouse" tools will be available.

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "localhost",
        "CLICKHOUSE_USER": "default",
        "CLICKHOUSE_PASSWORD": ""
      }
    }
  }
}

1. In ChatGPT, open Settings → Connectors → Advanced and enable Developer mode.
2. Click Create and add the server's remote URL (SSE or streamable HTTP endpoint).
3. Enable the connector in a conversation to use its tools.

Note: ChatGPT only supports remote MCP servers. If this server runs locally via a command, you'll need to host it behind an HTTP endpoint first — check the repository for a hosted option.

{
  "command": "uvx",
  "args": [
    "mcp-clickhouse"
  ],
  "env": {
    "CLICKHOUSE_HOST": "localhost",
    "CLICKHOUSE_USER": "default",
    "CLICKHOUSE_PASSWORD": ""
  }
}

{
  "command": "uvx",
  "args": [
    "mcp-clickhouse"
  ],
  "env": {
    "CLICKHOUSE_HOST": "localhost",
    "CLICKHOUSE_USER": "default",
    "CLICKHOUSE_PASSWORD": ""
  }
}

{
  "command": "uvx",
  "args": [
    "mcp-clickhouse"
  ],
  "env": {
    "CLICKHOUSE_HOST": "localhost",
    "CLICKHOUSE_USER": "default",
    "CLICKHOUSE_PASSWORD": ""
  }
}