[{"_1":2,"_350":-5,"_351":-5},"loaderData",{"_3":4,"_53":54,"_55":56,"_263":264},"root",{"_5":6,"_49":50,"_51":52},"appGlobal",{"_7":8,"_38":39,"_40":41},"config",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":-5,"_24":25,"_26":27,"_28":29,"_30":31,"_32":33,"_34":31,"_35":31,"_36":37},"APP_URL","https://glama.ai","CLIENT_ASSETS_URL","https://static.glama.ai/client/","ENVIRONMENT","LIVE","FACEBOOK_PIXEL_ID","1988603181578092","GOOGLE_ANALYTICS_MEASUREMENT_ID","G-GDQ5NW5CB5","GOOGLE_OAUTH2_CLIENT_ID","48173796263-7ohlqirg28gh2a7nel61coff3m1ogjtc.apps.googleusercontent.com","INTERCOM_APP_ID","wgcqevfz","INTERCOM_USER_HASH","POSTHOG_API_KEY","phc_aK0RnJxBEBRE0h0LIz21yyc9w6ylBxwUHMPB4712Bjc","REDDIT_PIXEL_ID","a2_fcqsoymvje51","RELEASE_VERSION","glama@production","SENTRY_DRY_RUN",false,"SENTRY_DSN","https://fc82aa9f808b13927ff29c56bda4d486@o4507975513735168.ingest.us.sentry.io/4507975514849280","SENTRY_SPOTLIGHT","SENTRY_TRACE","STRIPE_PUBLIC_KEY","pk_live_51QpZQ32LV3sZcHqzHlFuNhgSfggSNaQqCzZw9EMJ8tbhpQyZgcwQj1vz168FxQ35EGRcztKu2MankxiSs7zLCF4g00blUverGs","viewportWidth",1280,"visitorSession",{"_42":43,"_45":-5,"_46":47,"_48":-5},"attributes",[44],"BOT","membership","uid","bri5ixdrgl","userAccount","nonce","b05151147c2f0decdd3c446aa50691f3","toasts",[],"routes/_public/_layout",{},"routes/_public/mcp/servers/~uid/_pages/_layout",{"_57":-5,"_58":59,"_182":183},"githubUser","mcpServer",{"_60":61,"_62":63,"_42":84,"_88":89,"_90":89,"_91":92,"_97":98,"_120":121,"_122":123,"_116":124,"_125":-5,"_126":-5,"_127":128,"_135":-5,"_136":137,"_142":-5,"_143":144,"_147":148,"_46":179,"_180":181},"addedAt",["D",1736303855959],"argumentsJsonSchema",{"_64":65,"_66":67,"_72":73},"type","object","required",[68,69,70,71],"CLICKHOUSE_HOST","CLICKHOUSE_PORT","CLICKHOUSE_USER","CLICKHOUSE_PASSWORD","properties",{"_68":74,"_69":78,"_70":80,"_71":82},{"_64":75,"_76":77},"string","description","The host address of the ClickHouse server",{"_64":75,"_76":79},"The port number of the ClickHouse server",{"_64":75,"_76":81},"The username to connect to the ClickHouse server",{"_64":75,"_76":83},"The password to connect to the ClickHouse server",[85,86,87],"category:databases","author:official","language:python","descriptionMarkdown","ClickHouse database integration with schema inspection and query capabilities","descriptionPlainText","githubProject",{"_93":94,"_95":96},"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 `fastmcp 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",{"_99":100,"_101":102,"_103":104,"_105":106,"_107":108,"_112":113,"_114":115,"_118":119},"defaultBranch","main","fullName","ClickHouse/mcp-clickhouse","githubTreeId",58130,"language","Python","owner",{"_109":110,"_111":31},"login","ClickHouse","verified","recentStargazers",10,"spdxLicense",{"_116":117},"name","Apache 2.0","stargazers",41,"id",581,"inspectable",true,"mcp-clickhouse","npmPackage","prompts","relatedMcpServerIds",[129,130,131,132,133,134],452,355,319,254,257,398,"resources","scores",{"_138":139,"_140":139,"_141":139},"license",100,"quality","security","simpleIcon","supportedPlatforms",[145,146],"MACOS","WINDOWS","tools",[149,157,170],{"_116":150,"_76":151,"_152":153},"list_databases","","inputSchema",{"_64":65,"_154":155,"_72":156},"title","list_databasesArguments",{},{"_116":158,"_76":151,"_152":159},"list_tables",{"_64":65,"_154":160,"_66":161,"_72":163},"list_tablesArguments",[162],"database",{"_164":165,"_162":168},"like",{"_64":75,"_154":166,"_167":-5},"Like","default",{"_64":75,"_154":169},"Database",{"_116":171,"_76":151,"_152":172},"run_select_query",{"_64":65,"_154":173,"_66":174,"_72":176},"run_select_queryArguments",[175],"query",{"_175":177},{"_64":75,"_154":178},"Query","yvjy4csvo1","updatedAt",["D",1740290493465],"meta",[184,186,188,195,198,200,203,206,209,212,215,217,220,223,225,227,229,231,233],{"_154":185},"mcp-clickhouse | Glama",{"_187":89,"_116":76},"content",{"_189":190,"_191":192,"_193":194},"href","https://glama.ai/mcp/servers/yvjy4csvo1","rel","canonical","tagName","link",{"_187":124,"_196":197},"property","og:title",{"_187":89,"_196":199},"og:description",{"_187":201,"_196":202},"https://glama.ai/logo.png","og:logo",{"_187":204,"_196":205},"https://glama.ai/mcp/servers/yvjy4csvo1/og-image","og:image",{"_187":207,"_196":208},"630","og:image:height",{"_187":210,"_196":211},"1200","og:image:width",{"_187":213,"_196":214},"website","og:type",{"_187":190,"_196":216},"og:url",{"_187":218,"_196":219},"ChatGPT alternative for power users","og:site_name",{"_187":221,"_116":222},"summary_large_image","twitter:card",{"_187":218,"_116":224},"twitter:title",{"_187":89,"_116":226},"twitter:description",{"_187":204,"_116":228},"twitter:image",{"_187":207,"_116":230},"twitter:image:height",{"_187":210,"_116":232},"twitter:image:width",{"_234":235},"script:ld+json",{"_236":237,"_238":239},"@context","http://schema.org","@graph",[240],{"_236":241,"_242":243,"_244":245},"https://schema.org","@type","BreadcrumbList","itemListElement",[246,253,257,261],{"_242":247,"_248":249,"_116":250,"_251":252},"ListItem","item","https://glama.ai/","Glama","position",1,{"_242":247,"_248":254,"_116":255,"_251":256},"https://glama.ai/mcp","MCP",2,{"_242":247,"_248":258,"_116":259,"_251":260},"https://glama.ai/mcp/servers","Servers",3,{"_242":247,"_248":190,"_116":124,"_251":262},4,"routes/_public/mcp/servers/~uid/_pages/tools/~name/_route",{"_58":265,"_298":-5,"_299":300,"_182":304,"_341":342,"_40":349},{"_60":266,"_62":267,"_42":274,"_88":89,"_90":89,"_91":275,"_97":276,"_120":121,"_122":123,"_116":124,"_125":-5,"_126":-5,"_127":279,"_135":-5,"_136":280,"_142":-5,"_143":281,"_147":282,"_46":179,"_180":297},["D",1736303855959],{"_64":65,"_66":268,"_72":269},[68,69,70,71],{"_68":270,"_69":271,"_70":272,"_71":273},{"_64":75,"_76":77},{"_64":75,"_76":79},{"_64":75,"_76":81},{"_64":75,"_76":83},[85,86,87],{"_93":94,"_95":96},{"_99":100,"_101":102,"_103":104,"_105":106,"_107":277,"_112":113,"_114":278,"_118":119},{"_109":110,"_111":31},{"_116":117},[129,130,131,132,133,134],{"_138":139,"_140":139,"_141":139},[145,146],[283,286,292],{"_116":150,"_76":151,"_152":284},{"_64":65,"_154":155,"_72":285},{},{"_116":158,"_76":151,"_152":287},{"_64":65,"_154":160,"_66":288,"_72":289},[162],{"_164":290,"_162":291},{"_64":75,"_154":166,"_167":-5},{"_64":75,"_154":169},{"_116":171,"_76":151,"_152":293},{"_64":65,"_154":173,"_66":294,"_72":295},[175],{"_175":296},{"_64":75,"_154":178},["D",1740290493465],"mcpServerInstance","mcpServerTool",{"_76":151,"_120":301,"_152":302,"_116":150},1013,{"_72":303,"_154":155,"_64":65},{},[305,307,308,309,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325],{"_154":306},"list_databases - mcp-clickhouse | Glama",{"_187":151,"_116":76},{"_189":190,"_191":192,"_193":194},{"_187":310,"_196":197},"list_databases - mcp-clickhouse",{"_187":151,"_196":199},{"_187":201,"_196":202},{"_187":204,"_196":205},{"_187":207,"_196":208},{"_187":210,"_196":211},{"_187":213,"_196":214},{"_187":190,"_196":216},{"_187":218,"_196":219},{"_187":221,"_116":222},{"_187":218,"_116":224},{"_187":151,"_116":226},{"_187":204,"_116":228},{"_187":207,"_116":230},{"_187":210,"_116":232},{"_234":326},{"_236":237,"_238":327},[328],{"_236":241,"_242":243,"_244":329},[330,331,332,333,334,338],{"_242":247,"_248":249,"_116":250,"_251":252},{"_242":247,"_248":254,"_116":255,"_251":256},{"_242":247,"_248":258,"_116":259,"_251":260},{"_242":247,"_248":190,"_116":124,"_251":262},{"_242":247,"_248":335,"_116":336,"_251":337},"https://glama.ai/mcp/servers/yvjy4csvo1/tools","Tools",5,{"_242":247,"_248":339,"_116":150,"_251":340},"https://glama.ai/mcp/servers/yvjy4csvo1/tools/list_databases",6,"otherTools",[343,345,347],{"_58":344,"_116":150},{"_46":179},{"_58":346,"_116":158},{"_46":179},{"_58":348,"_116":171},{"_46":179},{"_48":-5},"actionData","errors"]

list_databases

Input Schema

Input Schema (JSON Schema)

Other Tools