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:)
clidey/whodb
WhoDB is a lightweight, next-generation database management and exploration tool designed to simplify and enhance the experience of working with multiple types of databases. It supports a broad range of databases including PostgreSQL, MySQL, SQLite, MongoDB, Redis, MariaDB, ElasticSearch, and notably Clickhouse, making it a versatile solution for various database environments. The tool is built with GoLang, ensuring high performance and efficiency, and features a clean, intuitive user interface that improves usability and navigation. One of the standout features of WhoDB is its natural language chat interface, which integrates with AI models like Ollama, ChatGPT, and Anthropic. This allows users to interact with their data conversationally, bypassing the need to write complex SQL queries. This conversational capability makes database querying and management accessible to users who may not be proficient in SQL. WhoDB also offers interactive schema visualization, enabling users to see and understand the structure of their databases through graphical representations. Inline editing and preview features allow for direct manipulation of data within the interface, streamlining workflows. Additionally, the tool includes a scratchpad feature similar to a Jupyter notebook, where users can perform and test database queries in an interactive environment. The project supports easy deployment through Docker and Docker Compose, facilitating quick setup and use. It is suitable for both small projects and complex enterprise systems, providing a lightweight yet powerful alternative to heavier database management tools like DBeaver. The project is actively maintained with a focus on performance, user experience, and broad database compatibility. Overall, WhoDB is designed to be a fast, user-friendly, and intelligent database explorer that leverages modern AI technologies to make database management more accessible and efficient.
https://github.com/clidey/whodb
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.
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.
ClickHouse/mcp-clickhouse
ClickHouse MCP Server is a secure MCP server enabling read-only SQL query execution and database management operations on ClickHouse clusters.
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.