# Postgres Hybrid Text Search (agent skill)

> Postgres Hybrid Text Search is an agent skill (a SKILL.md file) from timescale/pg-aiguide. It is used to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). It works with Claude Code, Codex, Cursor, Gemini CLI and OpenCode and has 1,857 GitHub stars across a repository of 2 listed skills.

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/pgtextsearch with pgvector together - Implement RRF (Reciprocal Rank Fusion) for search - Build search that handles both exact terms and meaning Keywords:* hybrid search, BM25, pgtextsearch, RRF, reciprocal rank fusion, keyword search,…

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/timescale/pg-aiguide |
| Skill path | skills/postgres-hybrid-text-search/SKILL.md |
| Skill name | postgres-hybrid-text-search |
| GitHub stars | 1,857 |
| Installs on skills.sh | not listed |
| License | Apache-2.0 |
| Skills in repo | 2 |
| Plugin marketplace | aiguide |
| Official | no |
| Works with | Claude Code, Codex, Cursor, Gemini CLI, OpenCode |
| Category | Coding |
| Last commit | Sep 25, 2026 |

## When it triggers

- Trigger when user asks to: - Combine keyword and semantic search - Implement hybrid search or multi-modal retrieval - Use BM25/pgtextsearch with pgvector together - Implement RRF (Reciprocal Rank Fusion) for search - Build search that handl

## Add this skill

### Claude Code

```sh
/plugin marketplace add timescale/pg-aiguide
/plugin install pg@aiguide
```

In the Claude apps, zip the skill folder and upload it under Customize > Skills > + > Upload a skill (code execution must be on).

### ChatGPT / Codex

```sh
git clone --depth 1 https://github.com/timescale/pg-aiguide.git
cp -r pg-aiguide/skills/postgres-hybrid-text-search .agents/skills/postgres-hybrid-text-search   # repo; ~/.agents/skills for all projects
```

### Cursor

```sh
git clone --depth 1 https://github.com/timescale/pg-aiguide.git
cp -r pg-aiguide/skills/postgres-hybrid-text-search .cursor/skills/postgres-hybrid-text-search   # project; ~/.cursor/skills for all projects
```

Sources (checked 2026-10-07): https://code.claude.com/docs/en/skills, https://support.claude.com/en/articles/12512180-using-skills-in-claude, https://learn.chatgpt.com/docs/build-skills, https://cursor.com/docs/context/skills

---

Canonical page: https://appsgit.com/skills/timescale-postgres-hybrid-text-search
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.