{"library":"mcp-clickhouse","title":"MCP ClickHouse Server","description":"An MCP server for ClickHouse. This library provides a FastAPI-based application that allows configuration of a ClickHouse database via MCP (Mediation Control Plane) and fetches data using a REST API. It is currently at version 0.3.0 and typically follows an iterative release cadence with feature additions and bug fixes.","language":"python","status":"active","last_verified":"Fri Apr 17","install":{"commands":["pip install mcp-clickhouse"],"cli":{"name":"mcp-clickhouse","version":"/usr/local/lib/python3.11/site-packages/fastmcp/server/auth/providers/jwt.py:10: AuthlibDeprecationWarning: authlib.jose module is deprecated, please use joserfc instead."}},"imports":["from mcp_clickhouse.server.main import app"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import uvicorn\nimport os\nfrom mcp_clickhouse.server.main import app\n\n# Set required environment variables for ClickHouse connection\n# In a real scenario, you would provide actual credentials or use a .env file.\nos.environ['MCP_CLICKHOUSE_DB_URL'] = os.environ.get('MCP_CLICKHOUSE_DB_URL', 'clickhouse://user:password@localhost:8123/default')\n\nif __name__ == \"__main__\":\n    print(f\"Starting MCP ClickHouse server on http://0.0.0.0:8000\")\n    print(f\"Using ClickHouse DB URL: {os.environ['MCP_CLICKHOUSE_DB_URL']}\")\n    uvicorn.run(app, host=\"0.0.0.0\", port=8000)","lang":"python","description":"This quickstart demonstrates how to programmatically run the MCP ClickHouse server using uvicorn. Note that `MCP_CLICKHOUSE_DB_URL` must be set for the server to function correctly. After running, you can access the API at `http://localhost:8000` (e.g., `http://localhost:8000/health`). For typical use, the CLI command `mcp-clickhouse start` is also available after installation.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}