{"_id":"@dmkozloff/clickhouse-mcp","_rev":"10-b9f7ed112d12a102f3473556e5b2fef8","name":"@dmkozloff/clickhouse-mcp","dist-tags":{"latest":"0.1.7"},"versions":{"0.1.0":{"name":"@dmkozloff/clickhouse-mcp","version":"0.1.0","keywords":["clickhouse","mcp","ai","llm"],"author":{"name":"Your Name"},"license":"MIT","_id":"@dmkozloff/clickhouse-mcp@0.1.0","maintainers":[{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"}],"bin":{"clickhouse-mcp":"dist/cli.js"},"dist":{"shasum":"f516631a80af3e4fa11a6f2056d222b8c1e09316","tarball":"https://registry.npmjs.org/@dmkozloff/clickhouse-mcp/-/clickhouse-mcp-0.1.0.tgz","fileCount":9,"integrity":"sha512-U8Yt8cVcAua1oXRE0gU3ljkWlRgBYlaZZpZBzWn0moJqUdXjsB+myQwaxzv0aUZ6QySm+Elcb6HRgRW1xIF1lQ==","signatures":[{"sig":"MEUCIBLFqmQuC5OqWq4RkjjODKxHbQ8EfWZ+YB/YZZsaNyscAiEAiHQvRThxlc08LfANOpIBkChpKkjl3AXHyLC5/CjuA0Y=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13098},"main":"dist/index.js","type":"module","_from":"file:dmkozloff-clickhouse-mcp-0.1.0.tgz","types":"./dist/index.d.ts","scripts":{"build":"tsc"},"_npmUser":{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"},"_resolved":"/private/var/folders/xn/g257qzqn5fs03n3_tnk0zm7h0000gn/T/d22f9b5b54edd136009f4506212f2622/dmkozloff-clickhouse-mcp-0.1.0.tgz","_integrity":"sha512-U8Yt8cVcAua1oXRE0gU3ljkWlRgBYlaZZpZBzWn0moJqUdXjsB+myQwaxzv0aUZ6QySm+Elcb6HRgRW1xIF1lQ==","_npmVersion":"10.5.0","description":"ClickHouse Model Context Protocol server","directories":{},"_nodeVersion":"20.12.2","dependencies":{"zod":"^3.22.0","@clickhouse/client":"^0.2.0","@modelcontextprotocol/sdk":"^0.1.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^18.0.0"},"_npmOperationalInternal":{"tmp":"tmp/clickhouse-mcp_0.1.0_1742465261648_0.12397030392645503","host":"s3://npm-registry-packages-npm-production"}},"0.1.1":{"name":"@dmkozloff/clickhouse-mcp","version":"0.1.1","keywords":["clickhouse","mcp","ai","llm"],"author":{"name":"Dmitry Kozlov"},"license":"MIT","_id":"@dmkozloff/clickhouse-mcp@0.1.1","maintainers":[{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"}],"bin":{"clickhouse-mcp":"dist/cli.js"},"dist":{"shasum":"59a47a50d74896c791c8dc9114fd94ac417a2da6","tarball":"https://registry.npmjs.org/@dmkozloff/clickhouse-mcp/-/clickhouse-mcp-0.1.1.tgz","fileCount":9,"integrity":"sha512-XVREWbEuXyvEj/gE4BxXrdmDz0VwBrjyBBxJ0pOpAFotIBZypIiwAEB5ba5yzm8OsX/tizlgAY9J6ZnBin+wXQ==","signatures":[{"sig":"MEUCIBxAHSnweiFaNh5wuY1JSHQGlyPxnqqH1pbe3fiDNZ8OAiEArTwvpBLDjjmB3yx9Rc+pRBP9d5Q/mVoqGcuu7g0gXTc=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13215},"main":"dist/index.js","type":"module","_from":"file:dmkozloff-clickhouse-mcp-0.1.1.tgz","types":"./dist/index.d.ts","engines":{"node":">=14.16"},"scripts":{"build":"tsc && chmod +x dist/cli.js"},"_npmUser":{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"},"_resolved":"/private/var/folders/xn/g257qzqn5fs03n3_tnk0zm7h0000gn/T/9665a69cc429c3f25817c47a72928917/dmkozloff-clickhouse-mcp-0.1.1.tgz","_integrity":"sha512-XVREWbEuXyvEj/gE4BxXrdmDz0VwBrjyBBxJ0pOpAFotIBZypIiwAEB5ba5yzm8OsX/tizlgAY9J6ZnBin+wXQ==","_npmVersion":"10.5.0","description":"ClickHouse Model Context Protocol server","directories":{},"_nodeVersion":"20.12.2","dependencies":{"zod":"^3.22.0","@clickhouse/client":"^0.2.0","@modelcontextprotocol/sdk":"^1.7.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^18.0.0"},"_npmOperationalInternal":{"tmp":"tmp/clickhouse-mcp_0.1.1_1742465942148_0.3721840051855281","host":"s3://npm-registry-packages-npm-production"}},"0.1.2":{"name":"@dmkozloff/clickhouse-mcp","version":"0.1.2","keywords":["clickhouse","mcp","ai","llm"],"author":{"name":"Dmitry Kozlov"},"license":"MIT","_id":"@dmkozloff/clickhouse-mcp@0.1.2","maintainers":[{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"}],"bin":{"clickhouse-mcp":"dist/cli.js"},"dist":{"shasum":"7bfc2afdc10e3991b24f7760e251d469b77f7f11","tarball":"https://registry.npmjs.org/@dmkozloff/clickhouse-mcp/-/clickhouse-mcp-0.1.2.tgz","fileCount":9,"integrity":"sha512-LSnXWWmZvKwAvWiaQe0xx32Gq1n9bo6VDs8R+vCJ8BTUjUJdQiAhePXgk9Z2Yx+jyuddkrde0vNCKcrjVoMAdA==","signatures":[{"sig":"MEUCIFHj2hURW/z/QNH0hBwo5K47XHvbBxrJpgfge0RSv2dXAiEA3Wk0IY1FBWqzlTG23djvMX5wm1kqQFLK+5H77qUJO2c=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13329},"main":"dist/index.js","type":"module","_from":"file:dmkozloff-clickhouse-mcp-0.1.2.tgz","types":"./dist/index.d.ts","engines":{"node":">=14.16"},"scripts":{"build":"tsc && chmod +x dist/cli.js"},"_npmUser":{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"},"_resolved":"/private/var/folders/xn/g257qzqn5fs03n3_tnk0zm7h0000gn/T/2cdf9325fc072ec0ced13d07a8360a90/dmkozloff-clickhouse-mcp-0.1.2.tgz","_integrity":"sha512-LSnXWWmZvKwAvWiaQe0xx32Gq1n9bo6VDs8R+vCJ8BTUjUJdQiAhePXgk9Z2Yx+jyuddkrde0vNCKcrjVoMAdA==","_npmVersion":"10.5.0","description":"ClickHouse Model Context Protocol server","directories":{},"_nodeVersion":"20.12.2","dependencies":{"zod":"^3.22.0","dotenv":"^16.4.7","@clickhouse/client":"^0.2.0","@modelcontextprotocol/sdk":"^1.7.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^18.0.0"},"_npmOperationalInternal":{"tmp":"tmp/clickhouse-mcp_0.1.2_1742469189027_0.4814966709229276","host":"s3://npm-registry-packages-npm-production"}},"0.1.3":{"name":"@dmkozloff/clickhouse-mcp","version":"0.1.3","keywords":["clickhouse","mcp","ai","llm"],"author":{"name":"Dmitry Kozlov"},"license":"MIT","_id":"@dmkozloff/clickhouse-mcp@0.1.3","maintainers":[{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"}],"bin":{"clickhouse-mcp":"dist/cli.js"},"dist":{"shasum":"4f4454d2adcfe1135e2f6e25f35f9a632bd82bc7","tarball":"https://registry.npmjs.org/@dmkozloff/clickhouse-mcp/-/clickhouse-mcp-0.1.3.tgz","fileCount":9,"integrity":"sha512-CYOZD+bK5z3fE4d66n/8hA5h2hEtgX5DNdUTHA7SRuRH2HEU7y5uQrZm9n6sTq//IoFOTe8SxbBID14oUY0Wbw==","signatures":[{"sig":"MEUCIEzUA6zzQMy5PyfiZp5NIkM8IwuO9q8XhjZJ2goCo3SnAiEA7kr4SvABqGTckDB9/rV+ZbMB4CgG32w3jtbsD+gJG4w=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13329},"main":"dist/index.js","type":"module","_from":"file:dmkozloff-clickhouse-mcp-0.1.3.tgz","types":"./dist/index.d.ts","engines":{"node":">=14.16"},"scripts":{"build":"tsc && chmod +x dist/cli.js"},"_npmUser":{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"},"_resolved":"/private/var/folders/xn/g257qzqn5fs03n3_tnk0zm7h0000gn/T/a37972e0feb787b163f4db0fae8cc5e5/dmkozloff-clickhouse-mcp-0.1.3.tgz","_integrity":"sha512-CYOZD+bK5z3fE4d66n/8hA5h2hEtgX5DNdUTHA7SRuRH2HEU7y5uQrZm9n6sTq//IoFOTe8SxbBID14oUY0Wbw==","_npmVersion":"10.5.0","description":"ClickHouse Model Context Protocol server","directories":{},"_nodeVersion":"20.12.2","dependencies":{"zod":"^3.22.0","dotenv":"^16.4.7","@clickhouse/client":"^0.2.0","@modelcontextprotocol/sdk":"^1.7.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^18.0.0"},"_npmOperationalInternal":{"tmp":"tmp/clickhouse-mcp_0.1.3_1742469738836_0.7257039206431251","host":"s3://npm-registry-packages-npm-production"}},"0.1.4":{"name":"@dmkozloff/clickhouse-mcp","version":"0.1.4","keywords":["clickhouse","mcp","ai","llm"],"author":{"name":"Dmitry Kozlov"},"license":"MIT","_id":"@dmkozloff/clickhouse-mcp@0.1.4","maintainers":[{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"}],"bin":{"clickhouse-mcp":"dist/cli.js"},"dist":{"shasum":"012f01e4105b7788e598dc3ad6fa7e08eeef6073","tarball":"https://registry.npmjs.org/@dmkozloff/clickhouse-mcp/-/clickhouse-mcp-0.1.4.tgz","fileCount":9,"integrity":"sha512-VUcYRg3LYPrq8eXLnPEVoU/JcxhKVbpBTEFvRJuKOzY755Sn+itHj/WqStq2R91TVkKs0XXIK88zTvbSo256uA==","signatures":[{"sig":"MEYCIQCEjn/XRDAFahumKQl0olhwk6SXz5EdgCzvUD4H78jhvQIhAK2CJHkU5qpvNaFLGjwmce1DAekJQqNVpBJUg6v1Iqul","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13666},"main":"dist/index.js","type":"module","_from":"file:dmkozloff-clickhouse-mcp-0.1.4.tgz","types":"./dist/index.d.ts","engines":{"node":">=14.16"},"scripts":{"build":"tsc && chmod +x dist/cli.js"},"_npmUser":{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"},"_resolved":"/private/var/folders/xn/g257qzqn5fs03n3_tnk0zm7h0000gn/T/79329df82bd8ef89a69cf79679ec5dac/dmkozloff-clickhouse-mcp-0.1.4.tgz","_integrity":"sha512-VUcYRg3LYPrq8eXLnPEVoU/JcxhKVbpBTEFvRJuKOzY755Sn+itHj/WqStq2R91TVkKs0XXIK88zTvbSo256uA==","_npmVersion":"10.5.0","description":"ClickHouse Model Context Protocol server","directories":{},"_nodeVersion":"20.12.2","dependencies":{"zod":"^3.22.0","dotenv":"^16.4.7","@clickhouse/client":"^0.2.0","@modelcontextprotocol/sdk":"^1.7.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^18.0.0"},"_npmOperationalInternal":{"tmp":"tmp/clickhouse-mcp_0.1.4_1742470374674_0.8104171049041824","host":"s3://npm-registry-packages-npm-production"}},"0.1.5":{"name":"@dmkozloff/clickhouse-mcp","version":"0.1.5","keywords":["clickhouse","mcp","ai","llm"],"author":{"name":"Dmitry Kozlov"},"license":"MIT","_id":"@dmkozloff/clickhouse-mcp@0.1.5","maintainers":[{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"}],"bin":{"clickhouse-mcp":"dist/cli.js"},"dist":{"shasum":"521647d5587fdb808bb6db21d241cde66e1a037a","tarball":"https://registry.npmjs.org/@dmkozloff/clickhouse-mcp/-/clickhouse-mcp-0.1.5.tgz","fileCount":9,"integrity":"sha512-eYKeccKlyDR+8cirDQJx0wTwAWYy3Pp2Lrd3pmfDQWO0QpMPQV42Cr2s1ammTE9i27oXZhfamZM2PYo3bftzxA==","signatures":[{"sig":"MEQCIB9GMWhSdd4nNEi6hKB1fmrd66iKq0b0czAlxOHKdglvAiBVBuS0vBFFNq0i2to/gQMaBGUA/f69l7YSKR/ZOuJl8A==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13413},"main":"dist/index.js","type":"module","_from":"file:dmkozloff-clickhouse-mcp-0.1.5.tgz","types":"./dist/index.d.ts","engines":{"node":">=14.16"},"scripts":{"build":"tsc && chmod +x dist/cli.js"},"_npmUser":{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"},"_resolved":"/private/var/folders/xn/g257qzqn5fs03n3_tnk0zm7h0000gn/T/3c72ce282e5a7e27e2771ac3c0ed816e/dmkozloff-clickhouse-mcp-0.1.5.tgz","_integrity":"sha512-eYKeccKlyDR+8cirDQJx0wTwAWYy3Pp2Lrd3pmfDQWO0QpMPQV42Cr2s1ammTE9i27oXZhfamZM2PYo3bftzxA==","_npmVersion":"10.5.0","description":"ClickHouse Model Context Protocol server","directories":{},"_nodeVersion":"20.12.2","dependencies":{"zod":"^3.22.0","dotenv":"^16.4.7","@clickhouse/client":"^0.2.0","@modelcontextprotocol/sdk":"^1.7.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^18.0.0"},"_npmOperationalInternal":{"tmp":"tmp/clickhouse-mcp_0.1.5_1742470999696_0.029690909705839985","host":"s3://npm-registry-packages-npm-production"}},"0.1.6":{"name":"@dmkozloff/clickhouse-mcp","version":"0.1.6","keywords":["clickhouse","mcp","ai","llm"],"author":{"name":"Dmitry Kozlov"},"license":"MIT","_id":"@dmkozloff/clickhouse-mcp@0.1.6","maintainers":[{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"}],"bin":{"clickhouse-mcp":"dist/cli.js"},"dist":{"shasum":"afe4ab7f5ea55f9b756d81e88627b73a55e5acf9","tarball":"https://registry.npmjs.org/@dmkozloff/clickhouse-mcp/-/clickhouse-mcp-0.1.6.tgz","fileCount":9,"integrity":"sha512-1CTwOAgIJhpiaHHAktQgyVdtxuipmPFpksZE4tddgTm+00FpDoo1SN3KQL8x6/dHe9D91aTCmuhcv/YiA8rh5Q==","signatures":[{"sig":"MEUCIQDyLzImaUfVXalPk8Z6fgibMOXNOSnBCxWIW7lXetMWJQIgUoPSt+wPq4pzzGerv3pcUGM0jIwE0p01NJa2XBchwRo=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13299},"main":"dist/index.js","type":"module","_from":"file:dmkozloff-clickhouse-mcp-0.1.6.tgz","types":"./dist/index.d.ts","engines":{"node":">=14.16"},"scripts":{"build":"tsc && chmod +x dist/cli.js"},"_npmUser":{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"},"_resolved":"/private/var/folders/xn/g257qzqn5fs03n3_tnk0zm7h0000gn/T/da1c424df34da97d5639d841158095be/dmkozloff-clickhouse-mcp-0.1.6.tgz","_integrity":"sha512-1CTwOAgIJhpiaHHAktQgyVdtxuipmPFpksZE4tddgTm+00FpDoo1SN3KQL8x6/dHe9D91aTCmuhcv/YiA8rh5Q==","_npmVersion":"10.5.0","description":"ClickHouse Model Context Protocol server","directories":{},"_nodeVersion":"20.12.2","dependencies":{"zod":"^3.22.0","dotenv":"^16.4.7","@clickhouse/client":"^0.2.0","@modelcontextprotocol/sdk":"^1.7.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^18.0.0"},"_npmOperationalInternal":{"tmp":"tmp/clickhouse-mcp_0.1.6_1742471778441_0.6416457226712213","host":"s3://npm-registry-packages-npm-production"}},"0.1.7":{"name":"@dmkozloff/clickhouse-mcp","version":"0.1.7","description":"ClickHouse Model Context Protocol server","main":"dist/index.js","type":"module","bin":{"clickhouse-mcp":"dist/cli.js"},"keywords":["clickhouse","mcp","ai","llm"],"author":{"name":"Dmitry Kozlov"},"license":"MIT","engines":{"node":">=14.16"},"publishConfig":{"access":"public"},"dependencies":{"@clickhouse/client":"^0.2.0","@modelcontextprotocol/sdk":"^1.7.0","dotenv":"^16.4.7","zod":"^3.22.0"},"devDependencies":{"@types/node":"^18.0.0","typescript":"^5.0.0"},"scripts":{"build":"tsc && chmod +x dist/cli.js"},"types":"./dist/index.d.ts","_id":"@dmkozloff/clickhouse-mcp@0.1.7","_integrity":"sha512-z9SGwem+nDMIbseNL+KhTMNIWHOhZYtDeX/oJv0wLrwgo4w/YXJ82Iyy4o9fqF5RkkTee77vzAo/hWST+WNbsQ==","_resolved":"/private/var/folders/xn/g257qzqn5fs03n3_tnk0zm7h0000gn/T/db57baa4067d51682bed33c76ca0c4b4/dmkozloff-clickhouse-mcp-0.1.7.tgz","_from":"file:dmkozloff-clickhouse-mcp-0.1.7.tgz","_nodeVersion":"20.12.2","_npmVersion":"10.5.0","dist":{"integrity":"sha512-z9SGwem+nDMIbseNL+KhTMNIWHOhZYtDeX/oJv0wLrwgo4w/YXJ82Iyy4o9fqF5RkkTee77vzAo/hWST+WNbsQ==","shasum":"d8c3ea051d9c9555ec00c0ed77173be499454394","tarball":"https://registry.npmjs.org/@dmkozloff/clickhouse-mcp/-/clickhouse-mcp-0.1.7.tgz","fileCount":9,"unpackedSize":13199,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIBDC8o/ibyMyJZSaxQ2dcKGT6TJspGbs999wYKdooGhzAiEA4Hf3twSpZ2TZOXWYX9Mh/wegIHH6QyaTcRULp3/NFGk="}]},"_npmUser":{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"},"directories":{},"maintainers":[{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/clickhouse-mcp_0.1.7_1745570769158_0.611407750910751"},"_hasShrinkwrap":false}},"time":{"created":"2025-03-20T10:19:02.087Z","modified":"2025-04-25T08:46:09.487Z","1.0.0":"2025-03-20T10:05:53.578Z","0.1.0":"2025-03-20T10:07:41.802Z","0.1.1":"2025-03-20T10:19:02.352Z","0.1.2":"2025-03-20T11:13:09.204Z","0.1.3":"2025-03-20T11:22:19.013Z","0.1.4":"2025-03-20T11:32:54.857Z","0.1.5":"2025-03-20T11:43:19.869Z","0.1.6":"2025-03-20T11:56:18.636Z","0.1.7":"2025-04-25T08:46:09.331Z"},"author":{"name":"Dmitry Kozlov"},"license":"MIT","keywords":["clickhouse","mcp","ai","llm"],"description":"ClickHouse Model Context Protocol server","maintainers":[{"name":"dmkozloff","email":"dmitrykozlov504@gmail.com"}],"readme":"# ClickHouse MCP Server\n\nA Model Context Protocol server for ClickHouse database interactions. This server allows AI models to safely access and query ClickHouse databases.\n\n## Installation\n\n```bash\nnpm install -g clickhouse-mcp\n```\n\n## Usage\n\n### Using npx\n\n```bash\nnpx clickhouse-mcp\n```\n\n### Environment Variables\n\nSet these environment variables before running:\n\n- `CLICKHOUSE_HOST`: Your ClickHouse host\n- `CLICKHOUSE_PORT`: Your ClickHouse port (default: 8443)\n- `CLICKHOUSE_USER`: Your ClickHouse username\n- `CLICKHOUSE_PASSWORD`: Your ClickHouse password\n- `CLICKHOUSE_DATABASE`: Your default ClickHouse database\n- `CLICKHOUSE_CONNECT_TIMEOUT_SEC`: Connection timeout in seconds (default: 10)\n- `CLICKHOUSE_CERT_PATH`: Path to CA certificate (optional)\n\nExample:\n\n```bash\nexport CLICKHOUSE_HOST=your-clickhouse-server.com\nexport CLICKHOUSE_PORT=8443\nexport CLICKHOUSE_USER=default\nexport CLICKHOUSE_PASSWORD=your_password\nexport CLICKHOUSE_DATABASE=default\nnpx clickhouse-mcp\n```\n\n## Features\n\n- **List Databases**: View all available databases on the server\n- **List Tables**: View all tables in a specified database\n- **Run SELECT Queries**: Execute read-only queries with security validation\n\n## Security\n\nThis server enforces read-only access to your ClickHouse database by:\n\n1. Setting the `readonly` ClickHouse setting to \"1\"\n2. Validating that only SELECT, SHOW, and DESCRIBE statements are executed\n3. Rejecting any other query types for security reasons\n\n## License\n\nMIT\n\n# clickhouse-mcp\nClickhouse MCP client that support TLS certificate authentication\n\n# Tools\n\n## run_select_query\n\nExecute SQL queries on your ClickHouse cluster.\nInput: sql (string): The SQL query to execute.\nAll ClickHouse queries are run with readonly = 1 to ensure they are safe.\n\n## list_databases\n\nList all databases on your ClickHouse cluster.\n\n## list_tables\n\nList all tables in a database.\nInput: database (string): The name of the database.\n\n\n# Environment Variables\nThe following environment variables are used to configure the ClickHouse connection:\n\n## Required Variables\nCLICKHOUSE_HOST: The hostname of your ClickHouse server\nCLICKHOUSE_USER: The username for authentication\nCLICKHOUSE_PASSWORD: The password for authentication\n\n## Optional Variables\n- CLICKHOUSE_PORT: The port number of your ClickHouse server\nDefault: 8443 if HTTPS is enabled, 8123 if disabled\nUsually doesn't need to be set unless using a non-standard port  \n\n- CLICKHOUSE_SECURE: Enable/disable HTTPS connection\nDefault: \"true\"\nSet to \"false\" for non-secure connections\n\n- CLICKHOUSE_VERIFY: Enable/disable SSL certificate verification\nDefault: \"true\"\nSet to \"false\" to disable certificate verification (not recommended for production)  \n\n- CLICKHOUSE_CONNECT_TIMEOUT: Connection timeout in seconds\nDefault: \"30\"\nIncrease this value if you experience connection timeouts  \n\n- CLICKHOUSE_SEND_RECEIVE_TIMEOUT: Send/receive timeout in seconds  \nDefault: \"300\"\nIncrease this value for long-running queries\n- CLICKHOUSE_DATABASE: Default database to use  \nDefault: None (uses server default)\nSet this to automatically connect to a specific database\n\n- CLICKHOUSE_CERT_PATH: Path to the TLS certificate file\nDefault: None\nSet this to the path of your TLS certificate file if using HTTPS","readmeFilename":"README.md"}