27.5 Using Graph Assistant in Modeler

The Graph Assistant feature in Modeler enables you to use natural language to create, review, and modify SQL property graphs. You can describe the graph or the changes you want, and the Graph Assistant generates or updates the graph accordingly.

Before you use Graph Assistant, ensure that the following prerequisites are met:

• You are connected either to an Oracle Autonomous AI Database instance running Oracle AI Database 26ai, or to an Oracle AI Database 26ai instance with DBMS_CLOUD installed.

  See Also:

  • Provision an Autonomous AI Database Instance
  • Installing DBMS_CLOUD
• An AI profile is configured for the database environment. Graph Assistant uses the AI profile to interpret natural language prompts and generate or modify SQL property graphs. See Generate SQL from Natural Language Prompts Using Select AI for more information.
• The Graph Assistant option is enabled in the Figure 27-15 panel.
• Select the AI profile that you want Graph Assistant to use from the Profile list in the Graph Assistant section of the Figure 27-15 panel.

To open Graph Assistant, expand the Graph Assistant panel by clicking the arrow on the left side of the Modeler page.

Figure 27-8 Graph Assistant

Description of "Figure 27-8 Graph Assistant"

The Graph Assistant panel contains the following components:

• Message box: Enter a natural language prompt or follow-up instruction.
• Send: Submits the prompt to Graph Assistant.
• Conversation area: Displays the prompts and responses exchanged with Graph Assistant.
• Add (+): Starts a new conversation.

  See also Store Chats and Clear Chats configurations in Configuring Modeler Settings.

You can use Graph Assistant to perform the following tasks:

• Create a new SQL property graph from a natural language description.
• Review an existing SQL property graph and receive a summary of its structure.
• Modify an existing SQL property graph by adding, removing, or updating vertices, edges, labels, or properties.
• Fix warnings while creating or editing a SQL property graph.

• Creating a SQL Property Graph Using Graph Assistant
  You can create a SQL property graph using Graph Assistant.
• Reviewing a SQL Property Graph Using Graph Assistant
  You can use Graph Assistant to review a SQL property graph after it has been loaded into the Modeler.
• Editing a SQL Property Graph Using Graph Assistant
  You can use Graph Assistant to edit a SQL property graph only after the graph has been loaded into the Modeler.

27.5.1 Creating a SQL Property Graph Using Graph Assistant

You can create a SQL property graph using Graph Assistant.

1. Expand the Graph Assistant panel by clicking the arrow on the left side of the Modeler page.
2. Click New Graph above the message box.
3. Select the source data tables that are required as input for the graph.
4. Click Send in the Select Tables panel.

   Graph Assistant displays the SQL property graph generated using the selected tables.

5. Review the generated graph or refine the graph using additional instructions.
6. Prompt Graph Assistant to execute the DDL if the proposed graph design is as expected.

   Figure 27-9 Creating a SQL Property Graph Using Graph Assistant

   
   

   
   Description of "Figure 27-9 Creating a SQL Property Graph Using Graph Assistant"

   
   

   Tip:

   Click Use to load the graph into Modeler. This makes the graph DDL available, enabling Graph Assistant to review or modify a SQL property graph in subsequent prompts.
7. Click Create Graph in the top right of the page.
   The graph gets created and you can interact with the graph using Graph Explorer.

27.5.2 Reviewing a SQL Property Graph Using Graph Assistant

You can use Graph Assistant to review a SQL property graph after it has been loaded into the Modeler.

1. Expand the Graph Assistant panel by clicking the arrow on the left side of the Modeler page.
2. Click Review graph above the message box.

   Note:

   Graph Assistant can review or modify only the graph that is currently loaded in the Modeler. If you create a graph draft using Graph Assistant, click Use to load the generated graph into the Modeler. Until you click Use, the graph DDL is not available and Graph Assistant cannot review or modify the graph.

   The summary of the SQL property graph that is loaded in the modeler is retrieved and displayed.

   Figure 27-10 Reviewing a SQL Property Graph Using Graph Assistant

   
   

   
   Description of "Figure 27-10 Reviewing a SQL Property Graph Using Graph Assistant"

   
   

27.5.3 Editing a SQL Property Graph Using Graph Assistant

You can use Graph Assistant to edit a SQL property graph only after the graph has been loaded into the Modeler.

1. Expand the Graph Assistant panel by clicking the arrow on the left side of the Modeler page.
2. Click Edit graph above the message box.

   Note:

   Graph Assistant can review or modify only the graph that is currently loaded in Modeler. If you create a graph draft using Graph Assistant, click Use to load the generated graph into Modeler. Until you click Use, the graph DDL is not available and Graph Assistant cannot review or modify the graph.

   The summary of the SQL property graph that is loaded in Modeler is retrieved and displayed.

3. Prompt Graph Assistant to edit the graph as required.

   Figure 27-11 Editing a SQL Property Graph Using Graph Assistant

   
   

   
   Description of "Figure 27-11 Editing a SQL Property Graph Using Graph Assistant"

   
   
4. Review the generated graph or refine the graph using additional instructions.
5. Click Update Graph on the top right of the page.
   The graph gets updated and can be queried in Graph Explorer.