← All skills

postgres-hybrid-text-search

100 / 100 · Low risk

Fine to try.

By timescale/pg-aiguide (GitHub) · coding · 1,884 stars · scanned at commit c39008a

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 terms and meaning **Keywords:** hybrid search, BM25, pg_textsearch, RRF, reciprocal rank fusion, keyw…

Works with any agent that supports SKILL.md skills.

What this skill can do

We found nothing in the files we read that matches our rules. That does not prove the skill is safe: see the limits of static scanning.

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'postgres-hybrid-text-search' ] || [ -L ~/.agents/skills/'postgres-hybrid-text-search' ]; then echo 'A skill folder named postgres-hybrid-text-search already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/timescale/pg-aiguide' "$d" && git -C "$d" checkout --quiet 'c39008a2773f75d63037e8eecf937456204786ba' -- 'skills/postgres-hybrid-text-search' && mkdir -p ~/.agents/skills && cp -R "$d"/'skills/postgres-hybrid-text-search' ~/.agents/skills/'postgres-hybrid-text-search' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'postgres-hybrid-text-search' ~/.claude/skills/'postgres-hybrid-text-search' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for timescale/pg-aiguide shows the score of its lowest-scoring skill.

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/timescale/pg-aiguide.svg)](https://zalavijaysinh.github.io/skilltrust/repos/timescale/pg-aiguide/)

Score history