# Oracle Forms

Hands your assistant the contents of Oracle Forms modules — blocks, triggers, PL/SQL — so you can read the logic without Forms Builder.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed, Gemini CLI · ★ 7
- Author: aoreshkov
- License: Apache-2.0 · policy=link-only · description only; the file stays with the author
- Source: https://github.com/aoreshkov/oracle-forms-mcp
- Updated: 2026-10-19
- HTML: https://affpapa.org/en/nevibecode/mcp/oracle-forms

## What it does

The server walks a directory of `.fmb`, `.mmb`, `.pll` and `.olb` modules and builds a structured index out of them. From there the assistant lists blocks, items, triggers and program units, pulls decoded PL/SQL bodies, and slices raw object XML by line range. No Forms Builder involved.

Conversion takes one of two routes. With `ORACLE_HOME` set, binaries go through the tools in `%ORACLE_HOME%\bin`: `frmf2xml` handles forms, menus and object libraries, while `frmcmp_batch` with `Module_Type=LIBRARY Script=YES` produces a `.pld` dump for `.pll`. Without `ORACLE_HOME`, pre-converted files such as `orders_fmb.xml` or `utils.pld` have to sit next to the modules — otherwise there is nothing to index. Check that first.

Caching keys off a fingerprint: file size, mtime and sha256. Edit a module and it flips to `STALE`, at which point read tools ask for a re-fetch. Notes and cross-references written about individual elements live in a separate store, so they survive re-indexing; an annotation made before the source changed gets flagged rather than dropped.

## Requirements
- Needs: Docker
- Environment variables: `OFMCP_CONVERTED_DIR`, `OFMCP_CONVERT_COMMAND`, `OFMCP_COMPILE_COMMAND` — keys and tokens: ask the human for the values, never commit them or put them in shared files.

## Install

### Claude Code (native platform)

**Platform CLI**
```bash
claude mcp add --env OFMCP_CONVERTED_DIR=<OFMCP_CONVERTED_DIR> --env OFMCP_CONVERT_COMMAND=<OFMCP_CONVERT_COMMAND> --env OFMCP_COMPILE_COMMAND=<OFMCP_COMPILE_COMMAND> --transport stdio oracle-forms -- docker run -i --rm -e OFMCP_CONVERTED_DIR -e OFMCP_CONVERT_COMMAND -e OFMCP_COMPILE_COMMAND ghcr.io/aoreshkov/oracle-forms-mcp:0.15.0
```
Replace <…> with your own values

### Codex

**Platform CLI**
```bash
codex mcp add oracle-forms --env OFMCP_CONVERTED_DIR=<OFMCP_CONVERTED_DIR> --env OFMCP_CONVERT_COMMAND=<OFMCP_CONVERT_COMMAND> --env OFMCP_COMPILE_COMMAND=<OFMCP_COMPILE_COMMAND> -- docker run -i --rm -e OFMCP_CONVERTED_DIR -e OFMCP_CONVERT_COMMAND -e OFMCP_COMPILE_COMMAND ghcr.io/aoreshkov/oracle-forms-mcp:0.15.0
```
Replace <…> with your own values

### Cursor

**Config file**
File `.cursor/mcp.json`:
```json
{
    "mcpServers": {
        "oracle-forms": {
            "command": "docker",
            "args": [
                "run",
                "-i",
                "--rm",
                "-e",
                "OFMCP_CONVERTED_DIR",
                "-e",
                "OFMCP_CONVERT_COMMAND",
                "-e",
                "OFMCP_COMPILE_COMMAND",
                "ghcr.io/aoreshkov/oracle-forms-mcp:0.15.0"
            ],
            "env": {
                "OFMCP_CONVERTED_DIR": "<OFMCP_CONVERTED_DIR>",
                "OFMCP_CONVERT_COMMAND": "<OFMCP_CONVERT_COMMAND>",
                "OFMCP_COMPILE_COMMAND": "<OFMCP_COMPILE_COMMAND>"
            }
        }
    }
}
```
Replace <…> with your own values

### GitHub Copilot

**Config file**
File `.vscode/mcp.json`:
```json
{
    "servers": {
        "oracle-forms": {
            "type": "stdio",
            "command": "docker",
            "args": [
                "run",
                "-i",
                "--rm",
                "-e",
                "OFMCP_CONVERTED_DIR",
                "-e",
                "OFMCP_CONVERT_COMMAND",
                "-e",
                "OFMCP_COMPILE_COMMAND",
                "ghcr.io/aoreshkov/oracle-forms-mcp:0.15.0"
            ],
            "env": {
                "OFMCP_CONVERTED_DIR": "<OFMCP_CONVERTED_DIR>",
                "OFMCP_CONVERT_COMMAND": "<OFMCP_CONVERT_COMMAND>",
                "OFMCP_COMPILE_COMMAND": "<OFMCP_COMPILE_COMMAND>"
            }
        }
    }
}
```
Replace <…> with your own values

### Gemini CLI

**Platform CLI**
```bash
gemini mcp add -e OFMCP_CONVERTED_DIR=<OFMCP_CONVERTED_DIR> -e OFMCP_CONVERT_COMMAND=<OFMCP_CONVERT_COMMAND> -e OFMCP_COMPILE_COMMAND=<OFMCP_COMPILE_COMMAND> oracle-forms docker run -i --rm -e OFMCP_CONVERTED_DIR -e OFMCP_CONVERT_COMMAND -e OFMCP_COMPILE_COMMAND ghcr.io/aoreshkov/oracle-forms-mcp:0.15.0
```
Replace <…> with your own values

## When to use it
- read the logic of a legacy `.fmb` without Forms Builder
- pull a trigger body into the model's context
- find every call site of a procedure across modules
- document blocks and program units of a form
- keep notes about elements across sessions

## Example prompts
- What does `ORDERS.fmb` do? Give me the module overview.
- Show the validation logic on the ORDERS block — the WHEN-VALIDATE-ITEM trigger.
- Where else is CALC_TOTAL called? Search the PL/SQL.

## Similar
- [World Monitor](https://affpapa.org/en/nevibecode/mcp/world-monitor.md) — MCP server · ★ 89408
- [Scrapling MCP Server](https://affpapa.org/en/nevibecode/mcp/scrapling-mcp-server.md) — MCP server · ★ 89433
- [MCP Toolbox for Databases](https://affpapa.org/en/nevibecode/mcp/googleapis-mcp-toolbox-for-databases.md) — MCP server · ★ 16717
- [PostHog MCP Server](https://affpapa.org/en/nevibecode/mcp/posthog-mcp-server.md) — MCP server · ★ 40409
- [dbx](https://affpapa.org/en/nevibecode/mcp/dbx.md) — MCP server · ★ 27669
- [Metabase](https://affpapa.org/en/nevibecode/mcp/metabase.md) — MCP server · ★ 49845

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md