mcp-clickhouse

3.3

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 henry@mcphub.com.

An MCP server for ClickHouse.

The ClickHouse MCP Server is a specialized server designed to facilitate interaction with ClickHouse databases using the Model Context Protocol (MCP). It provides a set of tools that allow users to execute SQL queries, list databases, and list tables within a ClickHouse cluster. The server is configured to ensure that all queries are executed in a read-only mode, enhancing security and preventing unintended data modifications. The server is currently in a transitional phase, with improvements to the configuration process expected in future updates.

Features

run_select_query: Execute SQL queries on your ClickHouse cluster with read-only permissions.
list_databases: List all databases on your ClickHouse cluster.
list_tables: List all tables in a specified database.

Tools

run_select_query
Execute SQL queries on your ClickHouse cluster.
list_databases
List all databases on your ClickHouse cluster.
list_tables
List all tables in a database.

Related MCP Servers

View all databases servers →

mysql_mcp_server

by designcomputer

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

pg-mcp-server

by stuzero

unknown

mcp-notion-server

by suekou

MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.

mcp-server-neon

by neondatabase-labs

Neon MCP Server is an open-source tool that enables natural language interaction with Neon Postgres databases.

gateway

by centralmind

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

supabase-mcp

by supabase-community

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

mcp-server-qdrant

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

anyquery

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.

mcp-server-mysql

by benborla

A Model Context Protocol server for MySQL databases using NodeJS, enabling LLMs to inspect schemas and execute SQL queries.

supabase-mcp-server

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.

chroma-mcp

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.

atlas-mcp-server

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

mcp-server-milvus

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.

mcp-graphql

by blurrah

A Model Context Protocol server that enables LLMs to interact with GraphQL APIs, providing schema introspection and query execution capabilities.

xiyan_mcp_server

by XGenerationLab

XiYan MCP Server is a Model Context Protocol server that enables natural language queries to databases, powered by XiYan-SQL, a state-of-the-art text-to-SQL model.

mcp-mongo-server

by kiliczsh

A Model Context Protocol server that enables LLMs to interact with MongoDB databases, providing capabilities for inspecting collection schemas and executing MongoDB operations through a standardized interface.

mongodb-lens

by furey

MongoDB Lens is a local Model Context Protocol (MCP) server that provides full-featured access to MongoDB databases using natural language via LLMs.

mcp-alchemy

by runekaagaard

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

mongo-mcp

by QuantGeekDev

A Model Context Protocol (MCP) server that enables LLMs to interact directly with MongoDB databases. Query collections, inspect schemas, and manage data seamlessly through natural language.

mcp-server-weaviate

by weaviate

Weaviate MCP Server is a protocol server designed to interact with the Weaviate vector database, providing functionalities for inserting and querying data.

postg-mem

by dariogriffo

PostgMem is a .NET-based MCP server that provides vector memory storage using PostgreSQL and pgvector for AI applications.

prometheus-mcp-server

by pab1it0

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

mssql_mcp_server

by RichardHan

A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases.

postgres-mcp-server

by aadarshjain

A Model Context Protocol (MCP) server implementation for PostgreSQL database exploration and querying.

meilisearch-mcp

by meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces like Claude.

notion-mcp-server

by awkoy

Notion MCP Server is a Model Context Protocol server implementation that enables AI assistants to interact with Notion's API, providing tools for reading, creating, and modifying Notion content through natural language interactions.

mcp-mysql-server

by f4ww4z

A Model Context Protocol server that provides MySQL database operations, enabling AI models to interact with MySQL databases through a standardized interface.