RAG Accuracy Optimizer A skill for optimizing end-to-end accuracy in RAG systems. Workflow Overview Each step impacts accuracy. Optimize each step in order. --- 1. Structured Data Design SQL vs Vector DB — When to Use What? | Criteria | SQL (PostgreSQL, MySQL) | Vector DB (Pinecone, Qdrant, Weaviate) | |---|---|---| | Exact facts (price, date, product code) | ✅ Optimal | ❌ Not suitable | | Semantic search (query meaning) | ❌ Not supported | ✅ Optimal | | Aggregation (SUM, COUNT, AVG) | ✅ Native | ❌ Not supported | | Fuzzy matching ("similar to...") | ⚠️ Limited | ✅ Optimal | | Hybrid (recomme…