Server spec
- Install
- See source repository
- Transport
- stdio
- Auth
- Not publicly specified
- Language
- Not publicly specified
- Tools exposed
- 6
- Official
- Community
The ClickHouse MCP server facilitates interactions between an AI agent and a ClickHouse database. It provides a structured way for the agent to execute queries and retrieve data, leveraging ClickHouse’s well-known capabilities for handling large-scale analytical workloads. This server is primarily useful for developers and data teams who need to automate or enhance their data querying workflows through AI agents.
Tools exposed
query_databaselist_tablesexecute_sqlfetch_schemamonitor_queriesoptimize_query
Resources
databasestablesschemasquery_results
Requirements
- ClickHouse server
- Network access to ClickHouse instance
- ClickHouse client libraries
Use cases
Retrieve structured data for analysisPerform complex SQL queries via an AI agentMonitor database performance and query executionAutomate data extraction and transformation tasks
Pros & cons
Pros
- High-performance querying for large datasets
- Integrates with ClickHouse's columnar storage engine
- Supports complex analytical queries
Cons
- Limited to ClickHouse database ecosystems
- May require optimization for specific query patterns
Related MCP servers
Compare ClickHouse
Explore the source
ClickHouse