ibm-db2-mcp-server-by-cdata

CData's Model Context Protocol (MCP) Server for IBM DB2

:heavy_exclamation_mark: This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our CData MCP Server for IBM DB2.

Purpose

We created this read-only MCP Server to allow LLMs (like Claude Desktop) to query live data IBM DB2 supported by the CData JDBC Driver for IBM DB2.

CData JDBC Driver connects to IBM DB2 by exposing them as relational SQL models.

This server wraps that driver and makes IBM DB2 data available through a simple MCP interface, so LLMs can retrieve live information by asking natural language questions — no SQL required.

Setup Guide

1. Clone the repository:

   git clone https://github.com/cdatasoftware/ibm-db2-mcp-server-by-cdata.git
   cd ibm-db2-mcp-server-by-cdata
   

2. Build the server:

   mvn clean install
   

   This creates the JAR file: CDataMCP-jar-with-dependencies.jar
3. Download and install the CData JDBC Driver for {source}: https://www.cdata.com/drivers/db2/download/jdbc
4. License the CData JDBC Driver:
   • Navigate to the lib folder in the installation directory, typically:
     • (Windows) C:\Program Files\CData\CData JDBC Driver for IBM DB2\
     • (Mac/Linux) /Applications/CData JDBC Driver for IBM DB2/
   • Run the command java -jar cdata.jdbc.db2.jar --license
   • Enter your name, email, and "TRIAL" (or your license key).
5. Configure your connection to the data source (Salesforce as an example):

   • Run the command java -jar cdata.jdbc.db2.jar to open the Connection String utility.

     

   • Configure the connection string and click "Test Connection"

     Note: If the data sources uses OAuth, you will need to authenticate in your browser.

   • Once successful, copy the connection string for use later.

6. Create a .prp file for your JDBC connection (e.g. ibm-db2.prp) using the following properties and format:
   • Prefix - a prefix to be used for the tools exposed
   • ServerName - a name for your server
   • ServerVersion - a version for your server
   • DriverPath - the full path to the JAR file for your JDBC driver
   • DriverClass - the name of the JDBC Driver Class (e.g. cdata.jdbc.db2.DB2Driver)
   • JdbcUrl - the JDBC connection string to use with the CData JDBC Driver to connect to your data (copied from above)
   • Tables - leave blank to access all data, otherwise you can explicitly declare the tables you wish to create access for

     Prefix=db2
     ServerName=CDataDB2
     ServerVersion=1.0
     DriverPath=PATH\TO\cdata.jdbc.db2.jar
     DriverClass=cdata.jdbc.db2.DB2Driver
     JdbcUrl=jdbc:db2:InitiateOAuth=GETANDREFRESH;
     Tables=
     

Using the Server with Claude Desktop

1. Create the config file for Claude Desktop ( claude_desktop_config.json) to add the new MCP server, using the format below. If the file already exists, add the entry to the mcpServers in the config file.

   Windows

   {
     "mcpServers": {
       "{classname_dash}": {
         "command": "PATH\\TO\\java.exe",
         "args": [
           "-jar",
           "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
           "PATH\\TO\\ibm-db2.prp"
         ]
       },
       ...
     }
   }
   

   Linux/Mac

   {
     "mcpServers": {
       "{classname_dash}": {
         "command": "/PATH/TO/java",
         "args": [
           "-jar",
           "/PATH/TO/CDat
   

... View full README on GitHub