Postgres Hybrid Text Search

Postgres Hybrid Text Search is an AI Engineering skill for Claude Code, published by timescale in pg-aiguide.

1.8K stars104 forkson timescale/pg-aiguideAdded 2026/08/18Repository updated 2026/06/26

aiai-agentsai-codingclaude-code-pluginclaude-code-pluginsclaude-code-plugins-marketplaceclaude-marketplaceclaude-pluginclaude-skillsdocsdocumentationmcpmcp-serverpostgrespostgresqlskills

Install in seconds

Install Postgres Hybrid Text Search

Copy Postgres Hybrid Text Search into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.

terminal

npx degit https://github.com/timescale/pg-aiguide/tree/main/skills/postgres-hybrid-text-search ~/.claude/skills/postgres-hybrid-text-search

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/timescale/pg-aiguide.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file: skills/postgres-hybrid-text-search/SKILL.md in timescale/pg-aiguide
Installs to: ~/.claude/skills/postgres-hybrid-text-search
Collection: One of 10 skills cataloged from this repository
Category: AI Engineering — 2451 skills

What Postgres Hybrid Text Search does

Postgres Hybrid Text Search combines BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). Use it when building search that handles both exact terms and meaning, such as product names mixed with conceptual queries.

Postgres Hybrid Text Search is cataloged under AI Engineering on DirSkills. Postgres Hybrid Text Search comes from a repository tagged ai, ai-agents, ai-coding, claude-code-plugin and claude-code-plugins.

Documentation

README

Excerpt

Hybrid Text Search

Hybrid search combines keyword search (BM25) with semantic search (vector embeddings) to get the best of both: exact keyword matching and meaning-based retrieval. Use Reciprocal Rank Fusion (RRF) to merge results from both methods into a single ranked list.

This guide covers combining pg_textsearch (BM25) with pgvector. Requires both extensions. For high-volume setups, filtering, or advanced pgvector tuning (binary quantization, HNSW parameters), see the pgvector-semantic-search skill.

This is the opening of the README. Read the full README on GitHub.

Frequently asked about Postgres Hybrid Text Search

What else does timescale publish alongside Postgres Hybrid Text Search?
Postgres Hybrid Text Search is one of 10 skills that DirSkills catalogs from timescale/pg-aiguide, the repository it ships in. Its siblings there include Find Hypertable Candidates, Ghost Database and PGVector Semantic Search. Each one is a separate skill with its own page in this directory, installs the same way Postgres Hybrid Text Search does, and is maintained by timescale in that same repository. The rest of the collection is listed on the timescale/pg-aiguide page.
How does Postgres Hybrid Text Search compare to other AI Engineering skills?
Postgres Hybrid Text Search ranks #921 by stars among the 2451 AI Engineering skills in this catalog. The most-starred ones next to it are Architecture Decision Records, AI-First Engineering and Agentic OS. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of Postgres Hybrid Text Search against them. Open each page to compare what they document and how they install.