dubin555A Model Context Protocal (MCP) server implement for ClickHouse.
A Model Context Protocal (MCP) server implement for ClickHouse.
ClickHouse MCP Server
A Model Context Protocal (MCP) server implement for ClickHouse.
This server provides AI assistants with a secure and structured way to explore and analyze databases. It enables them to list tables, read data, and execute SQL queries through a controlled interface, ensuring responsible database access.
Configuration
Set the following environment variables:
CLICKHOUSE_HOST=localhost
CLICKHOUSE_PORT=8123
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=CHANGE_TO_YOUR_PASSWORD
CLICKHOUSE_DATABASE=defaultOr via command-line args:
--hostthe database host--portthe database port--userthe database username--passwordthe database password--databasethe database name
Usage
Fake some data in clickhouse
Check the SQL in dev_contribute.md for details.
Post your question to AI assistant in Cline
What is the sales volume in each region? Which product is the best - selling?
CLINE
Configure the MCP server in VSCode, Cline extension, or other MCP client.: Example:
{
"mcpServers": {
"clickhouse": {
"command": "uv",
"args": [
"--directory",
"/path/to/clickhouse_mcp_server",
"run",
"-m",
"clickhouse_mcp_server.server"
],
"env": {
"CLICKHOUSE_HOST": "localhost",
"CLICKHOUSE_PORT": "8123",
"CLICKHOUSE_USER": "default",
"CLICKHOUSE_PASSWORD": "CHANGE_TO_YOUR_PASSWORD",
"CLICKHOUSE_DATABASE": "default"
}
}
}
}License
APACHE - See LICENSE file for details.
Contribute
See dev_contribute.md for details.
Prerequisites
- Python with
uvpackage manager - ClickHouse installation
- MCP server dependencies
Acknowledgement
This library's implementation was inspired by the following three repositories and incorporates their code, respect for the open-source spirit!
Thanks!
Pick your client and paste the snippet. Each one is the same server, written the way that client expects it.
- Run the command below in your terminal.
- Restart Claude Code, then check the connection with /mcp.
- Open your client's MCP config file, usually mcp.json.
- Merge this block into it.
- Restart the client to pick up the server.
- Run the command below in your terminal.
- Reload VS Code and check the MCP section of the Extensions view.
- Open ~/.codex/config.toml.
- Append this block.
- Restart Codex to pick up the server.
claude mcp add clickhouse -- uv --directory /path/to/clickhouse_mcp_server run -m clickhouse_mcp_server.server{
"mcpServers": {
"clickhouse": {
"env": {
"CLICKHOUSE_HOST": "",
"CLICKHOUSE_PORT": "",
"CLICKHOUSE_USER": "",
"CLICKHOUSE_DATABASE": "",
"CLICKHOUSE_PASSWORD": ""
},
"args": [
"--directory",
"/path/to/clickhouse_mcp_server",
"run",
"-m",
"clickhouse_mcp_server.server"
],
"command": "uv"
}
}
}code --add-mcp '{"name":"clickhouse","env":{"CLICKHOUSE_HOST":"","CLICKHOUSE_PORT":"","CLICKHOUSE_USER":"","CLICKHOUSE_DATABASE":"","CLICKHOUSE_PASSWORD":""},"args":["--directory","/path/to/clickhouse_mcp_server","run","-m","clickhouse_mcp_server.server"],"command":"uv"}'[mcp_servers.clickhouse]
command = "uv"
args = ["--directory", "/path/to/clickhouse_mcp_server", "run", "-m", "clickhouse_mcp_server.server"]Runs locally on your device. Your client starts the server itself, so nothing has to be hosted.
Install with your agent
Paste this prompt into your agent. It reads this page and does the setup for you.
Read https://aiagentslisting.com/mcp/clickhouse-mcp-server-2 to learn what the "ClickHouse MCP Server" MCP server does and how to install it. Add it to my coding agent's MCP configuration as documented on that page, then confirm the server connects and list the tools it exposes.Agents can also browse this directory over MCP at https://aiagentslisting.com/api/mcp
This server runs locally, so we can't read its tool list over the web yet.
What's missing
- Exposes toolsRequiredThe server reports at least one tool, from its manifest or a live read.0/15
- Verified liveWe connected to the server and it answered a real MCP handshake.0/20
- Ships promptsThe server exposes at least one prompt template.0/8
- Ships resourcesThe server exposes at least one resource.0/8
- Claimed by ownerThe maintainer proved ownership of this listing.0/4
All 9 checks (4 passed)
- Installation methodRequiredThe README documents at least one way to install or connect.15/15
- Exposes toolsRequiredThe server reports at least one tool, from its manifest or a live read.0/15
- Has a READMERequiredThe repository ships documentation we could read.10/10
- Verified liveWe connected to the server and it answered a real MCP handshake.0/20
- Easy installA paste-ready client config (an mcpServers block) is documented.12/12
- Has a licenseThe repository declares a license.8/8
- Ships promptsThe server exposes at least one prompt template.0/8
- Ships resourcesThe server exposes at least one resource.0/8
- Claimed by ownerThe maintainer proved ownership of this listing.0/4
Maintain this server? Claiming proves you own the listing and earns the last 4 points.
Claim this listingShow this grade in your README
Paste this line near the top of your repository's README. The badge always renders the current score.
[](https://aiagentslisting.com/mcp/clickhouse-mcp-server-2)Alternatives to ClickHouse MCP Server
Nothing comparable is listed yet.
No tagged releases on record.
Send this prompt to your agent to leave a review
Connect to the AI Agents Listing MCP server at https://aiagentslisting.com/api/mcp using the HTTP transport and complete the sign-in when it asks. Then call the submit_review tool for the listing "clickhouse-mcp-server-2" with a rating from 1 to 5 and a short note on what worked and what did not.No reviews yet
Be the first to share your experience with this tool.
Subscribe to our newsletter
One email a week. New agents, MCP servers and skills, and what is actually getting traction.