Use an AI Proxy Database for Select AI NL2SQL

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.

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.

Autonomous AI Database supports accessing data in other Autonomous AI Database through External Tables over Table Hyperlinks and Federated Tables. Both methods provide secure, read-only access across regions without data replication, but they differ in setup and control.

External Tables over Table Hyperlinks use a URL (Table Hyperlink) generated in the provider (source) Autonomous AI Database with DBMS_DATA_ACCESS.CREATE_URL. The consumer (target) Autonomous AI Database then creates an external table referencing this hyperlink using DBMS_CLOUD.CREATE_EXTERNAL_TABLE. This approach offers fine-grained control, letting you expose individual tables or views and manage hyperlink lifetimes directly. It’s best suited for ad-hoc or selective data sharing where administrators prefer explicit control over which objects are accessible. See Use Table Hyperlinks to Create an External Table for more details.

Federated Tables, provide an automated way to access remote Autonomous AI Database data. A federated table is created in the consumer database using DBMS_DATA_ACCESS.CREATE_FEDERATED_TABLE, which automatically manages hyperlink creation and metadata mapping behind the scenes. This method simplifies setup and is ideal for long-term, multi-object, or cross-region federation. Federated Tables integrate tightly with Autonomous AI Database governance using registered creation scopes and DBMS_DATA_ACCESS_ADMIN grants, and are designed for production-level, managed access across compartments or tenancies. See Create Federated Tables using Table Hyperlinks by Defining Scope for more details.

In summary, use External Tables over Table Hyperlinks when you need precise, short-term control over shared objects, and Federated Tables when you want a streamlined, scalable, and fully managed cross-database integration for Select AI. 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.

The primary use case for an AI proxy database with Select AI is for natural language to SQL generation using local metadata that results in federated queries.

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: