ClickHouse MCP Server
by ClickHouse · data-analytics · mcp-server, lobehub, validated, tools
An MCP server for ClickHouse. Requires external configuration of ClickHouse connection parameters via environment variables such as CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, and optionally CLICKHOUSE_DATABASE.
Source: https://github.com/ClickHouse/mcp-clickhouse
Install
git clone https://github.com/ClickHouse/mcp-clickhouseUse this forAI-extracted
- →Execute SQL queries against ClickHouse databases and retrieve structured results
- →Analyze large datasets and time-series data with AI assistance for insights and anomalies
- →Generate ClickHouse queries and schemas from natural language descriptions
- →Debug and optimize ClickHouse performance through AI-assisted query analysis
Works with
Tags: mcp-server, lobehub, validated, tools
⭐ 37 GitHub stars · Source: lobehub
About data-analytics MCP servers and Claude skills
data-analytics MCP servers extend what AI agents can do inside Claude Code, Cursor, Copilot, Codex, and Windsurf. The Skiln directory indexes 16,000+ such integrations across 22 categories.
ClickHouse MCP Server is one of hundreds of data-analytics entries indexed on Skiln. Browse the full data-analytics category or the complete directory of Claude skills, MCP servers, agents, commands, and hooks.
Related data-analytics MCPs and skills
- MCP-DB-Server by sujalsamkaria0066
Enables natural language querying of SQL databases with robust safety guarantees including read-only enforcement, AST validation, and row caps.
- census-mcp-server by zenlyticgreg
A production-grade MCP server for querying U.S. Census Bureau data (ACS 5-Year and Decennial) with tools for geographic fuzzy matching, variable search, and batched data retrieval, backed by a PostgreSQL cache for performance.
- h3yun-sql-troubleshooter by chuck9090
MCP server for querying H3Yun SQL data, enabling AI to execute read-only SQL queries and troubleshoot H3Yun business issues.
- MariaDB-MCP by TheNesdark
Enables interaction with MariaDB/MySQL databases via MCP, supporting read-only mode, SQL execution, and schema inspection.
- mcp-memory-keeper by anthonycho-ux
A local MCP server using SQLite to unify context and memory across multiple AI agents, enabling persistent decisions and preferences without re-explanation.
- clickhouse-mcp-server by reiple
Read-only MCP server for ClickHouse that allows listing databases and tables, describing schemas, and running SELECT queries.
- mcp-server by atamayop2018
Enables scraping and comparing LLM inference pricing from multiple providers using Firecrawl, storing results in SQLite for analysis.
- TaskMCP by CCLucky-uu
A personal task management MCP server that allows LLM clients to create, read, update, and delete tasks with projects, labels, and comments, using a local SQLite database that can also be accessed via a web UI.
Frequently asked questions
How do I install ClickHouse MCP Server?
Add the install command above to your Claude Code, Cursor, or Windsurf MCP configuration. Most servers register via npx, a local command, or a Docker image. Refer to the source repository for environment variables and credential requirements.
Which clients support ClickHouse MCP Server?
Any MCP-compatible client works: Claude Desktop, Claude Code CLI, Cursor, Windsurf, Zed, and VS Code with the official MCP extension. OpenAI Codex and GitHub Copilot increasingly support MCP via adapter bridges.
Is ClickHouse MCP Server free?
The server itself is typically open source. Any upstream service (API keys, paid tiers, hosted infrastructure) may have its own pricing. Check the source repository for details.