IBM Db2 for i for Gemini CLI
io.github.strom-capital/mcp-server-db2i
Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).
client:Gemini CLI
transport:stdio
runtime:npm
Install IBM Db2 for i in Gemini CLI
~/.gemini/settings.json · windows: %USERPROFILE%\.gemini\settings.json
{
"mcpServers": {
"mcp-server-db2i": {
"command": "npx",
"args": [
"-y",
"mcp-server-db2i"
],
"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>"
}
}
}
}Gemini expands $VAR and ${VAR} inside env values, so a secret can live in your shell rather than this file. Gemini CLI docs