db2-mcp-server

@huangjien

About db2-mcp-server

MCP server for DB2

Basic information

Category

Other

License

MIT license

Runtime

python

Transports

stdio

Publisher

huangjien

Config

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

{
  "mcpServers": {
    "db2-mcp-server": {
      "command": "uv",
      "args": [
        "v0.6.x"
      ]
    }
  }
}

Tools

No tools detected

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

Overview

What is db2-mcp-server?

db2-mcp-server is a Python-based server that uses the Model Context Protocol (MCP) to interact with IBM DB2 databases. It provides tools for listing tables and retrieving table metadata, and is intended for read-only database exploration.

How to use db2-mcp-server?

Clone the repository, set up a virtual environment with uv, install dependencies with pip install -r requirements.txt, then run the server with python src/db2_mcp_server/core.py. Tests can be executed using pytest --strict-markers --cov.

Key features of db2-mcp-server

List tables from the connected DB2 database.
Retrieve metadata for a specific table (column details, data types).
Read-only access – prohibits INSERT, UPDATE, DELETE operations.
Structured JSON logging (sensitive data excluded).
Requires Python 3.12, FastMCP, ibm_db, and Pydantic.

Use cases of db2-mcp-server

—

FAQ from db2-mcp-server

What databases does db2-mcp-server support?

It supports IBM DB2 databases.

Is the server read-only?

Yes, the server is read-only. It uses a database user with only SELECT privileges and prohibits SQL INSERT, UPDATE, or DELETE operations.

What are the software requirements?

Python 3.12, the FastMCP framework (latest stable version), the IBM DB2 Python driver (ibm_db), and Pydantic.

How do I run tests?

Use pytest (version ≥ 7.0.0) with the flags --strict-markers --cov to run tests and check code coverage (expected ≥ 90%).

What operations does db2-mcp-server provide?

It provides two tools: listing all tables from the connected database and retrieving metadata (column details and data types) for a specific table.

Comments

More Other MCP servers

XcodeBuildMCP

A Model Context Protocol (MCP) server and CLI that provides tools for agent use when working on iOS and macOS projects.

MaxKB

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

MCP Toolbox for Databases

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

🪟 Windows-MCP

MCP Server for Computer Use in Windows

FastMCP v2 🚀

🚀 The fast, Pythonic way to build MCP servers and clients.