Generate CRUD Pages for Oracle Database Tables with apex-mcp

apex_generate_crud(
    table_name="ORDERS",
    list_page_id=10,
    form_page_id=11,
    items_per_page=20,
    button_labels={
        "new": "New Order",
        "save": "Save Order",
        "delete": "Cancel Order",
        "confirm_delete": "Are you sure you want to cancel this order?",
    },
)

{
  "status": "ok",
  "table": "ORDERS",
  "list_page_id": 10,
  "form_page_id": 11,
  "pages_created": [10, 11],
  "items_created": ["P11_ORDER_ID", "P11_CUSTOMER_ID", "P11_ORDER_DATE", "P11_STATUS"],
  "lovs_created": ["LOV_CUSTOMER_ID"],
  "summary": {
    "columns_found": 8,
    "pk_columns": ["ORDER_ID"],
    "pk_type": "simple",
    "fk_columns": ["CUSTOMER_ID"],
    "items_on_form": 6,
    "lovs": 1,
    "skipped_blobs": []
  }
}

apex_generate_from_schema(
    tables=["EMPLOYEES", "DEPARTMENTS", "JOBS"],
    start_page_id=10,
    include_dashboard=True,
    nav_icon_map={
        "EMPLOYEES":   "fa-users",
        "DEPARTMENTS": "fa-building",
        "JOBS":        "fa-briefcase",
    },
)

{
    "name": "STATUS",          # item name suffix — becomes P{page_id}_STATUS
    "label": "Status",         # display label
    "type": "select",          # "text" | "select" | "date" | "number"
    "lov": "SELECT DISTINCT DS_STATUS d, DS_STATUS r FROM ORDERS ORDER BY 1",
}

apex_generate_report_page(
    page_id=30,
    page_name="Order History",
    sql_query="""
        SELECT o.order_id, c.customer_name, o.order_date, o.status, o.total_amount
          FROM orders o
          JOIN customers c ON c.customer_id = o.customer_id
         WHERE (:P30_STATUS IS NULL OR o.status = :P30_STATUS)
           AND (:P30_DATE_FROM IS NULL OR o.order_date >= TO_DATE(:P30_DATE_FROM, 'DD/MM/YYYY'))
    """,
    filter_items=[
        {"name": "STATUS",    "label": "Status",    "type": "select",
         "lov": "SELECT DISTINCT status d, status r FROM orders ORDER BY 1"},
        {"name": "DATE_FROM", "label": "From Date", "type": "date"},
    ],
)

result = apex_generate_modal_form(
    page_id=10,
    region_name="Quick Edit Order",
    table_name="ORDERS",
    pk_item_name="ORDER_ID",
    title="Edit Order",
)

// In a Dynamic Action or button click handler:
apex.region('modal_quick_edit_order').show();

{
    "title": "Step 1: Basic Info",
    "items": [
        {"name": "FIRST_NAME", "label": "First Name", "type": "text",   "required": True},
        {"name": "LAST_NAME",  "label": "Last Name",  "type": "text",   "required": True},
        {"name": "HIRE_DATE",  "label": "Hire Date",  "type": "date"},
        {"name": "DEPT_ID",    "label": "Department", "type": "select",
         "lov": "SELECT ds_nome d, id_dept r FROM departments ORDER BY 1"},
    ],
}

apex_generate_wizard(
    start_page_id=50,
    wizard_title="New Employee Onboarding",
    finish_redirect_page=1,
    steps=[
        {
            "title": "Step 1: Personal Info",
            "items": [
                {"name": "FIRST_NAME", "label": "First Name", "type": "text", "required": True},
                {"name": "LAST_NAME",  "label": "Last Name",  "type": "text", "required": True},
                {"name": "EMAIL",      "label": "Email",       "type": "text", "required": True},
            ],
        },
        {
            "title": "Step 2: Position",
            "items": [
                {"name": "JOB_ID",     "label": "Job Title",   "type": "select",
                 "lov": "SELECT job_title d, job_id r FROM jobs ORDER BY 1"},
                {"name": "HIRE_DATE",  "label": "Start Date",  "type": "date", "required": True},
                {"name": "SALARY",     "label": "Salary",      "type": "number"},
            ],
        },
        {
            "title": "Step 3: Department",
            "items": [
                {"name": "DEPT_ID",    "label": "Department",  "type": "select",
                 "lov": "SELECT department_name d, department_id r FROM departments ORDER BY 1"},
                {"name": "MANAGER_ID", "label": "Manager",     "type": "select",
                 "lov": "SELECT first_name||' '||last_name d, employee_id r FROM employees ORDER BY 1"},
            ],
        },
    ],
)