IBM DB2 for i for VS Code
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:VS Code
transport:stdio
runtime:npm
Install IBM DB2 for i in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "db2i-hostname",
"description": "DB2I_HOSTNAME",
"password": true
},
{
"type": "promptString",
"id": "db2i-username",
"description": "DB2I_USERNAME",
"password": true
},
{
"type": "promptString",
"id": "db2i-password",
"description": "DB2I_PASSWORD",
"password": true
},
{
"type": "promptString",
"id": "db2i-schema",
"description": "DB2I_SCHEMA",
"password": true
},
{
"type": "promptString",
"id": "db2i-profiles",
"description": "DB2I_PROFILES",
"password": true
},
{
"type": "promptString",
"id": "query-allowed-schemas",
"description": "QUERY_ALLOWED_SCHEMAS",
"password": true
},
{
"type": "promptString",
"id": "db2i-driver",
"description": "DB2I_DRIVER",
"password": true
},
{
"type": "promptString",
"id": "db2i-jdbc-options",
"description": "DB2I_JDBC_OPTIONS",
"password": true
},
{
"type": "promptString",
"id": "db2i-odbc-options",
"description": "DB2I_ODBC_OPTIONS",
"password": true
},
{
"type": "promptString",
"id": "db2i-mapepire-options",
"description": "DB2I_MAPEPIRE_OPTIONS",
"password": true
}
],
"servers": {
"mcp-server-db2i": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"mcp-server-db2i"
],
"env": {
"DB2I_HOSTNAME": "${input:db2i-hostname}",
"DB2I_USERNAME": "${input:db2i-username}",
"DB2I_PASSWORD": "${input:db2i-password}",
"DB2I_SCHEMA": "${input:db2i-schema}",
"DB2I_PROFILES": "${input:db2i-profiles}",
"QUERY_ALLOWED_SCHEMAS": "${input:query-allowed-schemas}",
"DB2I_DRIVER": "${input:db2i-driver}",
"DB2I_JDBC_OPTIONS": "${input:db2i-jdbc-options}",
"DB2I_ODBC_OPTIONS": "${input:db2i-odbc-options}",
"DB2I_MAPEPIRE_OPTIONS": "${input:db2i-mapepire-options}"
}
}
}
}
VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs