akworob/clickhouse-mcp-server
If you are the rightful owner of clickhouse-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
A comprehensive Model Context Protocol (MCP) server for interacting with ClickHouse databases, providing tools for database exploration, query execution, schema management, and performance monitoring.
Tools
Functions exposed to the LLM to take actions
clickhouse_list_databases
List all databases with metadata.
clickhouse_list_tables
List tables in a specific database.
clickhouse_get_table_schema
Get detailed schema information for a table.
clickhouse_execute_query
Execute SQL queries with optional parameters.
clickhouse_get_database_stats
Get comprehensive statistics about a database.
clickhouse_search_tables
Search for tables matching a pattern.
clickhouse_get_system_metrics
Get current system metrics and performance indicators.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client