ClickHouse

About

ClickHouse bridges the gap between Claude and ClickHouse databases by providing an MCP (Meta-Control Protocol) server interface. It allows Claude users to execute SQL queries, list available databases, and explore tables within those databases, enhancing the accessibility and usability of ClickHouse data within the Claude environment. The server emphasizes security by enforcing read-only queries, and provides configurable environment variables for customized database connections. Easily connect to your ClickHouse instance, or use the ClickHouse SQL Playground to explore data.

Key Features

• List all databases present on the ClickHouse cluster.
• 0 GitHub stars
• Configurable connection parameters via environment variables.
• Execute SQL queries on ClickHouse with read-only restrictions for safety.
• Supports secure (HTTPS) and non-secure connections.
• List all tables within a specified database.

Use Cases

• Querying ClickHouse databases from Claude.
• Integrating ClickHouse data insights into Claude workflows.
• Exploring ClickHouse schema and data from within Claude.