Skip to main content
Glama

apex_generate_modal_form

Create an inline modal popup form for Oracle APEX that returns a region_static_id for opening via JavaScript, replacing the need for a separate page.

Instructions

Create an inline modal popup form (no separate page). Returns region_static_id for JS open.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
titleNoModal title text shown in the dialog header. Defaults to ``region_name``.
page_idYesPage ID where the modal lives.
sequenceNoDisplay sequence for the region (default 10).
table_nameYesTable the modal form targets (used for the Save process).
auth_schemeNoOptional authorization scheme name.
region_nameYesDisplay name of the modal region.
pk_item_nameYesPage item name for the primary key (auto-prefixed with ``P{page_id}_`` if needed).

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations only provide basic non-read-only, non-destructive flags. The description adds useful behavioral context by specifying the implementation method ('inline modal popup form') and the return value ('region_static_id for JS open'). It does not detail side effects or permissions, but for a create operation this is acceptable.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two short sentences, front-loaded with the primary action and key differentiator, followed by the return value. Every word earns its place; no fluff or repetition of schema details.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With 7 parameters, all described in schema, an output schema present, and annotations given, the description is relatively short but sufficient. It captures the essential purpose, placement, and return value. Missing explicit guidance on when to choose this over alternatives, but that is covered under usage guidelines.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so all parameters are already documented with meanings and defaults. The description adds minimal parameter-level info beyond noting the feature of an inline modal. Baseline of 3 is appropriate since the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb ('Create') and resource ('inline modal popup form'), and clearly distinguishes from separate page creation by saying '(no separate page)'. It also states the key return value (region_static_id for JS open), making the tool's purpose unambiguous even among many sibling tools.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The phrase '(no separate page)' provides clear context for when to use this tool—when an inline modal is desired rather than a dedicated page. It does not explicitly name alternatives or exclusions, but the context is sufficient for an agent to differentiate from related page/region creation tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/TechFernandesLTDA/apex-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server