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,874 GitHub stars across a repository of 2 listed skills.
github.com/timescale/pg-aiguide/skills/postgres-hybrid-text-search (opens in a new tab)
Data as of from the GitHub API; description from the skill's SKILL.md. Report an error
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
Microsoft Code Reference
MicrosoftDocs/mcp
Find working code samples, verify API signatures, and fix Microsoft SDK errors using official docs.
Maintained · last commit Sep 10, 2026
CodingTypeScriptGrok Delegate
amElnagdy/delegate-skills
Delegate a coding task to the Grok Build CLI as a background implementer, then review its diff and land it yourself.
Maintained · last commit Oct 13, 2026
CodingJavaScriptImporting A Codebase
JetBrains/thinkrail
Use when asked to create the initial spec graph for an existing codebase that has source code but no specs.
Active · last commit Oct 25, 2026
OfficialCodingTypeScriptCodebase Mapping
a5c-ai/babysitter
Automatic codebase indexing for invisible context injection.
Active · last commit Aug 31, 2026
CodingJavaScriptX API
ginlix-ai/LangAlpha
Search X (Twitter) posts, pull user profiles, fetch specific tweets, and read reply threads for sentiment, news, and event research.
Active · last commit Oct 26, 2026
CodingPythonSwift Concurrency
AvdLee/Swift-Concurrency-Agent-Skill
Diagnose Swift Concurrency issues, refactor callback-based code to async/await, and guide Swift 6 migration when working with tasks, actors, @MainActor, Sendable, data races, thread safety, or…
Active · last commit Sep 14, 2026
Coding
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 Oct 22, 2026. Its latest release is v0.6.1. appsgit only lists skills from repositories with a commit in the last six months.