IBM Db2 for i

{
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "name": "io.github.Strom-Capital/mcp-server-db2i",
  "description": "Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).",
  "title": "IBM Db2 for i",
  "repository": {
    "url": "https://github.com/Strom-Capital/mcp-server-db2i",
    "source": "github"
  },
  "version": "3.6.1",
  "websiteUrl": "https://db2i-mcp.com",
  "packages": [
    {
      "registryType": "npm",
      "identifier": "mcp-server-db2i",
      "version": "3.6.1",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "IBM i hostname or IPv4 address",
          "isRequired": true,
          "placeholder": "ibmi.example.com",
          "name": "DB2I_HOSTNAME"
        },
        {
          "description": "IBM i user profile",
          "isRequired": true,
          "name": "DB2I_USERNAME"
        },
        {
          "description": "IBM i password",
          "isRequired": true,
          "isSecret": true,
          "name": "DB2I_PASSWORD"
        },
        {
          "description": "Default schema (library)",
          "placeholder": "MYLIB",
          "name": "DB2I_SCHEMA"
        },
        {
          "description": "Path to a YAML file of IBM i systems. When set, it replaces the DB2I_* connection variables",
          "name": "DB2I_PROFILES"
        },
        {
          "description": "Comma-separated schemas the server may read. Empty disables the check.",
          "placeholder": "MYLIB,OTHERLIB",
          "name": "QUERY_ALLOWED_SCHEMAS"
        },
        {
          "description": "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)",
          "default": "odbc",
          "name": "DB2I_DRIVER"
        },
        {
          "description": "Extra JT400 JDBC properties, semicolon-separated (jt400 and mapepire drivers)",
          "name": "DB2I_JDBC_OPTIONS"
        },
        {
          "description": "Extra IBM i Access ODBC connection keywords, semicolon-separated (odbc driver)",
          "name": "DB2I_ODBC_OPTIONS"
        },
        {
          "description": "SSH and Mapepire settings, semicolon-separated, e.g. hostKey=SHA256:...;agent=true;maxJobs=2 (mapepire driver)",
          "name": "DB2I_MAPEPIRE_OPTIONS"
        }
      ]
    }
  ]
}