build-paths - SKILL.md Agent Skill

name: build-paths 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. inputs: - target_dir: optional; passed through to the path-specific skill - topic: optional; passed through

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?

Wait for a number. If the user describes their experience instead of picking a number ("I've built RAG before"), suggest the matching path and ask them to confirm.

Step 2 — Dispatch

Answer	Hand off to
1 / "beginner" / "easy" / "first time with Oracle"	`build-paths/beginner/SKILL.md`
2 / "intermediate" / "RAG" / "MCP" / "tool-calling"	`build-paths/intermediate/SKILL.md`
3 / "advanced" / "agent" / "DB as only store"	`build-paths/advanced/SKILL.md`

Pass through target_dir and topic if the user supplied them.

After handoff, the path skill takes over completely. Don't second-guess it.

Step 3 — One-time prerequisites check (before handoff)

The new (post-restructure) skill set requires:

Docker — verify docker --version works.
Python 3.11+ — verify python --version.
OCI Generative AI API key — OCI_GENAI_API_KEY (a sk-... bearer token, generated in the OCI GenAI service console). All three tiers require this; auth is bearer-token over OpenAI-compatible HTTP, NOT SigV1, so the user does NOT need ~/.oci/config or a compartment OCID. Default endpoint is https://inference.generativeai.us-phoenix-1.oci.oraclecloud.com. If the user has no API key, ask them to generate one and stop.
OCI_GENAI_API_KEY must NEVER be committed — .env is in .gitignore. Confirm before writing any project files that reference it.

These prerequisites apply to every tier. Don't re-ask them inside each path.

Stop conditions

User wants something not on this list ("can I do this in TypeScript?", "I want a Postgres backend", "what about Mongo?"). Print: "v1 of build-paths is Python + Oracle only. See PLAN.md for the rationale and the v2 backlog." Stop.
User can't decide between two paths after 2 nudges. Default to intermediate and tell them so — it's the most representative shape.
User has no OCI Generative AI API key (OCI_GENAI_API_KEY, a sk-... value from the OCI GenAI service console). Stop. Point them at the OCI GenAI console to generate one (no full OCI tenancy needed), or at archive/ for Ollama-flavored older ideas.

What you must NOT do

Don't try to scaffold from this file. Hand off.
Don't load all three path skills "to compare." Read README.md once; pick.
Don't invent a fourth path.
Don't suggest Ollama as a fallback. The post-restructure tiers are OCI-GenAI-only on purpose.