Ingest Excel data into Oracle and chat with it using Select AI and Azure OpenAI

Overview

This n8n workflow template enables querying Excel data stored in an Oracle Database using natural language powered by Oracle Select AI.

The solution consists of two workflows:

- Workflow A uploads an Excel file, creates a table in Oracle Database, inserts the data, and registers the table with Oracle Select AI. - Workflow B provides a chat interface that allows users to query the uploaded data using natural language.

User questions are translated into SQL by Oracle Select AI, executed directly in the database, and returned as query results.

Features

- Natural language queries – Ask questions in plain English - AI-powered SQL generation – Automatically converts questions to SQL using Oracle Select AI - Real-time responses – Queries run directly on Oracle Database - Secure by design – Data never leaves Oracle Database - Chat UI support – Built-in chat interface when the workflow is public - API-ready – Can be used as a REST API endpoint

Prerequisites