db2-mcp
このDB2 for LUW MCPサーバーは、DB2データベースとのインタラクションを可能にするモデルコンテキストプロトコル（MCP）サーバーです。SQLクエリの実行やストアドプロシージャの呼び出しが可能で、設定も簡単です。環境変数を設定することで、データベース接続を行い、サーバーを起動できます。
GitHubスター
1
ユーザー評価
未評価
お気に入り
0
閲覧数
11
フォーク
0
イシュー
0
README
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
- 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.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.