Back to Browse

Db2i MCP Server

Developer ToolsModerate6.0MCP RegistryLocal
Free

Server data from the Official MCP Registry

Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).

About

Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).

Security Report

6.0
Moderate6.0Moderate Risk

This is a read-only IBM Db2 for i MCP server with bearer token and OAuth authentication, parameterized configuration, and sensible startup warnings for disabled TLS or host key checks. The visible code shows no data exfiltration or malicious patterns; the main concerns are network access to IBM i hosts and the optional HTTP transport, which are expected for this category, and the truncated code limits full verification. Supply chain analysis found 5 known vulnerabilities in dependencies. Package verification found 1 issue.

6 files analyzed · 10 issues found

Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.

What You'll Need

Set these up before or after installing:

IBM i hostname or IPv4 addressOptional

Environment variable: DB2I_HOSTNAME

IBM i user profileOptional

Environment variable: DB2I_USERNAME

IBM i passwordRequired

Environment variable: DB2I_PASSWORD

Default schema (library)Optional

Environment variable: DB2I_SCHEMA

Path to a YAML file of IBM i systems. When set, it replaces the DB2I_* connection variablesOptional

Environment variable: DB2I_PROFILES

Comma-separated schemas the server may read. Empty disables the check.Optional

Environment variable: QUERY_ALLOWED_SCHEMAS

Database driver: odbc (default, IBM i Access ODBC driver, no Java), jt400 (install node-jt400 next to the server; needs a JDK at install and a JRE at runtime) or mapepire (install @ibm/mapepire-js and ssh2; Mapepire over SSH, needs Java on the IBM i only)Optional

Environment variable: DB2I_DRIVER

Extra JT400 JDBC properties, semicolon-separated (jt400 and mapepire drivers)Optional

Environment variable: DB2I_JDBC_OPTIONS

Extra IBM i Access ODBC connection keywords, semicolon-separated (odbc driver)Optional

Environment variable: DB2I_ODBC_OPTIONS

SSH and Mapepire settings, semicolon-separated, e.g. hostKey=SHA256:...;agent=true;maxJobs=2 (mapepire driver)Optional

Environment variable: DB2I_MAPEPIRE_OPTIONS

How to Install

Add this to your MCP configuration file:

{
  "mcpServers": {
    "mcp-server-db2i": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-server-db2i@3.8.8"
      ],
      "env": {
        "DB2I_DRIVER": "your-db2i-driver-here",
        "DB2I_SCHEMA": "your-db2i-schema-here",
        "DB2I_HOSTNAME": "your-db2i-hostname-here",
        "DB2I_PASSWORD": "your-db2i-password-here",
        "DB2I_PROFILES": "your-db2i-profiles-here",
        "DB2I_USERNAME": "your-db2i-username-here",
        "DB2I_JDBC_OPTIONS": "your-db2i-jdbc-options-here",
        "DB2I_ODBC_OPTIONS": "your-db2i-odbc-options-here",
        "DB2I_MAPEPIRE_OPTIONS": "your-db2i-mapepire-options-here",
        "QUERY_ALLOWED_SCHEMAS": "your-query-allowed-schemas-here"
      }
    }
  }
}

Some servers take additional arguments. See the repository for details.

Reviews

No reviews yet

Be the first to review this server!