I find academic articles and books for research and literature reviews.

clickhouse-mcp-server
A Model Context Protocol (MCP) server that connects to ClickHouse databases and allows LLMs like Claude to explore and analyze data through natural language queries.
1
Github Watches
0
Github Forks
1
Github Stars
ClickHouse MCP Server
A Model Context Protocol (MCP) server that connects to ClickHouse databases and allows LLMs like Claude to explore and analyze data through natural language queries.
Features
- Connect to ClickHouse databases
- Expose table schemas as resources
- Run SQL queries from natural language instructions
- Execute read-only SQL queries
- Works with Claude Desktop for macOS
Demo
https://github.com/user-attachments/assets/b496b9b0-5955-49d5-8c26-733f34662d8f
Installation
- Clone this repository
- Install dependencies:
npm install
- Configure your environment variables in a
.env
file (see.env.example
for reference). Ensure you are using a read-only database user to restrict DDL and DML execution - Build the project:
npm run build
Usage
Running the server locally
npm start
Integrating with Claude Desktop
-
Create or update your Claude Desktop configuration file:
- On macOS:
~/Library/Application Support/Claude/claude_desktop_config.json
- On macOS:
-
Add the server configuration:
{
"mcpServers": {
"clickhouse-analytics": {
"command": "node",
"args": [
"/absolute/path/to/clickhouse-mcp-server/dist/index.js"
],
"env": {
"CLICKHOUSE_URL": "your_clickhouse_url",
"CLICKHOUSE_USERNAME": "your_username",
"CLICKHOUSE_PASSWORD": "your_password",
"CLICKHOUSE_DATABASE": "your_database"
}
}
}
}
- Restart Claude Desktop
Available Features
Resources
-
db://info
- Database information including tables and schemas -
table://{tableName}/schema
- Schema for a specific table -
table://{tableName}/sample
- Sample data (5 rows) from a specific table
Tools
-
execute-sql
- Run a read-only SQL query against the database -
natural-language-query
- Ask questions about your data in natural language
Security Considerations
- This server only allows read-only SQL queries
- Sensitive credentials should be stored securely in environment variables
- The server performs basic validation to prevent DDL or DML statement execution
- Always review query requests before execution
License
MIT
相关推荐
Confidential guide on numerology and astrology, based of GG33 Public information
Advanced software engineer GPT that excels through nailing the basics.
Converts Figma frames into front-end code for various mobile frameworks.
Take an adjectivised noun, and create images making it progressively more adjective!
Siri Shortcut Finder – your go-to place for discovering amazing Siri Shortcuts with ease
Discover the most comprehensive and up-to-date collection of MCP servers in the market. This repository serves as a centralized hub, offering an extensive catalog of open-source and proprietary MCP servers, complete with features, documentation links, and contributors.
Micropython I2C-based manipulation of the MCP series GPIO expander, derived from Adafruit_MCP230xx
The all-in-one Desktop & Docker AI application with built-in RAG, AI agents, No-code agent builder, MCP compatibility, and more.
Bridge between Ollama and MCP servers, enabling local LLMs to use Model Context Protocol tools
Fair-code workflow automation platform with native AI capabilities. Combine visual building with custom code, self-host or cloud, 400+ integrations.
Reviews

user_vOhatXZf
As a dedicated user of the clickhouse-mcp-server by bjpadhy, I can vouch for its exceptional performance and reliability. This server, accessible at https://github.com/bjpadhy/clickhouse-mcp-server, has significantly streamlined my database management processes. The open-source nature and robust functionality make it a noteworthy choice for any developer looking to enhance their ClickHouse experience. Highly recommended!