Oracle Select AI

This topic provides overview of integration of Oracle Select AI with DB Assistant.

Oracle Select AI in DB Assistant enables you to connect to an LLM through the database, while exposing the database information to the LLM through profiles. The profiles and user credentials to access those profiles (corresponding to LLMs) to use with Select AI are stored in the database.

Integrated with Oracle Select AI features, the DB Assistant module of Oracle® Database Navigator allows you to:

  • interact with your database connection and data model securely using natural language inputs
  • get insights of your code and data in a conversational manner through dedicated chats
  • create AI profiles corresponding to the language models and create user credentials to access those AI profiles
  • choose an AI provider and the language model (and version) to work with and configure the LLM settings
  • select the language model and version and configure the LLM settings
  • map specific data sets of a DB connection to the AI profiles and generate responses catering those data sets
  • generate prompt-based SQL statements and their detailed explanation including the output inference in natural language
  • get responses to inputs based on previous prompts without specifying the context for each prompt (Interactive mode chat)
  • perform Select AI-based context actions directly on the data editor (or console)

For more information, see Oracle Select AI documentation.

To work with Oracle Select AI, first open the DB Assistant window and select the database connection from the window banner. You then have to select an AI Profile and a Language Model from the respective drop-down fields of the DB Assistant window. This ensures the responses are generated in the context of the database connection which you have selected and the datasets which are mapped to the Profile.

Parent topic: Database Assistant