C
ClickHouse
Run OLAP SQL on ClickHouse.
·No reviews yet
Share:
About
Auto-generated
ClickHouse is a Model Context Protocol server in the Data & Databases category. It lets AI assistants that speak MCP call its tools and read its resources over STDIO.
Example tools
Illustrative tool names — the actual tool set is defined by the server at runtime.
query
Run a read-only SQL query
list_tables
List tables in the connected database
describe_table
Return column info for a table
Screenshots
No screenshots yet.
Frequently Asked Questions
Common questions about ClickHouse.
- What is the ClickHouse MCP for?
- This MCP allows you to run analytical SQL queries using the ClickHouse database. It is designed for Online Analytical Processing (OLAP) workloads, enabling efficient data aggregation and complex querying.
- How do I install the ClickHouse MCP in a client such as Cursor?
- Installation in a client like Cursor typically involves configuring the MCP to use the specified 'stdio' transport. You would add the ClickHouse MCP definition to your client's configuration, often through a 'Connect an MCP' or similar interface where you provide the slug 'clickhouse'.
- Does the ClickHouse MCP require authentication?
- Yes, this MCP requires an API key for authentication. You will need to obtain an API key and provide it during the MCP configuration process in your client to establish a secure connection.
- What kind of tasks can I perform with the ClickHouse MCP?
- You can execute OLAP SQL queries against your ClickHouse data warehouse. This enables tasks such as data analysis, reporting, and complex data aggregations directly through the MCP client.
- What are the common limitations of using the ClickHouse MCP?
- A common limitation is that its performance is highly dependent on the underlying ClickHouse database's configuration and its hardware resources. Optimizing query performance often requires understanding ClickHouse-specific query patterns.
- What are the costs associated with using the ClickHouse MCP?
- The cost depends entirely on your ClickHouse deployment. This MCP itself is community-provided, but operational costs will accrue from hosting and managing your ClickHouse database instances.
Install ClickHouse
Claude Desktop
Add this to claude_desktop_config.json.
{
"mcpServers": {
"clickhouse": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-clickhouse"
]
}
}
}Cursor
Add this to ~/.cursor/mcp.json.
{
"mcpServers": {
"clickhouse": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-clickhouse"
]
}
}
}VS Code
Add this to your workspace settings.json.
{
"mcp.servers": {
"clickhouse": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-clickhouse"
]
}
}
}Reviews
Sign in to leave a review.
No reviews yet. Be the first!
Discussion(0)
No comments yet.