Postgres Hybrid Text Search
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.
github.com/timescale/pg-aiguide/skills/postgres-hybrid-text-search (opens in a new tab)
- Multi-skill repo
- Plugin marketplace
- Needs API key
- Coding
- Actively maintained
Add this skill
Claude
This repository is a Claude Code plugin marketplace. In Claude Code:
/plugin marketplace add timescale/pg-aiguide
/plugin install pg@aiguideIn the Claude apps, zip the postgres-hybrid-text-search folder and upload it under Customize > Skills > + > Upload a skill (code execution must be on).
ChatGPT / Codex
Codex reads skills from .agents/skills/ in a repo or ~/.agents/skills/ for every project:
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 projectsStandalone skills also load in the ChatGPT desktop app.
Cursor
Cursor loads skills from .cursor/skills/ (or ~/.cursor/skills/) and also reads .claude/skills/:
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 projectsSource (checked Oct 7, 2026): code.claude.com/docs/en/skills (opens in a new tab), code.claude.com/docs/en/plugin-marketplaces (opens in a new tab), support.claude.com/en/articles/12512180-using-skills-in-claude (opens in a new tab), learn.chatgpt.com/docs/build-skills (opens in a new tab), cursor.com/docs/context/skills (opens in a new tab)
What this skill does
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,…
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
More skills in timescale/pg-aiguide
2 skills are listed from this repository.
Similar skills
More coding skills
Requesting Code Review
obra/superpowers
Use when completing tasks, implementing major features, or before merging to verify work meets requirements.
CodingShellReceiving Code Review
obra/superpowers
Use when receiving code review feedback, before implementing suggestions, especially if feedback seems unclear or technically questionable - requires technical rigor and verification, not…
CodingShellImprove Codebase Architecture
mattpocock/skills
Scan a codebase for deepening opportunities, present them as a visual HTML report, then grill through whichever one you pick.
CodingShellSetup Matt Pocock Skills
mattpocock/skills
Configure this repo for the engineering skills: set up its issue tracker, triage label vocabulary, and domain doc layout.
CodingShellCode Review
mattpocock/skills
Review the changes since a fixed point (commit, branch, tag, or merge-base) along two axes: Standards (does the code follow this repo's documented coding standards?) and Spec (does the code match…
CodingShellSetup Ts Deep Modules
mattpocock/skills
Wire dependency-cruiser into a TypeScript repo so each package is a deep module, with implementation hidden in subfolders and reachable only through its entry-point files.
CodingShell
What is the Postgres Hybrid Text Search 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. Its SKILL.md lives at github.com/timescale/pg-aiguide/skills/postgres-hybrid-text-search.
How do I install the Postgres Hybrid Text Search skill?
In Claude Code, run /plugin marketplace add timescale/pg-aiguide and then /plugin install pg@aiguide. For Codex or Cursor, copy the postgres-hybrid-text-search folder into .agents/skills/ or .cursor/skills/.
Is the Postgres Hybrid Text Search skill free?
Yes. The repository is open source under the Apache-2.0 license. The skill mentions an API key or token for an external service, which may need its own account.
Is Postgres Hybrid Text Search maintained?
The repository's most recent commit was on Sep 25, 2026. Its latest release is v0.6.1. appsgit only lists skills from repositories with a commit in the last six months.