Install IBM Db2 for i in LM Studio
What you need first
- LM Studio, installed.
- Node.js, which
gives the
npxcommand the server starts with. - Your own values for
YOUR_DB2I_HOSTNAME,YOUR_DB2I_USERNAME,YOUR_DB2I_PASSWORD.
Steps
- In LM Studio, open the Program tab and choose Install › Edit mcp.json.
- Add this block. If the file already has
mcpServers, add only the entry inside it.
{
"mcpServers": {
"mcp-server-db2i": {
"command": "npx",
"args": ["-y", "[email protected]"],
"env": { "DB2I_HOSTNAME": "YOUR_DB2I_HOSTNAME", "DB2I_USERNAME": "YOUR_DB2I_USERNAME", "DB2I_PASSWORD": "YOUR_DB2I_PASSWORD" }
}
}
} - Replace
YOUR_DB2I_HOSTNAME,YOUR_DB2I_USERNAME,YOUR_DB2I_PASSWORDwith your own values. - Save the file and restart LM Studio.
Check it worked
Ask LM Studio: List the tools of mcp-server-db2i.
If it does not start
- spawn npx ENOENT
- Node.js is not on the PATH that LM Studio sees. Install it, or write the
full path of
npxin the config. - The server starts, but its tools fail
- A
YOUR_…placeholder is still in the config, or its value is wrong. - Nothing changes after a restart
- The file is not valid JSON any more. Look for a missing comma where the block was added.