--- title: Natural language queries on Oracle Database 26ai:... description: Oracle Database 26ai is now available on Amazon RDS, and this guide walks through setting up Select AI — a feature that lets users query relational data using... canonical: https://daily.dev/posts/natural-language-queries-on-oracle-database-26ai-getting-started-with-select-ai-on-amazon-rds-for-o-fg4chzhty twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Natural language queries on Oracle Database 26ai: Getting started with Select AI on Amazon RDS for Oracle with Amazon Bedrock | daily.dev og:description: Oracle Database 26ai is now available on Amazon RDS, and this guide walks through setting up Select AI — a feature that lets users query relational data using... og:url: https://daily.dev/posts/natural-language-queries-on-oracle-database-26ai-getting-started-with-select-ai-on-amazon-rds-for-o-fg4chzhty og:image: https://api.daily.dev/og/posts/FG4chzHTY.png og:image:alt: Natural language queries on Oracle Database 26ai: Getting started with Select AI on Amazon RDS for Oracle with Amazon Bedrock og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Natural language queries on Oracle Database 26ai: Getting started with Select AI on Amazon RDS for Oracle with Amazon Bedrock **[AWS Database Blog](https://daily.dev/sources/aws-database-blog)** · 16 min read · 0 upvotes · 0 comments ## Summary Oracle Database 26ai is now available on Amazon RDS, and this guide walks through setting up Select AI — a feature that lets users query relational data using plain English powered by Amazon Bedrock foundation models. The tutorial covers creating a VPC interface endpoint for private Bedrock access, storing IAM credentials in Oracle via DBMS_CLOUD.CREATE_CREDENTIAL, configuring DBMS_CLOUD_AI profiles pointing to models like Claude Sonnet 4.6 or Amazon Nova, generating synthetic test data, and running natural language queries using SELECT AI syntax. Key actions include showsql (preview generated SQL), runsql (execute and return results), narrate (plain-English summary), and explainsql (explain existing SQL). A troubleshooting table covers common ORA errors with root causes and fixes. This is Part 1 of a three-part series; Parts 2 and 3 cover RAG with Oracle AI Vector Search and GraphRAG with SQL property graphs respectively. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How do I use Select AI on Amazon RDS for Oracle to query data with natural language? Select AI on Amazon RDS for Oracle 26ai works by configuring a DBMS_CLOUD_AI profile that specifies an Amazon Bedrock model, IAM credentials, and the tables to expose. You then use SELECT AI syntax in SQL. Oracle builds a prompt from your question and table schemas, calls the Bedrock model over a VPC interface endpoint, and returns results. Actions include runsql, showsql, narrate, and explainsql. _Developers integrating NL2SQL into Oracle workflows track new DBMS_CLOUD_AI patterns and model updates on daily.dev._ ### Why do I get ORA-20400 HTTP 400 when calling Amazon Bedrock from Oracle DBMS_CLOUD_AI? ORA-20400 HTTP 400 from DBMS_CLOUD_AI typically means the model ID is in single-region or on-demand format. Anthropic Claude and Amazon Nova Pro model IDs require the us. cross-region inference prefix (e.g., us.anthropic.claude-sonnet-4-6). Using the base model ID without this prefix causes the 400 error. Add the us. prefix to the model ID in your DBMS_CLOUD_AI profile to fix it. _Teams running Oracle on AWS catch breaking changes like model ID format requirements faster when following databases topics on daily.dev._ ### Do I need to enable Private DNS names on a VPC interface endpoint for Amazon Bedrock to work with Oracle RDS? Yes, enabling Private DNS names on the bedrock-runtime VPC interface endpoint is critical. Without it, Oracle resolves bedrock-runtime..amazonaws.com to a public IP instead of a private one, routing traffic outside the VPC. With Private DNS enabled, all Bedrock API calls from the private RDS subnet stay within the VPC and never traverse the public internet. _Engineers keeping Oracle RDS deployments private and compliant find AWS networking guidance like this on daily.dev._ ## Similar posts on daily.dev - [How to use AI to get answers from your database without writing SQL](https://daily.dev/posts/how-to-use-ai-to-get-answers-from-your-database-without-writing-sql-dpqzxmx6y) · All Things Open · 0 upvotes · 0 comments - [Building agentic AI patterns with Amazon Bedrock and SQL Server 2025 on Amazon RDS](https://daily.dev/posts/building-agentic-ai-patterns-with-amazon-bedrock-and-sql-server-2025-on-amazon-rds-gu2migzkd) · AWS Database Blog · 1 upvotes · 0 comments - [How to Build an AI-Powered RAG Chatbot with Amazon Lex, Bedrock, and S3](https://daily.dev/posts/how-to-build-an-ai-powered-rag-chatbot-with-amazon-lex-bedrock-and-s3-fkn6ujlnm) · freeCodeCamp · 3 upvotes · 0 comments --- Tags: [#aws](https://daily.dev/tags/aws), [#genai](https://daily.dev/tags/genai), [#oracle](https://daily.dev/tags/oracle), [#amazon-bedrock](https://daily.dev/tags/amazon-bedrock) [View this post on daily.dev](https://daily.dev/posts/natural-language-queries-on-oracle-database-26ai-getting-started-with-select-ai-on-amazon-rds-for-o-fg4chzhty) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Natural language queries on Oracle Database 26ai: Getting started with Select AI on Amazon RDS for Oracle with Amazon Bedrock","url":"https://daily.dev/posts/natural-language-queries-on-oracle-database-26ai-getting-started-with-select-ai-on-amazon-rds-for-o-fg4chzhty","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/natural-language-queries-on-oracle-database-26ai-getting-started-with-select-ai-on-amazon-rds-for-o-fg4chzhty"},"datePublished":"2026-08-11T16:27:52.708Z","dateModified":"2026-08-11T16:28:24.884Z","description":"Oracle Database 26ai is now available on Amazon RDS, and this guide walks through setting up Select AI — a feature that lets users query relational data using...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/baf5b374c99a14672841137ca34c6faf?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/baf5b374c99a14672841137ca34c6faf?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"AWS Database Blog","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"AWS Database Blog","logo":"https://media.daily.dev/image/upload/s--En-avd2a--/f_auto,q_auto/v1780213446/logos/aws-database-blog?_a=BAMAMiWQ0","url":"https://daily.dev/sources/aws-database-blog"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/natural-language-queries-on-oracle-database-26ai-getting-started-with-select-ai-on-amazon-rds-for-o-fg4chzhty","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"aws,genai,oracle,amazon-bedrock","timeRequired":"PT16M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"AWS Database Blog","item":"https://daily.dev/sources/aws-database-blog"},{"@type":"ListItem","position":3,"name":"Natural language queries on Oracle Database 26ai: Getting started with Select AI on Amazon RDS for Oracle with Amazon Bedrock"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/natural-language-queries-on-oracle-database-26ai-getting-started-with-select-ai-on-amazon-rds-for-o-fg4chzhty#faq","mainEntity":[{"@type":"Question","name":"How do I use Select AI on Amazon RDS for Oracle to query data with natural language?","acceptedAnswer":{"@type":"Answer","text":"Select AI on Amazon RDS for Oracle 26ai works by configuring a DBMS_CLOUD_AI profile that specifies an Amazon Bedrock model, IAM credentials, and the tables to expose. You then use SELECT AI syntax in SQL. Oracle builds a prompt from your question and table schemas, calls the Bedrock model over a VPC interface endpoint, and returns results. Actions include runsql, showsql, narrate, and explainsql. Developers integrating NL2SQL into Oracle workflows track new DBMS_CLOUD_AI patterns and model updates on daily.dev."}},{"@type":"Question","name":"Why do I get ORA-20400 HTTP 400 when calling Amazon Bedrock from Oracle DBMS_CLOUD_AI?","acceptedAnswer":{"@type":"Answer","text":"ORA-20400 HTTP 400 from DBMS_CLOUD_AI typically means the model ID is in single-region or on-demand format. Anthropic Claude and Amazon Nova Pro model IDs require the us. cross-region inference prefix (e.g., us.anthropic.claude-sonnet-4-6). Using the base model ID without this prefix causes the 400 error. Add the us. prefix to the model ID in your DBMS_CLOUD_AI profile to fix it. Teams running Oracle on AWS catch breaking changes like model ID format requirements faster when following databases topics on daily.dev."}},{"@type":"Question","name":"Do I need to enable Private DNS names on a VPC interface endpoint for Amazon Bedrock to work with Oracle RDS?","acceptedAnswer":{"@type":"Answer","text":"Yes, enabling Private DNS names on the bedrock-runtime VPC interface endpoint is critical. Without it, Oracle resolves bedrock-runtime..amazonaws.com to a public IP instead of a private one, routing traffic outside the VPC. With Private DNS enabled, all Bedrock API calls from the private RDS subnet stay within the VPC and never traverse the public internet. Engineers keeping Oracle RDS deployments private and compliant find AWS networking guidance like this on daily.dev."}}]} ```