mcp-server-db2i
Verified Safeby Strom-Capital
Overview
Enables AI assistants to query and inspect IBM DB2 for i databases using the Model Context Protocol (MCP) via stdio or HTTP.
Installation
npx mcp-server-db2iEnvironment Variables
- DB2I_HOSTNAME
- DB2I_USERNAME
- DB2I_USERNAME_FILE
- DB2I_PASSWORD
- DB2I_PASSWORD_FILE
- MCP_AUTH_TOKEN
Security Notes
The server demonstrates a strong focus on security. All SQL queries are validated using both AST parsing and regex patterns to ensure they are read-only (SELECT statements only) and block dangerous operations (DML, DDL, DCL, system commands like QCMDEXC). Sensitive credentials are handled via environment variables with a strong recommendation for file-based Docker secrets. The HTTP transport includes OAuth-style token authentication with `timingSafeEqual` to prevent timing attacks, IP-based rate limiting for authentication attempts, and explicit warnings/configuration for TLS/HTTPS. Logging redacts sensitive information like passwords. Resource limits (max sessions, query result limits) are configurable to prevent abuse.
Similar Servers
mcp
Connect IBM products and other enterprise systems to AI agents via the Model Context Protocol (MCP) to enable AI models to interact with various local and remote resources.
ibmi-mcp-server
The IBM i MCP Server enables AI agents to monitor, administer, and query IBM i systems using SQL tools, supporting performance analysis, system administration, and security vulnerability assessment.
warp-sql-server-mcp
An MCP server for SQL Server, enabling AI assistants to securely interact with databases for schema discovery, data retrieval, query execution, performance monitoring, and optimization.
photons
A comprehensive demonstration MCP server showcasing various functionalities of the Photon runtime, including basic data handling, streaming responses, progress reporting, in-memory state management, and interactive UI elements. It serves as a reference for developers building new photons.