Official ClickHouse MCP Server
Official ClickHouse MCP Server.
10K+
2
3 Tools
Version 4.43 or later needs to be installed to add the server automatically
Connect the MCP Toolkit gateway to Claude Desktop using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
Restart Claude Desktop for the changes to take effect.
- Open Claude Settings.
- Select the Developer tab.
- Select the Edit Config button.
- Add
clickhouseto themcpServerssection:
{
"mcpServers": {
"clickhouse": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"CLICKHOUSE_HOST",
"-e",
"CLICKHOUSE_PORT",
"-e",
"CLICKHOUSE_USER",
"-e",
"CLICKHOUSE_SECURE",
"-e",
"CLICKHOUSE_VERIFY",
"-e",
"CLICKHOUSE_CONNECT_TIMEOUT",
"-e",
"CLICKHOUSE_SEND_RECEIVE_TIMEOUT",
"-e",
"CLICKHOUSE_PASSWORD",
- mcp/clickhouse@sha256:861aae9d664cc13efe099a30f38f187812937af7c985d72b1bc02cb83f0a4c98
],
"env": {
"CLICKHOUSE_HOST": "{{clickhouse.host}}",
"CLICKHOUSE_PORT": "{{clickhouse.port}}",
"CLICKHOUSE_USER": "{{clickhouse.user}}",
"CLICKHOUSE_SECURE": "{{clickhouse.secure}}",
"CLICKHOUSE_VERIFY": "{{clickhouse.verify}}",
"CLICKHOUSE_CONNECT_TIMEOUT": "{{clickhouse.connect_timeout}}",
"CLICKHOUSE_SEND_RECEIVE_TIMEOUT": "{{clickhouse.send_receive_timeout}}",
"CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD_HERE>"
}
}
}
}Connect the MCP Toolkit gateway to Continue.dev using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
- In your global .continue folder (~/.continue on Mac/Linux, %USERPROFILE%.continue on Windows), create a a folder called mcpServers.
- Create a new file named clickhouse.yaml in the mcpServers folder.
- Write the following contents to clickhouse.yaml and save.
name: Docker MCP Official ClickHouse MCP Server
version: 1.0.1
schema: v1
mcpServers:
- name: Official ClickHouse MCP Server
command: docker
args:
- run
- --rm
- -i
- -e
- CLICKHOUSE_HOST
- -e
- CLICKHOUSE_PORT
- -e
- CLICKHOUSE_USER
- -e
- CLICKHOUSE_SECURE
- -e
- CLICKHOUSE_VERIFY
- -e
- CLICKHOUSE_CONNECT_TIMEOUT
- -e
- CLICKHOUSE_SEND_RECEIVE_TIMEOUT
- -e
- CLICKHOUSE_PASSWORD
- mcp/clickhouse@sha256:861aae9d664cc13efe099a30f38f187812937af7c985d72b1bc02cb83f0a4c98
env:
CLICKHOUSE_HOST: "{{clickhouse.host}}"
CLICKHOUSE_PORT: "{{clickhouse.port}}"
CLICKHOUSE_USER: "{{clickhouse.user}}"
CLICKHOUSE_SECURE: "{{clickhouse.secure}}"
CLICKHOUSE_VERIFY: "{{clickhouse.verify}}"
CLICKHOUSE_CONNECT_TIMEOUT: "{{clickhouse.connect_timeout}}"
CLICKHOUSE_SEND_RECEIVE_TIMEOUT: "{{clickhouse.send_receive_timeout}}"
CLICKHOUSE_PASSWORD: "<YOUR_CLICKHOUSE_PASSWORD_HERE>"Connect the MCP Toolkit gateway to Cursor using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
- Open Cursor Settings.
- Select the MCP Tools tab.
- Select the New Custom MCP button.
- Add
clickhouseto themcpServerssection:
{
"mcpServers": {
"clickhouse": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"CLICKHOUSE_HOST",
"-e",
"CLICKHOUSE_PORT",
"-e",
"CLICKHOUSE_USER",
"-e",
"CLICKHOUSE_SECURE",
"-e",
"CLICKHOUSE_VERIFY",
"-e",
"CLICKHOUSE_CONNECT_TIMEOUT",
"-e",
"CLICKHOUSE_SEND_RECEIVE_TIMEOUT",
"-e",
"CLICKHOUSE_PASSWORD",
- mcp/clickhouse@sha256:861aae9d664cc13efe099a30f38f187812937af7c985d72b1bc02cb83f0a4c98
],
"env": {
"CLICKHOUSE_HOST": "{{clickhouse.host}}",
"CLICKHOUSE_PORT": "{{clickhouse.port}}",
"CLICKHOUSE_USER": "{{clickhouse.user}}",
"CLICKHOUSE_SECURE": "{{clickhouse.secure}}",
"CLICKHOUSE_VERIFY": "{{clickhouse.verify}}",
"CLICKHOUSE_CONNECT_TIMEOUT": "{{clickhouse.connect_timeout}}",
"CLICKHOUSE_SEND_RECEIVE_TIMEOUT": "{{clickhouse.send_receive_timeout}}",
"CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD_HERE>"
}
}
}
}Define the MCP Toolkit gateway as a server in the MCP Visual Studio Code user settings. Learn more
"mcp": {
"servers": {
"MCP_DOCKER": {
"command": "docker",
"args": [
"mcp",
"gateway",
"run"
],
"type": "stdio"
}
}
}Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
Connect the MCP Toolkit gateway to Gordon using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
Manual installation
You can install the MCP server using:
Installation for