{
    "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
    "name": "io.github.ClickHouse/mcp-clickhouse",
    "description": "Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.",
    "title": "ClickHouse",
    "repository": {
        "url": "https://github.com/ClickHouse/mcp-clickhouse",
        "source": "github"
    },
    "version": "0.4.1",
    "websiteUrl": "https://clickhouse.com",
    "packages": [
        {
            "registryType": "pypi",
            "identifier": "mcp-clickhouse",
            "version": "0.4.1",
            "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) 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"
                }
            ]
        },
        {
            "registryType": "oci",
            "identifier": "ghcr.io/clickhouse/mcp-clickhouse:0.4.1",
            "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) 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"
                }
            ]
        }
    ],
    "_meta": {
        "io.modelcontextprotocol.registry/official": {
            "status": "active",
            "statusChangedAt": "2026-07-17T17:22:03.100012Z",
            "publishedAt": "2026-07-17T17:22:03.100012Z",
            "updatedAt": "2026-07-17T17:22:03.100012Z",
            "isLatest": true
        }
    }
}