mcpField
C
ClickHouse MCP Server

ClickHouse MCP Server

Local
github.com/bjpadhyDatabases1Updated 81w ago
Repository

About ClickHouse MCP Server

ClickHouse MCP Server connects ClickHouse databases to LLM clients for natural-language data exploration. It provides schema and sample-data resources alongside read-only SQL tools.

Key features

  1. 01ClickHouse database connection
  2. 02Table schema and sample resources
  3. 03Read-only SQL execution
  4. 04Natural-language data queries

Use cases

  1. 01Inspect database tables and schemas
  2. 02Ask questions about ClickHouse data
  3. 03Run read-only analytics queries

MCP support

Exposes database information, table schemas, and sample rows as MCP resources, with tools for read-only SQL and natural-language queries.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

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

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.