mcp-clickhouse

mcp-clickhouse

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

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

The ClickHouse MCP Server is a model context protocol server designed to interface with ClickHouse databases. It provides a secure and efficient way to execute SQL queries and manage databases and tables within a ClickHouse cluster. The server is configured to run queries in a read-only mode to ensure safety and prevent unauthorized data modifications. It supports integration with various platforms, including local development environments and cloud-based ClickHouse services. The server is highly configurable, allowing users to set environment variables for connection details, security settings, and timeouts. This flexibility makes it suitable for both development and production environments. Additionally, the server can be easily integrated into existing workflows using the Claude Desktop configuration, making it a versatile tool for developers and database administrators.

Features

  • Execute SQL queries on ClickHouse with read-only mode for safety.
  • List all databases within a ClickHouse cluster.
  • List all tables within a specified database.
0

Related MCP Servers

View all databases servers →
mcp-notion-server

mcp-notion-server

4.3

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.

databases
mcp-server-neon

mcp-server-neon

4.3

by neondatabase-labs

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

databases
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-server

mcp-server

3.9

by keboola

Keboola MCP Server connects AI agents and MCP clients to Keboola, enabling data access and transformations without glue code.

cloud_platforms
genai-toolbox

genai-toolbox

3.8

by googleapis

MCP Toolbox for Databases is an open source MCP server for databases, designed to simplify and secure the development of database tools.

databases
notion-mcp-server

notion-mcp-server

3.7

by makenotion

This project implements an MCP server for the Notion API, allowing integration with LLMs.

databases
supabase-mcp-server

supabase-mcp-server

3.7

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
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-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
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
mongodb-mcp-server

mongodb-mcp-server

3.7

by mongodb-js

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

databases
atlas-mcp-server

atlas-mcp-server

3.6

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
xiyan_mcp_server

xiyan_mcp_server

3.6

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.

databases
mcp-mongo-server

mcp-mongo-server

3.6

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.

databases
mcp-alchemy

mcp-alchemy

3.6

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
airtable-mcp-server

airtable-mcp-server

3.6

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
mongodb-lens

mongodb-lens

3.6

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.

databases
mcp-1panel

mcp-1panel

3.6

by 1Panel-dev

1Panel MCP Server is an implementation of the Model Context Protocol (MCP) server for 1Panel, providing a range of tools for system, website, certificate, application, and database management.

os_automation
prometheus-mcp-server

prometheus-mcp-server

3.6

by pab1it0

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

databases
mcp-redis

mcp-redis

3.6

by redis

The Redis MCP Server is a natural language interface designed for agentic applications to efficiently manage and search data in Redis.

databases
firebase-mcp

firebase-mcp

3.6

by gannonh

Firebase MCP enables AI assistants to work directly with Firebase services, including Firestore, Storage, and Authentication.

databases
mcp-pinecone

mcp-pinecone

3.6

by sirmews

The Pinecone Model Context Protocol Server for Claude Desktop allows users to read and write to a Pinecone index, facilitating operations like semantic search and document processing.

databases
mcp-server-duckdb

mcp-server-duckdb

3.6

by ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities through MCP tools.

databases
mssql_mcp_server

mssql_mcp_server

3.6

by RichardHan

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

databases
meilisearch-mcp

meilisearch-mcp

3.6

by meilisearch

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

databases
notion-mcp-server

notion-mcp-server

3.6

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.

ai_chatbot
mcp-server-aws

mcp-server-aws

3.6

by rishikavikondala

AWS MCP Server is a Model Context Protocol server implementation for AWS operations, supporting S3 and DynamoDB services.

cloud_platforms