Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).
Connect Runs on your machine
claude mcp add mcp-server-db2i -e DB2I_HOSTNAME=<DB2I_HOSTNAME> -e DB2I_USERNAME=<DB2I_USERNAME> -e DB2I_PASSWORD=<DB2I_PASSWORD> -e DB2I_SCHEMA=<DB2I_SCHEMA> -e DB2I_PROFILES=<DB2I_PROFILES> -e QUERY_ALLOWED_SCHEMAS=<QUERY_ALLOWED_SCHEMAS> -e DB2I_DRIVER=<DB2I_DRIVER> -e DB2I_JDBC_OPTIONS=<DB2I_JDBC_OPTIONS> -e DB2I_ODBC_OPTIONS=<DB2I_ODBC_OPTIONS> -e DB2I_MAPEPIRE_OPTIONS=<DB2I_MAPEPIRE_OPTIONS> -- npx -y [email protected]{
"mcpServers": {
"mcp-server-db2i": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DB2I_HOSTNAME": "<DB2I_HOSTNAME>",
"DB2I_USERNAME": "<DB2I_USERNAME>",
"DB2I_PASSWORD": "<DB2I_PASSWORD>",
"DB2I_SCHEMA": "<DB2I_SCHEMA>",
"DB2I_PROFILES": "<DB2I_PROFILES>",
"QUERY_ALLOWED_SCHEMAS": "<QUERY_ALLOWED_SCHEMAS>",
"DB2I_DRIVER": "<DB2I_DRIVER>",
"DB2I_JDBC_OPTIONS": "<DB2I_JDBC_OPTIONS>",
"DB2I_ODBC_OPTIONS": "<DB2I_ODBC_OPTIONS>",
"DB2I_MAPEPIRE_OPTIONS": "<DB2I_MAPEPIRE_OPTIONS>"
}
}
}
}{
"mcpServers": {
"mcp-server-db2i": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DB2I_HOSTNAME": "<DB2I_HOSTNAME>",
"DB2I_USERNAME": "<DB2I_USERNAME>",
"DB2I_PASSWORD": "<DB2I_PASSWORD>",
"DB2I_SCHEMA": "<DB2I_SCHEMA>",
"DB2I_PROFILES": "<DB2I_PROFILES>",
"QUERY_ALLOWED_SCHEMAS": "<QUERY_ALLOWED_SCHEMAS>",
"DB2I_DRIVER": "<DB2I_DRIVER>",
"DB2I_JDBC_OPTIONS": "<DB2I_JDBC_OPTIONS>",
"DB2I_ODBC_OPTIONS": "<DB2I_ODBC_OPTIONS>",
"DB2I_MAPEPIRE_OPTIONS": "<DB2I_MAPEPIRE_OPTIONS>"
}
}
}
}{
"servers": {
"mcp-server-db2i": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DB2I_HOSTNAME": "<DB2I_HOSTNAME>",
"DB2I_USERNAME": "<DB2I_USERNAME>",
"DB2I_PASSWORD": "<DB2I_PASSWORD>",
"DB2I_SCHEMA": "<DB2I_SCHEMA>",
"DB2I_PROFILES": "<DB2I_PROFILES>",
"QUERY_ALLOWED_SCHEMAS": "<QUERY_ALLOWED_SCHEMAS>",
"DB2I_DRIVER": "<DB2I_DRIVER>",
"DB2I_JDBC_OPTIONS": "<DB2I_JDBC_OPTIONS>",
"DB2I_ODBC_OPTIONS": "<DB2I_ODBC_OPTIONS>",
"DB2I_MAPEPIRE_OPTIONS": "<DB2I_MAPEPIRE_OPTIONS>"
}
}
}
}Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
DB2I_HOSTNAMERequired | IBM i hostname or IPv4 address |
DB2I_USERNAMERequired | IBM i user profile |
DB2I_PASSWORDRequired, secret | IBM i password |
DB2I_SCHEMAOptional | Default schema (library) |
DB2I_PROFILESOptional | Path to a YAML file of IBM i systems. When set, it replaces the DB2I_* connection variables |
QUERY_ALLOWED_SCHEMASOptional | Comma-separated schemas the server may read. Empty disables the check. |
DB2I_DRIVEROptional | 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) |
DB2I_JDBC_OPTIONSOptional | Extra JT400 JDBC properties, semicolon-separated (jt400 and mapepire drivers) |
DB2I_ODBC_OPTIONSOptional | Extra IBM i Access ODBC connection keywords, semicolon-separated (odbc driver) |
DB2I_MAPEPIRE_OPTIONSOptional | SSH and Mapepire settings, semicolon-separated, e.g. hostKey=SHA256:...;agent=true;maxJobs=2 (mapepire driver) |
Details
| Package | [email protected] (NPM, stdio) |
| First published | 11 Nov 2026 |
| Last updated | 11 Nov 2026 |
| Registry name | io.github.Strom-Capital/mcp-server-db2i |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.