Oracle Forms MCP
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Oracle Forms MCPshow me the blocks in ORDERS.fmb"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Oracle Forms MCP
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.
Built as a Kotlin Multiplatform core (pure @Serializable models and ports) with a JVM MCP
server on top: declarative tool adapters over a single FormsService, stdio and HTTP transports,
and a fingerprint-based on-disk cache. Oracle tool conversion feeds a streaming StAX parser that
turns Forms XML into a structured index.
Why
Oracle Forms applications from the 1990s–2000s are still running critical business processes, but
their logic is locked inside binary .fmb/.pll modules that only Forms Builder can open. That
makes them opaque to modern AI tooling and painful to review, document, or migrate.
Oracle Forms MCP turns those modules into structured, queryable content so an AI assistant can:
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, Java, or a rewrite, and search across every module's source.
Capture & retain knowledge — let the assistant record notes, tags, and cross-references on individual elements that persist across sessions and re-indexing, building up a durable map of a form no one fully remembers.
It is aimed at developers and teams doing Oracle Forms modernization, reverse engineering, code review, and documentation — anyone who needs to read Forms logic faster than opening it by hand.
Related MCP server: MCP Server for Oracle Database
See it work
A typical session against the bundled sample-forms directory:
You: What does ORDERS.fmb do?
AI → list_modules → ORDERS.fmb (NOT_CACHED), MAINMENU.mmb, UTILS.pll …
AI → fetch_module ORDERS.fmb → converted + indexed (3 blocks, 3 triggers, 3 program units)
AI → get_module_overview ORDERS → blocks, triggers, LOVs, record groups, windows, canvases …
You: Show me the validation logic on the ORDERS block.
AI → list_triggers block=ORDERS → WHEN-VALIDATE-ITEM (on ORDER_ID), WHEN-VALIDATE-RECORD
AI → get_trigger ORDERS WHEN-VALIDATE-ITEM → the decoded PL/SQL body
You: Where else is the CALC_TOTAL procedure called?
AI → search_source "calc_total" scope=plsql → hits across triggers and program units
You: That validation is the legacy pre-2010 path — note it so we remember.
AI → annotate_element ORDERS trigger WHEN-VALIDATE-ITEM kind=note "Legacy pre-2010 validation path" → saved
(next session) get_trigger ORDERS WHEN-VALIDATE-ITEM → body + the stored note inlineHow it works
list_modulesscans the configured--forms-dir(non-recursive) and reports each module's cache status:NOT_CACHED,CACHED,STALE(source changed on disk), orSOURCE_MISSING. A production forms directory holds thousands of modules, so the answer is filtered and paged: narrow withpattern/type/status, follownextCursorfor the rest, and readcountsByStatusfor the shape of the whole match.fetch_moduleproduces the module's text form in the cache and indexes it:ORACLE_HOMEset — binaries are converted with the Oracle tools in%ORACLE_HOME%\bin:frmf2xmlfor.fmb/.mmb/.olb(XML),frmcmp_batch(Module_Type=LIBRARY Script=YES) for.pll(a.pldtext dump).ORACLE_HOMEnot set — pre-converted files are expected next to the modules (orders_fmb.xml,dupes_fmb.xml,picker_fmb.xml,toolbar_fmb.xml,mainmenu_mmb.xml,objects_olb.xml,utils.pld) and copied into the cache.
A single StAX pass parses the XML into a structured index (blocks with items, triggers with decoded PL/SQL, program units, LOVs, record groups, windows, canvases, …). PL/SQL bodies are extracted to
.sqlsidecar files; every named XML element gets a line-range reference soget_object_xmlcan slice it back out of the converted file.The other tools read the cached index. Caching is fingerprint-based (size + mtime + sha256 of the source file): editing a module marks it
STALEand read tools ask for a re-fetch.annotate_elementandrelate_elementslet the assistant write durable meta-information back about individual elements (notes, tags, summaries, classifications, cross-references). This is kept in a separate store — not the derived index — so it survives re-fetching, and the read tools surface it inline. An annotation made before a source change is flagged, never dropped.
Tools
Tool | What it returns |
| Modules in the forms dir with type, size, and cache status; filter by |
| Converts + indexes one module (idempotent; progress notifications) |
| Names of every section + counts — the first call after a fetch ( |
| Blocks with base table, item count, trigger count |
| One block: items with type, property class, prompt and trigger names, and its master-detail relations ( |
| Triggers with level/scope; filter by block, item, or level ( |
| One trigger's decoded PL/SQL body (same-named triggers told apart by |
| Procedures, functions, package specs/bodies with line counts |
| One program unit's PL/SQL (disambiguate spec/body via |
| Line search over one fetched module: extracted PL/SQL ( |
| The same search across every cached module — cross-form calls, shared |
| A line range of a cached file, by |
| The raw XML fragment of any named object — the escape hatch |
Every tool checks its arguments against its own input schema before running. An argument it does not have is never silently dropped: the call fails with every problem listed at once (unknown arguments with the name most likely meant, missing ones with their permitted values, values outside an enum), plus an example call where the tool has one.
Where an object's meaning lives
Two Forms properties carry more meaning than anything else in a module, and both used to be
reachable only one get_object_xml call at a time.
An item's property class is usually its role: Forms shops name their classes for what the
object does, so a push button is an LOV button and a text item is a filter field only because
of the class it inherits. get_block reports propertyClass on every item and block, confirmed
against the classes the module actually declares.
A window's modality decides how a form is read — a modal window is a dialog, so the code that
fills it and the code that consumes the result sit on opposite sides of one interaction.
get_module_overview(verbosity: "detailed") returns the window and canvas objects behind two of
its name lists: modality, size, toolbar canvases, and the window each canvas sits on.
A property Forms did not write comes back as null, meaning the object keeps the Forms default —
never false. On an item that has a property class it does not even mean the default: the class
supplies the value, and in a real form that is where most of an item's behaviour lives. So
get_block(verbosity: "detailed") returns both — items[].dml, what the item itself wrote, and
effectiveDml, the same properties with the class applied (item, then class, then whatever that
class is based on, followed into other modules that are already fetched). An item is listed in
effectiveDml only when that chain resolved to the end, so a null there really is the Forms
default. Every other item is a row of unresolvedItems, with the reason and — when fetching fixes
it — the module to fetch; propertyClasses and the result's hint give the same account per class
and name the fetch_module call. items: [...] narrows all of it to the items a question is about.
get_block(columns: true) adds the block's data-source columns, the columns no item supplies, and
which of those are mandatory in the database — the ones an insert fails on unless a trigger assigns
them.
A block's master-detail relations decide what it can be queried through, so get_block serves
them at every verbosity: block.relations, the relations it is the master of (join condition,
deferred, autoQuery, deleteRecord, preventMasterlessOperations), and detailOf, the
relations that name it as their detail, with the master each is written on. A detail with
preventMasterlessOperations cannot be queried except through its master — which the form enforces,
not the database, so a port has to enforce it itself.
Reading around a result
Everything indexed is a line range into a file the cache owns, and those ranges used to name a
path with no way to resolve it. Every result that points at a file now carries a source:
"source": {
"uri": "oracleforms://ORDERS.fmb/plsql/triggers/ORDERS.ORDER_ID.WHEN-VALIDATE-ITEM.sql",
"file": "plsql/triggers/ORDERS.ORDER_ID.WHEN-VALIDATE-ITEM.sql",
"startLine": 1, "endLine": 3
}read_source takes either form back, so a search hit can be read in context and a truncated
fragment continued. The same files are readable as MCP resources —
oracleforms://{module}/converted for the converted text form and
oracleforms://{module}/plsql/{category}/{name} for one extracted block of PL/SQL — and every
such result also carries a resource_link content block, so a client can follow it without
parsing JSON. Reads are capped by lines and characters; a cut resource read says so in the text
it returns and names the call that continues it.
Paths stay cache-relative and URIs stay layout-independent: an absolute host path would mean nothing to a client talking to the container image or over HTTP.
Subclassed (inherited) objects
Forms lets a block, item, trigger or program unit be subclassed from another module, or copied
in with an object group (typically from an .olb). Either way the child stores only what it
overrides, so its PL/SQL body is genuinely empty in its own file while the code that runs lives in
the parent. Served naively that is not merely incomplete but wrong — an empty body reads as "this
button does nothing".
Every result that carries PL/SQL therefore also carries bodySource:
| Meaning |
| The body is defined in this module (the ordinary case) |
| The object is subclassed; |
| The body shown is the parent's, followed for this call ( |
| The object genuinely has no body |
The inherited reference is stated in the parent's vocabulary and in the shape the tools take,
so it is directly callable — BAR_LIST.SELECT in this form is name: SELECT, ownerPath: BAR over
there:
{
"name": "WHEN-BUTTON-PRESSED", "block": "BAR_LIST", "item": "SELECT",
"text": "", "bodySource": "inherited",
"inherited": { "module": "TOOLBAR", "file": "toolbar.fmb", "name": "SELECT", "ownerPath": "BAR" },
"hint": "… Call fetch_module(module=\"TOOLBAR.fmb\"), then get_trigger(module=\"TOOLBAR.fmb\", name=\"WHEN-BUTTON-PRESSED\", ownerPath=\"BAR.SELECT\")."
}For an object-group member, name is the object's own name and objectGroup names the group that
carried it — where the library files that group is not recorded in this module, so no ownerPath
is claimed for it. A parent in the same module is a property class: it supplies properties
rather than a definition, hides nothing, and is deliberately not reported as inheritance.
get_trigger and get_program_unit take resolve: true to follow the pointer in one call. It
reads only modules that are already cached — reaching an un-cached one would mean converting
it, which a read-only tool must not do — and falls back to the pointer plus the fetch_module
hint rather than failing. get_block flags subclassed blocks and items the same way, and
get_object_xml returns the pointer resolved to the level it was asked about (Forms writes the
raw ParentModule attribute on the enclosing owner, so the fragment alone cannot answer it).
Tracing across modules
A question about one form rarely stays inside it. A modal window is opened by whoever calls it, the
value it hands back travels through a :GLOBAL, and its toolbar is defined in a third form
entirely — so search_source, which searches the module you name, cannot answer any of the three:
search_modules "PICKER" → which forms call it
search_modules ":GLOBAL.picked_ref" → every module that writes or reads it
search_modules 'ParentFilename="toolbar.fmb"' scope=xml → every module that subclasses itEach hit names its module (moduleSpec, the NAME.ext string the other tools take), the
cache-relative file, the line, a snippet, and the uri that opens it. Matching is
case-insensitive by default, because Forms code writes the same module name as PICKER, picker
and Call_Form('picker') in the same code base; pass ignoreCase: false when precision matters.
Only modules that have been fetched are searched — reaching an un-fetched one would mean converting it, which a read-only tool must not do. So the coverage is part of the answer rather than an assumption:
{
"query": ":GLOBAL.picked_ref",
"cachedModules": 12, "scannedModules": 12, "skippedNotCached": 3090, "skippedStale": 1,
"hint": "3090 matching module(s) are not cached and were not searched — list_modules(status=\"not_cached\") names them, and fetch_module adds one to the search. 1 cached module(s) changed on disk …"
}To make a whole directory searchable, warm the cache before the session instead of one
fetch_module at a time: --prefetch runs the server once as a batch job that converts and
indexes every matching module, one line per module on stderr, then exits (with 1 if any failed).
Modules already current cost a fingerprint check, so a rerun picks up where a stopped one left off.
server --forms-dir /srv/forms --prefetch-all
server --forms-dir /srv/forms --prefetch ORDER --prefetch-type formBoth bounds are enforced and resumable: maxResults hits per page, and a ceiling on how many
modules one call reads — a query that matches nothing would otherwise read every converted file in
the cache before answering. Either one sets truncated and returns a nextCursor to pass back
with the same arguments. The cursor is bound to those arguments, so it cannot silently continue a
different search.
Annotations
Meta-information the assistant records back about an element rather than reads from it —
semantic notes, tags, classifications, and cross-reference relations. It is persisted in a durable
store, kept separate from the derived index (not in the protocol _meta field), so it survives
fetch_module re-indexing and is served back to later sessions. Each entry carries its author and
is flagged staleAgainstSource when it predates the module's current source, so a note is never
silently dropped. The read tools above (get_module_overview, get_block, get_trigger,
get_program_unit, get_object_xml) surface an element's annotations inline.
Tool | What it does |
| Store a note / summary / tag / classification about one element |
| Record a directed cross-reference between two elements (e.g. a trigger |
| The notes and relations stored about one element |
| Search a module's stored notes/tags/relations by text, kind, or tag |
| Delete a stored annotation or relation by id |
Plus a resource per cached module (oracleforms://ORDERS.fmb/index), the
oracleforms://{module}/index and oracleforms://{module}/annotations resource templates, and an
explain_module prompt.
Quick start
Pick the channel that matches your client: the plugin for Claude
Code, the .mcpb bundle for Claude Desktop, the
Docker image for everything else, or a
build from source. The server is published to the
official MCP Registry as
io.github.aoreshkov/oracle-forms-mcp.
Claude Code (one-command plugin)
/plugin marketplace add aoreshkov/oracle-forms-mcp
/plugin install oracle-forms@oracle-forms-mcpClaude Code prompts for your forms directory, then fetches and checksum-verifies the released
server into the plugin's data directory on first use — no clone, no build, no JSON to edit. The
tools are live after /reload-plugins, and the plugin's trace-form skill teaches the traversal
above — the order to ask in, and the readings that mislead — so a trace does not start with grep.
Requires a JDK 21+ on your
PATH(javac -version), because the plugin's bootstrap runs in Java's single-file source mode. With only a JRE, use the.mcpbbundle orclaude mcp addbelow.
Details, configuration options, and the escape hatches are in the plugin README.
Build from source
Requires a JRE 21+. Build and install:
gradlew :server:installDistRegister with Claude Code (stdio):
claude mcp add oracle-forms -- server/build/install/server/bin/server --forms-dir C:\path\to\formsClaude Desktop (one-click bundle)
Download oracle-forms-mcp-<version>.mcpb from the
latest release and open it. Claude
Desktop installs it as a connector and prompts for your forms directory with a native folder picker
— no JSON editing, no local build.
Requires a JRE 21+ on your
PATH. The bundle ships the server, not a Java runtime. The MCPB manifest format can only declare Node and Python runtimes, so this cannot be checked at install time: if the connector fails to start, confirmjava -versionworks in a terminal.
The same copy-mode caveat as Docker applies unless the machine has an
Oracle Forms installation (ORACLE_HOME) for live .fmb/.pll conversion.
The published image runs the server over stdio with no local build. Point the volume mount at
your forms directory (copy-mode: the pre-converted *_fmb.xml/*.pld files must sit next to the
modules — see Docker).
Claude Desktop (claude_desktop_config.json) and Cursor (~/.cursor/mcp.json) use the same shape:
{
"mcpServers": {
"oracle-forms": {
"command": "docker",
"args": ["run", "-i", "--rm",
"-v", "ofmcp-cache:/home/mcp/.cache", "-v", "/path/to/forms:/forms",
"ghcr.io/aoreshkov/oracle-forms-mcp", "--forms-dir", "/forms"]
}
}
}VS Code (.vscode/mcp.json) uses a servers key instead:
{
"servers": {
"oracle-forms": {
"command": "docker",
"args": ["run", "-i", "--rm",
"-v", "ofmcp-cache:/home/mcp/.cache", "-v", "${workspaceFolder}/forms:/forms",
"ghcr.io/aoreshkov/oracle-forms-mcp", "--forms-dir", "/forms"]
}
}
}The ofmcp-cache named volume keeps the parsed-module cache and — more importantly — the durable
annotation store across container restarts; --rm removes the container but not a named volume. Drop
it and the notes/tags/relations the assistant records won't survive the next run. See
Docker for the bind-mount variant and its one-time chown.
Prefer the native launcher? Swap "command": "docker", "args": [...] for
"command": "/abs/path/to/server/build/install/server/bin/server", "args": ["--forms-dir", "/abs/path/to/forms"].
Try it without any Oracle installation using the bundled fixtures:
server --forms-dir sample-formsHTTP transport:
server --forms-dir C:\forms --transport http --port 3000 # endpoint: http://127.0.0.1:3000/mcpDocker (copy-mode only)
A container image is published to ghcr.io/aoreshkov/oracle-forms-mcp. Oracle's frmf2xml /
frmcmp_batch binaries are proprietary and not bundled, so the image works only in
copy-mode: the modules you mount must already have their pre-converted text form
(*_fmb.xml/*_mmb.xml/*_olb.xml/*.pld) sitting next to them. For live .fmb/.pll
conversion, run the server on a host with an Oracle Forms installation (ORACLE_HOME set).
docker run -i -v /path/to/forms:/forms ghcr.io/aoreshkov/oracle-forms-mcp --forms-dir /formsPersisting the cache and annotations. Without a volume, the cache and the durable annotation
store live in the container's writable layer and are discarded when it exits. Mount a volume at
/home/mcp/.cache to keep them across runs:
docker run -i -v ofmcp-cache:/home/mcp/.cache -v /path/to/forms:/forms \
ghcr.io/aoreshkov/oracle-forms-mcp --forms-dir /formsA named or anonymous volume inherits the image's non-root ownership (uid 10001) and just works.
A host bind mount does not — Docker never chowns the target — so run chown 10001 /host/cache
once on the host first, or redirect the writes with --cache-dir / --annotations-dir onto a path
the container user can write.
Options
--forms-dir <path> Directory containing the Forms modules (or pass it positionally)
--convert-command <cmd> Site-supplied converter command (with its arguments) instead of frmf2xml
--compile-command <cmd> Separate converter command for .pll libraries (0.11.0+)
--converted-dir <path> Directory the converted XML/.pld is written into (default: the cache)
--transport stdio|http Transport (default: stdio)
--port <int> HTTP port (default: 3000)
--allowed-host / --allowed-origin Extra HTTP hosts/origins (localhost-only by default)
--cache-dir <path> Cache override (default: OS cache dir + /oracle-forms-mcp)
--annotations-dir <path> Durable annotation store (default: <cache dir>/annotations)
--conversion-timeout <sec> Kill a stuck conversion (default: 120)
--prefetch <pattern> Fetch every module whose name contains <pattern>, then exit
--prefetch-all Fetch every module in the forms directory, then exit
--prefetch-type <type> Limit --prefetch to form, menu, library or object_libraryThe converter options can also be set as environment variables, for clients that configure a
server with variables rather than arguments (docker run -e, the env block of an MCP config).
A flag always wins over its variable:
Flag | Variable |
|
|
|
|
|
|
--convert-command and --converted-dir are also exposed as configuration in the
Claude Code plugin (/plugin → Oracle Forms), and all three in
the .mcpb bundle (Claude Desktop's connector settings) and the registry listing for the Docker
image — so whichever channel you install from, you can point the server at your own converter and
your own output directory without editing JSON by hand. Leaving any of them unset is always valid:
an empty value counts as "not configured".
Keeping the converted XML
By default a module's converted text form lives inside its cache entry. Point --converted-dir at
a directory of your own to keep the XML where you can read, diff, or feed it to other tooling:
server --forms-dir C:\forms --converted-dir C:\forms-xmlAll modules share that one flat directory, each file named the way Oracle names it —
orders_fmb.xml, mainmenu_mmb.xml, utils.pld — so a re-fetch replaces a module's file rather
than accumulating copies. The directory is created if missing, and it must not be the forms
directory itself (the names would collide with the pre-converted modules read from there); a
subdirectory of the forms directory is fine, since it is scanned non-recursively.
This is the directory the converter writes into, not somewhere files are moved to afterwards:
the converter runs with it as its working directory, so a wrapper that writes to a fixed location
can simply be pointed at it. Output is attributed to a module by Oracle's naming first
(orders_fmb.xml), falling back to "the newest matching file written after the run started" for
converters that name their output freely; conversions sharing the directory are serialised so that
fallback cannot mix two modules up. Whatever name the converter chose, the file is renamed to the
canonical one, and the index records it by a stable converted/<name> path either way — so an
index stays valid whether or not this option is set.
Using your own converter
If your site wraps the Forms tools — its own environment setup, logon handling, a patched
frmf2xml, or a different converter entirely — point the server at it:
server --forms-dir C:\forms --convert-command C:\tools\fmb2xml.batThe value is a whole command line, not just an executable, so a wrapper that needs arguments of its own — an interpreter, a container, a compatibility layer — is configured directly:
server --forms-dir /srv/forms --convert-command "/opt/forms/convert.sh --xml --quiet"
server --forms-dir C:\forms --convert-command "\"C:\tools\my tools\f2x.bat\" /nologon"
server --forms-dir /srv/forms --convert-command '["wine", "/opt/forms/frmf2xml.exe", "{}"]'Two syntaxes are accepted, and neither is ever handed to a shell — the command is split here and spawned with an argv list:
A quoted string. Split on whitespace, with
"…"or'…'grouping a part that contains spaces. Backslashes are literal, so Windows paths need no doubling.A JSON array —
["wine", "f2x.exe", "-xml"]— one element per argument, the same shape MCP clients use forcommand/args. Prefer it when quoting gets awkward, and note that JSON itself requires\\for a backslash.
A value that names an existing file is taken whole, spaces and all, so a plain path configured before this option accepted arguments keeps working unquoted.
The module's absolute path goes wherever you write {}; with no {} in the command it is
appended as the last argument, which is what the earlier <command> <module> convention did. The
command runs with the working directory set to the converted directory — that module's cache
directory by default — and is expected to write the text form there. A tool that cannot be pointed
at a working directory is given the output file instead: {out} is replaced with its absolute
path (<converted dir>/orders_fmb.xml, <converted dir>/utils.pld). {out} is only ever
substituted, never appended, so a command without it is run exactly as before. This mirrors how frmf2xml is
driven, so a script that already wraps it needs no changes. Emit the same formats the parser reads:
XML for .fmb/.mmb/.olb, a .pld dump for .pll. Oracle's <name>_fmb.xml naming is
preferred but not required — any .xml (or .pld for a library) written into the working directory
is picked up.
The program itself may be a path (absolute or relative to where the server was started) or a bare
name, which is looked up on PATH.
With --converted-dir that working directory is your directory, so
a wrapper that writes to a fixed place of its own — rather than to wherever it was started — works
by pointing --converted-dir at it. Scripts that write into their working directory need no
adjustment either way.
Precedence is --convert-command → ORACLE_HOME → copy-mode, so an explicitly configured
command wins even on a machine with a Forms installation (.pll libraries can be taken out of
that order — see below). A blank value counts
as unset. Like ORACLE_HOME, the command is parsed and validated at the first conversion rather
than at startup, so a stale setting still leaves cached modules readable; the error then names the
flag to fix.
The output must be freshly written. Because Forms-era tools return unreliable exit codes, a run is judged by its output file, and a file older than the run is treated as a leftover from a previous failed attempt. A script that copies a pre-generated file with
copy,xcopy, orcp -ppreserves the source's timestamp and will be rejected with "produced no output file". Redirect or rewrite instead (type src > out,cat src > out), ortouchthe result.
The command is operator configuration only — no tool argument can choose or extend it. Tool callers supply a module name, which is resolved against the scanned forms directory before the converter sees it, and the command is spawned directly with an argv list rather than through a shell, so nothing in a module's path or in your own quoting can turn into a second command.
Converting PL/SQL libraries with their own command
Since 0.11.0. No Oracle tool converts a .pll to XML: frmf2xml accepts forms, menus, and object
libraries only, and a library is dumped to .pld text by frmcmp instead. A --convert-command
built around frmf2xml therefore fails on every library. --compile-command gives .pll modules
a command line of their own, with the same syntax and placeholders, and leaves every other module
type where it was:
server --forms-dir /srv/forms --converted-dir /srv/forms-xml --convert-command "/opt/forms/f2xml.sh {}" --compile-command "frmcmp_batch Module={} Module_Type=LIBRARY Script=YES Batch=YES Logon=NO Output_File={out}"or, as a JSON array:
--compile-command '["frmcmp_batch", "Module={}", "Module_Type=LIBRARY", "Script=YES", "Batch=YES", "Logon=NO", "Output_File={out}"]'Write it on one line. The value is split into arguments without a shell, so a \ line
continuation copied into a configuration field would reach the tool as a literal argument.
Give frmcmp Output_File={out}. Without it, frmcmp writes the .pld next to the module —
into the forms directory, whatever its working directory — where the server would then read it as
a pre-converted file. When a run produces nothing in the converted directory but did leave a fresh
file next to the module, the error names that file and says to add {out}; the server does not
delete it.
Logon=NO matters too: without it (or a real Userid=), frmcmp prints its usage and exits 0
having written nothing.
Which converter a module reaches:
|
|
|
|
|
— | — | — | copy-mode | copy-mode |
— | — | set |
|
|
— | set | — / set | convert command | convert command |
set | — | — | compile command | copy-mode |
set | — | set | compile command |
|
set | set | — / set | compile command | convert command |
With --compile-command unset, nothing changes: a --convert-command that already handles
libraries keeps receiving them. Where a type is served in copy-mode, its pre-converted text form is
what the cache entry is checked against, so re-exporting an _fmb.xml still marks that form stale
while its libraries are converted from their binaries.
Cache
%LOCALAPPDATA%\oracle-forms-mcp (Windows), ~/Library/Caches/oracle-forms-mcp (macOS),
$XDG_CACHE_HOME/oracle-forms-mcp (Linux). One directory per module:
ORDERS.fmb/
converted/orders_fmb.xml converted (or copied) text form
plsql/triggers/*.sql decoded trigger bodies
plsql/program-units/*.sql decoded program units
plsql/menu-items/*.sql menu-item command bodies (menu modules)
index.json the structured indexSafe to delete at any time; modules are simply re-fetched. With
--converted-dir the converted/ file is written to the directory
you name instead and the rest of the entry stays here.
Annotations are not part of this derived cache. They live in a separate annotations/ store
(one NAME.ext.json per module, defaulting to <cache dir>/annotations, overridable with
--annotations-dir), so deleting a module's cache entry — or re-fetching it — leaves the notes,
tags, and relations you recorded intact.
Notes on the Oracle tools
frmf2xmlwrites its output into the process working directory; the server runs it with the converted directory as cwd (--converted-dir, else the module's cache dir) and passesOVERWRITE=YES USE_PROPERTY_IDS=NO.frmcmp_batchis preferred overfrmcmp(headless); the server passesScript=YES Batch=YES Logon=NOand an explicitOutput_File— without one,frmcmpwrites the.pldnext to the module rather than into its working directory — and augmentsFORMS_PATHwith the forms dir so attached libraries resolve.Forms tools have unreliable exit codes — success is judged by the output file existing, being non-empty, and being newer than the invocation; failures surface the tool's output tail.
.pldfiles may be written in the client NLS charset; the parser reads UTF-8 with a windows-1252 fallback (setNLS_LANGaccordingly if you see mojibake).
Development
gradlew build # compile + all tests (no Oracle installation needed)
gradlew updateKotlinAbi # refresh the ABI dump (core/api/*.api) after public API changes
gradlew :server:run --args="--forms-dir sample-forms"
gradlew :server:packageMcpb # build the installable .mcpb bundleConverter behavior is tested against a fake ORACLE_HOME (stub scripts); the full copy-mode
pipeline is covered end-to-end by FormsServiceIntegrationTest against the bundled fixtures.
This server cannot be deployed
Maintenance
Related MCP Connectors
Read-only AI coding tools for change verification, release readiness, capacity, and guidance.
- mcpOAuthcom.formester
Give AI agents access to form submissions — read, search, update, and process file attachments.
Query Allen-Bradley and Siemens PLC projects, live tag values, and analyses in plain English.
Query and audit AppSheet apps in natural language via Knotrik's pre-scanned definitions.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceProvides contextual Oracle database schema information to AI assistants, enabling them to understand and work with large databases containing thousands of tables. Supports multi-database connections, smart schema caching, table lookups, and relationship mapping.-
- FlicenseNot gradedqualityDmaintenanceEnables AI applications to run SQL queries and retrieve results from Oracle Database.8-
- AlicenseBqualityFmaintenanceEnables AI assistants to build, inspect, and modify Oracle APEX 24.2 applications via natural language, providing 86 tools across 15 categories.10015MIT
- AlicenseNot gradedqualityCmaintenanceEnables AI agents to safely inspect Oracle Database schemas, objects, and PL/SQL source with a strict read-only guard, without ever modifying data.11 npmMIT