MCP cover image
See in Github
2025-04-07

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

  1. Clone this repository
  2. Install dependencies:
npm install
  1. 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
  2. Build the project:
npm run build

Usage

Running the server locally

npm start

Integrating with Claude Desktop

  1. Create or update your Claude Desktop configuration file:

    • On macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
  2. 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"
      }
    }
  }
}
  1. 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

相关推荐

  • Yusuf Emre Yeşilyurt
  • I find academic articles and books for research and literature reviews.

  • https://suefel.com
  • Latest advice and best practices for custom GPT development.

  • https://maiplestudio.com
  • Find Exhibitors, Speakers and more

  • Carlos Ferrin
  • Encuentra películas y series en plataformas de streaming.

  • Joshua Armstrong
  • Confidential guide on numerology and astrology, based of GG33 Public information

  • Elijah Ng Shi Yi
  • Advanced software engineer GPT that excels through nailing the basics.

  • Emmet Halm
  • Converts Figma frames into front-end code for various mobile frameworks.

  • lumpenspace
  • Take an adjectivised noun, and create images making it progressively more adjective!

  • Lists Tailwind CSS classes in monospaced font

  • https://appia.in
  • Siri Shortcut Finder – your go-to place for discovering amazing Siri Shortcuts with ease

  • apappascs
  • 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.

  • ShrimpingIt
  • Micropython I2C-based manipulation of the MCP series GPIO expander, derived from Adafruit_MCP230xx

  • modelcontextprotocol
  • Model Context Protocol Servers

  • Mintplex-Labs
  • The all-in-one Desktop & Docker AI application with built-in RAG, AI agents, No-code agent builder, MCP compatibility, and more.

  • ravitemer
  • A powerful Neovim plugin for managing MCP (Model Context Protocol) servers

  • jae-jae
  • MCP server for fetch web page content using Playwright headless browser.

  • patruff
  • Bridge between Ollama and MCP servers, enabling local LLMs to use Model Context Protocol tools

  • pontusab
  • The Cursor & Windsurf community, find rules and MCPs

  • n8n-io
  • Fair-code workflow automation platform with native AI capabilities. Combine visual building with custom code, self-host or cloud, 400+ integrations.

    Reviews

    2 (1)
    Avatar
    user_vOhatXZf
    2025-04-17

    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!