A read-only MCP server for interacting with a DB2 database.
Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.
Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"db2-mcp-server","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
# db2-mcp-server [](https://badge.fury.io/py/db2-mcp-server) [](https://opensource.org/licenses/MIT) [](https://github.com/huangjien/db2-mcp-server) ## Overview The `db2-mcp-server` is a Python-based server utilizing the MCP framework to interact with IBM DB2 databases. It provides tools for listing tables and retrieving table metadata. ## Features - **List Tables**: Retrieve a list of tables from the connected DB2 database. - **Get Table Metadata**: Fetch metadata for a specific table, including column details and data types. - **Dynamic Prompt Loading**: Load custom prompts from JSON configuration files for flexible query assistance. - **Built-in Prompts**: Pre-configured prompts for DB2 query help and schema analysis. ## Requirements - Python 3.12 - FastMCP (latest stable version) - IBM DB2 Python driver (`ibm_db`) - Pydantic ## Setup Instructions 1. **Clone the Repository** ```bash git clone <repository-url> cd db2-mcp-server ``` 2. **Set Up Virtual Environment** ```bash uv v0.6.x source uv/bin/activate ``` 3. **Install Dependencies** ```bash pip install -r requirements.txt ``` 4. **Run the Server** ```bash python src/db2_mcp_server/core.py ``` ## Dynamic Prompts The server supports dynamic prompt loading from JSON configuration files. Set the `PROMPTS_FILE` environment variable to specify a custom prompts configuration file. ### Example Usage ```bash export PROMPTS_FILE=/path/to/your/prompts_config.json python src/db2_mcp_server/core.py ``` ### Configuration Format See `examples/prompts_config.json` for a complete example and `docs/DYNAMIC_PROMPTS.md` for detailed documentation. ## Testing - Use `pytest` (version ≥ 7.0.0) for running tests. - Current test coverage: **92.98%** (exceeding the 80% requirement). - …
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.