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
Converts Figma frames into front-end code for various mobile frameworks.
Advanced software engineer GPT that excels through nailing the basics.
Take an adjectivised noun, and create images making it progressively more adjective!
Embark on a thrilling diplomatic quest across a galaxy on the brink of war. Navigate complex politics and alien cultures to forge peace and avert catastrophe in this immersive interstellar adventure.
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!