How do I install the chmcp mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `CLICKHOUSE_HOST`, `CLICKHOUSE_PORT`, `CLICKHOUSE_USER`, `CLICKHOUSE_PASSWORD`, `CLICKHOUSE_SECURE`, `CLICKHOUSE_READONLY`, `CLICKHOUSE_CLOUD_KEY_ID`, `CLICKHOUSE_CLOUD_KEY_SECRET` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Chmcp MCP Server

A comprehensive Model Context Protocol (MCP) server that provides **two distinct capabilities**: 1. **Database Operations** - Connect to and query

Remote serverstreamable-httpPython

What is the Chmcp MCP Server?

A comprehensive Model Context Protocol (MCP) server that provides two distinct capabilities: 1. Database Operations - Connect to and query any ClickHouse

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the Chmcp MCP Server

{
  "mcpServers": {
    "chmcp": {
      "command": "/path/to/uv",
      "args": [
        "run",
        "--with",
        "chmcp",
        "--python",
        "3.13",
        "chmcp"
      ],
      "env": {
        "CLICKHOUSE_HOST": "your-server.com",
        "CLICKHOUSE_PORT": "8443",
        "CLICKHOUSE_USER": "your-username",
        "CLICKHOUSE_PASSWORD": "YOUR_CLICKHOUSE_PASSWORD",
        "CLICKHOUSE_SECURE": "true",
        "CLICKHOUSE_READONLY": "true"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

Variable	Description	Required
CLICKHOUSE_HOST	Declared in the maintainer’s client configuration.	Check documentation
CLICKHOUSE_PORT	Declared in the maintainer’s client configuration.	Check documentation
CLICKHOUSE_USER	Declared in the maintainer’s client configuration.	Check documentation
CLICKHOUSE_PASSWORD	Declared in the maintainer’s client configuration.	Check documentation
CLICKHOUSE_SECURE	Declared in the maintainer’s client configuration.	Check documentation
CLICKHOUSE_READONLY	Declared in the maintainer’s client configuration.	Check documentation

Example prompts to try

“Use Chmcp to Admin.”
“Use Chmcp to Developer.”
“Use Chmcp to Read.”

Frequently asked questions

A comprehensive Model Context Protocol (MCP) server that provides **two distinct capabilities**: 1. **Database Operations** - Connect to and query any ClickHouse Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.