mcp400 (Bashdi)

mcp400-用于AS400/DB2 for i的MCP服务器

基于Spring Boot的MCP服务器，提供有关IBM i（AS/400）数据库的更多上下文和元数据。它目前允许查询表（仅表名和描述）、列、主键和索引。

在vscode中使用Github Copilot

1. 下载mcp400.jar
2. 按照说明操作：https://code.visualstudio.com/docs/copilot/chat/mcp-servers

您需要指定环境变量： AS400_ADDRESS、AS400_USER和AS400_PASSWORD。

示例.vcode/.mcp.json

{
    "inputs": [
        {
            "type": "promptString",
            "id": "AS400_ADDRESS",
            "description": "as400 address",
            "password": false
        },
        {
            "type": "promptString",
            "id": "AS400_USER",
            "description": "as400 user",
            "password": false
        },
        {
            "type": "promptString",
            "id": "AS400_PASSWORD",
            "description": "as400 password",
            "password": true
        }
    ],
    "servers": {
        "mcp400": {
            "type": "stdio",
            "command": "java",
            "args": [
                "-jar",
                "C:\\Users\\bashdi\\Downloads\\mcp400.jar"
            ],
            "env": {
                "AS400_ADDRESS": "${input:AS400_ADDRESS}",
                "AS400_USER": "${input:AS400_USER}",
                "AS400_PASSWORD": "${input:AS400_PASSWORD}"
            }
        }
    }
}

在mcp服务器启动时，VSCode会要求您提供凭据并安全保存