Back to MCP Servers
🧩

IBM Db2 for i MCP Server

API key required

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

To add IBM Db2 for i to Claude, run the install command below or copy the ready-made config for Claude Code, Claude Desktop, Cursor and VS Code further down. Restart your client after adding it and its tools show up in your next conversation. It needs 10 environment variables, listed below.

DatabaseAPIDevTools

Install

npx -y mcp-server-db2i@3.8.5

Environment variables

DB2I_HOSTNAMESet in your MCP config
DB2I_USERNAMESet in your MCP config
DB2I_PASSWORDSet in your MCP config
DB2I_SCHEMASet in your MCP config
DB2I_PROFILESSet in your MCP config
QUERY_ALLOWED_SCHEMASSet in your MCP config
DB2I_DRIVERSet in your MCP config
DB2I_JDBC_OPTIONSSet in your MCP config
DB2I_ODBC_OPTIONSSet in your MCP config
DB2I_MAPEPIRE_OPTIONSSet in your MCP config

Install with your client

Terminal
claude mcp add ibm-db2-for-i --env DB2I_HOSTNAME=<YOUR_DB2I_HOSTNAME> --env DB2I_USERNAME=<YOUR_DB2I_USERNAME> --env DB2I_PASSWORD=<YOUR_DB2I_PASSWORD> --env DB2I_SCHEMA=<YOUR_DB2I_SCHEMA> --env DB2I_PROFILES=<YOUR_DB2I_PROFILES> --env QUERY_ALLOWED_SCHEMAS=<YOUR_QUERY_ALLOWED_SCHEMAS> --env DB2I_DRIVER=<YOUR_DB2I_DRIVER> --env DB2I_JDBC_OPTIONS=<YOUR_DB2I_JDBC_OPTIONS> --env DB2I_ODBC_OPTIONS=<YOUR_DB2I_ODBC_OPTIONS> --env DB2I_MAPEPIRE_OPTIONS=<YOUR_DB2I_MAPEPIRE_OPTIONS> -- npx -y mcp-server-db2i@3.8.5

Run this in a terminal to add the server to Claude Code.

What this does

IBM Db2 for i exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation.

Requirements

This server needs the following environment variables to be set before it can run:

DB2I_HOSTNAME
DB2I_USERNAME
DB2I_PASSWORD
DB2I_SCHEMA
DB2I_PROFILES
QUERY_ALLOWED_SCHEMAS
DB2I_DRIVER
DB2I_JDBC_OPTIONS
DB2I_ODBC_OPTIONS
DB2I_MAPEPIRE_OPTIONS

Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).

Frequently asked questions

How do I install IBM Db2 for i?

Run the Claude Code command in the install section to add IBM Db2 for i to Claude Code, or copy the ready-made config for your client from the install section on this page. Restart your client afterwards and the tools appear in your next conversation.

Which clients work with IBM Db2 for i?

This page carries setup and config for Claude Code, Claude Desktop, Cursor and VS Code. Any other MCP client that accepts a standard server config can connect to IBM Db2 for i as well.

Does IBM Db2 for i need an API key?

Yes. Before it can run, set these environment variables: DB2I_HOSTNAME, DB2I_USERNAME, DB2I_PASSWORD, DB2I_SCHEMA, DB2I_PROFILES, QUERY_ALLOWED_SCHEMAS, DB2I_DRIVER, DB2I_JDBC_OPTIONS, DB2I_ODBC_OPTIONS, DB2I_MAPEPIRE_OPTIONS. They go in the env block of your MCP config.

Imported from the Official MCP Registry. The details above come from the registry entry; the maker can claim this listing to correct them, add docs, and see its traffic.

Is this your MCP server?

Claim this listing to see its traffic, fix details yourself, and skip the review queue on future updates.

Listed on clauderules.net

Add this badge to your README

Show visitors this server is listed in the ClaudeRules directory. The badge links straight to this listing.

Markdown
[![Listed on clauderules.net](https://clauderules.net/api/badge/io-github-strom-capital-mcp-server-db2i)](https://clauderules.net/mcp/io-github-strom-capital-mcp-server-db2i)
HTML
<a href="https://clauderules.net/mcp/io-github-strom-capital-mcp-server-db2i" target="_blank" rel="noopener noreferrer"><img src="https://clauderules.net/api/badge/io-github-strom-capital-mcp-server-db2i" alt="Listed on clauderules.net" /></a>