apex_generate_dashboard
Generate an Oracle APEX dashboard page with KPI metric cards and JET charts from SQL queries. Specify page ID and KPI definitions to create the dashboard.
Instructions
Generate a dashboard page with KPI metric cards and JET charts.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"page_id": "<page_id>"
},
"name": "apex_generate_dashboard"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ir_sql | No | SQL for the bottom Interactive Report. If omitted, uses a sample query. | |
| page_id | Yes | Page ID for the dashboard (typically 1). | |
| ir_title | No | Title for the IR region (default: "Recent Records"). | Recent Records |
| page_name | No | Display name (default: "Dashboard"). | Dashboard |
| kpi_queries | No | List of KPI card definitions. Each dict: { "title": "Total Users", "sql": "SELECT COUNT(*) FROM users", "icon": "fa-users", "color": "u-color-1" } If omitted, creates 4 sample KPI cards. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |