IBM Db2 for i MCP Server

by strom-capitalio.github.Strom-Capital/mcp-server-db2iv3.5.0

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

23Node.jsstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active8d ago

Install IBM Db2 for i MCP server

claude mcp add db2i -e DB2I_HOSTNAME='<db2i-hostname>' -e DB2I_USERNAME='<db2i-username>' -e DB2I_PASSWORD='<db2i-password>' -- npx -y mcp-server-db2i

{
  "mcpServers": {
    "db2i": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-server-db2i"
      ],
      "env": {
        "DB2I_HOSTNAME": "<db2i-hostname>",
        "DB2I_USERNAME": "<db2i-username>",
        "DB2I_PASSWORD": "<db2i-password>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "db2i": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-server-db2i"
      ],
      "env": {
        "DB2I_HOSTNAME": "<db2i-hostname>",
        "DB2I_USERNAME": "<db2i-username>",
        "DB2I_PASSWORD": "<db2i-password>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "db2i": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-server-db2i"
      ],
      "env": {
        "DB2I_HOSTNAME": "<db2i-hostname>",
        "DB2I_USERNAME": "<db2i-username>",
        "DB2I_PASSWORD": "<db2i-password>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "db2i": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-server-db2i"
      ],
      "env": {
        "DB2I_HOSTNAME": "<db2i-hostname>",
        "DB2I_USERNAME": "<db2i-username>",
        "DB2I_PASSWORD": "<db2i-password>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
DB2I_HOSTNAME	yes	—	IBM i hostname or IPv4 address
DB2I_USERNAME	yes	—	IBM i user profile
DB2I_PASSWORD	yes	yes	IBM i password
DB2I_SCHEMA	—	—	Default schema (library)
DB2I_PROFILES	—	—	Path to a YAML file of IBM i systems. When set, it replaces the DB2I_* connection variables
QUERY_ALLOWED_SCHEMAS	—	—	Comma-separated schemas the server may read. Empty disables the check.
DB2I_DRIVER	—	—	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)
DB2I_JDBC_OPTIONS	—	—	Extra JT400 JDBC properties, semicolon-separated (jt400 and mapepire drivers)
DB2I_ODBC_OPTIONS	—	—	Extra IBM i Access ODBC connection keywords, semicolon-separated (odbc driver)
DB2I_MAPEPIRE_OPTIONS	—	—	SSH and Mapepire settings, semicolon-separated, e.g. hostKey=SHA256:...;maxJobs=2 (mapepire driver)

Freshness

Active — last maintenance signal 8d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-10-01 · 8d ago · GitHub
Latest release
2026-10-01 · 8d ago · GitHub · v3.5.0
Package published
no data · npm/PyPI
Registry entry updated
2026-10-01 · 8d ago · official registry · v3.5.0

FAQ

›How do I install the IBM Db2 for i MCP server in Claude Code?

Run: claude mcp add db2i -e DB2I_HOSTNAME='<db2i-hostname>' -e DB2I_USERNAME='<db2i-username>' -e DB2I_PASSWORD='<db2i-password>' -- npx -y mcp-server-db2i. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does IBM Db2 for i require an API key?

Yes. It expects DB2I_HOSTNAME, DB2I_USERNAME, DB2I_PASSWORD, of which 1 is a secret.

›Can I use IBM Db2 for i as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is IBM Db2 for i in the official MCP registry?

Yes, as io.github.Strom-Capital/mcp-server-db2i.