Interact with ClickHouse databases through the Model Context Protocol
Best for Enabling AI agents to perform ad-hoc data analysis on production ClickHouse clusters.
A Model Context Protocol (MCP) server that provides tools for interacting with ClickHouse® databases. This server enables AI assistants and other MCP clients to query, analyze, and interact with ClickHouse® databases through a standardized protocol.
What it does
- Support for STDIO, HTTP, and SSE transport protocols
- OAuth 2.0 and JWE-based authentication support
- Automatic generation of MCP tools from ClickHouse views
- Dynamic resource discovery for database schemas
- TLS encryption for secure database and server connections
Setup requirements
Requires 3 environment variables: CLICKHOUSE_HOST, MCP_TRANSPORT, MCP_PORT. Available via Docker and Helm and Source.
View Altinity MCP details vs
Full-featured MCP server for Apache Superset with 128+ tools
Best for Automating the creation and deployment of BI dashboards for new projects.
A comprehensive Model Context Protocol (MCP) server for Apache Superset. Gives AI assistants (Claude, GPT, etc.) full control over your Superset instance — dashboards, charts, datasets, SQL Lab, users, roles, RLS, and more — through 128+ tools.
What it does
- 128+ MCP tools covering the complete Superset REST API
- Full security management including users, roles, RLS, and groups
- Built-in safety validations with confirmation flags and DDL/DML blocking
- Dashboard native filter management and automatic datasource access synchronization
- Support for multiple transport options including HTTP, SSE, and stdio
Setup requirements
Requires 3 environment variables: SUPERSET_URL, SUPERSET_USERNAME, SUPERSET_PASSWORD. Available via uvx and pip.
View Apache Superset details Biggest differences
CompareAltinity MCPApache Superset
Best forEnabling AI agents to perform ad-hoc data analysis on production ClickHouse clusters.Automating the creation and deployment of BI dashboards for new projects.
StandoutSupport for STDIO, HTTP, and SSE transport protocols.128+ MCP tools covering the complete Superset REST API.
SetupDocker or Helm, needs 3 env vars, stdio transport.uvx or pip, needs 3 env vars, http transport.
Transportstdiohttp
Community23 GitHub stars21 GitHub stars
Bottom line
Pick Altinity MCP if...Enabling AI agents to perform ad-hoc data analysis on production ClickHouse clusters. Support for STDIO, HTTP, and SSE transport protocols. Docker or Helm, needs 3 env vars, stdio transport.
Pick Apache Superset if...Automating the creation and deployment of BI dashboards for new projects. 128+ MCP tools covering the complete Superset REST API. uvx or pip, needs 3 env vars, http transport.
The real split here is workflow fit, not raw counts. Altinity MCP: Enabling AI agents to perform ad-hoc data analysis on production ClickHouse clusters. Apache Superset: Automating the creation and deployment of BI dashboards for new projects. Public traction is fairly close (23 vs 21 stars).