Skills
.Work. You
Rest

build-paths-intermediate

Official

Scaffold an Oracle in-DB agent in hours

Software Engineering#rag#mcp#oracle#onnx#open webui#in-db embeddings#sql agent
Authororacle-devrel
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Build a production-shaped SQL tool-calling agent and in-database embedding workflow on Oracle, without the usual glue-code and integration pitfalls from RAG and chatbot prototypes.

Core Features & Use Cases

  • LLM-to-live-SQL via MCP: Lets Grok-4 choose tools like list_tables, describe_table, describe_schema, run_sql, and vector_search to answer questions grounded in your Oracle schema.
  • In-DB ONNX embeddings: Registers an ONNX MiniLM model in Oracle and uses VECTOR_EMBEDDING inside the database for both ingestion and query-time embedding.
  • Oracle-friendly full stack: Scaffolds a FastAPI adapter and Open WebUI so users can test the agent immediately with a durable chat-history layer.

Quick Start

Tell the AI to scaffold the intermediate path in your current empty directory, and ask it to build an NL2SQL demo with in-DB ONNX embeddings and Grok-4 tool calling over the Oracle schema.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: build-paths-intermediate
Download link: https://github.com/oracle-devrel/oracle-ai-developer-hub/archive/main.zip#build-paths-intermediate

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.