Select AI Interfaces

Select AI interfaces support environments such as SQL, PL/SQL, and Python.

Select AI for SQL

Use Select AI for SQL to generate and run SQL queries using natural language input. Instead of writing queries manually, describe the data you want to access, and Select AI translates your request into SQL statements.

Select AI for SQL uses generative AI capabilities, including large language models (LLMs). It supports natural language to SQL query generation, and other advanced data interaction features.

Select AI for SQL uses the DBMS_CLOUD_AI and DBMS_CLOUD_AI_AGENT packages to process natural language prompts and execute queries directly within the database.

For more information, see the documentation for DBMS_CLOUD_AI and DBMS_CLOUD_AI_AGENT.

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, consistent metadata management, and agentic AI capabilities. It also supports Python 3.14 and includes an updated HTML documentation site (New)

What You Can Do

• NL2SQL: Use natural language to query your database through AI-based SQL generation. This includes generating SQL queries, running the generated queries, explaining generated SQL, and narrating query results.

• Chat: Create and manage conversations with prompt history to support chat-style interactions with generative AI models.

• Synthetic Data Generation: Generate synthetic data for testing and analysis using generative AI

• Summarize: Summarize text or query results

• Translate: Translate text between languages

• AI Agents: Create autonomous and interaction AI agents. See Select AI Agent for Python for details.

• Sync and Async connections: Connect to the database using synchronous or asynchronous connections

  You can use select_ai.create_pool() and select_ai.create_pool_async() to create shared connection pools for improved concurrency and resource sharing.

• AI Profiles: Create and manage AI profiles to enable using AI models from a wide range of AI providers

Supported Platforms

Select AI for Python is certified for Autonomous AI Database 26ai and 19c. Select AI for Python may work on other platforms, however, it is not certified.

Click https://github.com/oracle/python-select-ai/issues to report issues.

Supported Functions for Select AI Profile (Synchronous and Asynchronous)

When you send prompts through a profile, you can choose among several functions defined for AI profile objects. Some are as follows:

• create(): Create the AI profile in the database or replace if necessary. See create() GitHub documentation.

• delete(): Remove the profile. See delete() GitHub documentation.

• generate(): Use the profile to process a prompt as per the chosen action. See generete() GitHub documentation

• generate_synthetic_data(): Create synthetic data based on the supplied attributes. See generate_synthetic_data() GitHub documentation.

• get_attributes(): Return the current profile attributes. See get_attributes() GitHub documentation.

• run_sql(): Generate and run SQL (default). See run_sql() GitHub documentation.

• show_sql(): Generate SQL without running it. See show_sql() GitHub documentation.

• explain_sql(): Provide explanation for generated SQL. See explain_sql() GitHub documentation.

• narrate(): Describe query results in natural language. See narrate() on GitHub documentation.

• chat(): Engage in a free-form conversation. See chat() GitHub documentation.

• show_prompt(): Display the constructed prompt sent to the generative AI model. See show_prompt() GitHub documentation.

• summarize(): Produce a summary for provided content. See summarize() GitHub documentation.

• translate(): Translate text from a specified source language to a target language. See translate() GitHub documentation.

For a complete list of functions, see Select AI for Python guide. See also Use AI Keyword to Enter Prompts for more information on the Select AI actions.

Supported Classes

The library includes classes to manage providers, profiles, conversations, synthetic data, and agentic workflows. Both synchronous and asynchronous versions are available.

• Provider Classes: Define AI provider: OpenAIProvider, AzureProvider, OCIGenAIProvider, AWSProvider, GoogleProvider, AnthropicProvider, CohereProvider, HuggingFaceProvider.

• Profile: defines the generative AI profile to process prompts (provider, credentials, metadata, options) and supports synthetic data generation.

• ProfileAttributes: profile configuration details such as provider, credential name, max tokens, temperature, or object list.

• ConversationAttributes: manage conversational context across prompts.

• SyntheticDataAttributes: create synthetic datasets for testing and development.

• Class-level delete method (Profile.delete_profile(profile_name)): This class-level methods delete database objects directly without requiring initialization of a proxy object.

  For Select AI Agent related class-level delete methods, see Select AI Agent for Python.

Asynchronous equivalents exist for Profile, Conversation, and VectorIndex classes.

Async Select AI Support

Select AI for Python provides asynchronous APIs that enable interaction with Autonomous AI Database. These APIs use Python’s async and await constructs and support coroutine-based applications.

Async APIs are available for the following key objects in the library:

• AsyncProfile

• AsyncConversation

• AsyncVectorIndex

Use select_ai.create_pool_async() to manage connections in asynchronous workflows.

These classes provide functionality equivalent to their synchronous counterparts. Async APIs are useful in applications that require concurrent operations or event-driven workflows.

For complete API reference, see Select AI for Python guide.

API and Attribute Update Enhancements

The following enhancements are available:

• All proxy objects support fetch() to retrieve existing objects.

• All proxy objects provide set_attribute() and set_attributes() for consistent updates

• All tool creation APIs support an instruction parameter to define precise run behavior.

Privilege and HTTP Access

Privilege management is separate from HTTP access configuration.

Privilege APIs:

• select_ai.grant_privileges

• select_ai.revoke_privileges

Privileges are updated to include:

• DBMS_CLOUD

• DBMS_CLOUD_AI

• DBMS_CLOUD_AI_AGENT

• DBMS_CLOUD_PIPELINE

HTTP access APIs:

• select_ai.grant_http_access

• select_ai.revoke_http_access

Other Enhancements

• Python 3.14 support

• New HTML documentation site on GitHub using the Python docs theme: GitHub Select AI for Python Documentation

• Installation for Release 1.2.2:

  pip install select_ai