Oracle MCP Server

Serves Oracle Forms module content (.fmb/.mmb/.pll/.olb) from a directory to MCP clients.

Local serverstdio

What is the Oracle MCP Server?

Serves Oracle Forms module content (.fmb/.mmb/.pll/.olb) from a directory to MCP clients.

The short version

An MCP server that serves the content of Oracle Forms modules (.fmb forms, .mmb menus, .pll PL/SQL libraries, .olb object libraries) found in a directory, so AI assistants can inspect blocks, items, triggers, program units, and raw object XML without opening Forms Builder.

  • Understand a legacy app — — enumerate blocks, items, triggers, and program units without a Forms IDE
  • Review & document PL/SQL — — pull decoded trigger and program-unit bodies straight into the model's context
  • Assist modernization — — feed decades-old business logic to an assistant for migration to APEX,
  • Capture & retain knowledge — — let the assistant record notes, tags, and cross-references on

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
list_modulesEvery module in the forms dir with type, size, and cache status
fetch_moduleConverts + indexes one module (idempotent; progress notifications)
get_module_overviewNames of every section + counts — the first call after a fetch
list_blocksBlocks with base table, item count, trigger count
get_blockOne block in full: items (type, column, canvas, prompt) + trigger names
list_triggersTriggers with level/scope; filter by block, item, or level (verbosity=detailed adds a PL/SQL preview)
get_triggerOne trigger's decoded PL/SQL body
list_program_unitsProcedures, functions, package specs/bodies with line counts
get_program_unitOne program unit's PL/SQL (disambiguate spec/body via unitType)
search_sourceLine search over extracted PL/SQL (plsql), the raw XML (xml), or both; paginated via offset/nextOffset
get_object_xmlThe raw XML fragment of any named object — the escape hatch

How to install the Oracle MCP Server

{
  "mcpServers": {
    "oracle-forms": {
      "command": "docker",
      "args": ["run", "-i", "--rm", "ghcr.io/aoreshkov/oracle-forms-mcp"],
      "env": {
        "ORDER_ID": "your-value",
        "FORMS_PATH": "your-value"
      }
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Configuration

VariableDescriptionRequired
ORDER_IDConfiguration value read at startup.Optional
FORMS_PATHFilesystem location the server is allowed to use.Optional

Example prompts to try

  • “Use Oracle to list modules.”
  • “Use Oracle to fetch module.”
  • “Use Oracle to get module overview.”

Frequently asked questions

Serves Oracle Forms module content (.fmb/.mmb/.pll/.olb) from a directory to MCP clients. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.