db2-mcp-server

@huangjien

关于 db2-mcp-server

MCP server for DB2

基本信息

分类

其他

许可证

MIT license

运行时

python

传输方式

stdio

发布者

huangjien

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.

评论

其他分类下的更多 MCP 服务器

MaxKB

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

Inbox Zero AI MCP

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

Servers

modelcontextprotocol

Model Context Protocol Servers

EverArt

modelcontextprotocol

Model Context Protocol Servers

IDA Pro MCP

AI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP.