# Oracle Forms

> Oracle Forms is an MCP server for developer tools. Inspect Oracle Forms modules (.fmb, .mmb, .pll, .olb): blocks, triggers and PL/SQL. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Platforms:** CLI, self-hosted
- **Repository:** https://github.com/aoreshkov/oracle-forms-mcp
- **MCP Registry name:** io.github.aoreshkov/oracle-forms-mcp
- **Categories:** [developer tools](https://ai-powered.com/categories/developer-tools), [databases](https://ai-powered.com/categories/databases)
- **Listing updated:** 2026-11-18

## About

Legacy Oracle Forms logic sits in binary modules that normally need Forms Builder to open. This server indexes a directory of them so an assistant can read blocks, items, triggers, program units and raw object XML directly. Conversion uses Oracle's tools when ORACLE_HOME is set, or pre-converted files placed beside the modules when it is not, and results are cached on disk with a fingerprint so stale modules are detected.

Its 18 tools cover a typical review: list modules, fetch and index one, get an overview, then drill into blocks, triggers and program units, or search source within one module or across all cached ones. Annotation tools let the assistant store notes, tags and cross-references that survive re-indexing, building a durable map of a form. Tool inputs are validated against their schema, with every problem listed at once.

It is written in Kotlin, runs over stdio (and HTTP), and ships as a Docker image, a .mcpb bundle for Claude Desktop and a Claude Code plugin with a trace-form skill.

## Features

- **Module indexing:** Converts and indexes forms, menus, PL/SQL libraries and object libraries.
- **Decoded PL/SQL:** Returns trigger and program unit bodies.
- **Cross-module search:** Search source across every cached module.
- **Persistent annotations:** Notes, tags and relations that survive re-indexing.
- **Staleness tracking:** Cache status flags changed modules.
- **Several install routes:** Plugin, .mcpb bundle, Docker image or source build.

## Good for

- Document a legacy form no one remembers
- Trace where a PL/SQL procedure is called across modules
- Prepare logic for migration to APEX or Java
- Review trigger code without opening Forms Builder

## Install

### Claude Code (Terminal)

```sh
claude mcp add oracle-forms-mcp -- docker run -i --rm ghcr.io/aoreshkov/oracle-forms-mcp:0.20.0
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "oracle-forms-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/aoreshkov/oracle-forms-mcp:0.20.0"
      ]
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "oracle-forms-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/aoreshkov/oracle-forms-mcp:0.20.0"
      ]
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "oracle-forms-mcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/aoreshkov/oracle-forms-mcp:0.20.0"
      ]
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "oracle-forms-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/aoreshkov/oracle-forms-mcp:0.20.0"
      ]
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "oracle-forms-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/aoreshkov/oracle-forms-mcp:0.20.0"
      ]
    }
  }
}
```

## Tools

- `list_modules`: Lists modules with type, size and cache status
- `fetch_module`: Converts and indexes one module
- `get_module_overview`: Returns section names and counts
- `list_blocks`: Lists blocks with base table and counts
- `get_block`: Returns one block with its items and relations
- `list_triggers`: Lists triggers by block, item or level
- `get_trigger`: Returns a trigger's decoded PL/SQL body
- `list_program_units`: Lists procedures, functions and packages
- `get_program_unit`: Returns one program unit's PL/SQL
- `search_source`: Searches lines within one fetched module
- `search_modules`: Searches across every cached module
- `read_source`: Reads a line range of a cached file
- `get_object_xml`: Returns the raw XML of a named object
- `annotate_element`: Stores a note, summary, tag or classification
- `relate_elements`: Records a cross-reference between two elements
- `get_element_annotations`: Returns notes and relations for an element
- `search_annotations`: Searches stored annotations
- `remove_annotation`: Deletes an annotation or relation by id

## FAQ

### What file types does it read?

Forms (.fmb), menus (.mmb), PL/SQL libraries (.pll) and object libraries (.olb).

### Do I need Oracle installed?

Not necessarily. It uses Oracle tools when ORACLE_HOME is set, otherwise pre-converted files beside the modules.

### Do annotations survive re-fetching?

Yes. They live in a separate store.

### How do I install it for Claude Code?

Run /plugin marketplace add aoreshkov/oracle-forms-mcp then /plugin install oracle-forms@oracle-forms-mcp.

### How do I add Oracle Forms to Claude Code?

Run this command in your terminal: claude mcp add oracle-forms-mcp -- docker run -i --rm ghcr.io/aoreshkov/oracle-forms-mcp:0.20.0

### What are the best alternatives to Oracle Forms?

The closest alternatives to Oracle Forms are REA, Context7, Chrome DevTools MCP, Codebase Memory and GitHub.

## Where this comes from

- Description: written from the project's README.
- Install steps: from the official MCP Registry entry.

## Alternatives

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Context7](https://ai-powered.com/mcp/context7): Context7 is a freemium MCP server for developer tools.
- [Chrome DevTools MCP](https://ai-powered.com/mcp/chrome-devtools-mcp-2): Chrome DevTools MCP is an open-source MCP server for browser automation.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [awesome-mcp-servers](https://ai-powered.com/mcp/awesome-mcp-servers-2): awesome-mcp-servers is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.

---
Source: https://ai-powered.com/mcp/oracle-forms
