{"name":"io.github.ClickHouse/mcp-clickhouse","slug":"clickhouse-mcp-clickhouse","title":"ClickHouse","description":"Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.","url":"https://mcp.market/server/clickhouse-mcp-clickhouse","rating":null,"grade":"A","score":85,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":70,"stars":877,"forks":208,"downloads_week":55938,"last_push_at":"2026-09-18T23:38:58.000Z","license":"Apache-2.0"},"uptime":null,"claimed":false,"transport":"mixed","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/ClickHouse/mcp-clickhouse","website":"https://clickhouse.com","version":"0.6.0","remotes":[],"packages":[{"registryType":"pypi","identifier":"mcp-clickhouse","version":"0.6.0","runtimeHint":"uvx","transport":{"type":"stdio"},"environmentVariables":[{"description":"Hostname of the ClickHouse server","isRequired":true,"name":"CLICKHOUSE_HOST"},{"description":"Username for ClickHouse authentication","isRequired":true,"name":"CLICKHOUSE_USER"},{"description":"Password for ClickHouse authentication","isRequired":true,"isSecret":true,"name":"CLICKHOUSE_PASSWORD"},{"description":"ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise","name":"CLICKHOUSE_PORT"},{"description":"Use HTTPS to connect to ClickHouse","format":"boolean","default":"true","name":"CLICKHOUSE_SECURE"},{"description":"Verify SSL certificates","format":"boolean","default":"true","name":"CLICKHOUSE_VERIFY"},{"description":"Default database to use","name":"CLICKHOUSE_DATABASE"},{"description":"ClickHouse role to activate for the session","name":"CLICKHOUSE_ROLE"},{"description":"Allow write operations (DDL and DML). Queries run read-only by default","format":"boolean","default":"false","name":"CLICKHOUSE_ALLOW_WRITE_ACCESS"},{"description":"Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled","format":"boolean","default":"false","name":"CLICKHOUSE_ALLOW_DROP"},{"description":"Query tool timeout in seconds","format":"number","default":"30","name":"CLICKHOUSE_MCP_QUERY_TIMEOUT"},{"description":"Maximum query worker thread pool size","format":"number","default":"10","name":"CLICKHOUSE_MCP_MAX_WORKERS"}]},{"registryType":"oci","identifier":"ghcr.io/clickhouse/mcp-clickhouse:0.6.0","transport":{"type":"stdio"},"environmentVariables":[{"description":"Hostname of the ClickHouse server","isRequired":true,"name":"CLICKHOUSE_HOST"},{"description":"Username for ClickHouse authentication","isRequired":true,"name":"CLICKHOUSE_USER"},{"description":"Password for ClickHouse authentication","isRequired":true,"isSecret":true,"name":"CLICKHOUSE_PASSWORD"},{"description":"ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise","name":"CLICKHOUSE_PORT"},{"description":"Use HTTPS to connect to ClickHouse","format":"boolean","default":"true","name":"CLICKHOUSE_SECURE"},{"description":"Verify SSL certificates","format":"boolean","default":"true","name":"CLICKHOUSE_VERIFY"},{"description":"Default database to use","name":"CLICKHOUSE_DATABASE"},{"description":"ClickHouse role to activate for the session","name":"CLICKHOUSE_ROLE"},{"description":"Allow write operations (DDL and DML). Queries run read-only by default","format":"boolean","default":"false","name":"CLICKHOUSE_ALLOW_WRITE_ACCESS"},{"description":"Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled","format":"boolean","default":"false","name":"CLICKHOUSE_ALLOW_DROP"},{"description":"Query tool timeout in seconds","format":"number","default":"30","name":"CLICKHOUSE_MCP_QUERY_TIMEOUT"},{"description":"Maximum query worker thread pool size","format":"number","default":"10","name":"CLICKHOUSE_MCP_MAX_WORKERS"}]}],"tools":[],"scan":{"score":85,"grade":"A","scanned_at":"2026-09-20T16:17:57.407Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-20T16:17:57.374Z","components":{"code":{"score":25,"max":25,"notes":["13 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":15,"max":15,"notes":["last push 2 days ago"]},"identity":{"score":9,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"pypi","identifier":"mcp-clickhouse","version":"0.6.0","found":true,"weeklyDownloads":55938,"license":"Apache-2.0","dependencyCount":11,"publishedAt":"2026-09-03T14:07:54.517169Z"}],"repo":{"found":true,"owner":"ClickHouse","repo":"mcp-clickhouse","archived":false,"pushedAt":"2026-09-18T23:38:58Z","stars":877,"forks":208,"openIssues":10,"ownerType":"Organization","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/54801242?v=4","ownerCreatedAt":"2019-09-02T10:22:35Z","license":"Apache-2.0"},"icon":{"url":"https://avatars.githubusercontent.com/u/54801242?v=4&s=128","source":"github"},"presence":{"stars":877,"forks":208,"downloadsWeek":55938,"license":"Apache-2.0","lastPushAt":"2026-09-18T23:38:58.000Z","score":70}}}},"grade_history":[],"reviews":[]}