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,885 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
Grok 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 Nov 14, 2026
CodingJavaScriptRust Port
morganlinton/BeautifulRust
Port code from C, C++, Python, Go, JavaScript, or TypeScript into idiomatic Rust that keeps the original behavior: ownership instead of manual memory, Result instead of error codes and exceptions…
Too new to judge · created Oct 23, 2026
CodingPythonCodebase Mapping
a5c-ai/babysitter
Automatic codebase indexing for invisible context injection.
Active · last commit Aug 31, 2026
CodingJavaScriptCode Mv Render
Unclecheng-li/AI_Animation
代码渲染 MV / 数据纪录片的确定性工程库——帧 = f(时间),浏览器预览与离线导出逐帧一致。收录两支开源音乐视频参考工程(world.execute(me); 的 Canvas2D 三画面 + pdoom 的 three.js 逐字卡拉 OK),以及本库自建并已导出的《CVE 编号破十万》90 秒数据纪录片实现:镜头模型、15…
Maintained · last commit Oct 26, 2026
CodingHTMLGolang Naming
samber/cc-skills-golang
Go (Golang) naming conventions — covers packages, constructors, structs, interfaces, constants, enums, errors, booleans, receivers, getters/setters, functional options, acronyms, test functions, and…
Active · last commit Nov 8, 2026
CodingGoSwift 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 Nov 6, 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 Nov 12, 2026. Its latest release is v0.6.1. appsgit only lists skills from repositories with a commit in the last six months.