Specialized patterns for building production-grade Retrieval-Augmented Generation systems on Oracle Cloud.
Install
mkdir -p .claude/skills/rag-expert && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/11339" && unzip -o skill.zip -d .claude/skills/rag-expert && rm skill.zipInstalls to .claude/skills/rag-expert
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Retrieval-Augmented Generation patterns on Oracle Cloud Infrastructure — embeddings, vector stores, hybrid search, reranking, and production RAG architectureKey capabilities
- →Design OCI RAG pipelines
- →Select embedding models
- →Implement hybrid search
- →Configure reranking strategies
How it works
It applies OCI-specific architectural patterns for vector search, utilizing Oracle AI Database 26ai and Cohere models.
Inputs & outputs
When to use rag-expert
- →Designing OCI-native vector search
- →Optimizing RAG retrieval quality
- →Selecting embedding models
- →Architecting enterprise search
About this skill
RAG Expert for OCI
You are an expert in Retrieval-Augmented Generation patterns on Oracle Cloud Infrastructure.
When to Use
- Building RAG systems on OCI
- Selecting embedding models and vector stores
- Optimizing retrieval quality
- Enterprise RAG architecture
OCI RAG Architecture
┌─────────────────────── Security & Governance ─────────────────────┐
│ │
│ ┌──────────┐ ┌──────────────┐ ┌──────────────────────┐ │
│ │Documents │───▶│ Processing │───▶│ Embedding │ │
│ │ │ │ (Doc Under- │ │ (Cohere Embed 4) │ │
│ └──────────┘ │ standing) │ └───────────┬──────────┘ │
│ └──────────────┘ │ │
│ ┌────────▼────────┐ │
│ │ Vector Store │ │
│ │ (26ai AI Vector │ │
│ │ Search) │ │
│ └────────┬────────┘ │
│ │ │
│ ┌──────────┐ ┌──────────────┐ ┌─────────▼─────────┐ │
│ │ Query │───▶│ Retrieval │───▶│ Reranking │ │
│ │ │ │ + Hybrid │ │ (Rerank 3.5) │ │
│ └──────────┘ └──────────────┘ └─────────┬─────────┘ │
│ │ │
│ ┌──────────────┐ ┌─────────▼─────────┐ │
│ │ Response │◀───│ Generation │ │
│ │ │ │ (Command A) │ │
│ └──────────────┘ └───────────────────┘ │
│ │
└──────────────────── Observability & Evaluation ────────────────────┘
OCI Components for RAG
| Component | OCI Service | Alternatives |
|---|---|---|
| Embeddings | Cohere Embed 4 (multimodal) | Embed Multilingual 3 |
| Vector Store | Oracle AI Database 26ai | OCI Search, OpenSearch |
| LLM | Cohere Command A | Llama 4 Maverick, Gemini 2.5 |
| Document Processing | Document Understanding | Custom parsers |
| Reranking | Cohere Rerank 3.5 | - |
| Orchestration | GenAI Agent Hub | Oracle ADK |
Embedding Models on OCI
| Model | Dimensions | Best For |
|---|---|---|
| Cohere Embed 4 | 1024 | Multimodal (text + images) |
| Cohere Embed Multilingual 3 | 1024 | 100+ languages |
Vector Store Options
Oracle AI Database 26ai (Recommended)
- Native AI Vector Search with Unified Hybrid (vector + keyword)
- Select AI Agent for in-database AI
- Combine with relational, JSON, graph data
- Best for: Existing Oracle customers, enterprise
OCI Search (Managed)
- Fully managed, integrated with GenAI Agents
- Good for: Quick start, managed solution
Retrieval Optimization
1. Hybrid Search (26ai)
SELECT id, title,
(0.7 * (1 - VECTOR_DISTANCE(embedding, :qvec, COSINE))
+ 0.3 * SCORE(1)) AS hybrid_score
FROM documents
WHERE CONTAINS(content, :keyword_query, 1) > 0
ORDER BY hybrid_score DESC
FETCH FIRST 10 ROWS ONLY;
2. Reranking
Always rerank with Cohere Rerank 3.5 for production quality.
3. Chunking Strategy
- Fixed size (512 tokens, 50 overlap) for simple docs
- Semantic chunking for complex documents
- Hierarchical (Document > Section > Paragraph) for enterprise
Quality Metrics
| Metric | Target | How to Measure |
|---|---|---|
| Retrieval Recall | >90% | Ground truth comparison |
| Answer Relevance | >4.5/5 | LLM-as-judge |
| Faithfulness | >95% | Citation verification |
| Latency (P95) | <3s | End-to-end timing |
Before Building Custom RAG
Check OCI AI Blueprints first:
- Llama Stack blueprint includes vLLM + ChromaDB + Postgres + Jaeger
- Repository: https://github.com/oracle-quickstart/oci-ai-blueprints
Cline Activation
To use this skill in Cline, reference it at the start of your message:
@skills/rag-expert/SKILL.md
Design a production RAG system on OCI using Oracle AI Database 26ai for hybrid search, Cohere Embed 4 for embeddings, and Cohere Rerank 3.5. The use case is enterprise contract analysis.
Or in a .clinerules workflow:
## RAG Architecture
When designing RAG systems on OCI, load @skills/rag-expert/SKILL.md. Use the 3-tier diagram standard, always include reranking, prefer Oracle AI Database 26ai for hybrid search, and check AI Blueprints before building custom.
Triggers: RAG, retrieval-augmented generation, vector search OCI, embeddings OCI, hybrid search, Cohere Embed, Rerank 3.5, OCI RAG architecture
When not to use it
- →Simple keyword-only search tasks
Prerequisites
Limitations
- →Requires OCI infrastructure
- →Dependent on Cohere model availability
How it compares
It provides cloud-specific blueprints rather than generic RAG advice, focusing on OCI service integration.
Compared to similar skills
rag-expert side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| rag-expert (this skill) | 0 | 5mo | No flags | Advanced |
| ai-sdk | 11 | 2mo | Review | Advanced |
| embedding-strategies | 8 | 2mo | No flags | Intermediate |
| agentdb-vector-search | 0 | 6mo | Review | Advanced |
Try saying
Example prompts that trigger this skill in your AI assistant.
You might also like
ai-sdk
vercel
Answer questions about the AI SDK and help build AI-powered features. Use when developers: (1) Ask about AI SDK functions like generateText, streamText, ToolLoopAgent, embed, or tools, (2) Want to build AI agents, chatbots, RAG systems, or text generation features, (3) Have questions about AI providers (OpenAI, Anthropic, Google, etc.), streaming, tool calling, structured output, or embeddings, (4) Use React hooks like useChat or useCompletion. Triggers on: "AI SDK", "Vercel AI SDK", "generateText", "streamText", "add AI to my app", "build an agent", "tool calling", "structured output", "useChat".
embedding-strategies
wshobson
Select and optimize embedding models for semantic search and RAG applications. Use when choosing embedding models, implementing chunking strategies, or optimizing embedding quality for specific domains.
agentdb-vector-search
ruvnet
Implement semantic vector search with AgentDB for intelligent document retrieval, similarity matching, and context-aware querying. Use when building RAG systems, semantic search engines, or intelligent knowledge bases.
pinecone
davila7
Managed vector database for production AI applications. Fully managed, auto-scaling, with hybrid search (dense + sparse), metadata filtering, and namespaces. Low latency (<100ms p95). Use for production RAG, recommendation systems, or semantic search at scale. Best for serverless, managed infrastructure.
embeddings
ruvnet
Vector embeddings with HNSW indexing, sql.js persistence, and hyperbolic support. 75x faster with agentic-flow integration. Use when: semantic search, pattern matching, similarity queries, knowledge retrieval. Skip when: exact text matching, simple lookups, no semantic understanding needed.
trulens-dataset-curation
truera
Create and curate evaluation datasets with ground truth for TruLens