Chmcp
Enables comprehensive database operations and cloud management for ClickHouse via a Model Context Protocol (MCP) server.
概要
Chmcp serves as an advanced Model Context Protocol (MCP) server specifically designed for ClickHouse, vastly expanding capabilities beyond basic database interactions. This production-ready solution facilitates both on-premise ClickHouse database operations and complete management of ClickHouse Cloud. By integrating 100% of the official ClickHouse Cloud API, it provides a comprehensive suite of over 50 tools for managing organizations, services, API keys, members, backups, and more, offering deep integration possibilities with large language models and other automated systems.
主な機能
- Comprehensive ClickHouse Cloud API Integration (50+ management tools)
- Advanced ClickHouse Cloud features like ClickPipes and Reverse Private Endpoints management
- Enhanced Database Operations (list databases/tables, run SELECT queries with safety guarantees)
- Production-Ready (robust error handling, SSL support, detailed configuration)
- Management of ClickHouse organizations, services, API keys, members, and invitations
- 3 GitHub stars
ユースケース
- Performing secure, read-only database operations on ClickHouse instances with enhanced metadata access.
- Integrating Large Language Models (LLMs) like Claude with ClickHouse for data querying and cloud resource management.
- Automating the provisioning, scaling, and management of ClickHouse Cloud services.