How do I install IBM Db2 for i?

Install via Claude Code (local): 1. Install Claude Code CLI 2. Copy the command below, replace with real env values, then run in terminal 3. See Environment variables below if listed Example: claude mcp add mcp-server-db2i --env DB2I_HOSTNAME= --env DB2I_USERNAME= --env DB2I_PASSWORD= -- npx -y mcp-server-db2i

What is IBM Db2 for i good for?

IBM Db2 for i is a fit for: Code review & GitHub, Cursor essentials. See AgentHub scenario pages for pairings.

IBM Db2 for i MCP Setup & Guide

MCP ServerMCP RegistryOfficial

io.github.Strom-Capital/mcp-server-db2i · v3.5.0

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

View on MCP Registry ↗Repository ↗

Copy the install config on this page first, then verify docs and permissions upstream.

Overview

Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH). IBM Db2 for i is a MCP Server listed from MCP Registry. Transports: stdio. This page includes an overview, setup tutorial, install commands, and use cases for Trae, Tongyi Lingma, Cursor, Claude Code, and VS Code.

Use cases

Code review & GitHub Cursor essentials

AgentHub Verified AvailabilityTested & Ready

Automated pipeline validated install commands, protocol & client compatibility

Verified At2026-10-04

Install Snippets TestedCLI & JSON config syntax verified

Protocol Handshake ReadyComplies with JSON-RPC 2.0 specifications

Origin Registry ActiveSourced from official-mcp-registry

Verified ClientsClaude Code、Claude Desktop、Cursor 等

Security Tier: A+ 级 · 官方认证推荐 (A+)·Maintained by official/verified teams, audited for standard MCP protocol compliance.

Score 90/100

Copy by platform

Choose your platform

Open or create .cursor/mcp.json in your project root
Click Copy config and paste; merge only this mcpServers entry if others exist
Replace <placeholders> in env with real secrets (see Environment variables below)
Save, then Cmd+Shift+P → Reload Window

Pre-fill Environment Variables (Optional)

DB2I_HOSTNAME

Required

DB2I_USERNAME

Required

DB2I_PASSWORD

Requiredsecret

DB2I_SCHEMA

DB2I_PROFILES

QUERY_ALLOWED_SCHEMAS

DB2I_DRIVER

DB2I_JDBC_OPTIONS

DB2I_ODBC_OPTIONS

DB2I_MAPEPIRE_OPTIONS

Privacy Guarantee: Keys are replaced 100% locally in your browser memory and are NEVER uploaded or stored on any server.

Click to copy snippet

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

Setup tutorial

Open the IBM Db2 for i page and confirm this MCP Server (source: MCP Registry).
Copy the Cursor, Claude Code, or VS Code snippet.
Merge it into mcpServers and replace env placeholders with real secrets.
Reload the window, then call the MCP tools from your agent chat.

Install commands

Install commands and setup steps are in the HTML so search engines and no-JS browsers can read them without running client JavaScript.

Claude Code (local)

Install Claude Code CLI
Copy the command below, replace <placeholders> with real env values, then run in terminal
See Environment variables below if listed

claude mcp add mcp-server-db2i --env DB2I_HOSTNAME=<DB2I_HOSTNAME> --env DB2I_USERNAME=<DB2I_USERNAME> --env DB2I_PASSWORD=<DB2I_PASSWORD> -- npx -y mcp-server-db2i

Cursor — .cursor/mcp.json (local)

Open or create .cursor/mcp.json in your project root
Click Copy config and paste; merge only this mcpServers entry if others exist
Replace <placeholders> in env with real secrets (see Environment variables below)
Save, then Cmd+Shift+P → Reload Window

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

VS Code — .vscode/mcp.json (local)

Install GitHub Copilot in VS Code with MCP support
Open or create .vscode/mcp.json in your project root
Click Copy config and paste; merge only this mcpServers entry if others exist
Replace <placeholders> in env with real secrets
Save and Developer: Reload Window

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

Claude Desktop — claude_desktop_config.json (local)

Open Claude Desktop claude_desktop_config.json (see remote guide for paths)
Click Copy config and merge under mcpServers
Replace <placeholders> in env with real secrets
Fully quit and restart Claude Desktop

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

Trae — .trae/mcp.json (local)

Trae → Settings → MCP, or edit .trae/mcp.json / global mcp.json
Click Copy config and merge mcpServers
Replace <placeholders> in env with real secrets
Save and reload Trae

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

Cherry Studio — MCP settings (local)

Cherry Studio → Settings → MCP Servers → Add (STDIO)
Or import JSON: click Copy config and merge mcpServers
Replace <placeholders> in env; ensure Node.js / uv (npx, uvx) are installed
Enable the server and check tools load

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

Tongyi Lingma — MCP config (local)

Lingma Settings → MCP → + → STDIO or config file
Click Copy config and merge mcpServers
Replace <placeholders> in env; need Node.js 18+ (npx) or uv (uvx)
Confirm connected before using tools in agent chat

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

Windsurf — mcp_config.json (local)

Edit ~/.codeium/windsurf/mcp_config.json
Click Copy config and merge mcpServers (stdio same as Cursor)
Replace <placeholders> in env, save, refresh Cascade

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

Cline — MCP Servers (local)

Cline panel → Settings → MCP Servers
Click Copy config and merge
Replace <placeholders> in env, then save

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

WorkBuddy — .workbuddy/mcp.json (local)

Edit ~/.workbuddy/mcp.json (user) or project .workbuddy/mcp.json
Or Plugins → MCP Servers → Configure MCP and paste the JSON below
Replace <placeholders> in env; on Windows prefer absolute paths for command/scripts
Save, restart WorkBuddy, confirm connector status is green

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

Troubleshooting & Common ErrorsFAQ

Common connection errors and verified fixes for IBM Db2 for i

Getting 'connection closed' or exit code 1 in Cursor / Claude Code for IBM Db2 for i?

Usually caused by missing runtime paths or IDE environment inheritance. Fix steps: 1. Verify Node.js 18+ (npx) or Python 3.10+ (uvx) is installed; 2. Run 'which npx' or 'which uvx' in terminal, and replace 'command' with absolute path; 3. Reload or restart the client window after modifying config.

Fix Snippet

# Check binary path in terminal:
which npx
node -v

Getting 'spawn npx ENOENT' or 'command not found'?

The editor background process does not inherit your full terminal PATH. Solution: Globally install the package, or set the absolute binary path (e.g. C:\Program Files\nodejs\npx.cmd on Windows, or /usr/local/bin/npx on macOS).

Missing required environment variable or authentication failure?

IBM Db2 for i requires environment variables (DB2I_HOSTNAME、DB2I_USERNAME、DB2I_PASSWORD). Ensure you have added valid keys under the 'env' object in your config file without trailing whitespace.

Fix Snippet

// .cursor/mcp.json 或 claude_desktop_config.json
{
  "env": {
    "DB2I_HOSTNAME": "your_actual_key_here"
  }
}

Still not connecting? Read the MCP troubleshooting guide →

Tool Mock Playground

Sandbox

IBM Db2 for i Tool Interface Simulation · Preview tool schema & outputs without local runtime

Sandbox Ready

fn: mcp_server_db2iExecute the core tool interface of IBM Db2 for i

Request ArgumentsJSON Schema

{
  "target": "IBM Db2 for i",
  "action": "execute",
  "options": {
    "mode": "standard",
    "timeoutMs": 5000
  }
}

💡Parameters generated dynamically by Agent runtime

Agent Tool Output

Click 'Run Mock' above

to preview the raw response returned to the LLM

Env: AgentHub Virtual SandboxJSON-RPC 2.0

Decision Guide: Why & When to Use

Assess suitability before installing to save trial-and-error time

Best Suited For

PR review
Changelog generation
Cross-repo issue search

When NOT to Use

Replacing human security audit
Unauthorized repo access

Recommended Workflow Pairing:View Scenario →

Most people compare similar tools or check scenario guides before installing—start here.

Browse more like this Search similar Pick by scenario Prompt playbooks MCP hands-on Reviews & comparisons

Listing badge: put AgentHub on your site

Copy either snippet into your project homepage, docs, or GitHub README. The badge is a hotlinked SVG — nothing to host — and it links back to this page so visitors can find the install steps.

Preview

HTML

<a href="https://myagenthub.cn/p/io.github.Strom-Capital/mcp-server-db2i" title="Listed on AgentHub: IBM Db2 for i" target="_blank" rel="noopener">
  <img src="https://myagenthub.cn/badge/io.github.Strom-Capital/mcp-server-db2i?lang=en" alt="Listed on AgentHub: IBM Db2 for i" height="20" style="border:0"/>
</a>

Markdown (GitHub README)

[![Listed on AgentHub: IBM Db2 for i](https://myagenthub.cn/badge/io.github.Strom-Capital/mcp-server-db2i?lang=en)](https://myagenthub.cn/p/io.github.Strom-Capital/mcp-server-db2i)

Badges are generated on the fly from /badge/<package-id>, so name and listing changes propagate automatically. Keep the link target unchanged — it is what counts as the referral.

Unified Manifest

{
  "id": "io.github.Strom-Capital/mcp-server-db2i",
  "type": "mcp-server",
  "version": "3.5.0",
  "displayName": "IBM Db2 for i",
  "description": "Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).",
  "repository": {
    "url": "https://github.com/Strom-Capital/mcp-server-db2i",
    "source": "github"
  },
  "homepage": "https://db2i-mcp.com",
  "distribution": {
    "packages": [
      {
        "registryType": "npm",
        "identifier": "mcp-server-db2i",
        "version": "3.5.0",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "DB2I_HOSTNAME",
            "description": "IBM i hostname or IPv4 address",
            "isRequired": true
          },
          {
            "name": "DB2I_USERNAME",
            "description": "IBM i user profile",
            "isRequired": true
          },
          {
            "name": "DB2I_PASSWORD",
            "description": "IBM i password",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "DB2I_SCHEMA",
            "description": "Default schema (library)"
          },
          {
            "name": "DB2I_PROFILES",
            "description": "Path to a YAML file of IBM i systems. When set, it replaces the DB2I_* connection variables"
          },
          {
            "name": "QUERY_ALLOWED_SCHEMAS",
            "description": "Comma-separated schemas the server may read. Empty disables the check."
          },
          {
            "name": "DB2I_DRIVER",
            "description": "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)"
          },
          {
            "name": "DB2I_JDBC_OPTIONS",
            "description": "Extra JT400 JDBC properties, semicolon-separated (jt400 and mapepire drivers)"
          },
          {
            "name": "DB2I_ODBC_OPTIONS",
            "description": "Extra IBM i Access ODBC connection keywords, semicolon-separated (odbc driver)"
          },
          {
            "name": "DB2I_MAPEPIRE_OPTIONS",
            "description": "SSH and Mapepire settings, semicolon-separated, e.g. hostKey=SHA256:...;maxJobs=2 (mapepire driver)"
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode",
    "trae",
    "cherry-studio",
    "lingma",
    "windsurf",
    "cline",
    "workbuddy"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.Strom-Capital/mcp-server-db2i",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.Strom-Capital%2Fmcp-server-db2i/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}