IBM Db2 for i vs Ibmi MCP Server
A side-by-side look at the IBM Db2 for i and Ibmi MCP Server MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose IBM Db2 for i for databases work as a local process; choose Ibmi MCP Server for databases as a local process. You can also run both side by side in one mcpServers block.
Which MCP server should you choose?
Choose IBM Db2 for i when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- You have the keys it needs:
DB2I_HOSTNAME, DB2I_USERNAME, DB2I_PASSWORD. - You want tools like
execute_query, export_query, list_schemas.
Choose Ibmi MCP Server when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- Its auth model fits you: other.
- You have the keys it needs:
DB2I_HOST, DB2I_USER, DB2I_PASS, DB2I_PORT, DB2I_IGNORE_UNAUTHORIZED, MCP_SERVER_CONFIG. - You want tools like
Database.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 60/100 · Good | 57/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | Not declared | other |
| Pricing | Not declared | Free |
| Required env vars | DB2I_HOSTNAMEDB2I_USERNAMEDB2I_PASSWORD | DB2I_HOSTDB2I_USERDB2I_PASSDB2I_PORTDB2I_IGNORE_UNAUTHORIZEDMCP_SERVER_CONFIG |
| Verified owner | Community listing | Community listing |
| GitHub stars | 26 | 87 |
| Directory activity | 1 views 0 installs 0 upvotes | 1 views 0 installs 0 upvotes |
| Tools | 20 | 1 |
| Full listing | View IBM Db2 for i | View Ibmi MCP Server |
Tools & capabilities
IBM Db2 for i tools 20
execute_queryExecute read-only SELECT queries, with an optional `chart` hint for the [result view](docs/tools.md#result-view)export_queryWrite 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 setlist_schemasList schemas/libraries (with optional filter)list_tablesList tables in a schema (with optional filter)search_tablesFind tables by name or description across librariessearch_columnsFind columns by name or description across librariesdescribe_tableGet detailed column informationlist_viewsList views in a schema (with optional filter)list_indexesList SQL indexes for a tableget_table_constraintsGet primary keys, foreign keys, unique constraintslist_routinesList SQL procedures and functions in a library, with language, external program, and SQL data accessdescribe_routineParameters, return value or result columns, and a call template for a procedure or function- +8 more on the listing page
Ibmi MCP Server tools 1
DatabaseTables, indexes, constraints, statistics
Ready-to-paste client configs
Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.
IBM Db2 for i
{
"mcpServers": {
"ibm-db2-for-i": {
"command": "npx",
"args": [
"-y",
"-p",
"mcp-server-db2i@latest",
"-p",
"node-jt400",
"mcp-server-db2i"
],
"env": {
"DB2I_HOSTNAME": "YOUR_DB2I_HOSTNAME_HERE",
"DB2I_USERNAME": "YOUR_DB2I_USERNAME_HERE",
"DB2I_PASSWORD": "YOUR_DB2I_PASSWORD_HERE"
}
}
}
}
Ibmi MCP Server
{
"mcpServers": {
"ibm-ibmi-mcp-server": {
"command": "npx",
"args": [
"-y",
"@ibm/ibmi-mcp-server@latest"
],
"env": {
"DB2I_HOST": "YOUR_DB2I_HOST_HERE",
"DB2I_USER": "YOUR_DB2I_USER_HERE",
"DB2I_PASS": "YOUR_DB2I_PASS_HERE",
"DB2I_PORT": "YOUR_DB2I_PORT_HERE",
"DB2I_IGNORE_UNAUTHORIZED": "YOUR_DB2I_IGNORE_UNAUTHORIZED_HERE",
"MCP_SERVER_CONFIG": "YOUR_MCP_SERVER_CONFIG_HERE"
}
}
}
}
Frequently asked questions
IBM Db2 for i is categorized under Databases and uses a local stdio subprocess. Ibmi MCP Server belongs to Databases and uses a local stdio subprocess. Pick IBM Db2 for i for databases work and Ibmi MCP Server for databases.
Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.
IBM Db2 for i has no declared pricing — check the project's own site. Ibmi MCP Server is listed as free. Auth: other. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.
Yes. MCP clients support multiple servers: add ibm-db2-for-i and ibm-ibmi-mcp-server as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, IBM Db2 for i has a quality signal of 60/100 (Good) with 1 views, 0 installs and 26 GitHub stars. Ibmi MCP Server has 57/100 (Good) with 1 views, 0 installs and 87 GitHub stars.