Raw values for ClickHouse
io.github.ClickHouse/mcp-clickhouse · Registry status: active
What the source declared verbatim, unchanged and uninterpreted. The derived values on the overview page are computed from these.
Evidence for this page: The values on this page come from several collections. Each row therefore states its own origin.
| Description (raw) | Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB. Source: MCP-Register · collected on 2026-08-26 · self-declared |
|---|---|
| Environment variables (raw) | CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_PORT, CLICKHOUSE_SECURE, CLICKHOUSE_VERIFY, CLICKHOUSE_CA_CERT, CLICKHOUSE_CLIENT_CERT, CLICKHOUSE_CLIENT_CERT_KEY, CLICKHOUSE_TLS_MODE, CLICKHOUSE_DATABASE, CLICKHOUSE_ROLE, CLICKHOUSE_ALLOW_WRITE_ACCESS, CLICKHOUSE_ALLOW_DROP, CLICKHOUSE_MCP_QUERY_TIMEOUT, CLICKHOUSE_MCP_MAX_WORKERS, CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_PORT, CLICKHOUSE_SECURE, CLICKHOUSE_VERIFY, CLICKHOUSE_CA_CERT, CLICKHOUSE_CLIENT_CERT, CLICKHOUSE_CLIENT_CERT_KEY, CLICKHOUSE_TLS_MODE, CLICKHOUSE_DATABASE, CLICKHOUSE_ROLE, CLICKHOUSE_ALLOW_WRITE_ACCESS, CLICKHOUSE_ALLOW_DROP, CLICKHOUSE_MCP_QUERY_TIMEOUT, CLICKHOUSE_MCP_MAX_WORKERS Source: MCP-Register · collected on 2026-09-22 · self-declared |
| Required secret variables (raw) | confirmed absent Source: MCP-Register · collected on 2026-09-22 · self-declared |
| Transports (raw) | stdio, stdio Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Path arguments (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Repository (raw) | https://github.com/ClickHouse/mcp-clickhouse Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Package registries (raw) | oci, pypi Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Required secret headers (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Path environment variables (raw) | CLICKHOUSE_CA_CERT, CLICKHOUSE_CLIENT_CERT, CLICKHOUSE_CLIENT_CERT_KEY Source: MCP-Register · collected on 2026-09-22 · self-declared |
| Remote URLs (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Remote hosts (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Registry status message (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| First listed in the registry (raw) | 2026-09-21 Source: MCP-Register · collected on 2026-09-22 · self-declared |
| Last changed in the registry (raw) | 2026-09-21 Source: MCP-Register · collected on 2026-09-22 · self-declared |
| Schema version of the raw record (raw) | https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Delivery form (raw) | package Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Repository platform (raw) | github Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Repository subfolder (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Package identifiers (raw) | ghcr.io/clickhouse/mcp-clickhouse:0.7.0, mcp-clickhouse Source: MCP-Register · collected on 2026-09-22 · self-declared |
| Package versions (raw) | 0.7.0 Source: MCP-Register · collected on 2026-09-22 · self-declared |
| Runtime hints (raw) | uvx Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Environment variable formats (raw) | boolean, filepath, number Source: MCP-Register · collected on 2026-09-22 · self-declared |
| Environment variable descriptions (raw) | CLICKHOUSE_ALLOW_DROP=Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled · CLICKHOUSE_ALLOW_WRITE_ACCESS=Allow write operations (DDL and DML). Queries run read-only by default · CLICKHOUSE_CA_CERT=Path to a PEM CA bundle for ClickHouse server certificate verification · CLICKHOUSE_CLIENT_CERT=Path to a PEM client certificate for the ClickHouse HTTPS connection · CLICKHOUSE_CLIENT_CERT_KEY=Path to the PEM private key for CLICKHOUSE_CLIENT_CERT · CLICKHOUSE_DATABASE=Default database to use · CLICKHOUSE_HOST=Hostname of the ClickHouse server · CLICKHOUSE_MCP_MAX_WORKERS=Maximum query worker thread pool size · CLICKHOUSE_MCP_QUERY_TIMEOUT=Query tool timeout in seconds · CLICKHOUSE_PASSWORD=Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode · CLICKHOUSE_PORT=ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise · CLICKHOUSE_ROLE=ClickHouse role to activate for the session · CLICKHOUSE_SECURE=Use HTTPS to connect to ClickHouse · CLICKHOUSE_TLS_MODE=Client certificate mode: mutual, proxy, or strict · CLICKHOUSE_USER=Username for ClickHouse authentication · CLICKHOUSE_VERIFY=Verify SSL certificates Source: MCP-Register · collected on 2026-09-22 · self-declared |
| Icon formats (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Connection paths (source structure) | {"packages":[{"registryType":"pypi","identifier":"mcp-clickhouse","version":"0.7.0","runtimeHint":"uvx","transport":"stdio","environment":[{"name":"CLICKHOUSE_HOST","description":"Hostname of the ClickHouse server","required":true,"secret":false},{"name":"CLICKHOUSE_USER","description":"Username for ClickHouse authentication","required":true,"secret":false},{"name":"CLICKHOUSE_PASSWORD","description":"Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode","required":false,"secret":true},{"name":"CLICKHOUSE_PORT","description":"ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise","required":false,"secret":false},{"name":"CLICKHOUSE_SECURE","description":"Use HTTPS to connect to ClickHouse","format":"boolean","required":false,"secret":false},{"name":"CLICKHOUSE_VERIFY","description":"Verify SSL certificates","format":"boolean","required":false,"secret":false},{"name":"CLICKHOUSE_CA_CERT","description":"Path to a PEM CA bundle for ClickHouse server certificate verification","format":"filepath","required":false,"secret":false},{"name":"CLICKHOUSE_CLIENT_CERT","description":"Path to a PEM client certificate for the ClickHouse HTTPS connection","format":"filepath","required":false,"secret":false},{"name":"CLICKHOUSE_CLIENT_CERT_KEY","description":"Path to the PEM private key for CLICKHOUSE_CLIENT_CERT","format":"filepath","required":false,"secret":false},{"name":"CLICKHOUSE_TLS_MODE","description":"Client certificate mode: mutual, proxy, or strict","required":false,"secret":false},{"name":"CLICKHOUSE_DATABASE","description":"Default database to use","required":false,"secret":false},{"name":"CLICKHOUSE_ROLE","description":"ClickHouse role to activate for the session","required":false,"secret":false},{"name":"CLICKHOUSE_ALLOW_WRITE_ACCESS","description":"Allow write operations (DDL and DML). Queries run read-only by default","format":"boolean","required":false,"secret":false},{"name":"CLICKHOUSE_ALLOW_DROP","description":"Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled","format":"boolean","required":false,"secret":false},{"name":"CLICKHOUSE_MCP_QUERY_TIMEOUT","description":"Query tool timeout in seconds","format":"number","required":false,"secret":false},{"name":"CLICKHOUSE_MCP_MAX_WORKERS","description":"Maximum query worker thread pool size","format":"number","required":false,"secret":false}],"additional_arguments_declared":false},{"registryType":"oci","identifier":"ghcr.io/clickhouse/mcp-clickhouse:0.7.0","transport":"stdio","environment":[{"name":"CLICKHOUSE_HOST","description":"Hostname of the ClickHouse server","required":true,"secret":false},{"name":"CLICKHOUSE_USER","description":"Username for ClickHouse authentication","required":true,"secret":false},{"name":"CLICKHOUSE_PASSWORD","description":"Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode","required":false,"secret":true},{"name":"CLICKHOUSE_PORT","description":"ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise","required":false,"secret":false},{"name":"CLICKHOUSE_SECURE","description":"Use HTTPS to connect to ClickHouse","format":"boolean","required":false,"secret":false},{"name":"CLICKHOUSE_VERIFY","description":"Verify SSL certificates","format":"boolean","required":false,"secret":false},{"name":"CLICKHOUSE_CA_CERT","description":"Path to a PEM CA bundle for ClickHouse server certificate verification","format":"filepath","required":false,"secret":false},{"name":"CLICKHOUSE_CLIENT_CERT","description":"Path to a PEM client certificate for the ClickHouse HTTPS connection","format":"filepath","required":false,"secret":false},{"name":"CLICKHOUSE_CLIENT_CERT_KEY","description":"Path to the PEM private key for CLICKHOUSE_CLIENT_CERT","format":"filepath","required":false,"secret":false},{"name":"CLICKHOUSE_TLS_MODE","description":"Client certificate mode: mutual, proxy, or strict","required":false,"secret":false},{"name":"CLICKHOUSE_DATABASE","description":"Default database to use","required":false,"secret":false},{"name":"CLICKHOUSE_ROLE","description":"ClickHouse role to activate for the session","required":false,"secret":false},{"name":"CLICKHOUSE_ALLOW_WRITE_ACCESS","description":"Allow write operations (DDL and DML). Queries run read-only by default","format":"boolean","required":false,"secret":false},{"name":"CLICKHOUSE_ALLOW_DROP","description":"Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled","format":"boolean","required":false,"secret":false},{"name":"CLICKHOUSE_MCP_QUERY_TIMEOUT","description":"Query tool timeout in seconds","format":"number","required":false,"secret":false},{"name":"CLICKHOUSE_MCP_MAX_WORKERS","description":"Maximum query worker thread pool size","format":"number","required":false,"secret":false}],"additional_arguments_declared":false}],"remotes":[]} Source: MCP-Register · collected on 2026-09-22 · self-declared |
Position within the directory
How many of the 41,867 published entries carry the same measured value. A reference figure, not an assessment.
- Required secrets declaredno35,800 of 41,867 carry this value (86 %)View these entries
- Execution locationlocal17,056 of 41,867 carry this value (41 %)View these entries
- Path argument presentyes498 of 41,867 carry this value (1.2 %)View these entries
- Repository URL listedyes30,107 of 41,867 carry this value (72 %)View these entries
- Field of use, derived from the vendor descriptionDatabases338 of 41,867 carry this value (0.8 %)View these entries
All 5 values together are carried by 14 of 41,867 entries.
tracevero · https://tracevero.com/mcp/io-github-clickhouse-mcp-clickhouse/rohangaben