# postgres-hybrid-text-search

> Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Ra…

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, keyword search, full-text search, reranking, cross-encoder

Covers: pg_textsearch BM25 index setup, parallel query patterns, client-side RRF fusion (Python/TypeScript), weighting strategies, and optional ML reranking.

- Type: Skill
- Made by: timescale
- Category: Databases
- Formats: Skills
- Version: 45013fb
- Source: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search
- Page: https://pluginboard.ai/skills/postgres-hybrid-text-search

## Works with

- ChatGPT
- Claude
- Gemini
- GitHub Copilot
- Cursor
- Claude Code
- Codex
- Antigravity
- Gemini CLI
- Replit
- OpenClaw
- OpenCode
- Hermes Agent

## Install

### ChatGPT

In ChatGPT: Download the postgres-hybrid-text-search folder and zip it, then Plugins → Skills → Create → Upload from your computer. Business and Enterprise plans.

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### Claude

In Claude (web or desktop): Download the postgres-hybrid-text-search folder and zip the folder itself, then upload it in Customize → Skills.

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### Gemini

In Gemini: Download the postgres-hybrid-text-search folder, then at gemini.google.com click Customize → Skills → Create → Upload and pick the folder (or a .zip of it).

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### GitHub Copilot

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.copilot/skills/postgres-hybrid-text-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### Cursor

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.cursor/skills/postgres-hybrid-text-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### Claude Code

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.claude/skills/postgres-hybrid-text-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### Codex

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.agents/skills/postgres-hybrid-text-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### Antigravity

In Antigravity: Copy the postgres-hybrid-text-search folder into ~/.gemini/config/skills (Antigravity app and IDE) or ~/.gemini/antigravity-cli/skills (Antigravity CLI).

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### Gemini CLI

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.gemini/skills/postgres-hybrid-text-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### Replit

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search .agents/skills/postgres-hybrid-text-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### OpenClaw

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.openclaw/skills/postgres-hybrid-text-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### OpenCode

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.config/opencode/skills/postgres-hybrid-text-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

### Hermes Agent

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.hermes/skills/postgres-hybrid-text-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres-hybrid-text-search

---
From Pluginboard (https://pluginboard.ai).