5.13 Creating a Data Model Using AI

Create a data model using the Generative AI Service already configured on the workspace.

To create a data model using AI, you must have a Generative AI Service configured and enable the Used by App Builder setting. If an AI Service is not available, the Create Data Model Using AI option is hidden. To learn more, see Managing Generative AI Services in Oracle APEX App Builder User’s Guide.

To create a data model using AI:

  1. On the Workspace home page, click SQL Workshop.
  2. Click Utilities.
  3. Click Create Data Model Using AI.

    Tip:

    You can also access Create Data Model Using AI directly from the Tasks list on the SQL Workshop home page.
  4. Select the SQL Format:
    • Oracle SQL
    • Quick SQL

    Tip:

    APEX saves this choice as a user preference.
  5. Request the database objects:
    • Select from the sample prompts to begin.
    • Enter your own request using natural language.
    The APEX Assistant begins building a SQL script based on the information you provide.

To complete the SQL script:

  1. For Oracle SQL format, click Create SQL Script.
    APEX generates the script and brings you to the Script Editor page.
  2. For Quick SQL format, click Review Quick SQL.
    APEX generates the Quick SQL code and brings you to the Quick SQL page.

To save, edit, and run the script:

  1. In Script Name, enter a name for the script. Script name extensions are optional.
  2. Optional: Edit the script.
  3. Click Run to run the script.