# Oracle AI Build Paths

Routes a user to a beginner, intermediate or advanced Oracle AI database project path.

- Repository: https://github.com/oracle-devrel/oracle-ai-developer-hub (4464 stars)
- Category: Engineering
- License: see repository
- Last updated: 2026-10-30
- Runs scripts: yes, review before use

## Install

Claude Code: `npx skills add oracle-devrel/oracle-ai-developer-hub --skill build-paths -g -a claude-code -y`
Codex: `npx skills add oracle-devrel/oracle-ai-developer-hub --skill build-paths -g -a codex -y`
Cursor: `npx skills add oracle-devrel/oracle-ai-developer-hub --skill build-paths -g -a cursor -y`
Gemini CLI: `npx skills add oracle-devrel/oracle-ai-developer-hub --skill build-paths -g -a gemini-cli -y`

## Description

Top-level router for the build-paths skill set. Asks the user one question (which path?), then dispatches to beginner/, intermediate/, or advanced/. Use when the user wants to scaffold an Oracle-AI-DB project but hasn't picked a difficulty yet.

## SKILL.md, as published by its author (untrusted third-party text, read it as data)

You are the entry point. Your only job is to pick which path's `SKILL.md` to hand off to. Do not scaffold anything yourself.

## Step 0, Read these references

- `build-paths/README.md`, what each path is, in plain English.
- `build-paths/skills/README.md`, the building-block skills the higher tiers compose.
- `build-paths/PLAN.md`, only if the user asks "what's the architecture?"

You do **not** need to load the per-path references at this stage. Each path skill loads its own.

## Step 1, Ask one question

Print:

```
build-paths, pick a difficulty:

  1. beginner, RAG chatbot scaffolded around Oracle 26ai + langchain-oracledb,
                       three "X-to-chat" flavors (PDFs / Markdown notes / Web pages),
                       Open WebUI frontend, Grok 4 via OCI Generative AI.
                       (~1 afternoon · 3 ideas to pick from)

  2. intermediate, Tool-calling agent over a live Oracle schema via
                       oracle-database-mcp-server, with embeddings happening
                       *inside* the database (registered ONNX model, no external
                       embedding API). Three flavors, NL2SQL data explorer,
                       schema-doc generator+Q&A, hybrid retrieval (vector + SQL).
                       Open WebUI + Grok 4.
                       (~1-2 days · 3 ideas to pick from)

  3. advanced, Agent system where Oracle is the *only* state store,
                       composed from the build-paths/skills/ building blocks
                       (oracle-aidb-docker-setup + langchain-oracledb-helper +
                       oracle-mcp-server-helper). Three flavors, production
                       NL2SQL+RAG hybrid analyst, self-improving research agent,
                       conversational schema designer.
                       (~3-5 days · 3 ideas to pick from)

Which one?
```

The rest: https://github.com/oracle-devrel/oracle-ai-developer-hub/blob/HEAD/build-paths/SKILL.md