Canner/WrenAI
WrenAI is an open-source GenBI engine that empowers AI agents to generate, deploy, and govern trustworthy business intelligence dashboards and SQL across various data sources, including ClickHouse.
Awesome ClickHouse › CHUI(Chat-based User Interface) or CHUBACA(Chat-Based Client:)
ClickHouse/mcp-clickhouse
The ClickHouse MCP Server is a specialized MCP (Modular Control Protocol) server designed specifically for interacting with ClickHouse, a high-performance columnar database management system. This project provides a secure and efficient way to execute SQL queries on a ClickHouse cluster, ensuring that all queries are run in a read-only mode to maintain data safety and integrity. The server supports essential database operations such as running select queries, listing all databases, and listing tables within a specified database. This functionality is exposed through simple commands that can be integrated into other systems or used directly. Configuration of the MCP server involves setting environment variables that define the connection parameters to the ClickHouse service, including host, port, user credentials, and security options like HTTPS and SSL verification. The project supports both local development setups using Docker and remote connections to ClickHouse Cloud or the ClickHouse SQL Playground, making it versatile for different deployment scenarios. The README provides detailed instructions for setting up the server, including how to configure the Claude Desktop application to use the MCP server, how to start a local ClickHouse cluster for development, and how to manage dependencies and environment variables. It emphasizes security best practices by advising minimal privilege usage for the MCP database user. Overall, this project facilitates seamless and secure interaction with ClickHouse databases through an MCP server interface, making it easier for developers and administrators to manage and query their ClickHouse data environments efficiently. It is particularly useful for those who want to integrate ClickHouse querying capabilities into applications or workflows that support MCP servers.
https://github.com/ClickHouse/mcp-clickhouse
Also in CHUI(Chat-based User Interface) or CHUBACA(Chat-Based Client:)
googleapis/mcp-toolbox
MCP Toolbox is an open-source Model Context Protocol server that connects AI agents, IDEs, and applications directly to various enterprise databases, including ClickHouse, for data interaction and ...
sqlchat/sqlchat
SQL Chat is a chat-based SQL client that uses natural language to interact with databases, supporting multiple database types and offering both hosted and self-hosted options for intuitive database management.
clidey/whodb
WhoDB is a lightweight, high-performance database management tool supporting multiple databases including Clickhouse, featuring a natural language chat interface for intuitive data interaction.
wannabespace/conar
Conar is an AI-powered open-source tool that simplifies and secures interactions with multiple databases including PostgreSQL, MySQL, MSSQL, and Clickhouse by providing intelligent SQL query assistance and optimization.
centralmind/gateway
CentralMind Gateway is a universal MCP-Server that automatically generates secure, LLM-optimized APIs for multiple structured databases including ClickHouse, enabling AI agents to access data efficiently and compliantly.
Guepard-Corp/qwery-core
Qwery is a versatile data querying and visualization platform that enables natural language queries across multiple databases including ClickHouse, supported by AI agents and available as both desktop and cloud applications.