db2-mcp-server

db2-mcp-server

0
databases

The db2-mcp-server is a Python-based server designed to interact with IBM DB2 databases using the MCP framework. It provides functionalities for listing tables and fetching table metadata while enforcing read-only database operations to ensure security.

Overview

The db2-mcp-server is a Python server using the MCP framework for interacting with IBM DB2 databases. It offers features like listing tables and retrieving table metadata from the connected DB2 database.

Features

  • List Tables: Retrieve a list of tables from the DB2 database.
  • Get Table Metadata: Fetch metadata for a specific table, including column details and data types.

Requirements

  • Python 3.12
  • FastMCP (latest stable version)
  • IBM DB2 Python driver (ibm_db)
  • Pydantic

Security and API Restrictions

  • The server is read-only, only allowing SELECT operations.

Logging

  • Errors are logged in structured JSON format, excluding sensitive data.

Contribution

  • Contributions are welcome. Follow the coding standards and testing guidelines.