Skip to content
Windsurf

IBM DB2 for i for Windsurf

io.github.strom-capital/mcp-server-db2i

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

client:Windsurf transport:stdio runtime:npm

Install IBM DB2 for i in Windsurf

~/.codeium/windsurf/mcp_config.json · windows: %USERPROFILE%\.codeium\windsurf\mcp_config.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

{
  "mcpServers": {
    "mcp-server-db2i": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-server-db2i"
      ],
      "env": {
        "DB2I_HOSTNAME": "<DB2I_HOSTNAME>",
        "DB2I_USERNAME": "<DB2I_USERNAME>",
        "DB2I_PASSWORD": "<DB2I_PASSWORD>",
        "DB2I_SCHEMA": "<DB2I_SCHEMA>",
        "DB2I_PROFILES": "<DB2I_PROFILES>",
        "QUERY_ALLOWED_SCHEMAS": "<QUERY_ALLOWED_SCHEMAS>",
        "DB2I_DRIVER": "<DB2I_DRIVER>",
        "DB2I_JDBC_OPTIONS": "<DB2I_JDBC_OPTIONS>",
        "DB2I_ODBC_OPTIONS": "<DB2I_ODBC_OPTIONS>",
        "DB2I_MAPEPIRE_OPTIONS": "<DB2I_MAPEPIRE_OPTIONS>"
      }
    }
  }
}

Global only — Windsurf has no per-project MCP config. Refresh Cascade after saving. Windsurf docs

IBM DB2 for i in other clients