n8n
Use n8n with Oracle AI Database to automate SQL workflows and build retrieval-augmented generation workflows with Oracle AI Vector Search.
n8n provides three Oracle integrations for different workflow roles. Use the Oracle AI Database node for database actions, the Oracle AI Database Vector Store node for document retrieval, and the Oracle AI Database Embeddings node to generate embeddings with an ONNX model in Oracle AI Database.
Supported Features
| n8n node | Use it for | Connection |
|---|---|---|
| Oracle AI Database Vector Store | Insert documents, retrieve documents, connect a vector store to a retriever or AI agent, and search by metadata. | Details · AI cluster root node |
| Oracle AI Database Embeddings | Generate document and query embeddings with an ONNX embedding model loaded in Oracle AI Database. | Details · AI cluster sub-node |
| Oracle AI Database | Execute SQL and perform select, insert, insert-or-update, update, and delete operations. | Details · Regular app node |
Integration Workflow
Build an n8n RAG workflow by connecting the nodes in this order:
- Use a document loader to read source content.
- Connect the Oracle AI Database Embeddings sub-node to the Oracle AI Database Vector Store node.
- Insert documents into an Oracle vector table.
- Connect the vector store to a Vector Store Retriever, Question and Answer Chain, Vector Store Question Answer Tool, or AI Agent.
- Use the Oracle AI Database node for SQL operations that prepare, enrich, or manage workflow data.
The Vector Store node creates the table when you insert documents and the table does not already exist. Your Oracle AI Database instance must support Oracle AI Vector Search for vector-store operations.
Requirements
- An n8n instance with the Oracle nodes available.
- Oracle AI Database 19c or later for the Oracle AI Database node.
- Oracle AI Vector Search support for vector-store operations.
- An Oracle credential configured in n8n.
- An ONNX embedding model loaded in Oracle AI Database when you use the Oracle AI Database Embeddings node.
For advanced Oracle AI Database features such as Transparent Application Continuity and Sharding, the n8n documentation also requires Oracle Client Libraries 19c or later.