mcp-clickhousemcp-clickhouse MCP server

— (0)

Reviewed by Daniel Nikulshyn·Updated June 2026

Overview

The mcp-clickhouse MCP server is an An MCP server for ClickHouse. It features ClickHouse Tools, including run_query to execute SQL queries on your ClickHouse cluster, list_databases to list all databases on your ClickHouse cluster, and list_tables to list tables in a database with pagination. Additionally, it includes chDB Tools, like run_chdb_select_query, to execute SQL queries using chDB's embedded ClickHouse engine. It also provides a Health Check Endpoint to check the server's health and a Security mechanism for authentication. The server can be set up for internal services, local development, or with OAuth / OIDC authentication providers through FastMCP.

Key features

run_query to execute SQL queries on ClickHouse cluster
list_databases to list all databases on ClickHouse cluster
list_tables to list tables in a database with pagination
run_chdb_select_query to execute SQL queries using chDB's embedded ClickHouse engine
Health Check Endpoint for server monitoring
Multiple authentication modes, including OAuth and OIDC through FastMCP

Pricing

Model: Free
Category: MCP Servers
Rating: No reviews yet

Use cases

Monitoring ClickHouse Server Health

Use the Health Check Endpoint to monitor the server's health and detect any issues.

Executing SQL Queries on ClickHouse

Use the ClickHouse Tools, like run_query, to execute SQL queries on your ClickHouse cluster.

Securing ClickHouse Server

Implement authentication and authorization using the multiple supported modes, including OAuth and OIDC through FastMCP.

Pros & Cons

Pros

Allows for the execution of SQL queries on a ClickHouse cluster
Supports multiple authentication modes, including OAuth and OIDC
Has a built-in health check endpoint for server monitoring

Cons

Only suitable for internal services due to security concerns
Limited flexibility in query execution
Requires proper authentication and authorization configuration

Battle record

Across 1 battle in the Pantheon.

0

1st

0

2nd

1

3rd

Last battle

#3
MCP Servers Showdown — May 26, 2026
May 26, 2026 · #3 of 5

Reviews

Sign in to leave a review.

No reviews yet. Be the first!

Q&A

No questions yet — be the first to ask.

Ask a question

MCP Servers alternatives

Playwright MCP

MCP Servers

Open-source MCP server that lets LLMs drive real browsers via Playwright and accessibility snapshots.

Pydantic AI

MCP Servers

Python agent framework from the Pydantic team for building type-safe GenAI apps.

Cognee

MCP Servers

Adaptive memory layer that helps AI agents learn from context over time.

Inbox Zero

MCP Servers

AI email assistant that organizes, drafts replies, and helps you reach inbox zero faster.

Screenpipe

MCP Servers

Open-source 24/7 local screen and audio recording for building context-aware AI apps

AgentKit

MCP Servers

TypeScript library for building and orchestrating AI agents with tools, memory, and multi-agent workflows.

onchain-mcp

MCP Servers

Bringing the bankless onchain API to MCP

markitdown

MCP Servers

Python tool for converting files and office documents to Markdown.