pgvector-search
✓Production hybrid search combining PGVector HNSW with BM25 using Reciprocal Rank Fusion. Use when implementing hybrid search, semantic + keyword retrieval, vector search optimization, metadata filtering, or choosing between HNSW and IVFFlat indexes.
Installation
SKILL.md
| Query | Embedding similarity | Exact word matches | | Strengths | Synonyms, concepts | Exact phrases, rare terms | | Weaknesses | Exact matches, technical terms | No semantic understanding | | Index | HNSW (pgvector) | GIN (tsvector) |
| Query speed | 50ms | 3ms (17x faster) | | Index time | 2 min | 20 min | | Best for | < 100k vectors | 100k+ vectors | | Recall@10 | 0.85-0.95 | 0.95-0.99 |
| index-strategies.md | HNSW vs IVFFlat, tuning, iterative scans | Choosing/optimizing indexes | | hybrid-search-rrf.md | RRF algorithm, SQL implementation, debugging | Implementing hybrid search | | metadata-filtering.md | Pre/post filtering, score boosting | Improving relevance |
Production hybrid search combining PGVector HNSW with BM25 using Reciprocal Rank Fusion. Use when implementing hybrid search, semantic + keyword retrieval, vector search optimization, metadata filtering, or choosing between HNSW and IVFFlat indexes. Source: yonatangross/orchestkit.
Facts (cite-ready)
Stable fields and commands for AI/search citations.
- Install command
npx skills add https://github.com/yonatangross/orchestkit --skill pgvector-search- Source
- yonatangross/orchestkit
- Category
- </>Dev Tools
- Verified
- ✓
- First Seen
- 2026-02-01
- Updated
- 2026-02-18
Quick answers
What is pgvector-search?
Production hybrid search combining PGVector HNSW with BM25 using Reciprocal Rank Fusion. Use when implementing hybrid search, semantic + keyword retrieval, vector search optimization, metadata filtering, or choosing between HNSW and IVFFlat indexes. Source: yonatangross/orchestkit.
How do I install pgvector-search?
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/yonatangross/orchestkit --skill pgvector-search Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code or Cursor
Where is the source repository?
https://github.com/yonatangross/orchestkit
Details
- Category
- </>Dev Tools
- Source
- skills.sh
- First Seen
- 2026-02-01