clickhouse-mcp-server

clickhouse-mcp-server

1
databasesai_chatbot

ClickHouse MCP Server connects to ClickHouse databases and lets users perform data exploration and analysis via natural language queries using large language models like Claude. It allows for executing read-only SQL queries and is designed to work with macOS.

ClickHouse MCP Server

A Model Context Protocol server that connects to ClickHouse databases, enabling large language models 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

Installation

  1. Clone this repository
  2. Install dependencies
  3. Configure environment variables in a .env file
  4. Build the project

Security Considerations

  • Allows only read-only SQL queries
  • Store sensitive credentials securely
  • Basic validation to prevent DDL or DML execution