Search
Collection
Category
Tag
Blog
Pricing
Submit
Studio

Newsletter

Join the Community

Subscribe to our newsletter for the latest news and updates

Email

Find Mcp Servers and Clients

The ultimate directory for Model Context Protocol (MCP) servers and clients

Product

Search
Collection
Category
Tag

Resources

Blog
Pricing
Submit
Studio

Company

About Us
Privacy Policy
Terms of Service
Sitemap

Copyright © 2025 All Rights Reserved.

Home
Category
mcp-clickhouse

mcp-clickhouse

An MCP (Meta-Config Provider) server for ClickHouse, enabling SQL queries and database management via Claude.

Screenshot of mcp-clickhouse

Introduction

Information

Websitegithub.com
Published date2025/03/30

Categories

Databases
Developer Tools

Tags

dev-tools
utilities
security
infrastructure
command-line
database

More Products

image of notion-mcp-server

Developer ToolsCloud Platforms

notion-mcp-server

Official Notion MCP Server implements the Model Context Protocol for the Notion API, enabling AI-driven interactions and automation.

dev-tools knowledge-base utilities ai-tools web+3

image of GitHub MCP Server

Developer ToolsVersion ControlCloud Platforms

GitHub MCP Server

GitHub MCP Server enables advanced automation and interaction capabilities for developers and tools using Model Context Protocol.

dev-tools version-control cloud ai-tools automation

image of mcp-server-cloudflare

Cloud PlatformsDeveloper ToolsCommand Line

mcp-server-cloudflare

Cloudflare MCP Server enables natural language interaction with Cloudflare's API for managing Workers, KV, R2, D1, and more via MCP.

cloud dev-tools command-line utilities infrastructure+4

ClickHouse MCP Server

An MCP server for ClickHouse, designed to facilitate interaction with ClickHouse databases through the Claude interface.

Features

Tools:
- run_select_query: Executes SQL SELECT queries on a ClickHouse cluster with readonly mode enabled for safety.
  - Input: sql (string) - The SQL query to execute.
- list_databases: Lists all databases on the ClickHouse cluster.
- list_tables: Lists all tables within a specified database.
  - Input: database (string) - The name of the database.

Configuration

Configuration involves modifying the Claude Desktop configuration file to include the MCP server details and ClickHouse connection parameters.

Key parameters include:

ClickHouse host, port, user, and password.
SSL settings (secure and verify).
Connection and send/receive timeouts.

Development

Local development setup involves using Docker Compose to run a ClickHouse cluster and setting up environment variables for connection details. The server can be easily tested using the mcp dev command.