Natural language queries on Oracle Database 26ai: Getting started with Select AI on Amazon RDS for Oracle with Amazon Bedrock

This article demonstrates Select AI on Oracle Database 26ai with Amazon RDS, enabling natural language queries powered by Amazon Bedrock foundation models.

• Query relational data using plain English prompts; Oracle generates and executes SQL automatically
• DBMS_CLOUD_AI package constructs prompts with table schemas and sends them to foundation models like Claude Sonnet or Amazon Nova
• Configure VPC interface endpoints to keep data private within your VPC without public internet traversal
• Store IAM credentials in Oracle using DBMS_CLOUD.CREATE_CREDENTIAL for secure authentication
• Create DBMS_CLOUD_AI profiles specifying the AI provider, model, and tables to expose to the LLM
• Generate synthetic test data directly from the LLM into Oracle tables
• Use SELECT AI syntax with actions like runsql, showsql, narrate, and explainsql for various query patterns
• DBMS_CLOUD_AI.GENERATE() enables additional tasks like summarization, translation, and chat without schema context

Select AI removes SQL expertise barriers for business analysts while keeping AI logic inside the trusted Oracle environment with full administrative control over exposed tables and models.