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.zip

Installs 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 architecture
157 charsno explicit “when” trigger
Advanced

Key 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

You give it
RAG architecture requirements
You get back
OCI-native RAG design pattern

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

ComponentOCI ServiceAlternatives
EmbeddingsCohere Embed 4 (multimodal)Embed Multilingual 3
Vector StoreOracle AI Database 26aiOCI Search, OpenSearch
LLMCohere Command ALlama 4 Maverick, Gemini 2.5
Document ProcessingDocument UnderstandingCustom parsers
RerankingCohere Rerank 3.5-
OrchestrationGenAI Agent HubOracle ADK

Embedding Models on OCI

ModelDimensionsBest For
Cohere Embed 41024Multimodal (text + images)
Cohere Embed Multilingual 31024100+ 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

MetricTargetHow to Measure
Retrieval Recall>90%Ground truth comparison
Answer Relevance>4.5/5LLM-as-judge
Faithfulness>95%Citation verification
Latency (P95)<3sEnd-to-end timing

Before Building Custom RAG

Check OCI AI Blueprints first:


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

Cohere API access

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.

SkillInstallsUpdatedSafetyDifficulty
rag-expert (this skill)05moNo flagsAdvanced
ai-sdk112moReviewAdvanced
embedding-strategies82moNo flagsIntermediate
agentdb-vector-search06moReviewAdvanced

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".

1150

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.

890

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.

07

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.

34

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.

02

trulens-dataset-curation

truera

Create and curate evaluation datasets with ground truth for TruLens

10

Search skills

Search the agent skills registry