[{"_1":2,"_309":-5,"_310":-5},"loaderData",{"_3":4,"_20":21,"_22":23,"_24":25,"_253":254},"root",{"_5":6,"_7":8},"toasts",[],"visitor",{"_9":10,"_11":12},"viewportWidth",1280,"visitorSession",{"_13":14,"_16":-5,"_17":18,"_19":-5},"attributes",[15],"BOT","membership","uid","CH5zfJ6DeT","userAccount","routes/_public/_layout",{},"routes/_public/mcp/servers/~namespace/_layout",{},"routes/_public/mcp/servers/~namespace/~slug/_pages/_layout",{"_26":-5,"_27":28,"_29":30,"_172":173},"githubUser","maintainer",false,"mcpServer",{"_31":32,"_33":34,"_13":55,"_63":64,"_65":64,"_66":67,"_72":73,"_96":-5,"_97":98,"_99":100,"_101":102,"_82":83,"_112":87,"_113":-5,"_114":-5,"_115":116,"_117":118,"_125":-5,"_126":127,"_132":-5,"_108":83,"_133":134,"_137":138,"_17":169,"_170":171},"addedAt",["D",1736303855959],"argumentsJsonSchema",{"_35":36,"_52":53,"_41":54},"properties",{"_37":38,"_43":44,"_46":47,"_49":50},"CLICKHOUSE_HOST",{"_39":40,"_41":42},"description","The host address of the ClickHouse server","type","string","CLICKHOUSE_PORT",{"_39":45,"_41":42},"The port number of the ClickHouse server","CLICKHOUSE_USER",{"_39":48,"_41":42},"The username to connect to the ClickHouse server","CLICKHOUSE_PASSWORD",{"_39":51,"_41":42},"The password to connect to the ClickHouse server","required",[37,43,46,49],"object",[56,57,58,59,60,61,62],"category:databases","author:official","hosting:remote-capable","language:python","security_grade:a","quality_grade:a","license_grade:a","descriptionMarkdown","ClickHouse database integration with schema inspection and query capabilities","descriptionPlainText","githubProject",{"_68":69,"_70":71},"readme","# ClickHouse MCP Server\n[![PyPI - Version](https://img.shields.io/pypi/v/mcp-clickhouse)](https://pypi.org/project/mcp-clickhouse)\n\nAn MCP server for ClickHouse.\n\n $\"mcp-clickhouse$ \n\n## Features\n\n### Tools\n\n* `run_select_query`\n - Execute SQL queries on your ClickHouse cluster.\n - Input: `sql` (string): The SQL query to execute.\n - All ClickHouse queries are run with `readonly = 1` to ensure they are safe.\n\n* `list_databases`\n - List all databases on your ClickHouse cluster.\n\n* `list_tables`\n - List all tables in a database.\n - Input: `database` (string): The name of the database.\n\n## Configuration\n\n1. Open the Claude Desktop configuration file located at:\n - On macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`\n - On Windows: `%APPDATA%/Claude/claude_desktop_config.json`\n\n2. Add the following:\n\n```json\n{\n \"mcpServers\": {\n \"mcp-clickhouse\": {\n \"command\": \"uv\",\n \"args\": [\n \"run\",\n \"--with\",\n \"mcp-clickhouse\",\n \"--python\",\n \"3.13\",\n \"mcp-clickhouse\"\n ],\n \"env\": {\n \"CLICKHOUSE_HOST\": \"\",\n \"CLICKHOUSE_PORT\": \"\",\n \"CLICKHOUSE_USER\": \"\",\n \"CLICKHOUSE_PASSWORD\": \"\",\n \"CLICKHOUSE_SECURE\": \"true\",\n \"CLICKHOUSE_VERIFY\": \"true\",\n \"CLICKHOUSE_CONNECT_TIMEOUT\": \"30\",\n \"CLICKHOUSE_SEND_RECEIVE_TIMEOUT\": \"30\"\n }\n }\n }\n}\n```\n\nUpdate the environment variables to point to your own ClickHouse service.\n\nOr, if you'd like to try it out with the [ClickHouse SQL Playground](https://sql.clickhouse.com/), you can use the following config:\n\n```json\n{\n \"mcpServers\": {\n \"mcp-clickhouse\": {\n \"command\": \"uv\",\n \"args\": [\n \"run\",\n \"--with\",\n \"mcp-clickhouse\",\n \"--python\",\n \"3.13\",\n \"mcp-clickhouse\"\n ],\n \"env\": {\n \"CLICKHOUSE_HOST\": \"sql-clickhouse.clickhouse.com\",\n \"CLICKHOUSE_PORT\": \"8443\",\n \"CLICKHOUSE_USER\": \"demo\",\n \"CLICKHOUSE_PASSWORD\": \"\",\n \"CLICKHOUSE_SECURE\": \"true\",\n \"CLICKHOUSE_VERIFY\": \"true\",\n \"CLICKHOUSE_CONNECT_TIMEOUT\": \"30\",\n \"CLICKHOUSE_SEND_RECEIVE_TIMEOUT\": \"30\"\n }\n }\n }\n}\n```\n\n\n3. Locate the command entry for `uv` and replace it with the absolute path to the `uv` executable. This ensures that the correct version of `uv` is used when starting the server. On a mac, you can find this path using `which uv`.\n\n4. Restart Claude Desktop to apply the changes.\n\n## Development\n\n1. In `test-services` directory run `docker compose up -d` to start the ClickHouse cluster.\n\n2. Add the following variables to a `.env` file in the root of the repository.\n\n```\nCLICKHOUSE_HOST=localhost\nCLICKHOUSE_PORT=8123\nCLICKHOUSE_USER=default\nCLICKHOUSE_PASSWORD=clickhouse\n```\n\n3. Run `uv sync` to install the dependencies. To install `uv` follow the instructions [here](https://docs.astral.sh/uv/). Then do `source .venv/bin/activate`.\n\n4. For easy testing, you can run `mcp dev mcp_clickhouse/mcp_server.py` to start the MCP server.\n\n### Environment Variables\n\nThe following environment variables are used to configure the ClickHouse connection:\n\n#### Required Variables\n* `CLICKHOUSE_HOST`: The hostname of your ClickHouse server\n* `CLICKHOUSE_USER`: The username for authentication\n* `CLICKHOUSE_PASSWORD`: The password for authentication\n\n#### Optional Variables\n* `CLICKHOUSE_PORT`: The port number of your ClickHouse server\n - Default: `8443` if HTTPS is enabled, `8123` if disabled\n - Usually doesn't need to be set unless using a non-standard port\n* `CLICKHOUSE_SECURE`: Enable/disable HTTPS connection\n - Default: `\"true\"`\n - Set to `\"false\"` for non-secure connections\n* `CLICKHOUSE_VERIFY`: Enable/disable SSL certificate verification\n - Default: `\"true\"`\n - Set to `\"false\"` to disable certificate verification (not recommended for production)\n* `CLICKHOUSE_CONNECT_TIMEOUT`: Connection timeout in seconds\n - Default: `\"30\"`\n - Increase this value if you experience connection timeouts\n* `CLICKHOUSE_SEND_RECEIVE_TIMEOUT`: Send/receive timeout in seconds\n - Default: `\"300\"`\n - Increase this value for long-running queries\n* `CLICKHOUSE_DATABASE`: Default database to use\n - Default: None (uses server default)\n - Set this to automatically connect to a specific database\n\n#### Example Configurations\n\nFor local development with Docker:\n```env\n# Required variables\nCLICKHOUSE_HOST=localhost\nCLICKHOUSE_USER=default\nCLICKHOUSE_PASSWORD=clickhouse\n\n# Optional: Override defaults for local development\nCLICKHOUSE_SECURE=false # Uses port 8123 automatically\nCLICKHOUSE_VERIFY=false\n```\n\nFor ClickHouse Cloud:\n```env\n# Required variables\nCLICKHOUSE_HOST=your-instance.clickhouse.cloud\nCLICKHOUSE_USER=default\nCLICKHOUSE_PASSWORD=your-password\n\n# Optional: These use secure defaults\n# CLICKHOUSE_SECURE=true # Uses port 8443 automatically\n# CLICKHOUSE_DATABASE=your_database\n```\n\nFor ClickHouse SQL Playground:\n```env\nCLICKHOUSE_HOST=sql-clickhouse.clickhouse.com\nCLICKHOUSE_USER=demo\nCLICKHOUSE_PASSWORD=\n# Uses secure defaults (HTTPS on port 8443)\n```\n\nYou can set these variables in your environment, in a `.env` file, or in the Claude Desktop configuration:\n\n```json\n{\n \"mcpServers\": {\n \"mcp-clickhouse\": {\n \"command\": \"uv\",\n \"args\": [\n \"run\",\n \"--with\",\n \"mcp-clickhouse\",\n \"--python\",\n \"3.13\",\n \"mcp-clickhouse\"\n ],\n \"env\": {\n \"CLICKHOUSE_HOST\": \"\",\n \"CLICKHOUSE_USER\": \"\",\n \"CLICKHOUSE_PASSWORD\": \"\",\n \"CLICKHOUSE_DATABASE\": \"\"\n }\n }\n }\n}\n```\n\n","url","https://github.com/ClickHouse/mcp-clickhouse","githubRepository",{"_74":75,"_76":77,"_78":79,"_80":81,"_82":83,"_84":85,"_89":90,"_91":92,"_94":95},"defaultBranch","main","fullName","ClickHouse/mcp-clickhouse","githubTreeId",100452,"language","Python","name","mcp-clickhouse","owner",{"_86":87,"_17":88},"login","ClickHouse","jwss6ip8xv","recentStargazers",14,"spdxLicense",{"_82":93},"Apache 2.0","stargazers",116,"glamaJson","id",581,"inspectable",true,"integrations",[103],{"_104":105,"_39":110,"_17":111},"brand",{"_106":107,"_82":87,"_108":109},"logoSvgPath","M21.333 10H24v4h-2.667ZM16 1.335h2.667v21.33H16Zm-5.333 0h2.666v21.33h-2.666ZM0 22.665V1.335h2.667v21.33zm5.333-21.33H8v21.33H5.333Z","slug","clickhouse","Allows executing SQL queries on a ClickHouse cluster and retrieving information about databases and tables. It provides tools to run SELECT queries, list databases, and list tables in a database.","v222n5wfvf","namespace","npmPackage","prompts","redditPostForeignId","1hw9c9x","relatedMcpServerIds",[119,120,121,122,123,124],452,355,319,254,257,398,"resources","scores",{"_128":129,"_130":129,"_131":129},"license",100,"quality","security","simpleIcon","supportedPlatforms",[135,136],"MACOS","WINDOWS","tools",[139,147,160],{"_82":140,"_39":141,"_142":143},"list_databases","","inputSchema",{"_41":54,"_144":145,"_35":146},"title","list_databasesArguments",{},{"_82":148,"_39":141,"_142":149},"list_tables",{"_41":54,"_144":150,"_52":151,"_35":153},"list_tablesArguments",[152],"database",{"_154":155,"_152":158},"like",{"_41":42,"_144":156,"_157":-5},"Like","default",{"_41":42,"_144":159},"Database",{"_82":161,"_39":141,"_142":162},"run_select_query",{"_41":54,"_144":163,"_52":164,"_35":166},"run_select_queryArguments",[165],"query",{"_165":167},{"_41":42,"_144":168},"Query","yvjy4csvo1","updatedAt",["D",1742612851696],"meta",[174,176,178,185,188,190,193,196,199,202,205,207,210,213,215,217,219,221,223],{"_144":175},"mcp-clickhouse | Glama",{"_177":64,"_82":39},"content",{"_179":180,"_181":182,"_183":184},"href","https://glama.ai/mcp/servers/@ClickHouse/mcp-clickhouse","rel","canonical","tagName","link",{"_177":83,"_186":187},"property","og:title",{"_177":64,"_186":189},"og:description",{"_177":191,"_186":192},"https://glama.ai/logo.png","og:logo",{"_177":194,"_186":195},"https://glama.ai/mcp/servers/@ClickHouse/mcp-clickhouse/og-image","og:image",{"_177":197,"_186":198},"630","og:image:height",{"_177":200,"_186":201},"1200","og:image:width",{"_177":203,"_186":204},"website","og:type",{"_177":180,"_186":206},"og:url",{"_177":208,"_186":209},"ChatGPT alternative for power users","og:site_name",{"_177":211,"_82":212},"summary_large_image","twitter:card",{"_177":208,"_82":214},"twitter:title",{"_177":64,"_82":216},"twitter:description",{"_177":194,"_82":218},"twitter:image",{"_177":197,"_82":220},"twitter:image:height",{"_177":200,"_82":222},"twitter:image:width",{"_224":225},"script:ld+json",{"_226":227,"_228":229},"@context","http://schema.org","@graph",[230],{"_226":231,"_232":233,"_234":235},"https://schema.org","@type","BreadcrumbList","itemListElement",[236,243,247,251],{"_232":237,"_238":239,"_82":240,"_241":242},"ListItem","item","https://glama.ai/","Glama","position",1,{"_232":237,"_238":244,"_82":245,"_241":246},"https://glama.ai/mcp","MCP",2,{"_232":237,"_238":248,"_82":249,"_241":250},"https://glama.ai/mcp/servers","Servers",3,{"_232":237,"_238":180,"_82":83,"_241":252},4,"routes/_public/mcp/servers/~namespace/~slug/_pages/_explorer/blob/~branch/~/_route",{"_255":256,"_260":75,"_29":261,"_297":298,"_299":300},"blob",{"_177":257,"_258":259},"from .mcp_server import mcp\n\n\ndef main():\n mcp.run()\n\n\nif __name__ == \"__main__\":\n main()\n","fileName","main.py","branch",{"_31":262,"_33":263,"_13":270,"_63":64,"_65":64,"_66":271,"_72":272,"_96":-5,"_97":98,"_99":100,"_101":275,"_82":83,"_112":87,"_113":-5,"_114":-5,"_115":116,"_117":278,"_125":-5,"_126":279,"_132":-5,"_108":83,"_133":280,"_137":281,"_17":169,"_170":296},["D",1736303855959],{"_35":264,"_52":269,"_41":54},{"_37":265,"_43":266,"_46":267,"_49":268},{"_39":40,"_41":42},{"_39":45,"_41":42},{"_39":48,"_41":42},{"_39":51,"_41":42},[37,43,46,49],[56,57,58,59,60,61,62],{"_68":69,"_70":71},{"_74":75,"_76":77,"_78":79,"_80":81,"_82":83,"_84":273,"_89":90,"_91":274,"_94":95},{"_86":87,"_17":88},{"_82":93},[276],{"_104":277,"_39":110,"_17":111},{"_106":107,"_82":87,"_108":109},[119,120,121,122,123,124],{"_128":129,"_130":129,"_131":129},[135,136],[282,285,291],{"_82":140,"_39":141,"_142":283},{"_41":54,"_144":145,"_35":284},{},{"_82":148,"_39":141,"_142":286},{"_41":54,"_144":150,"_52":287,"_35":288},[152],{"_154":289,"_152":290},{"_41":42,"_144":156,"_157":-5},{"_41":42,"_144":159},{"_82":161,"_39":141,"_142":292},{"_41":54,"_144":163,"_52":293,"_35":294},[165],{"_165":295},{"_41":42,"_144":168},["D",1742612851696],"path","mcp_clickhouse","treeMembers",[301,303,305,307],{"_297":302,"_41":255},"mcp_clickhouse/__init__.py",{"_297":304,"_41":255},"mcp_clickhouse/main.py",{"_297":306,"_41":255},"mcp_clickhouse/mcp_env.py",{"_297":308,"_41":255},"mcp_clickhouse/mcp_server.py","actionData","errors"]