@bankvision/mcp-as400-server

Model Context Protocol (MCP) server for IBM AS400/iSeries database operations.

Prerequisites

• Java 17 or later - Required to run the server
  • Install from Adoptium or your package manager

Installation

Global Installation

npm install -g @bankvision/mcp-as400-server

Run with npx (no installation)

npx @bankvision/mcp-as400-server

Usage

Environment Variables (Required)

export AS400_HOST=your-as400-host
export AS400_USERNAME=your-username
export AS400_PASSWORD=your-password

Run in STDIO Mode (for MCP clients)

MCP_SERVER_MODE=stdio mcp-as400-server

Run in HTTP Mode (for remote access)

MCP_SERVER_MODE=http MCP_HTTP_PORT=8080 mcp-as400-server

VS Code Integration

Add to .vscode/mcp.json:

{
  "servers": {
    "as400": {
      "command": "npx",
      "args": ["@bankvision/mcp-as400-server"],
      "env": {
        "AS400_HOST": "your-as400-host",
        "AS400_USERNAME": "your-username",
        "AS400_PASSWORD": "your-password",
        "MCP_SERVER_MODE": "stdio"
      },
      "type": "stdio"
    }
  }
}

Claude Desktop Integration

Add to Claude Desktop config (~/Library/Application Support/Claude/claude_desktop_config.json on macOS):

{
  "mcpServers": {
    "as400": {
      "command": "npx",
      "args": ["@bankvision/mcp-as400-server"],
      "env": {
        "AS400_HOST": "your-as400-host",
        "AS400_USERNAME": "your-username",
        "AS400_PASSWORD": "your-password",
        "MCP_SERVER_MODE": "stdio"
      }
    }
  }
}

Available Tools

| Tool | Description | |------|-------------| | execute_query | Execute SELECT queries and return results as JSON | | execute_update | Execute INSERT, UPDATE, DELETE statements | | list_tables | List all tables in a library/schema | | describe_table | Get column definitions and metadata | | get_sample_data | Get sample rows from a table | | get_server_info | Get AS400 connection information |

Configuration

| Variable | Required | Default | Description | |----------|----------|---------|-------------| | AS400_HOST | Yes | - | AS400 hostname or IP | | AS400_USERNAME | Yes | - | AS400 username | | AS400_PASSWORD | Yes | - | AS400 password | | AS400_LIBRARY | No | VISION4 | Default library/schema | | MCP_SERVER_MODE | No | stdio | stdio or http | | MCP_HTTP_PORT | No | 8080 | HTTP port (when mode=http) |

Links

• GitHub Repository
• Full Documentation
• Docker Image

License

MIT