IBM Db2 for i MCP Server

mcp-server-db2i is a Model Context Protocol (MCP) server for IBM Db2 for i (Db2i) on IBM i (AS/400). It enables AI assistants like Claude and Cursor to query and inspect IBM i databases through the IBM i Access ODBC driver, or optionally the JT400 JDBC driver or Mapepire over SSH. Its 21 documented tools cover table, tables. It runs locally over stdio via the published package.

People who work with table and tables and want it reachable from Claude, Cursor, VS Code, or another MCP client. The project is written in TypeScript.

VERIFIED ACTIVE

LAST COMMIT 2026-09-28 · ★ 22 · #130 OF 165 MAINTAINED CLOUD INFRASTRUCTURE · VERIFIED 2026-09-30

MIT · TypeScript servers · how we verify → /methodology

01 · Install IBM Db2 for i

before you install - you'll need

Set DB2I_HOSTNAME, DB2I_USERNAME, DB2I_PASSWORD before connecting. DB2I_SCHEMA is optional or environment-specific per the README.

Claude Code

claude mcp add strom-capital-mcp-server-db2i -- npx -y mcp-server-db2i

Claude Desktop / Cursor / VS Code - add to config

{
  "mcpServers": {
    "strom-capital-mcp-server-db2i": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-server-db2i"
      ]
    }
  }
}

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions

license MIT - declared in the repository

npm package mcp-server-db2i - unscoped; check the name against the project README before installing

registry namespace io.github.Strom-Capital is GitHub-verified and matches the repo owner

03 · What IBM Db2 for i can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

What you can build

With this server connected, an agent can execute read-only SELECT queries, list schemas/libraries (with optional filter), list tables in a schema (with optional filter), and find tables by name or description across libraries.

Capability map

Tools grouped from the project's README - what IBM Db2 for i lets an agent do.

read & search

11 tools - e.g. List schemas/libraries (with optional filter); Find columns by name or description across libraries; List views in a schema (with optional filter)

list_schemas · search_columns · list_views · list_indexes · list_routines · describe_routine…

Table

3 tools - e.g. Get detailed column information; Get primary keys, foreign keys, unique constraints; Row count, last change, and per-column distinct and null counts from stored statistics or a scan

describe_table · get_table_constraints · profile_table

Tables

2 tools - e.g. List tables in a schema (with optional filter); Find tables by name or description across libraries

list_tables · search_tables

run & execute

1 tool - e.g. Execute read-only SELECT queries

execute_query

Export

1 tool - e.g. Write every row of a read-only query to a CSV or XLSX file: a path over stdio, a short-lived download link over HTTP. Off unless EXPORT_ENABLED is set

export_query

Validate

1 tool - e.g. Check a statement without running it, including catalog names

validate_query

Index

1 tool - e.g. List the indexes the query optimizer asked for in a library, merged and ranked by temporary index use

index_advice

Cust

1 tool - e.g. Contains "CUST"

CUST

Latest releases

v3.2.0 · 2026-09-30

3.2.0 (2026-09-30) · send server instructions built from custom tool files

v3.1.0 · 2026-09-29

3.1.0 (2026-09-29) · close session pools that sit idle (MCP_POOL_IDLE_TIMEOUT) · keep one pool per OAuth sign-in across token refreshes · do not undo a revocation that lands during a token refresh · bump hono from…

v3.0.1 · 2026-09-29

3.0.1 (2026-09-29) · point npx instructions at mcp-server-db2i@latest · return hosted OAuth clients to their callback from a page, not a form redirect

04 · Who maintains IBM Db2 for i

IBM Db2 for i is maintained by strom-capital. It's the only MCP server we track from this author; the repo dates to Jan 2026.

05 · Facts

repository: github.com/strom-capital/mcp-server-db2i
website: https://db2i-mcp.com/
category: cloud infrastructure - ranked #130 of 165 actively-maintained cloud infrastructure servers as of 2026-09-30.
release cadence: 10+ releases in the last 90 days (latest 2026-09-30)
registry: io.github.Strom-Capital/mcp-server-db2i (active, first published 2026-09-23 · 14 versions)
packages: npm:mcp-server-db2i

06 · IBM Db2 for i FAQ

Is IBM Db2 for i still maintained?

Yes - as of 2026-09-30, its last commit was 2026-09-28 and it shipped 10+ releases in the last 90 days. We re-verify nightly.

What can IBM Db2 for i do?

How do I install IBM Db2 for i?

Run `npx -y mcp-server-db2i`. The README documents 4 environment variables (DB2I_HOSTNAME, DB2I_USERNAME, DB2I_PASSWORD…) to set first. Set DB2I_HOSTNAME, DB2I_USERNAME, DB2I_PASSWORD before connecting. DB2I_SCHEMA is optional or environment-specific per the README. You can also paste the ready-made client config above.

Does IBM Db2 for i run locally?

Yes - it's a stdio server: it runs on your machine (via npx) with your user's permissions. Your data stays local unless the server itself calls external APIs.

07 · Alternatives to IBM Db2 for i

Alternatives to IBM Db2 for i

Maintained cloud infrastructure servers if IBM Db2 for i isn't the fit.

Pairs well with

Servers that cover what IBM Db2 for i doesn't - only shown when the pairing reason fits the companion.

More cloud infrastructure MCP servers · Coolify · Search Console MCP · Killbottleneck · Emfirge · Costco

More TypeScript MCP servers · Advanced GitLab MCP server · Local Memory · StudioMeyer Video · AI AppSec · see all