A Model Context Protocol (MCP) server for interacting with DB2 for LUW databases.
- Establish connections to DB2 databases
- Execute SQL queries
- Call stored procedures
- Clone this repository
- Configure your database connection in the
.envfile - Install dependencies
python3 -m venv db2_x86_env
source db2_x86_env/bin/activate
pip install --trusted-host pypi.org --trusted-host files.pythonhosted.org -r requirements.txtsource ./db2_x86_env/bin/activate && python3 server.py
./python_x86_wrapper.sh server.py # (for Apple M1/M2 chips)
{
"mcpServers": {
"db2-mcp": {
"autoApprove": [
"connect_db"
],
"disabled": false,
"timeout": 60,
"command": "/Users/zlx/Desktop/zlx/3.Coding/AI/db2-mcp/python_x86_wrapper.sh",
"args": [
"/Users/zlx/Desktop/zlx/3.Coding/AI/db2-mcp/server.py"
],
"env": {
"DB2_DATABASE": "tpcc",
"DB2_HOSTNAME": "192.168.0.100",
"DB2_PORT": "50000",
"DB2_USERNAME": "db2user",
"DB2_PASSWORD": "db2user@2025"
},
"transportType": "stdio"
}
}
} "ECvXtBighSOVs1JMd1GBy": {
"name": "db2-mcp",
"type": "stdio",
"description": "",
"isActive": true,
"command": "/Users/zlx/Desktop/zlx/3.Coding/AI/db2-mcp/python_x86_wrapper.sh",
"args": [
"/Users/zlx/Desktop/zlx/3.Coding/AI/db2-mcp/server.py"
],
"env": {
"DB2_DATABASE": "tpcc",
"DB2_HOSTNAME": "192.168.0.100",
"DB2_PORT": "50000",
"DB2_USERNAME": "db2user",
"DB2_PASSWORD": "db2user@2025"
},
}Establishes a connection with the target DB2 database.
Executes a read-only SQL query and returns the results.
Calls a stored procedure or function with the specified parameters.