ClickHouse
About
Integrates with ClickHouse databases to execute SQL queries and retrieve results in JSON format, enabling data analysis and exploration directly within conversation interfaces.
Details
- Author
- burakdirin
- Repository
- burakdirin/clickhouse-mcp-server
- Downloads
- 1,387
- License
- MIT License
- Categories
- Database, Other, Productivity, Developer Tools, Design, AI, Search, Security, Infrastructure
- Tags
- #integration
Jump to
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
ClickHouseCommand (node, npx, python, etc.)uvArguments-
Argument 1
--directory -
Argument 2
/Users/burakdirin/Projects/clickhouse-mcp-server -
Argument 3
run -
Argument 4
clickhouse-mcp-server
Environment-
CLICKHOUSE_HOST
localhost -
CLICKHOUSE_USER
root -
CLICKHOUSE_DATABASE
[optional] -
CLICKHOUSE_PASSWORD
password -
CLICKHOUSE_READONLY
true
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
-
Argument 1
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
connect_database
Connects to a specific Clickhouse database. Parameters: database (string) - Name of the database to connect to. Returns a confirmation message when connection is successful.
execute_query
Executes Clickhouse queries. Parameters: query (string) - SQL query/queries to execute. Returns query results in JSON format. Multiple queries can be sent separated by semicolons.
The server provides two tools:
- connect_database: Connects to a specific Clickhouse database
- database parameter: Name of the database to connect to (string)
- Returns a confirmation message when connection is successful
- execute_query: Executes Clickhouse queries
- query parameter: SQL query/queries to execute (string)
- Returns query results in JSON format
- Multiple queries can be sent separated by semicolons
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"clickhouse": {
"env": {
"CLICKHOUSE_HOST": "localhost",
"CLICKHOUSE_USER": "root",
"CLICKHOUSE_DATABASE": "[optional]",
"CLICKHOUSE_PASSWORD": "password",
"CLICKHOUSE_READONLY": "true"
},
"args": [
"--directory",
"/Users/burakdirin/Projects/clickhouse-mcp-server",
"run",
"clickhouse-mcp-server"
],
"command": "uv"
}
}
}Linux
{
"env": {
"CLICKHOUSE_HOST": "localhost",
"CLICKHOUSE_USER": "root",
"CLICKHOUSE_DATABASE": "[optional]",
"CLICKHOUSE_PASSWORD": "password",
"CLICKHOUSE_READONLY": "true"
},
"args": [
"clickhouse-mcp-server"
],
"command": "uvx"
}Macos
{
"env": {
"CLICKHOUSE_HOST": "localhost",
"CLICKHOUSE_USER": "root",
"CLICKHOUSE_DATABASE": "[optional]",
"CLICKHOUSE_PASSWORD": "password",
"CLICKHOUSE_READONLY": "true"
},
"args": [
"--directory",
"/Users/burakdirin/Projects/clickhouse-mcp-server",
"run",
"clickhouse-mcp-server"
],
"command": "uv"
}Windows
{
"env": {
"CLICKHOUSE_HOST": "localhost",
"CLICKHOUSE_USER": "root",
"CLICKHOUSE_DATABASE": "[optional]",
"CLICKHOUSE_PASSWORD": "password",
"CLICKHOUSE_READONLY": "true"
},
"args": [
"clickhouse-mcp-server"
],
"command": "uvx"
}A Clickhouse database MCP server project.
-
connect_database: Connects to a specific Clickhouse database
- databaseparameter: Name of the database to connect to (string)
- Returns a confirmation message when connection is successful
execute_query: Executes Clickhouse queries
- queryparameter: SQL query/queries to execute (string)
- Returns query results in JSON format
- Multiple queries can be sent separated by semicolons
The server uses the following environment variables:
- CLICKHOUSE_HOST: Clickhouse server address (default: "localhost")
- CLICKHOUSE_USER: Clickhouse username (default: "root")
- CLICKHOUSE_PASSWORD: Clickhouse password (default: "")
- CLICKHOUSE_DATABASE: Initial database (optional)
- CLICKHOUSE_READONLY: Read-only mode (set to 1/true to enable, default: false)
MacOS:~/Library/Application\ Support/Claude/claude_desktop_config.json
Windows:%APPDATA%/Claude/claude_desktop_config.json
{ "mcpServers": { "clickhouse-mcp-server": { "command": "uv", "args": [ "--directory", "/Users/burakdirin/Projects/clickhouse-mcp-server", "run", "clickhouse-mcp-server" ], "env": { "CLICKHOUSE_HOST": "localhost", "CLICKHOUSE_USER": "root", "CLICKHOUSE_PASSWORD": "password", "CLICKHOUSE_DATABASE": "[optional]", "CLICKHOUSE_READONLY": "true" } } } }
{ "mcpServers": { "clickhouse-mcp-server": { "command": "uvx", "args": [ "clickhouse-mcp-server" ], "env": { "CLICKHOUSE_HOST": "localhost", "CLICKHOUSE_USER": "root", "CLICKHOUSE_PASSWORD": "password", "CLICKHOUSE_DATABASE": "[optional]", "CLICKHOUSE_READONLY": "true" } } } }
To install Clickhouse Database Integration Server for Claude Desktop automatically viaSmithery:
npx -y @smithery/cli install @burakdirin/clickhouse-mcp-server --client claude
To prepare the package for distribution:
This will create source and wheel distributions in thedist/directory.
Note: You'll need to set PyPI credentials via environment variables or command flags:
- Token:--tokenorUV_PUBLISH_TOKEN
- Or username/password:--username/UV_PUBLISH_USERNAMEand--password/UV_PUBLISH_PASSWORD
Since MCP servers run over stdio, debugging can be challenging. For the best debugging experience, we strongly recommend using theMCP Inspector.
You can launch the MCP Inspector vianpmwith this command:
npx @modelcontextprotocol/inspector uv --directory /Users/burakdirin/Projects/clickhouse-mcp-server run clickhouse-mcp-server
Upon launching, the Inspector will display a URL that you can access in your browser to begin debugging.
Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.
Query and analyze data with MotherDuck and local DuckDB
An MCP server for querying and interacting with AWS Athena.
Access Google BigQuery to understand dataset structures and execute SQL queries.
A secure, self-hosted Model Context Protocol (MCP) server for Google BigQuery. Hard table allowlists, per-query scan ceilings, built-in rate limiting, and predictable costs on Cloud Run. Works with Claude, ChatGPT, Cursor, Gemini, and any MCP-compatible AI agent.
A read-only MCP server for SAP BusinessObjects BI, powered by the CData JDBC Driver.
A Node.js server for querying ClickHouse databases.
MCP Server accessing and administrate the Apache Druid Database
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
