Part I Select AI

  • 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 enables conversations for intuitive way to work with your data, enhances response accuracy with Retrieval Augmented Generation (RAG), and generates realistic synthetic data for testing, development, and training.
  • Select AI Conversations
    Conversations in Select AI refer to the interactive dialogue between the user and the system, where a sequence of user-provided natural language prompts are stored and managed to support long-term memory for LLM interactions.
  • Select AI with Retrieval Augmented Generation (RAG)
    Select AI with RAG augments your natural language prompt by retrieving content from your specified vector store using semantic similarity search. This reduces hallucinations by using your specific and up-to-date content and provides more relevant natural language responses to your prompts.
  • Use an AI Proxy Database for Select AI NL2SQL
    Select AI runs natively inside Oracle Autonomous AI Database and Oracle AI Database, both of which can operate as an AI proxy database, also referred to as "sidecar". An AI proxy database can support both local and external data sources (on-premises, cloud, or third-party). Using standard Oracle federation mechanisms such as Database Links, Cloud Links, Table Hyperlinks, and Federated Tables, Select AI generates federated SQL from natural language prompts using metadata across Oracle and non-Oracle systems.
  • Synthetic Data Generation
    Generate synthetic data using random generators, algorithms, statistical models, and Large Language Models (LLMs) to simulate real data for developing and testing solutions effectively.
  • Feedback
    Select AI enables you to provide feedback to help improve your selected LLM's ability to generate more accurate SQL queries.
  • Generate a Summary with Select AI
    Select AI enables you to generate a summary of your text, especially large texts, generally supporting up to 1 GB using AI providers. You can extract key insights from texts or large files as per your specific needs. This feature uses the LLM specified in your AI profile to generate a summary for a given text.
  • Translate
    With Select AI, you can use generative AI from the OCI translation service to translate your text into the language of your choice.
  • Private Endpoint Access for Select AI Models
    You can enable secure, private access to generative AI models by deploying Ollama or Llama.cpp behind a private endpoint within your Virtual Cloud Network (VCN). This architecture is designed for organizations that need to keep AI processing fully private. The setup isolates both the Autonomous AI Database Serverless and your AI model servers from the public internet using private subnets, security lists, and controlled routing.
  • 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.