mcp-clickhouse

ClickHouse/mcp-clickhouse

4.3
databases

If you are the rightful owner of mcp-clickhouse and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

An MCP server for ClickHouse that allows executing SQL queries and managing databases and tables.

Tools

Functions exposed to the LLM to take actions

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

run_select_query

Run a SELECT query in a ClickHouse database

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Related MCP Servers

View all databases servers →
dbhub

dbhub

4.6

by bytebase

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface.

databases
mindsdb

mindsdb

4.6

by mindsdb

MindsDB is an open-source server that enables seamless interaction with large-scale federated data using the Model Context Protocol (MCP).

databases
mcp-alchemy

mcp-alchemy

4.4

by runekaagaard

MCP Alchemy is a model context protocol server that connects Claude Desktop to various databases, enabling advanced database exploration and query execution.

databases
pg-mcp-server

pg-mcp-server

4.4

by stuzero

unknown

databases
supabase-mcp

supabase-mcp

4.3

by supabase-community

Connect your Supabase projects to AI assistants using the Model Context Protocol (MCP) server.

databases
mongodb-mcp-server

mongodb-mcp-server

4.2

by mongodb-js

A Model Context Protocol server for interacting with MongoDB Databases and MongoDB Atlas.

databases
python-mcp-server-client

python-mcp-server-client

4.2

by GobinFan

MCP Server is a server implementing the Model Context Protocol (MCP) to provide a standardized interface for AI models, connecting external data sources and tools like file systems, databases, or APIs.

ai_chatbot
mcp-server-qdrant

mcp-server-qdrant

4.1

by qdrant

The mcp-server-qdrant is a Model Context Protocol server designed to integrate with the Qdrant vector search engine, providing a semantic memory layer for storing and retrieving information.

knowledge_and_memory
prisma

prisma

4.1

by prisma

Prisma is a next-generation ORM for Node.js and TypeScript, providing tools for data modeling, migrations, and querying databases.

databases
mcp-memory-libsql

mcp-memory-libsql

4.0

by spences10

A high-performance, persistent memory system for the Model Context Protocol (MCP) powered by libSQL, providing vector search capabilities and efficient knowledge storage.

knowledge_and_memory
supabase-mcp-server

supabase-mcp-server

4.0

by alexander-zuev

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

databases
gateway

gateway

4.0

by centralmind

CentralMind Gateway is a tool designed to expose databases to AI agents via MCP or OpenAPI protocols, providing secure, LLM-optimized APIs.

databases
mysql_mcp_server_pro

mysql_mcp_server_pro

4.0

by wenb1n-dev

mcp_mysql_server_pro is a comprehensive MySQL server tool that extends beyond basic CRUD operations to include database anomaly analysis and custom tool extensions.

databases
doris-mcp-server

doris-mcp-server

3.9

by apache

Doris MCP Server is a backend service built with Python and FastAPI, designed to connect to Apache Doris databases and potentially leverage LLMs for tasks like NL2SQL.

databases
postgresql-mcp-server

postgresql-mcp-server

3.9

by HenkDz

A Model Context Protocol (MCP) server that provides comprehensive PostgreSQL database management capabilities for AI assistants.

databases
mcp-databricks-server

mcp-databricks-server

3.8

by RafaelCartenet

This is a Model Context Protocol (MCP) server for executing SQL queries against Databricks using the Statement Execution API.

databases
mcp-proxy

mcp-proxy

3.7

by tbxark

An MCP proxy server that aggregates and serves multiple MCP resource servers through a single HTTP server.

databases
chroma-mcp

chroma-mcp

3.7

by chroma-core

Chroma MCP Server is an open-source embedding database server that facilitates the integration of LLM applications with external data sources using the Model Context Protocol.

databases
anyquery

anyquery

3.7

by julien040

Anyquery is a versatile SQL query engine that allows users to run SQL queries on various data sources, including files, databases, and applications, with support for LLMs and MySQL server functionality.

databases
mcp-kql-server

mcp-kql-server

3.7

by 4R9UN

A Model Context Protocol (MCP) server for executing Kusto Query Language (KQL) queries against Azure Data Explorer clusters.

databases
mcp-server-elasticsearch

mcp-server-elasticsearch

3.7

by elastic

This server connects agents to your Elasticsearch data using the Model Context Protocol, allowing interaction with Elasticsearch indices through natural language conversations.

databases
atlas-mcp-server

atlas-mcp-server

3.7

by cyanheads

ATLAS (Adaptive Task & Logic Automation System) is a project, knowledge, and task management system for LLM Agents, implemented as a Model Context Protocol (MCP) server.

developer_tools
airtable-mcp-server

airtable-mcp-server

3.7

by domdomegg

A Model Context Protocol server that provides read and write access to Airtable databases, enabling LLMs to inspect database schemas and manage records.

databases
prometheus-mcp-server

prometheus-mcp-server

3.7

by pab1it0

A Model Context Protocol (MCP) server for Prometheus, enabling access to Prometheus metrics and queries through standardized MCP interfaces.

databases
mariadb-mcp-server

mariadb-mcp-server

3.7

by rjsalgado

This MCP server provides access to MariaDB / MySQL databases, allowing users to list databases, tables, describe table schemas, and execute SQL queries with security features.

databases
mcp-server-milvus

mcp-server-milvus

3.6

by zilliztech

The MCP Server for Milvus enables seamless integration between LLM applications and the Milvus vector database, providing a standardized way to connect LLMs with the context they need.

databases
mcp-database-server

mcp-database-server

3.6

by executeautomation

The MCP Database Server provides database access capabilities to Claude, supporting SQLite, SQL Server, and PostgreSQL databases.

databases