vba mcp for Claude Desktop

io.github.mrfentmen/vba-mcp

VBA MCP: 20 real tools to read, check, lint, scaffold, build and run VBA code.

client:Claude Desktop transport:stdio runtime:npm

Install vba mcp in Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json · windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "vba-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@mrfentmen/vba-mcp"
      ]
    }
  }
}

Settings → Developer → Edit Config opens this file. Restart the app after saving. Claude Desktop docs