Use Autonomous AI Database as an AI Proxy for Select AI

Select AI runs natively inside Oracle Autonomous AI Database, which can operate as an AI Proxy Database, also referred to as "sidecar", for local and external data sources (on-premises, cloud, or third-party). Using standard Oracle federation mechanisms such as Database Links and Cloud Links, Select AI generates federated SQL from natural language prompts across Oracle and non-Oracle systems.

Autonomous AI Database hosts act as a central metadata and processing layer for both local and external data sources. The AI Proxy Database controls distributed query processing while external systems remain authoritative for their data.

What Is an AI Proxy Database

An AI Proxy Database is an Autonomous AI Database instance that runs Select AI on behalf of local or external data sources. It does not own the data. Instead, it uses metadata exposed through Database Links and Cloud Links to interpret natural language requests and generate SQL that runs across distributed systems.

In this architecture, the AI Proxy Database:

  • Hosts Select AI

  • Uses the user-specified LLM to interpret intent and generate SQL

  • Coordinates federated query execution

  • Returns results as standard SQL result sets

This approach enables AI-driven analytics across heterogeneous data stores without migrating or duplicating data.

See Use Database Links with Autonomous Database and Use Cloud Links for Read Only Data Access on Autonomous AI Database for more details.

For example, a natural language query such as “Show pending orders for Acme Corp” retrieves customer data from a BigQuery table on Google Cloud and order details from an Amazon Redshift database on AWS. Select AI manages the joins, data locations, and query optimization, so you do not need to write SQL or move data manually. Select AI uses AI profiles, roles, and encryption to protect data and ensure compliance across linked databases. Using a fully managed database with Real Application Security (RAS), AI Proxy Database powered by Select AI ensures secure and efficient AI-based data access and analysis.

See:

Topics

  • How Select AI Uses the AI Proxy Database
    You create Database Links or Cloud Links to expose remote tables and views to the AI Proxy Database. These objects appear as mapped schemas inside Autonomous AI Database. Select AI reads the metadata from these mapped objects and builds an augmented prompt.
  • Database Links vs Cloud Links
    The AI Proxy Database uses Database Links and Cloud Links to access external data sources and generate federated SQL through Select AI. Both mechanisms expose metadata to Select AI, but they serve different connectivity and governance needs.
  • Primary Use Case
    Select AI converts natural language prompts into SQL that run across multiple databases.

Parent topic: Select AI Features

How Select AI Uses the AI Proxy Database

You create Database Links or Cloud Links to expose remote tables and views to the AI Proxy Database. These objects appear as mapped schemas inside Autonomous AI Database. Select AI reads the metadata from these mapped objects and builds an augmented prompt.

Select AI sends the augmented prompt to the user-specified LLM, which generates SQL that spans local and remote data sources. The AI Proxy Database runs the federated query, pushes processing to external systems, and completes joins or aggregations as needed. Results return as standard SQL result sets.

From the user’s perspective, the query behaves as if it runs against a single system.

Parent topic: Use Autonomous AI Database as an AI Proxy for Select AI

Database Links vs Cloud Links

The AI Proxy Database uses Database Links and Cloud Links to access external data sources and generate federated SQL through Select AI. Both mechanisms expose metadata to Select AI, but they serve different connectivity and governance needs.

Database Links connect the AI Proxy Database to external databases, Oracle and non-Oracle, using direct network connectivity and credentials. They support heterogeneous environments, including on-premises systems, legacy Oracle databases, and third-party databases such as PostgreSQL, MySQL, SQL Server, Amazon Redshift, Snowflake, and others. With Database Links, Select AI reads table and view metadata from remote schemas and generates federated NL2SQL that runs across distributed systems while data remains in its source database. See CREATE DATABASE LINK for more details.

Cloud Links connect one Autonomous AI Database to another in a controlled and secure way. A data owner chooses which tables or views to share and makes them available to other Autonomous AI Databases. Once shared, other databases can find and use this data without setting up usernames, passwords, wallets, or network connections. The data remains read-only and stays in the source database, while the sharing rules are centrally managed. Cloud Links are designed specifically for sharing data between Autonomous AI Databases in a simple and governed manner. See Use Cloud Links for Read Only Data Access on Autonomous AI Database for more details.

In both cases, Select AI relies on exposed metadata, not physical data movement, to interpret natural language prompts and generate SQL. The AI Proxy Database coordinates query execution, while external systems remain authoritative for their data and enforce their own security controls.

Supported External Data Sources

When used as an AI Proxy Database, Autonomous AI Database can operate on data stored in a wide range of external systems, including but not limited to:

  • Oracle Autonomous AI Database (including previous versions such as 19c)

  • PostgreSQL

  • MySQL

  • SQL Server

  • Azure SQL

  • DB2

  • Teradata

  • Amazon Redshift

  • Snowflake

  • Databricks

  • Salesforce

Support depends on network accessibility and the use of Database Links or Cloud Links. See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for a complete list of supported non-Oracle databases.

Parent topic: Use Autonomous AI Database as an AI Proxy for Select AI

Primary Use Case

Select AI converts natural language prompts into SQL that run across multiple databases.

Federated queries: Your data platform may include on-premises relational databases, Autonomous AI Database, data lakes, legacy systems, or third-party data stores. You can use Select AI to query alongside Autonomous AI Database through Database Links or Cloud Links as a sidecar.

The AI Proxy Database coordinates query running while external systems process their data in place. This keeps data in its original location and avoids replication, synchronization, or ETL.

Key Benefits:

  • Keep data in source systems

  • Avoid ETL, replication, and data movement

  • Query Oracle and non-Oracle databases together

  • Extend generative AI and NL2SQL to legacy and cloud systems

  • Use a single Select AI interface across all data sources

Parent topic: Use Autonomous AI Database as an AI Proxy for Select AI