{
    "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
    "name": "io.github.motherduckdb/mcp-server-motherduck",
    "description": "SQL analytics and data engineering for AI Assistants and IDEs",
    "repository": {
        "url": "https://github.com/motherduckdb/mcp-server-motherduck",
        "source": "github"
    },
    "version": "1.0.7",
    "icons": [
        {
            "src": "https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64",
            "mimeType": "image/png",
            "sizes": [
                "64x64"
            ]
        }
    ],
    "packages": [
        {
            "registryType": "pypi",
            "registryBaseUrl": "https://pypi.org",
            "identifier": "mcp-server-motherduck",
            "version": "1.0.7",
            "transport": {
                "type": "stdio"
            },
            "packageArguments": [
                {
                    "description": "Transport type for MCP server. Use 'http' for HTTP Streamable transport.",
                    "default": "stdio",
                    "choices": [
                        "stdio",
                        "http",
                        "sse",
                        "stream"
                    ],
                    "type": "named",
                    "name": "--transport"
                },
                {
                    "description": "Port to listen on for HTTP transport",
                    "format": "number",
                    "default": "8000",
                    "type": "named",
                    "name": "--port"
                },
                {
                    "description": "Host to bind the MCP server",
                    "default": "127.0.0.1",
                    "type": "named",
                    "name": "--host"
                },
                {
                    "description": "Database path: ':memory:' for in-memory, 'md:' for MotherDuck, or file/S3 path",
                    "default": ":memory:",
                    "type": "named",
                    "name": "--db-path"
                },
                {
                    "description": "Access token for MotherDuck connections",
                    "isSecret": true,
                    "type": "named",
                    "name": "--motherduck-token"
                },
                {
                    "description": "Enable write access (server runs in read-only mode by default)",
                    "type": "named",
                    "name": "--read-write"
                },
                {
                    "description": "Enable the switch_database_connection tool to change databases at runtime",
                    "type": "named",
                    "name": "--allow-switch-databases"
                },
                {
                    "description": "Enable SaaS mode for MotherDuck (disables local filesystem access)",
                    "type": "named",
                    "name": "--motherduck-saas-mode"
                },
                {
                    "description": "SQL file path or SQL string to execute on startup",
                    "type": "named",
                    "name": "--init-sql"
                },
                {
                    "description": "Home directory for DuckDB",
                    "type": "named",
                    "name": "--home-dir"
                },
                {
                    "description": "Maximum number of rows to return from queries",
                    "format": "number",
                    "default": "1024",
                    "type": "named",
                    "name": "--max-rows"
                },
                {
                    "description": "Maximum number of characters in query results",
                    "format": "number",
                    "default": "50000",
                    "type": "named",
                    "name": "--max-chars"
                },
                {
                    "description": "Query execution timeout in seconds (-1 to disable)",
                    "format": "number",
                    "default": "-1",
                    "type": "named",
                    "name": "--query-timeout"
                },
                {
                    "description": "Use temporary connections for read-only local DuckDB files (default: true)",
                    "type": "named",
                    "name": "--ephemeral-connections"
                }
            ],
            "environmentVariables": [
                {
                    "description": "Access token for MotherDuck connections (alternative to --motherduck-token)",
                    "isSecret": true,
                    "name": "motherduck_token"
                },
                {
                    "description": "Access token for MotherDuck connections (alternative to --motherduck-token)",
                    "isSecret": true,
                    "name": "MOTHERDUCK_TOKEN"
                },
                {
                    "description": "Used by DuckDB for extensions and config. Override with --home-dir if not set.",
                    "name": "HOME"
                },
                {
                    "description": "AWS access key for S3 database connections",
                    "isSecret": true,
                    "name": "AWS_ACCESS_KEY_ID"
                },
                {
                    "description": "AWS secret access key for S3 database connections",
                    "isSecret": true,
                    "name": "AWS_SECRET_ACCESS_KEY"
                },
                {
                    "description": "AWS session token for temporary credentials",
                    "isSecret": true,
                    "name": "AWS_SESSION_TOKEN"
                },
                {
                    "description": "AWS region for S3 database connections",
                    "name": "AWS_DEFAULT_REGION"
                },
                {
                    "description": "AWS endpoint for S3 database connections",
                    "name": "AWS_ENDPOINT"
                }
            ]
        }
    ],
    "_meta": {
        "io.modelcontextprotocol.registry/official": {
            "status": "active",
            "statusChangedAt": "2026-06-09T12:56:38.524877Z",
            "publishedAt": "2026-06-09T12:56:38.524877Z",
            "updatedAt": "2026-06-09T12:56:38.524877Z",
            "isLatest": true
        },
        "io.modelcontextprotocol.registry/publisher-provided": {
            "publishedAt": "2026-06-09T12:56:38+00:00",
            "updatedAt": "2026-06-09T12:56:38+00:00"
        }
    }
}