AI Solution

Building Database Chatbots with SQL Dialog Skills


Contemporary bot architectures feature a limited set of intents that dictate responses. However, recent advances in retrieval-augmented generation (RAG) capabilities can empower AI systems to provide natural language responses to unanticipated queries.

This solution categorizes diverse chatbot types and builds chatbots driven by AI and machine learning (ML) that are adept at processing natural language and interfacing with Oracle Autonomous Database. With the integration of Oracle Digital Assistant, these chatbots can comprehend user queries, translate them into SQL statements, and execute database inquiries. Such advancements hold transformative potential, enabling seamless interaction across web, mobile, and Oracle APEX application interfaces.


Demo: Building Database Chatbots with SQL Dialog Skills (1:48)

Prerequisites and setup

  1. Oracle Cloud account—sign-up page
  2. Oracle Digital Assistant—documentation
  3. Oracle APEX—documentation
  4. Oracle Autonomous Database—documentation


  1. Oracle专指Oracle境外公司而非甲骨文中国。
  2. 相关Cloud或云术语均指代Oracle境外公司提供的云技术或其解决方案。