Configuring MCP Server Support for PeopleTools Metadata

PeopleSoft delivers the Python-based PeopleSoft MCP server to enable MCP-compatible LLM clients to retrieve PeopleTools metadata and managed objects in a structured format. Configure the client to launch the PeopleSoft MCP server over standard input and output (stdio).

Connecting LLM Clients to the MCP Server

Any LLM client that supports MCP, such as Cline, Claude Desktop, Codex, or a custom Python MCP client, can connect to the PeopleSoft MCP server. Add the PeopleSoft MCP server to the client's MCP configuration file.

The following example configures the PeopleSoft MCP server in write mode:

{
  "mcpServers": {
    "PSIDE_MCP": {
      "type": "stdio",
      "command": "<absolute_path_to_ps_home>",
      "args": [
        "<absolute_path_to_ps_home>\\bin\\client\\winx86\\PeopleCodeAssist\\MCPServers\\ps_mcp_server.py"
      ],
      "env": {
        "TNS_ADMIN": "C:\\apps\\db\\oracle102\\network\\admin",
        "ORACLE_HOME": "C:\\oracle12c\\product\\12.1.0\\dbhome_1",
        "PS_HOME": "<absolute_path_to_ps_home>",
        "MODE": "write"
      }
    }
  }
}

If MODE is omitted or set to read, the server exposes only the read tools. If MODE is set to compile, the server exposes the read tools and compile-only tools. If MODE is set to write, the server exposes the read tools and the staging and bulk-save tools.

The env section is critical for the MCP server to function properly. It provides the server with the required PeopleSoft environment details.

The following table describes the parameters for the env section.

API	Description
TNS_ADMIN	Specify the path to folder where tnsnames.ora is present.
ORACLE_HOME	Specify the path to oracle home.
PS_HOME	Specify the absolute path to PS_HOME.

Note:

Use \\ inplace of \ in the json file.