mcp-clickhouse
323
ClickHouse MCP Server is a model context protocol server specifically for ClickHouse, allowing for executing secure SQL queries and managing databases easily. It is configurable to work both locally and with cloud setups, providing streamlined operations for developers.
ClickHouse MCP Server
An MCP server designed for ClickHouse, providing tools for executing SQL queries, listing databases, and listing tables using a secure and configured environment. Simplifies database operations by exposing a set of functional tools for interaction with ClickHouse.
Features
- Execute safe SQL queries on ClickHouse with read-only operations.
- List all databases and specific tables within a database.
Configuration
- Supports configuration through environment variables for connecting to ClickHouse.
- Examples provided for local development and cloud setup.
Development
- Setup guidance for running a development environment using Docker and configuring env files.
- Instructions for running tests and ensuring a secure environment.
Environment Variables
- Detailed configuration options for required and optional variables including host, user authentication, and timeout settings.