Clickhouse MCP Server provides a direct integration with ClickHouse databases, enabling AI assistants to execute SQL queries and connect to specific databases through a simple interface. Built by Burak Dirin, this Python-based implementation offers two main tools: 'connect_database' for establishing database connections and 'execute_query' for running SQL queries with results returned in JSON format. The server supports configuration through environment variables for connection settings and includes a read-only mode option for enhanced security. It's particularly valuable for workflows requiring data analysis, reporting, or exploration of information stored in ClickHouse databases without leaving the conversation interface.
Connects to a specific Clickhouse database. Parameters: database (string) - Name of the database to connect to. Returns a confirmation message when connection is successful.
Executes Clickhouse queries. Parameters: query (string) - SQL query/queries to execute. Returns query results in JSON format. Multiple queries can be sent separated by semicolons.
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AIOur bundler currently only supports TypeScript-based servers. Check back soon!