Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). **Trigger when user asks to:** - Combine keyword and semantic search - Implement hybrid search or multi-modal retrieval - Use BM25/pg_textsearch with pgvector together - Implement RRF (Reciprocal Rank Fusion) for search - Build search that handles both exact…
Install
npx skills add timescale/pg-aiguide --skill postgres-hybrid-text-searchnpx skills add timescale/pg-aiguide --skill postgres-hybrid-text-search -a claude-code -gnpx skills add timescale/pg-aiguide --skill postgres-hybrid-text-search -a codex -ggemini skills install https://github.com/timescale/pg-aiguide.git --path skills/postgres-hybrid-text-searchgh skill install timescale/pg-aiguide postgres-hybrid-text-searchgit clone --depth 1 https://github.com/timescale/pg-aiguide /tmp/timescale__pg-aiguide
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/timescale__pg-aiguide/skills/postgres-hybrid-text-search ~/.claude/skills/postgres-hybrid-text-search # Claude Code
cp -R /tmp/timescale__pg-aiguide/skills/postgres-hybrid-text-search ~/.agents/skills/postgres-hybrid-text-search # Codex, Cursor, Gemini CLI, Copilot, OpenCode