apex_generate_from_schema
Build complete Oracle APEX apps from table names: generates CRUD pages, a dashboard, and navigation automatically.
Instructions
Generate a complete app from a list of tables: CRUD pages + dashboard + navigation.
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": {
"tables": "<tables>"
},
"name": "apex_generate_from_schema"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tables | Yes | List of table names to generate CRUDs for. Example: ["EMPLOYEES", "DEPARTMENTS", "PROJECTS"] | |
| nav_icon_map | No | Dict mapping table name to Font Awesome icon class. Example: {"EMPLOYEES": "fa-users", "DEPARTMENTS": "fa-building"} Defaults to "fa-table" for unmapped tables. | |
| start_page_id | No | First page ID for the first CRUD list (default 10). Pages are allocated: 10/11, 12/13, 14/15... | |
| include_dashboard | No | Generate a dashboard page with record counts (default True). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |