Advertise
MCP.so
Sign In
I

IBM DB2 MCP Server by CData

@CDataSoftware

Repository

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

About IBM DB2 MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for IBM DB2 (beta)](https://www.cdata.com/download/download.aspx?sku=EDZK-V&type=beta).

#ibm#db2#mcp-server#cdata

IBM DB2 MCP Server by CData config

Add this server to your MCP-compatible client using the configuration below.

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

IBM DB2 MCP Server by CData tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is IBM DB2 MCP Server by CData?

The IBM DB2 MCP Server by CData is a read-only MCP (Model Context Protocol) server that allows LLMs like Claude Desktop to query live IBM DB2 data using natural language. It wraps the CData JDBC Driver for IBM DB2, exposing the database as relational SQL models through a simple MCP interface.

How to use IBM DB2 MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for IBM DB2, create a .prp file with your JDBC connection string, and configure Claude Desktop (or another client) by adding the server to claude_desktop_config.json. The server runs via java -jar CDataMCP-jar-with-dependencies.jar <path-to>.prp and communicates over stdio, so it must run on the same machine as the client.

Key features of IBM DB2 MCP Server by CData

  • Read-only access to IBM DB2 data
  • Natural language querying with no SQL required
  • Built on the CData JDBC Driver for IBM DB2
  • Exposes three tools: get_tables, get_columns, run_query
  • Uses stdio transport (same-machine client only)
  • Configurable via a simple .prp file

Use cases of IBM DB2 MCP Server by CData

  • Ask LLMs about live IBM DB2 data in natural language
  • Retrieve table schemas and column metadata from IBM DB2
  • Execute read-only SQL queries via an AI assistant
  • Enable conversational data exploration without writing SQL

Frequently asked questions

1

Is this server read-only or read-write?

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, CData offers a separate beta MCP Server for IBM DB2.

2

What are the runtime requirements?

You need Java, Maven (to build), and the CData JDBC Driver for IBM DB2 (which must be downloaded and licensed separately).

3

How do I connect to IBM DB2?

Create a `.prp` file with properties including Prefix, ServerName, DriverPath, DriverClass, and JdbcUrl (obtained from the CData JDBC Driver's connection string utility). The driver supports OAuth where needed.

4

What transport does this server use?

The server uses `stdio` transport, so it can only be used with clients that run on the same machine as the server.

5

What tools are exposed by the server?

The server exposes three tools: `{servername}_get_tables`, `{servername}_get_columns`, and `{servername}_run_query`. The `servername` prefix is configured in the `.prp` file.

Comments

More Other MCP servers

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K
P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

Advertise