DB2 for LUW MCP Server

A Model Context Protocol (MCP) server for interacting with DB2 for LUW databases.

Features

• Establish connections to DB2 databases
• Execute SQL queries
• Call stored procedures

Setup

1. Clone this repository
2. Configure your database connection in the .env file
3. 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.txt

Usage

Starting the server

source ./db2_x86_env/bin/activate && python3 server.py

./python_x86_wrapper.sh server.py  # (for Apple M1/M2 chips)

MCP config for Cursor or cherry studio

Cursor

{
  "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"
    }
  }
}

Cherry Studio

  "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"
      },
    }

MCP Tools

connect_db

Establishes a connection with the target DB2 database.

run_sql

Executes a read-only SQL query and returns the results.

call_sp

Calls a stored procedure or function with the specified parameters.