Use Select AI for Natural Language Interaction with your Database

Select AI enables SQL access to generative AI using Large Language Models (LLMs) and embedding models. This includes support for natural language to SQL query generation and retrieval augmented generation, among other features.

• 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, using retrieval augmented generation with vector stores, generating synthetic data, or chatting with the LLM.

• Select AI for Python

  Select AI for Python integrates generative AI capabilities into Autonomous AI Database workflows. Select AI for Python provides a client library, select_ai, that enables you to use DBMS_CLOUD_AI capabilities in Autonomous AI Database from Python. Select AI for Python supports enhanced generative AI workflows, summarization, feedback mechanisms, consistent metadata management, and agentic AI capabilities. It also supports Python 3.14 and includes an updated HTML documentation site (New)

• Select AI Concepts

  Explores the concepts and terms related to Select AI.

• Select AI Use Cases

  Select AI enhances data interaction and enables developers to build AI-driven applications directly from SQL, transforming natural language prompts to SQL queries and text responses, supporting chat interaction with LLMs, enhancing response accuracy with current data using RAG, and generating synthetic data.

• Getting Started with Select AI

  To get started, review the prerequisites and the tasks that you need to perform to use Select AI.

• Manage AI Profiles

  You can create and manage your AI profiles through DBMS_CLOUD_AI package.

• Use AI Keyword to Enter Prompts

  Use AI as the keyword in a SELECT statement for interacting with the database using natural language prompts.

• Select AI Features

  Select AI supports the following features.

• Examples of Using Select AI

  Explore integrating Oracle's Select AI with various supported AI providers to generate, run, and explain SQL from natural language prompts or chat with the LLM.

See Also:

• DBMS_CLOUD_AI Package

• Select AI and Select AI Agent Capability Matrix