pgvector-search

Community

Fast, precise hybrid search with PGVector.

Authoryonatangross
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill enables production-grade hybrid search by combining semantic vector retrieval with keyword search (BM25) using Reciprocal Rank Fusion, providing fast and accurate results over large document collections.

Core Features & Use Cases

  • Hybrid semantic + keyword search with RRF to balance recall and precision across 1024-dim embeddings and text indexes.
  • Vector indexing with HNSW for scalable, low-latency retrieval on large corpora.
  • BM25 keyword search via precomputed tsvector and gin indexes for exact phrase matching.
  • Metadata boosting using section titles, document paths, and content types to improve relevance.
  • Use cases: enterprise docs, knowledge bases, API docs, code repositories, and product FAQs.

Quick Start

Run a sample hybrid search by providing a query and obtaining top results from the search endpoint.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: pgvector-search
Download link: https://github.com/yonatangross/create-yg-app/archive/main.zip#pgvector-search

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.