{"passport":{"unfragile":{"@version":"1.0","version":"2026-05","artifact":{"id":"clickhouse-mcp-server","slug":"clickhouse-mcp-server","name":"ClickHouse MCP Server","type":"mcp","url":"https://github.com/ClickHouse/mcp-clickhouse","page_url":"https://unfragile.ai/clickhouse-mcp-server","categories":["mcp-servers","data-analysis"],"tags":["mcp","clickhouse","sql","analytics","olap","official"],"pricing":{"model":"free","free":true,"starting_price":null},"status":"active","verified":false},"capabilities":[{"id":"clickhouse-mcp-server__cap_1","uri":"capability://mcp.servers.overview","name":"overview","description":"ClickHouse/mcp-clickhouse | DeepWiki \n Loading...\n\n \n Index your code with Devin \n DeepWiki DeepWiki ClickHouse/mcp-clickhouse \n\n Index your code with \n\n Devin \n Edit Wiki Share \n\n Loading...\n\n \n\n Last indexed: 26 April 2025 ( d42bc1 )\n\n Overview \n System Architecture \n Dependencies and Requirements \n Core Components \n MCP Server \n Configuration System \n ClickHouse Tools \n Database and Table Listing \n Query Execution \n Setup and Usage \n Installation \n Configuration \n Integration with Claude Desktop \n Development Guide \n Testing \n CI/CD Pipeline \n Code Style and Standards \n \n\n Menu \n\n Overview \n\n \n Relevant source files \n \n README.md \n\n mcp_clickhouse/mcp_server.py \n\n pyproject.toml \n\n \n \n This document provides a comprehensive introduction to the mcp-clickhouse repository, which implements a FastMCP server that provides read-only access to ClickHouse databases. This system enables applications like Claude Desktop to interact with ClickHouse databases in a controlled, secure manner without requiring direct database connection handling in those applications.\n\n For detailed setup instructions, see Setup and Usage , and for integration with Claude Desktop specifically, see Integration with Claude Desktop .\n\n Key Purpose and Features \n\n mcp-clickhouse serves as a bridge between client applications and ClickHouse databases, providing three primary capabilities:\n\n \n Database Listing : Retrieve a list of all available databases in the ClickHouse instance\n\n Table Information : Get det","intents":[],"best_for":[],"limitations":[],"requires":[],"input_types":[],"output_types":[],"categories":["mcp-servers","data-analysis"],"confidence":0.5,"matches":0,"success_rate":0},{"id":"clickhouse-mcp-server__cap_2","uri":"capability://mcp.servers.1.1.system.architecture","name":"1.1 system architecture","description":"System Architecture | ClickHouse/mcp-clickhouse | DeepWiki \n Loading...\n\n \n Index your code with Devin \n DeepWiki DeepWiki ClickHouse/mcp-clickhouse \n\n Index your code with \n\n Devin \n Edit Wiki Share \n\n Loading...\n\n \n\n Last indexed: 26 April 2025 ( d42bc1 )\n\n Overview \n System Architecture \n Dependencies and Requirements \n Core Components \n MCP Server \n Configuration System \n ClickHouse Tools \n Database and Table Listing \n Query Execution \n Setup and Usage \n Installation \n Configuration \n Integration with Claude Desktop \n Development Guide \n Testing \n CI/CD Pipeline \n Code Style and Standards \n \n\n Menu \n\n System Architecture \n\n \n Relevant source files \n \n mcp_clickhouse/__init__.py \n\n mcp_clickhouse/main.py \n\n mcp_clickhouse/mcp_server.py \n\n \n \n This document describes the architectural design and components of the mcp-clickhouse system. It outlines the high-level structure, component relationships, data flow, and execution patterns of the system. For information on dependencies and requirements, see Dependencies and Requirements .\n\n Overview \n\n The mcp-clickhouse system is designed to provide a secure, read-only interface to ClickHouse databases through a FastMCP server. It offers tools for database exploration and query execution while maintaining strict security controls.\n\n \n Sources: mcp_clickhouse/mcp_server.py 1-229 mcp_clickhouse/__init__.py 1-13 mcp_clickhouse/main.py 1-10 \n\n Core Components \n\n The system consists of several key components that work together to provid","intents":[],"best_for":[],"limitations":[],"requires":[],"input_types":[],"output_types":[],"categories":["mcp-servers","data-analysis"],"confidence":0.5,"matches":0,"success_rate":0},{"id":"clickhouse-mcp-server__cap_3","uri":"capability://mcp.servers.core.components","name":"core components","description":"Core Components | ClickHouse/mcp-clickhouse | DeepWiki \n Loading...\n\n \n Index your code with Devin \n DeepWiki DeepWiki ClickHouse/mcp-clickhouse \n\n Index your code with \n\n Devin \n Edit Wiki Share \n\n Loading...\n\n \n\n Last indexed: 26 April 2025 ( d42bc1 )\n\n Overview \n System Architecture \n Dependencies and Requirements \n Core Components \n MCP Server \n Configuration System \n ClickHouse Tools \n Database and Table Listing \n Query Execution \n Setup and Usage \n Installation \n Configuration \n Integration with Claude Desktop \n Development Guide \n Testing \n CI/CD Pipeline \n Code Style and Standards \n \n\n Menu \n\n Core Components \n\n \n Relevant source files \n \n mcp_clickhouse/mcp_env.py \n\n mcp_clickhouse/mcp_server.py \n\n \n \n This document provides detailed information about the main components that make up the mcp-clickhouse system. It covers the architectural structure, functional elements, and how they interact to provide a simplified interface for ClickHouse database operations. For information about how to set up and use these components, see Setup and Usage .\n\n Component Overview \n\n The mcp-clickhouse system consists of several core components that work together to provide secure, read-only access to ClickHouse databases.\n\n \n Sources: mcp_clickhouse/mcp_server.py 34-151 mcp_clickhouse/mcp_env.py 12-137 \n\n Key Components and Their Functions \n\n The mcp-clickhouse system contains the following key components:\n\n Component Description Implementation FastMCP Server The server that exposes t","intents":[],"best_for":[],"limitations":[],"requires":[],"input_types":[],"output_types":[],"categories":["mcp-servers","data-analysis"],"confidence":0.5,"matches":0,"success_rate":0},{"id":"clickhouse-mcp-server__headline","uri":"capability://mcp.servers.clickhouse.mcp.server","name":"ClickHouse MCP Server","description":"ClickHouse/mcp-clickhouse | DeepWiki \n Loading...\n\n \n Index your code with Devin \n DeepWiki DeepWiki ClickHouse/mcp-clickhouse \n\n Index your code with \n\n Devin \n Edit Wiki Share \n\n Loading...\n\n \n\n Last indexed: 26 April 2025 ( d42bc1 )\n\n Overview \n System Architecture \n Dependencies and Requirements \n Core Components \n MCP Server \n Configuration System \n ClickHouse Tools \n Database and Table Listing \n Query Execution \n Setup and Usage \n Installation \n Configuration \n Integration with Claude Desktop \n Development Guide \n Testing \n CI/CD Pipeline \n Code Style and Standards \n \n\n Menu \n\n Overview \n\n \n Relevant source files \n \n README.md \n\n mcp_clickhouse/mcp_server.py \n\n pyproject.toml \n\n \n \n This document provides a comprehensive introduction to the mcp-clickhouse repository, which implements a FastMCP server that provides read-only access to ClickHouse databases. This system enables applications like Claude Desktop to interact with ClickHouse databases in a controlled, secure manner without requiring direct database connection handling in those applications.\n\n For detailed setup instructions, see Setup and Usage , and for integration with Claude Desktop specifically, see Integration ","intents":[],"best_for":[],"limitations":[],"requires":[],"input_types":[],"output_types":[],"categories":["mcp-servers","data-analysis"],"confidence":0.5,"matches":0,"success_rate":0}],"trust":{"score":56,"verified":false,"data_access_risk":"high","permissions":["MCP client access","configured credentials for target service"],"failure_modes":["builder identity is not verified yet","no observed match outcomes yet"],"rank_breakdown":{"adoption":0.30973115561559916,"quality":0.8,"ecosystem":0.68,"match_graph":0.25,"freshness":1,"weights":{"adoption":0.25,"quality":0.25,"ecosystem":0.15,"match_graph":0.23,"freshness":0.12}},"observed_outcomes":{"matches":0,"success_rate":0,"avg_confidence":0,"top_intents":[],"last_matched_at":null},"maintenance":{"status":"active","updated_at":"2026-06-11T11:43:36.300Z","last_scraped_at":null,"last_commit":null},"community":{"stars":800,"forks":null,"weekly_downloads":null,"model_downloads":null,"model_likes":null}},"distribution":{"claim_url":"https://unfragile.ai/submit?claim=clickhouse-mcp-server","compare_url":"https://unfragile.ai/compare?artifact=clickhouse-mcp-server"}},"signature":"eLQlbmc8dAzicYTpo+dfqia+sxGb8TO3PeZSmP11r46Gmc7J1zPAXMph/momuasUmNhLvRsMbWhrAffy2xn3BA==","signedAt":"2026-06-15T05:32:01.709Z","signedBy":"unfragile.ai","version":1},"_links":{"self":"https://unfragile.ai/api/v1/passport/clickhouse-mcp-server","artifact":"https://unfragile.ai/clickhouse-mcp-server","verify":"https://unfragile.ai/api/v1/verify?slug=clickhouse-mcp-server","publicKey":"https://unfragile.ai/api/v1/trust-passport-public-key","spec":"https://unfragile.ai/trust","schema":"https://unfragile.ai/schema.json","docs":"https://unfragile.ai/docs"}}