IBM Db2 for i
local MCP serverInstallation
Terminal
claude mcp add mcp-server-db2i -e DB2I_HOSTNAME=... -e DB2I_USERNAME=... -e DB2I_PASSWORD=... -e DB2I_SCHEMA=... -e DB2I_PROFILES=... -e QUERY_ALLOWED_SCHEMAS=... -e DB2I_DRIVER=... -e DB2I_JDBC_OPTIONS=... -e DB2I_ODBC_OPTIONS=... -e DB2I_MAPEPIRE_OPTIONS=... -- npx -y mcp-server-db2i
Run in your project folder. Add --scope user to use it everywhere.
Claude Desktop, Cursor & other clients
Add to claude_desktop_config.json or .cursor/mcp.json.
{
"mcpServers": {
"mcp-server-db2i": {
"command": "npx",
"args": [
"-y",
"mcp-server-db2i"
],
"env": {
"DB2I_HOSTNAME": "...",
"DB2I_USERNAME": "...",
"DB2I_PASSWORD": "...",
"DB2I_SCHEMA": "...",
"DB2I_PROFILES": "...",
"QUERY_ALLOWED_SCHEMAS": "...",
"DB2I_DRIVER": "...",
"DB2I_JDBC_OPTIONS": "...",
"DB2I_ODBC_OPTIONS": "...",
"DB2I_MAPEPIRE_OPTIONS": "..."
}
}
}
}Fill in the environment variables with your own credentials.
Summary
Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).
Questions
IBM Db2 for i is a local MCP server distributed as the npm package mcp-server-db2i.
Run: claude mcp add mcp-server-db2i -e DB2I_HOSTNAME=... -e DB2I_USERNAME=... -e DB2I_PASSWORD=... -e DB2I_SCHEMA=... -e DB2I_PROFILES=... -e QUERY_ALLOWED_SCHEMAS=... -e DB2I_DRIVER=... -e DB2I_JDBC_OPTIONS=... -e DB2I_ODBC_OPTIONS=... -e DB2I_MAPEPIRE_OPTIONS=... -- npx -y mcp-server-db2i
Run: codex mcp add mcp-server-db2i --env DB2I_HOSTNAME=... --env DB2I_USERNAME=... --env DB2I_PASSWORD=... --env DB2I_SCHEMA=... --env DB2I_PROFILES=... --env QUERY_ALLOWED_SCHEMAS=... --env DB2I_DRIVER=... --env DB2I_JDBC_OPTIONS=... --env DB2I_ODBC_OPTIONS=... --env DB2I_MAPEPIRE_OPTIONS=... -- npx -y mcp-server-db2i
Similar MCP servers
NameStars
- Avrotizeio.github.clemensv/avrotize131
- MCP Local WPio.github.verygoodplugins/mcp-local-wp33
- schemacrawler-aiio.github.schemacrawler/schemacrawler-ai12
- Codebase Memoryio.github.DeusData/codebase-memory-mcp45K
- Oh My Posh Validatordev.ohmyposh/validator24K
- Airweave Searchio.github.airweave-ai/search6,561
- LINQ to DBio.github.linq2db/linq2db.cli3,329
- QueryWeavercom.falkordb/QueryWeaver1,081