Skip to main content
Glama

apex_add_jet_chart

Adds an Oracle JET chart region to an APEX page. Use SQL to supply LABEL and VALUE data for bar, line, pie, donut, or area charts.

Instructions

Add an Oracle JET chart region. Types: bar, line, pie, donut, area. SQL must alias LABEL + VALUE.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
heightNoChart height in pixels (default 400).
page_idYesTarget page ID.
sequenceNoRegion display order on the page.
sql_queryNoSQL query returning at least 2 columns: label + value. Example: "SELECT DS_STATUS AS LABEL, COUNT(*) AS VALUE FROM TEA_AVALIACOES GROUP BY DS_STATUS"
chart_typeNoChart style: - "bar": Vertical bar chart (default) - "bar_horizontal": Horizontal bar chart - "line": Line chart (good for trends over time) - "area": Filled area chart (good for cumulative data) - "pie": Pie chart (distribution, no axes) - "donut": Donut chart (distribution with center hole) - "combo": Bar + line on same chart (use extra_series for line)bar
orientationNo"vertical" (default) or "horizontal" (for bar charts only).vertical
region_nameYesRegion title shown in the APEX page.
series_nameNoDisplay name for the data series (shown in legend/tooltip).
extra_seriesNoAdditional data series for multi-series charts. List of dicts: [{"sql": "...", "value_column": "VALUE", "label_column": "LABEL", "series_name": "Series 2"}] Each extra series can have its own SQL query.
label_columnNoColumn name used for X axis / slices (default "LABEL").LABEL
value_columnNoColumn name used for Y axis / slice size (default "VALUE").VALUE
x_axis_titleNoOptional X axis label.
y_axis_titleNoOptional Y axis label.
color_paletteNoOptional list of hex colors for chart series (e.g., ["#00995D", "#1e88e5"]). Note: color_palette is accepted for future compatibility but not applied in APEX 24.2.13.
legend_positionNoWhere to show the legend: "end" (right), "top", "bottom", "start" (left), "auto".end

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes
Behavior4/5

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

Annotations already indicate this is a write operation (readOnlyHint=false) and non-destructive (destructiveHint=false). The description adds meaningful behavioral context by specifying the SQL alias requirement and the supported chart types, which goes beyond the structured annotations. No contradictions with annotations.

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?

The description is extremely concise: three short sentences or fragments that immediately state the action, list types, and give the key SQL constraint. No filler words, front-loaded with the core purpose. Every sentence earns its place.

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

Completeness3/5

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

For a tool with 15 parameters and many sibling chart tools, the description is minimal. It covers the core purpose and a key constraint, but does not orient the agent among the extensive sibling chart tools (e.g., combo, area, bubble). The rich output schema and parameter descriptions compensate, but the lack of tool selection guidance makes it less complete.

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%, with every parameter having detailed descriptions (e.g., chart_type enumerates all options with explanations, sql_query includes an example). The description's note 'SQL must alias LABEL + VALUE' reinforces the sql_query parameter but adds little beyond the schema. Baseline 3 is appropriate given high schema coverage.

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

Purpose4/5

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

The description clearly states the action: 'Add an Oracle JET chart region' with a verb and resource. It lists common chart types (bar, line, pie, donut, area), but does not explicitly differentiate from the many sibling chart tools like apex_add_area_chart or apex_add_combo_chart. The schema reveals additional types (combo, bar_horizontal) not mentioned, so purpose is clear but not fully distinguishing.

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

Usage Guidelines3/5

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

The description provides an important usage prerequisite: 'SQL must alias LABEL + VALUE.' However, it gives no guidance on when to use this tool versus specialized chart siblings (e.g., apex_add_pareto_chart, apex_add_scatter_plot). Usage context is implied (general JET chart addition) but no explicit alternatives or exclusions are stated.

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