Back to Browse

Db2i MCP Server

Developer ToolsLow Risk10.0MCP RegistryLocal
Free

Server data from the Official MCP Registry

Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).

About

Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).

Security Report

10.0
Low Risk10.0Low Risk

Valid MCP server (3 strong, 1 medium validity signals). 1 code issue detected. No known CVEs in dependencies. Package registry verified. Imported from the Official MCP Registry. Trust signals: trusted author (3/3 approved); 5 highly-trusted packages. 1 finding(s) downgraded by scanner intelligence.

6 files analyzed · 2 issues found

Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.

Permissions Required

This plugin requests these system permissions. Most are normal for its category.

env_vars

Check that this permission is expected for this type of plugin.

What You'll Need

Set these up before or after installing:

IBM i hostname or IPv4 addressOptional

Environment variable: DB2I_HOSTNAME

IBM i user profileOptional

Environment variable: DB2I_USERNAME

IBM i passwordRequired

Environment variable: DB2I_PASSWORD

Default schema (library)Optional

Environment variable: DB2I_SCHEMA

Path to a YAML file of IBM i systems. When set, it replaces the DB2I_* connection variablesOptional

Environment variable: DB2I_PROFILES

Comma-separated schemas the server may read. Empty disables the check.Optional

Environment variable: QUERY_ALLOWED_SCHEMAS

Database driver: odbc (default, IBM i Access ODBC driver, no Java), jt400 (install node-jt400 next to the server; needs a JDK at install and a JRE at runtime) or mapepire (install @ibm/mapepire-js and ssh2; Mapepire over SSH, needs Java on the IBM i only)Optional

Environment variable: DB2I_DRIVER

Extra JT400 JDBC properties, semicolon-separated (jt400 and mapepire drivers)Optional

Environment variable: DB2I_JDBC_OPTIONS

Extra IBM i Access ODBC connection keywords, semicolon-separated (odbc driver)Optional

Environment variable: DB2I_ODBC_OPTIONS

SSH and Mapepire settings, semicolon-separated, e.g. hostKey=SHA256:...;maxJobs=2 (mapepire driver)Optional

Environment variable: DB2I_MAPEPIRE_OPTIONS

How to Install

Add this to your MCP configuration file:

{
  "mcpServers": {
    "io-github-strom-capital-mcp-server-db2i": {
      "env": {
        "DB2I_DRIVER": "your-db2i-driver-here",
        "DB2I_SCHEMA": "your-db2i-schema-here",
        "DB2I_HOSTNAME": "your-db2i-hostname-here",
        "DB2I_PASSWORD": "your-db2i-password-here",
        "DB2I_PROFILES": "your-db2i-profiles-here",
        "DB2I_USERNAME": "your-db2i-username-here",
        "DB2I_JDBC_OPTIONS": "your-db2i-jdbc-options-here",
        "DB2I_ODBC_OPTIONS": "your-db2i-odbc-options-here",
        "DB2I_MAPEPIRE_OPTIONS": "your-db2i-mapepire-options-here",
        "QUERY_ALLOWED_SCHEMAS": "your-query-allowed-schemas-here"
      },
      "args": [
        "-y",
        "mcp-server-db2i"
      ],
      "command": "npx"
    }
  }
}

Reviews

No reviews yet

Be the first to review this server!