Skip to content
VS Code

IBM DB2 for i for VS Code

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:VS Code transport:stdio runtime:npm

Install IBM DB2 for i in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "db2i-hostname",
      "description": "DB2I_HOSTNAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db2i-username",
      "description": "DB2I_USERNAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db2i-password",
      "description": "DB2I_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db2i-schema",
      "description": "DB2I_SCHEMA",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db2i-profiles",
      "description": "DB2I_PROFILES",
      "password": true
    },
    {
      "type": "promptString",
      "id": "query-allowed-schemas",
      "description": "QUERY_ALLOWED_SCHEMAS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db2i-driver",
      "description": "DB2I_DRIVER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db2i-jdbc-options",
      "description": "DB2I_JDBC_OPTIONS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db2i-odbc-options",
      "description": "DB2I_ODBC_OPTIONS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db2i-mapepire-options",
      "description": "DB2I_MAPEPIRE_OPTIONS",
      "password": true
    }
  ],
  "servers": {
    "mcp-server-db2i": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-server-db2i"
      ],
      "env": {
        "DB2I_HOSTNAME": "${input:db2i-hostname}",
        "DB2I_USERNAME": "${input:db2i-username}",
        "DB2I_PASSWORD": "${input:db2i-password}",
        "DB2I_SCHEMA": "${input:db2i-schema}",
        "DB2I_PROFILES": "${input:db2i-profiles}",
        "QUERY_ALLOWED_SCHEMAS": "${input:query-allowed-schemas}",
        "DB2I_DRIVER": "${input:db2i-driver}",
        "DB2I_JDBC_OPTIONS": "${input:db2i-jdbc-options}",
        "DB2I_ODBC_OPTIONS": "${input:db2i-odbc-options}",
        "DB2I_MAPEPIRE_OPTIONS": "${input:db2i-mapepire-options}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

IBM DB2 for i in other clients