AS400

Provides AS400 metadata, source code access, and program relationships via ODBC for CL/RPG/COBOL development.

python

0

GitHub Stars

python

Language

4 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "omni-s-as400-mcp": {
      "command": "C:/path/to/as400-mcp/.venv/Scripts/python.exe",
      "args": [
        "-m",
        "as400_mcp.server"
      ],
      "env": {
        "AS400_CONNECTION_STRING": "DRIVER={IBM i Access ODBC Driver};SYSTEM=YOUR_SYSTEM;UID=USER;PWD=PASS;CCSID=1208;EXTCOLINFO=1"
      }
    }
  }
}

You gain a read-only MCP server that connects to an AS/400 (IBM i) system via ODBC to fetch metadata, source code, program references, and system information. It is designed to help Claude Code users accelerate CL, RPG, and COBOL development by providing structured access to tables, sources, and program relationships while keeping operations read-only for security.

How to use

You operate the MCP server from your Claude Code project and access data through the MCP tooling it exposes. Your workflow typically involves inspecting table structures and labels, viewing source files, examining program references, retrieving sample data, and then generating web interfaces or APIs that consume these MCP results.

How to install

Prerequisites: you need Python 3.10 or later and the IBM i Access ODBC Driver. Ensure your AS/400 system is reachable (7.3 or newer is supported; 7.4+ enables additional features). You also need connection details for the AS/400 host.

Clone the MCP server repository, create a virtual environment, and install the package in editable mode.

Available tools

list_libraries

List libraries with descriptive labels.

list_tables

List tables/files available in libraries.

get_columns

Get column metadata including Japanese labels, data types, and key information.

list_source_files

List source files such as QCLSRC and QRPGSRC.

list_sources

List source members within source files.

get_source

Retrieve the contents of a source member.

get_data

Fetch data from tables.

get_table_info

Retrieve detailed information about a table.

get_system_info

Retrieve system information such as OS version and PTF level.

list_programs

List programs (RPG, CL, COBOL, etc.).

get_program_references

Analyze program references and call relationships between files and programs.

list_data_areas

List data areas (shared variables).

execute_sql

Execute read-only SELECT queries against the database.