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.

1st

2nd

3rd

Last battle

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

Reviews

No reviews yet. Be the first!

Q&A

Can mcp-clickhouse execute write queries on the ClickHouse cluster?

Queries run in read‑only mode by default (`CLICKHOUSE_ALLOW_WRITE_ACCESS=false`). Write access can be enabled explicitly if needed, allowing `run_query` to execute INSERT or UPDATE statements when the server is configured to permit writes.

Asked by Celia Ramirez · Aug 6, 2025

What pagination options are available when listing tables in a database?

The `list_tables` tool supports pagination via `page_token` and `page_size` parameters. By default it returns 50 tables per page, but you can adjust `page_size` and use the returned `next_page_token` to fetch subsequent pages, optionally filtering with `like` or `not_like`.

Asked by Marisol Pena · Jul 31, 2025

How can I monitor the health of the mcp-clickhouse server in a Kubernetes environment?

The server exposes an unauthenticated health check endpoint at `/health` that returns `200 OK` with body `OK` when it can connect to ClickHouse, and `503 Service Unavailable` otherwise. This endpoint is designed for liveness/readiness probes in Kubernetes or load balancer checks.

Asked by Kwame Mensah · Jul 8, 2025

What authentication methods does mcp-clickhouse support and how are they configured?

mcp-clickhouse supports multiple authentication modes, including OAuth and OIDC via FastMCP, as well as internal service authentication. Configuration is done through the FastMCP settings in the server’s JSON configuration, allowing you to enable the desired provider and set required credentials.

Asked by Stella Papadopoulos · Jun 21, 2025