AdYour product here, seen by people installing AI tools every day Sponsor slots open: 12 of 12, from $249 a month

IBM Db2 for i

Community

MCP server by Strom-Capital · updated · ★ 27 · 232 downloads a week

Score 77

Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH). IBM Db2 for i is a community project by Strom-Capital, not verified by a company domain.

Yours? Claim it
Maintenance

Last commit 5 days ago

Licence

MIT: permissive, fine for commercial use

Quality

Clear description, published package or server URL, original repository

Security

No risky patterns in the files we checked

What you need

SettingNeededWhat it is
DB2I_HOSTNAMEEnvironment variableRequiredIBM i hostname or IPv4 address
DB2I_USERNAMEEnvironment variableRequiredIBM i user profile
DB2I_PASSWORDEnvironment variable, secretRequiredIBM i password
DB2I_SCHEMAEnvironment variableOptionalDefault schema (library)
DB2I_PROFILESEnvironment variableOptionalPath to a YAML file of IBM i systems. When set, it replaces the DB2I_* connection variables
QUERY_ALLOWED_SCHEMASEnvironment variableOptionalComma-separated schemas the server may read. Empty disables the check.
DB2I_DRIVEREnvironment variableOptionalDatabase 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 Default: odbc
DB2I_JDBC_OPTIONSEnvironment variableOptionalExtra JT400 JDBC properties, semicolon-separated (jt400 and mapepire drivers)
DB2I_ODBC_OPTIONSEnvironment variableOptionalExtra IBM i Access ODBC connection keywords, semicolon-separated (odbc driver)
DB2I_MAPEPIRE_OPTIONSEnvironment variableOptionalSSH and Mapepire settings, semicolon-separated, e.g. hostKey=SHA256:...;agent=true;maxJobs=2 (mapepire driver)

From the publisher's entry in the official MCP Registry. Required settings are already in the install config below as placeholders.

Install IBM Db2 for i

Built from the published package, never by AI
claude mcp add ibm-db2-for-i -e DB2I_HOSTNAME=ibmi.example.com -e DB2I_USERNAME=YOUR_DB2I_USERNAME -e DB2I_PASSWORD=YOUR_DB2I_PASSWORD -- npx -y mcp-server-db2i

Run in your terminal. Add --scope user to use it in every project.

Step-by-step: install IBM Db2 for i in Claude Code

MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the ibm-db2-for-i block.

Weekly newsletter

Like IBM Db2 for i? Get the best new MCP servers every week

The best new tools, security warnings before you install something risky, and one practical tip. Free, three minute read.

No spam. Unsubscribe in one click. Privacy

Security check

A

No download-and-run commands, hidden instructions or signs of sending keys out were found.

Checked automatically: README.md, package.json. This looks for known risky patterns and is not a full audit. How grades work

Alternatives to IBM Db2 for i

All alternatives →

IBM Db2 for i: common questions

How do I install IBM Db2 for i?

In Claude Code run claude mcp add ibm-db2-for-i -e DB2I_HOSTNAME=ibmi.example.com -e DB2I_USERNAME=YOUR_DB2I_USERNAME -e DB2I_PASSWORD=YOUR_DB2I_PASSWORD -- npx -y mcp-server-db2i. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.

Is IBM Db2 for i the official server?

IBM Db2 for i is a community project by Strom-Capital, not verified by a company domain.

Is IBM Db2 for i free?

The code is published under the MIT licence. The service it connects to may have its own pricing.

Is IBM Db2 for i safe to use?

It scores 77 of 100. Grades: maintenance A, licence A, quality C. Security check: grade A, no risky patterns found in the files checked. Review the code before you install. How grades work.

What are alternatives to IBM Db2 for i?

Similar MCP servers: Supabase, ArcadeDB MCP Server, MCP Toolbox for Databases, MCP Toolbox for Databases.

Does IBM Db2 for i work with ChatGPT?

Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.

Add to stack

Loading.