ClickHouse MCP Server

MCPOpen SourceApache-2.010.0

by Aenterhy • Data & Databases

An MCP server that facilitates safe execution of SQL queries on ClickHouse clusters.

Example Use Cases

1
Execute read-only SQL queries safely on ClickHouse clusters.
2
List and manage ClickHouse databases and tables.
3
A configurable MCP server for different ClickHouse environments.

Description

The ClickHouse MCP Server allows users to run SQL queries and manage databases on ClickHouse clusters safely with read-only access. It supports listing databases and tables, making it a powerful tool for managing ClickHouse environments. The server can be configured easily for local or cloud environments, providing flexibility in deployment.

Capabilities(3 total)

Tools (3)

list_databases

List available ClickHouse databases

list_tables

List available ClickHouse tables in a database, including schema, comment, row count, and column count. Args: database: The database to list tables from like: Optional LIKE pattern to filter table names not_like: Optional NOT LIKE pattern to exclude table names page_token: Token for pagination, obtained from a previous call page_size: Number of tables to return per page (default: 50) include_detailed_columns: Whether to include detailed column metadata (default: True). When False, the columns array will be empty but create_table_query still contains all column information. This reduces payload size for large schemas. Returns: A dictionary containing: - tables: List of table information (as dictionaries) - next_page_token: Token for the next page, or None if no more pages - total_tables: Total number of tables matching the filters

database:string*like:anynot_like:anypage_token:anypage_size:integerinclude_detailed_columns:boolean

run_select_query

Run a SELECT query in a ClickHouse database

query:string*

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C61/100

9/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities3 Tools / 0 Prompts / 0 Resources

OwnerAenterhy

CategoryData & Databases

DependenciesStandalone

Set Your Username