1.1 About Select AI

Use natural language to interact with your database and LLMs through SQL to enhance user productivity and develop AI-based applications. Select AI simplifies and automates using generative AI, whether generating, running, and explaining SQL from a natural language prompt, generating synthetic data, or chatting with the LLM.

When you use Select AI, Autonomous AI Database manages the process of converting natural language into SQL. This means you can provide a natural language prompt instead of SQL code to interact with your data. Select AI serves as a productivity tool for SQL users and developers and enables non-expert SQL users to derive useful insights from their data, without having to understand data structures or technical languages. Other features include synthetic data generation, supporting chat history for conversations, and other features, all from a SQL interface.

The DBMS_CLOUD_AI package enables integration with a user-specified LLM for generating SQL code using natural language prompts. For natural language to SQL generation, this package provides an augmented prompt to the LLM containing the relevant database schema metadata. This enables generating, running, and explaining SQL queries based on natural language prompts. It also facilitates synthetic data generation, and allows for chatting with the LLM. The DBMS_CLOUD_AI package works with AI providers listed in Select your AI Provider and LLMs.

Note:

You must have an account with the AI provider and provide the credentials through DBMS_CLOUD_AI objects that the Autonomous AI Database uses.

See Also:

Select AI and Select AI Agent Capability Matrix to learn about Select AI capabilities available across Autonomous AI Database and Oracle AI Database releases.

Topics

  • Usage Guidelines
    Provides usage guidelines to assist in the use of Select AI for natural language to SQL generation..
  • Supported Platforms
    Select AI is supported on Autonomous AI Database Serverless and Autonomous AI Database on Dedicated Exadata Infrastructure and Cloud at Customers.

Parent topic: Use Select AI for Natural Language Interaction with your Database

1.1.1 Usage Guidelines

Provides usage guidelines to assist in the use of Select AI for natural language to SQL generation..

Intended Use

This feature generates, runs, and explains SQL queries from user-provided natural language prompts. It automates tasks that users would otherwise perform manually using their schema metadata and a large language model (LLM) of their choice.

Depending on the Select AI action you specify, you provide a prompt, whether for natural language to SQL generation, or pass-through chat, and Select AI automates the interaction with LLMs and your database using SQL and PL/SQL interfaces. Specifically, it generates SQL queries from natural language based on metadata from the specified schema and tables. Additionally, it facilitates chat-based generative AI. It also explains SQL queries based on natural language prompts and supports synthetic data generation for one or multiple schema tables. Select AI enables submitting general requests with the chat action.

Prompt Augmentation Data

For SQL query generation, the database augments the user-specified prompt with database metadata to mitigate hallucinations from the LLM. The augmented prompt is then sent to the user-specified LLM to produce the query.

The database augments the prompt with schema metadata only. This metadata may include schema definitions, table and column comments, and content available from the data dictionary. For the purposes of SQL generation, the database does not provide table or view contents (actual row or column values) when augmenting the prompt.

The narrate action provides the LLM with the results of a natural language-to-SQL query, which contains database data. The LLM uses these results to generate a natural language response.

WARNING:

Large language models (LLMs) have been trained on a broad set of text documentation and content, typically from the Internet. As a result, LLMs may have incorporated patterns from invalid or malicious content, including SQL injection. Thus, while LLMs are adept at generating useful and relevant content, they also can generate incorrect and false information including SQL queries that produce inaccurate results and/or compromise security of your data.

The queries generated on your behalf by the user-specified LLM provider will be run in your database. Your use of this feature is solely at your own risk, and, notwithstanding any other terms and conditions related to the services provided by Oracle, constitutes your acceptance of that risk and express exclusion of Oracle’s responsibility or liability for any damages resulting from that use.

Parent topic: About Select AI

1.1.2 Supported Platforms

Select AI is supported on Autonomous AI Database Serverless and Autonomous AI Database on Dedicated Exadata Infrastructure and Cloud at Customers.

  • Autonomous AI Database Serverless
  • Autonomous AI Database on Dedicated Exadata Infrastructure
  • Autonomous AI Database on Dedicated Exadata Infrastructure Region
  • Autonomous AI Database Cloud@Customer

Parent topic: About Select AI