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:)
wannabespace/conar
Conar is an AI-powered open-source tool designed to simplify interactions with multiple databases including PostgreSQL, MySQL, MSSQL, and Clickhouse. It is currently in beta and aims to provide intelligent assistance in writing and optimizing SQL queries through AI integration. Users can securely store their database connection information in the cloud with encrypted connection strings and password protection, ensuring data security. The project supports multiple databases with PostgreSQL as the primary focus, while support for others like MySQL and MongoDB is either available or forthcoming. The tool features a modern tech stack including React with TypeScript, Electron for desktop application capabilities, TailwindCSS for styling, and various libraries and frameworks such as Vite, TanStack, Drizzle ORM, and others to enhance development efficiency and user experience. It integrates AI SDKs from providers like Anthropic, OpenAI, Gemini, and XAI to power its intelligent SQL assistance features. Conar offers a secure and open environment for database management, emphasizing encrypted storage of connection strings and password protection. It supports multiple databases, making it versatile for different user needs. The AI-powered features help users by generating and optimizing SQL queries, potentially improving productivity and reducing errors in database operations. The project provides clear instructions for development setup, including package installation, starting databases with Docker Compose, preparing the database schema with migrations, and running the project in development mode. It also includes testing capabilities with unit and end-to-end tests to ensure reliability and quality. Overall, Conar is a promising tool for developers and database administrators looking for AI-enhanced database interaction across several popular database systems, including Clickhouse, with a focus on security, usability, and open-source collaboration.
https://github.com/wannabespace/conar
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.
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.