a year ago
research-and-dataa readonly clickhouse mcp server and ensure your ai use clickhouse safely
Overview
What is ClickHouse Readonly MCP?
ClickHouse Readonly MCP is a FastMCP server designed for executing read-only ClickHouse queries, ensuring safe usage of ClickHouse for AI applications.
How to use ClickHouse Readonly MCP?
To use ClickHouse Readonly MCP, install it via pip or from the source, and configure the connection settings in a JSON file. You can then execute read-only SQL queries through the MCP tool.
Key features of ClickHouse Readonly MCP?
- Executes read-only SQL queries securely.
- Input validation to ensure only SELECT, SHOW, DESCRIBE, and EXPLAIN operations are allowed.
- Supports both HTTP and native ClickHouse connections with automatic failover.
- Outputs results in a clean table format.
- Supports parameterized queries for flexible querying.
- High-performance query execution and result handling.
Use cases of ClickHouse Readonly MCP?
- Safely querying ClickHouse databases in AI applications.
- Performing analytics and reporting without modifying data.
- Integrating with Python applications for data retrieval.
FAQ from ClickHouse Readonly MCP?
- Can I execute write operations with ClickHouse Readonly MCP?
No, this server is designed exclusively for read-only operations to ensure data integrity.
- How do I install ClickHouse Readonly MCP?
You can install it using pip or by cloning the repository from GitHub.
- Is ClickHouse Readonly MCP suitable for production use?
Yes, it is designed for high performance and safe querying in production environments.