{"_id":"@dockndevai/mcp-clickhouse","_rev":"8-ca5c0c01cd6e4c4896b6a89612cfe643","name":"@dockndevai/mcp-clickhouse","dist-tags":{"latest":"0.3.0"},"versions":{"0.1.0":{"name":"@dockndevai/mcp-clickhouse","version":"0.1.0","keywords":["mcp","model-context-protocol","clickhouse","olap","sql","observability","llm","ai"],"license":"MIT","_id":"@dockndevai/mcp-clickhouse@0.1.0","maintainers":[{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"}],"homepage":"https://github.com/dockndevai/mcp-clickhouse#readme","bugs":{"url":"https://github.com/dockndevai/mcp-clickhouse/issues"},"bin":{"mcp-clickhouse":"dist/index.js"},"dist":{"shasum":"499823fea742a8a67bdcdcd53e01a55798d178f4","tarball":"https://registry.npmjs.org/@dockndevai/mcp-clickhouse/-/mcp-clickhouse-0.1.0.tgz","fileCount":30,"integrity":"sha512-IJvCZMHYk2G2Fnk34DGjdw6MwDiQo5Gx+XpDl+7FcbmPrvPbu/rtEEZIs8lOASWx7tAY21o6295Ootmw2KV1PQ==","signatures":[{"sig":"MEQCIBYT9l0ffaU/bSxZ4FTvWxvxTpue5l25AhXOZh77FKhjAiBGzi5YV0FIj7aTs9Bk6v/vSfkAJcGitdGSZkzMsyMnPA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@dockndevai%2fmcp-clickhouse@0.1.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":56971},"type":"module","engines":{"node":">=20"},"gitHead":"94512303097dad836022f00357ba649b950290f5","mcpName":"io.github.dockndevai/mcp-clickhouse","scripts":{"dev":"tsx watch src/index.ts","lint":"tsc -p tsconfig.json --noEmit","test":"vitest run","build":"tsc -p tsconfig.json","start":"node dist/index.js","typecheck":"tsc -p tsconfig.json --noEmit","test:watch":"vitest","prepublishOnly":"npm run build"},"_npmUser":{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"},"repository":{"url":"git+https://github.com/dockndevai/mcp-clickhouse.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol server for ClickHouse — query and manage databases with SQL-classification-based security modes and access-control flags.","directories":{},"_nodeVersion":"20.20.2","dependencies":{"zod":"^3.23.8","@clickhouse/client":"^1.7.0","@modelcontextprotocol/sdk":"^1.12.0"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.19.2","vitest":"^3.2.7","typescript":"^5.6.3","@types/node":"^22.9.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-clickhouse_0.1.0_1787471367016_0.9819113666996475","host":"s3://npm-registry-packages-npm-production"}},"0.1.1":{"name":"@dockndevai/mcp-clickhouse","version":"0.1.1","keywords":["mcp","model-context-protocol","clickhouse","olap","sql","observability","llm","ai"],"license":"MIT","_id":"@dockndevai/mcp-clickhouse@0.1.1","maintainers":[{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"}],"homepage":"https://github.com/dockndevai/mcp-clickhouse#readme","bugs":{"url":"https://github.com/dockndevai/mcp-clickhouse/issues"},"bin":{"mcp-clickhouse":"dist/index.js"},"dist":{"shasum":"ff3503fdd46e75aa77acb64e65d555fa032ff39f","tarball":"https://registry.npmjs.org/@dockndevai/mcp-clickhouse/-/mcp-clickhouse-0.1.1.tgz","fileCount":33,"integrity":"sha512-X2yV15Dgejxh2DCy/kmjpv8sKu+YjIuwe9pJXao7Uc8s7lywYE4OpSshvG1rnRxdKGbbJuWX6dlOdRSCFqNkqw==","signatures":[{"sig":"MEYCIQC30BzAV5j/LZ8Gnoflo7QySAO4m7OiJTuKA0C8rRdLYAIhAJSjGrCn7+1T1On4OmpswYGsT3TM89GLSC0U43g8qCmp","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@dockndevai%2fmcp-clickhouse@0.1.1","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":61389},"type":"module","engines":{"node":">=20"},"gitHead":"e1dd07e5accccad53cdeecf5eef301a07b0977c6","mcpName":"io.github.dockndevai/mcp-clickhouse","scripts":{"dev":"tsx watch src/index.ts","lint":"tsc -p tsconfig.json --noEmit","test":"vitest run","build":"tsc -p tsconfig.json","start":"node dist/index.js","typecheck":"tsc -p tsconfig.json --noEmit","test:watch":"vitest","prepublishOnly":"npm run build"},"_npmUser":{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"},"repository":{"url":"git+https://github.com/dockndevai/mcp-clickhouse.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol server for ClickHouse — query and manage databases with SQL-classification-based security modes and access-control flags.","directories":{},"_nodeVersion":"20.20.2","dependencies":{"zod":"^3.23.8","@clickhouse/client":"^1.7.0","@modelcontextprotocol/sdk":"^1.12.0"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.19.2","vitest":"^3.2.7","typescript":"^5.6.3","@types/node":"^22.9.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-clickhouse_0.1.1_1787885332910_0.12700828934703878","host":"s3://npm-registry-packages-npm-production"}},"0.1.2":{"name":"@dockndevai/mcp-clickhouse","version":"0.1.2","keywords":["mcp","model-context-protocol","clickhouse","olap","sql","observability","llm","ai"],"license":"MIT","_id":"@dockndevai/mcp-clickhouse@0.1.2","maintainers":[{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"}],"homepage":"https://github.com/dockndevai/mcp-clickhouse#readme","bugs":{"url":"https://github.com/dockndevai/mcp-clickhouse/issues"},"bin":{"mcp-clickhouse":"dist/index.js"},"dist":{"shasum":"4dc7a490ee7ac7f1fc05cea753c306ef6c9b026a","tarball":"https://registry.npmjs.org/@dockndevai/mcp-clickhouse/-/mcp-clickhouse-0.1.2.tgz","fileCount":33,"integrity":"sha512-WAACHv+oCQNR/DGn8QqPu3sOVLT768PRbu1LKAwHvuGLh+b3UlVzg/ezs1/g8KZO+b2dnyY/21S1A5YjuzP0Gw==","signatures":[{"sig":"MEQCICeQK0LBrFjMHbrJPtj3cM/eEni/NC+3dVKcA/C9+BYGAiBEWgRBTbzqRJ1KgSBPn9s/gYt4TLANGWS+2spkfG/qmg==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@dockndevai%2fmcp-clickhouse@0.1.2","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":61389},"type":"module","engines":{"node":">=20"},"gitHead":"9325c584dfdb4654191e4f28a6858790a979ebcf","mcpName":"io.github.dockndevai/mcp-clickhouse","scripts":{"dev":"tsx watch src/index.ts","lint":"tsc -p tsconfig.json --noEmit","test":"vitest run","build":"tsc -p tsconfig.json","start":"node dist/index.js","typecheck":"tsc -p tsconfig.json --noEmit","test:watch":"vitest","prepublishOnly":"npm run build"},"_npmUser":{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"},"repository":{"url":"git+https://github.com/dockndevai/mcp-clickhouse.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol server for ClickHouse — query and manage databases with SQL-classification-based security modes and access-control flags.","directories":{},"_nodeVersion":"20.20.2","dependencies":{"zod":"^3.23.8","@clickhouse/client":"^1.7.0","@modelcontextprotocol/sdk":"^1.30.0"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.19.2","vitest":"^3.2.7","typescript":"^5.6.3","@types/node":"^22.9.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-clickhouse_0.1.2_1788070720752_0.45817936335776577","host":"s3://npm-registry-packages-npm-production"}},"0.1.3":{"name":"@dockndevai/mcp-clickhouse","version":"0.1.3","keywords":["mcp","model-context-protocol","clickhouse","olap","sql","observability","llm","ai"],"license":"MIT","_id":"@dockndevai/mcp-clickhouse@0.1.3","maintainers":[{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"}],"homepage":"https://github.com/dockndevai/mcp-clickhouse#readme","bugs":{"url":"https://github.com/dockndevai/mcp-clickhouse/issues"},"bin":{"mcp-clickhouse":"dist/index.js"},"dist":{"shasum":"8a6a841060c3c40f1379a00acee8e6cca48bb351","tarball":"https://registry.npmjs.org/@dockndevai/mcp-clickhouse/-/mcp-clickhouse-0.1.3.tgz","fileCount":33,"integrity":"sha512-3tZiHqzlNu0m6vzTr3/9vKEuGDMoigTBdfiDAQcbMQvhLNJfok6s8Dxq0X38jIUYMaCI/W+jWqafloJVpWFOJw==","signatures":[{"sig":"MEUCIBXhG/bCEaNAMlPbXsiFZ+/4H/pTYog2OYQcklB+37UcAiEAvFPxSYWiuHY3eDH9kCPl7B1YIidWlC4mqY29nocJc0o=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@dockndevai%2fmcp-clickhouse@0.1.3","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":61389},"type":"module","engines":{"node":">=22"},"gitHead":"bd3f39868c41744dce3b8dc98826e70cbed2c2aa","mcpName":"io.github.dockndevai/mcp-clickhouse","scripts":{"dev":"tsx watch src/index.ts","lint":"tsc -p tsconfig.json --noEmit","test":"vitest run","build":"tsc -p tsconfig.json","start":"node dist/index.js","typecheck":"tsc -p tsconfig.json --noEmit","test:watch":"vitest","prepublishOnly":"npm run build"},"_npmUser":{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"},"repository":{"url":"git+https://github.com/dockndevai/mcp-clickhouse.git","type":"git"},"_npmVersion":"10.9.8","description":"Model Context Protocol server for ClickHouse — query and manage databases with SQL-classification-based security modes and access-control flags.","directories":{},"_nodeVersion":"22.23.2","dependencies":{"zod":"^3.23.8","@clickhouse/client":"^1.7.0","@modelcontextprotocol/sdk":"^1.30.0"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.19.2","vitest":"^5.0.0","typescript":"^5.6.3","@types/node":"^22.9.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-clickhouse_0.1.3_1788969319374_0.5722228481790026","host":"s3://npm-registry-packages-npm-production"}},"0.2.0":{"name":"@dockndevai/mcp-clickhouse","version":"0.2.0","keywords":["mcp","model-context-protocol","clickhouse","olap","sql","observability","llm","ai"],"license":"MIT","_id":"@dockndevai/mcp-clickhouse@0.2.0","maintainers":[{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"}],"homepage":"https://github.com/dockndevai/mcp-clickhouse#readme","bugs":{"url":"https://github.com/dockndevai/mcp-clickhouse/issues"},"bin":{"mcp-clickhouse":"dist/index.js"},"dist":{"shasum":"2707881ac6a8f541fd0e0ecc7e0848e29e0e27e3","tarball":"https://registry.npmjs.org/@dockndevai/mcp-clickhouse/-/mcp-clickhouse-0.2.0.tgz","fileCount":36,"integrity":"sha512-KscgeuugLoDJHDRRO7RCqtBMFEwqhFmMTdPjlEAWLKnNVw9K5Qco7hAG8+fEAHtJ+s9+FNV2tJIErR4x02l/Ew==","signatures":[{"sig":"MEUCIQDEJq8ByLedNXfTFIDMFwAH0ucn3y802teTnKzEH4yI+QIgAnygqWz3EHF1Oh0UXDWFJYnMJr4TtwQGPzSA9/SRb+E=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@dockndevai%2fmcp-clickhouse@0.2.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":67991},"type":"module","engines":{"node":">=22"},"gitHead":"0ed9236abf5512d89094ce85dcf7d31e38b4547b","mcpName":"io.github.dockndevai/mcp-clickhouse","scripts":{"dev":"tsx watch src/index.ts","lint":"tsc -p tsconfig.json --noEmit","test":"vitest run","build":"tsc -p tsconfig.json","start":"node dist/index.js","typecheck":"tsc -p tsconfig.json --noEmit","test:watch":"vitest","prepublishOnly":"npm run build"},"_npmUser":{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"},"repository":{"url":"git+https://github.com/dockndevai/mcp-clickhouse.git","type":"git"},"_npmVersion":"10.9.8","description":"Model Context Protocol server for ClickHouse — query and manage databases with SQL-classification-based security modes and access-control flags.","directories":{},"_nodeVersion":"22.23.2","dependencies":{"zod":"^3.23.8","@clickhouse/client":"^1.7.0","@modelcontextprotocol/sdk":"^1.30.0"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.19.2","vitest":"^5.0.0","typescript":"^5.6.3","@types/node":"^22.9.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-clickhouse_0.2.0_1788981898030_0.6913799897189858","host":"s3://npm-registry-packages-npm-production"}},"0.2.1":{"name":"@dockndevai/mcp-clickhouse","version":"0.2.1","keywords":["mcp","model-context-protocol","clickhouse","olap","sql","observability","llm","ai"],"license":"MIT","_id":"@dockndevai/mcp-clickhouse@0.2.1","maintainers":[{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"}],"homepage":"https://github.com/dockndevai/mcp-clickhouse#readme","bugs":{"url":"https://github.com/dockndevai/mcp-clickhouse/issues"},"bin":{"mcp-clickhouse":"dist/index.js"},"dist":{"shasum":"c852a023d3a91db538db0e2acfd36e22eaa8ceab","tarball":"https://registry.npmjs.org/@dockndevai/mcp-clickhouse/-/mcp-clickhouse-0.2.1.tgz","fileCount":36,"integrity":"sha512-2D2u482BunGQMZ9cHHs9qOT56IbhSjPo3Rdz62H/HgP5BwQE4Vy7peXQT8PcEPFfvLC/ZL2TLlUALpxpr1pQLw==","signatures":[{"sig":"MEUCIQCiux+5FhldKU/zFhgjC+umni3b9utINwTAOt8UQkLjgwIga+oWhjrle1VdS+lW1gTaT/cpeKBRONNNC2lmtPO3nSY=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@dockndevai%2fmcp-clickhouse@0.2.1","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":68205},"type":"module","engines":{"node":">=22"},"gitHead":"2e84c18fecd9aa819b7ea4590d11410dee81fe70","mcpName":"io.github.dockndevai/mcp-clickhouse","scripts":{"dev":"tsx watch src/index.ts","lint":"tsc -p tsconfig.json --noEmit","test":"vitest run","build":"tsc -p tsconfig.json","start":"node dist/index.js","typecheck":"tsc -p tsconfig.json --noEmit","test:watch":"vitest","prepublishOnly":"npm run build"},"_npmUser":{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"},"repository":{"url":"git+https://github.com/dockndevai/mcp-clickhouse.git","type":"git"},"_npmVersion":"10.9.8","description":"Model Context Protocol server for ClickHouse — query and manage databases with SQL-classification-based security modes and access-control flags.","directories":{},"_nodeVersion":"22.23.2","dependencies":{"zod":"^3.23.8","@clickhouse/client":"^1.7.0","@modelcontextprotocol/sdk":"^1.30.0"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.19.2","vitest":"^5.0.0","typescript":"^5.6.3","@types/node":"^22.9.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-clickhouse_0.2.1_1788983025484_0.7104021864792918","host":"s3://npm-registry-packages-npm-production"}},"0.2.2":{"name":"@dockndevai/mcp-clickhouse","version":"0.2.2","keywords":["mcp","model-context-protocol","clickhouse","olap","sql","observability","llm","ai"],"license":"MIT","_id":"@dockndevai/mcp-clickhouse@0.2.2","maintainers":[{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"}],"homepage":"https://github.com/dockndevai/mcp-clickhouse#readme","bugs":{"url":"https://github.com/dockndevai/mcp-clickhouse/issues"},"bin":{"mcp-clickhouse":"dist/index.js"},"dist":{"shasum":"57c2c8067b2c789f50a836855810e338019a7c69","tarball":"https://registry.npmjs.org/@dockndevai/mcp-clickhouse/-/mcp-clickhouse-0.2.2.tgz","fileCount":36,"integrity":"sha512-Vj/RxgBIfd44YOu0bJTySm2y2/c+n2iBn1PMoBRcupgAzKewDcTcfihV5k4WEPvSw72ubeQ5aS0giUXSkXjcMQ==","signatures":[{"sig":"MEQCIHA4LJHFyS2EnpOZmW5TIIUMPbJnLnCaTg1ZMRTDcdO3AiB8PxqgzJI8l88miO+6G9vk7JVrL+8hfvYf8Ap+duajQA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"},{"sig":"MEUCIECiG3yIsTKeBx8jfMMUQxFmep3PrEbAs1zL8g+Hez+rAiEAt8pFG6ypr179hK150DtRxbhsQOvKu5PSbVC+8FofclY=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@dockndevai%2fmcp-clickhouse@0.2.2","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":68196},"type":"module","engines":{"node":">=22"},"gitHead":"97b50ebf4fa50e9f0ba49e6f97c9ab538c17b279","mcpName":"io.github.dockndevai/mcp-clickhouse","scripts":{"dev":"tsx watch src/index.ts","lint":"tsc -p tsconfig.json --noEmit","test":"vitest run","build":"tsc -p tsconfig.json","start":"node dist/index.js","typecheck":"tsc -p tsconfig.json --noEmit","test:watch":"vitest","prepublishOnly":"npm run build"},"_npmUser":{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"},"repository":{"url":"git+https://github.com/dockndevai/mcp-clickhouse.git","type":"git"},"_npmVersion":"10.9.8","description":"Model Context Protocol server for ClickHouse — query and manage databases with SQL-classification-based security modes and access-control flags.","directories":{},"_nodeVersion":"22.23.2","dependencies":{"zod":"^4.5.4","@clickhouse/client":"^1.7.0","@modelcontextprotocol/sdk":"^1.30.0"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.23.13","vitest":"^5.0.0","typescript":"^7.0.2","@types/node":"^26.5.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-clickhouse_0.2.2_1789235866725_0.451764359243896","host":"s3://npm-registry-packages-npm-production"}},"0.3.0":{"_id":"@dockndevai/mcp-clickhouse@0.3.0","bin":{"mcp-clickhouse":"dist/index.js"},"bugs":{"url":"https://github.com/dockndevai/mcp-clickhouse/issues"},"dist":{"shasum":"6596147a6c2472f9e82bcd7ecc902393911d640e","tarball":"https://registry.npmjs.org/@dockndevai/mcp-clickhouse/-/mcp-clickhouse-0.3.0.tgz","fileCount":39,"integrity":"sha512-qE7hK9w6NxRUmYc6aycjRV30Kk92AqWaw77wsJFxhMGclrqrJNZVI59oMZSBrmv0hW/tebqb/EgM2CfS7B+D/w==","signatures":[{"sig":"MEUCIFkwjhIhplBPg7DBueiiRVpgg0Pl8R7yJq+jJok6zkKhAiEAxj+OuAG2Au38OhGai2pDduQbcC73OPilRRGEnPnj+EA=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"},{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQC0ftwOUtUD3k4sn/C5jQuzEwUSZQ5wHZ2kTDsF6RmFTgIgAStzzndpdUr0ZClV+qf5WrCyk8LMEBgFVLHQJ2yI2lc="}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@dockndevai%2fmcp-clickhouse@0.3.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":78231},"name":"@dockndevai/mcp-clickhouse","type":"module","engines":{"node":">=22"},"gitHead":"f3600322f750d636364c88419f2a3f2a42e8185e","license":"MIT","mcpName":"io.github.dockndevai/mcp-clickhouse","scripts":{"dev":"tsx watch src/index.ts","lint":"tsc -p tsconfig.json --noEmit","test":"vitest run","build":"tsc -p tsconfig.json","start":"node dist/index.js","typecheck":"tsc -p tsconfig.json --noEmit","test:watch":"vitest","prepublishOnly":"npm run build"},"version":"0.3.0","_npmUser":{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"},"homepage":"https://github.com/dockndevai/mcp-clickhouse#readme","keywords":["mcp","model-context-protocol","clickhouse","olap","sql","observability","llm","ai"],"repository":{"url":"git+https://github.com/dockndevai/mcp-clickhouse.git","type":"git"},"_npmVersion":"10.9.8","description":"Model Context Protocol server for ClickHouse — query and manage databases with SQL-classification-based security modes and access-control flags.","directories":{},"maintainers":[{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"}],"_nodeVersion":"22.23.2","dependencies":{"zod":"^4.5.4","@clickhouse/client":"^1.7.0","@modelcontextprotocol/sdk":"^1.30.0"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.23.13","vitest":"^5.0.0","typescript":"^7.0.2","@types/node":"^26.5.0"},"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mcp-clickhouse_0.3.0_1790685023612_0.8788210428010734"}}},"time":{"created":"2026-08-23T07:49:26.754Z","modified":"2026-09-29T12:30:24.143Z","0.1.0":"2026-08-23T07:49:27.155Z","0.1.1":"2026-08-28T02:48:53.032Z","0.1.2":"2026-08-30T06:18:40.900Z","0.1.3":"2026-09-09T15:55:19.512Z","0.2.0":"2026-09-09T19:24:58.165Z","0.2.1":"2026-09-09T19:43:45.624Z","0.2.2":"2026-09-12T17:57:46.829Z","0.3.0":"2026-09-29T12:30:23.696Z"},"bugs":{"url":"https://github.com/dockndevai/mcp-clickhouse/issues"},"license":"MIT","homepage":"https://github.com/dockndevai/mcp-clickhouse#readme","keywords":["mcp","model-context-protocol","clickhouse","olap","sql","observability","llm","ai"],"repository":{"url":"git+https://github.com/dockndevai/mcp-clickhouse.git","type":"git"},"description":"Model Context Protocol server for ClickHouse — query and manage databases with SQL-classification-based security modes and access-control flags.","maintainers":[{"name":"dock-n-dev-ai","email":"ankitcs17071993@gmail.com"}],"readme":"# mcp-clickhouse\n\n[![CI](https://github.com/dockndevai/mcp-clickhouse/actions/workflows/ci.yml/badge.svg)](https://github.com/dockndevai/mcp-clickhouse/actions/workflows/ci.yml)\n[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](./LICENSE)\n[![npm](https://img.shields.io/npm/v/@dockndevai/mcp-clickhouse)](https://www.npmjs.com/package/@dockndevai/mcp-clickhouse)\n\nA [Model Context Protocol](https://modelcontextprotocol.io) server for **ClickHouse**. It lets an MCP-capable client (Claude Desktop, Claude Code, etc.) explore schemas, run analytical queries, and manage the database — with behaviour controlled entirely by flags.\n\nThe security model is **statement-aware**: every SQL statement is classified as read, write, or destructive, and gated against the current access mode. Read-only mode additionally runs queries under ClickHouse's own `readonly=1` setting.\n\n## Features\n\n- **Exploration & monitoring** — databases, tables, columns, `SHOW CREATE`, table stats (parts/rows/bytes), running queries, server metrics, cluster topology.\n- **Read queries** — a `query` tool that only accepts read statements, capped at `CLICKHOUSE_MAX_ROWS`.\n- **Management** — an `execute` tool for INSERT/CREATE/ALTER (read-write) and DROP/TRUNCATE/DELETE (admin), each gated by classification.\n- **Access modes** — `read-only` → `read-write` → `admin`, layered so a mode never exposes statements above its level.\n- **Security flags** — database allowlist, protected databases, destructive gating, row cap, dry-run, and JSON audit logging (see below).\n\n## Security model\n\n| Concern | Flag | Default | Effect |\n| --- | --- | --- | --- |\n| What can the server do? | `CLICKHOUSE_MODE` | `read-only` | `read-only` exposes read tools only (and refuses non-SELECT in `query`); `read-write` adds `execute` for writes; `admin` allows destructive statements. |\n| Which databases are in scope? | `CLICKHOUSE_DATABASE_ALLOWLIST` | *(all)* | When set, operations on other databases are refused. |\n| Which databases are read-only forever? | `CLICKHOUSE_PROTECTED_DATABASES` | `system,information_schema` | Readable, never mutable. |\n| Can it run destructive SQL? | `CLICKHOUSE_ALLOW_DELETE` | `false` | DROP/TRUNCATE/DELETE/… need this **and** admin mode. |\n| Result size cap | `CLICKHOUSE_MAX_ROWS` | `1000` | Hard cap on rows returned to the model. |\n| Preview without executing | `CLICKHOUSE_DRY_RUN` | `false` | Write/destructive statements validate + log intent, then return. |\n| Audit trail | `CLICKHOUSE_AUDIT_LOG` | `true` | Emits a JSON line to stderr per guarded operation. |\n| Interactive confirmation | *(automatic)* | — | Destructive & high-impact actions prompt the human to approve via MCP elicitation before running; clients without elicitation fall back to the `*_ALLOW_*` gate. |\n\nStatement classification lives in `src/sql.ts` and is fail-safe: `ALTER … DELETE/UPDATE` counts as destructive, and anything unparseable is treated as destructive.\n\n## Tools\n\n**Read** (`read-only`+): `list_databases`, `list_tables`, `describe_table`, `show_create_table`, `table_stats`, `running_queries`, `server_metrics`, `cluster_info`, `query`\n\n**Write/Admin** (`read-write`+): `execute` — runs a single statement after classifying it; writes need read-write mode, destructive statements need admin mode + `CLICKHOUSE_ALLOW_DELETE`.\n\n## Quickstart — add to your agent\n\nPublished on npm as [`@dockndevai/mcp-clickhouse`](https://www.npmjs.com/package/@dockndevai/mcp-clickhouse). No clone or build needed — your MCP client runs it on demand with `npx`. **Start in `read-only` mode**; see [`.env.example`](.env.example) for every variable and [docs/CLIENTS.md](docs/CLIENTS.md) for the full per-client guide.\n\n**Claude Code** (CLI)\n\n```bash\nclaude mcp add clickhouse -e CLICKHOUSE_URL=\"http://localhost:8123\" -e CLICKHOUSE_USER=\"default\" -e CLICKHOUSE_MODE=\"read-only\" -- npx -y @dockndevai/mcp-clickhouse\n```\n\n**Claude Desktop · Cursor · Windsurf** — same block in `claude_desktop_config.json`, `.cursor/mcp.json`, or `~/.codeium/windsurf/mcp_config.json`:\n\n```json\n{\n  \"mcpServers\": {\n    \"clickhouse\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@dockndevai/mcp-clickhouse\"\n      ],\n      \"env\": {\n        \"CLICKHOUSE_URL\": \"http://localhost:8123\",\n        \"CLICKHOUSE_USER\": \"default\",\n        \"CLICKHOUSE_MODE\": \"read-only\"\n      }\n    }\n  }\n}\n```\n\n**OpenAI Codex CLI** — in `~/.codex/config.toml`:\n\n```toml\n[mcp_servers.clickhouse]\ncommand = \"npx\"\nargs = [\"-y\", \"@dockndevai/mcp-clickhouse\"]\nenv = { CLICKHOUSE_URL = \"http://localhost:8123\", CLICKHOUSE_USER = \"default\", CLICKHOUSE_MODE = \"read-only\" }\n```\n\n**VS Code (GitHub Copilot, Agent mode)** — in `.vscode/mcp.json`:\n\n```json\n{\n  \"servers\": {\n    \"clickhouse\": {\n      \"type\": \"stdio\",\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@dockndevai/mcp-clickhouse\"\n      ],\n      \"env\": {\n        \"CLICKHOUSE_URL\": \"http://localhost:8123\",\n        \"CLICKHOUSE_USER\": \"default\",\n        \"CLICKHOUSE_MODE\": \"read-only\"\n      }\n    }\n  }\n}\n```\n\n## Example prompts\n\n- *\"What are the biggest tables in the `analytics` database?\"*\n- *\"Show me the schema for `events` and run a query for daily counts this week.\"*\n- *\"Which queries are currently running and using the most memory?\"*\n\n## Run from source (development)\n\nPrefer the published package above. To run from a clone:\n\n```bash\nnpm install\nnpm run build\nnode dist/index.js   # with the environment variables set\n```\n\n## Develop\n\n```bash\nnpm run dev\nnpm test          # SQL classification + security policy (30 tests)\nnpm run typecheck\n```\n\n## Publishing\n\nThis server ships a [`server.json`](server.json) for the official MCP registry and an [`mcpName`](package.json) for npm ownership validation. See **[PUBLISHING.md](PUBLISHING.md)** for publishing to npm and listing on the MCP registry, Smithery, Glama, Cursor, and PulseMCP.\n\n## License\n\nMIT\n","readmeFilename":"README.md"}