🎯

postgres-hybrid-text-search

🎯Skill

from timescale/pg-aiguide

What it does

A PostgreSQL skill for implementing hybrid search that combines BM25 keyword search (via pg_textsearch) with semantic vector search (via pgvector), using Reciprocal Rank Fusion (RRF) to merge results into a single ranked list for improved retrieval relevance.

📦

Same repository

timescale/pg-aiguide(10 items)

postgres-hybrid-text-search

Installation

Vibe Index InstallInstalls to .claude/skills/ - auto-recognized by Claude Code

npx vibeindex add timescale/pg-aiguide --skill postgres-hybrid-text-search

skills.sh Install⚠ Installs to .agents/skills/ - may not be auto-recognized by Claude Code

npx skills add timescale/pg-aiguide --skill postgres-hybrid-text-search

Manual InstallCopy SKILL.md content and save to the path below

~/.claude/skills/postgres-hybrid-text-search/SKILL.md

SKILL.md

82Installs

AddedFeb 4, 2026

View on GitHub Back to Skills

More from this repository9

🏪

timescale-pg-aiguide🏪Marketplace

Enhances AI coding tools with intelligent, version-aware PostgreSQL code generation, providing semantic search and best practice recommendations for database schemas and queries.

🎯

pgvector-semantic-search🎯Skill

Enables semantic search in PostgreSQL by storing and efficiently querying vector embeddings using pgvector, supporting RAG, similarity search, and AI-powered content retrieval.

🎯

postgres🎯Skill

Provides AI coding agents with deep, version-aware PostgreSQL expertise through semantic search over the official manual and curated best-practice skills, helping generate dramatically better schemas with more constraints, indexes, and modern PG features.

🎯

design-postgres-tables🎯Skill

Designs PostgreSQL tables with best practices, focusing on normalization, data types, constraints, indexing, and schema optimization strategies.

🎯

setup-timescaledb-hypertables🎯Skill

Configures and optimizes TimescaleDB hypertables for high-performance time-series, IoT, and metrics data storage with automatic partitioning and compression.

🎯

migrate-postgres-tables-to-hypertables🎯Skill

Converts identified PostgreSQL tables to TimescaleDB hypertables with optimal configuration, migration planning, and performance validation.

🎯

find-hypertable-candidates🎯Skill

A hypertable candidate finder skill from pg-aiguide, providing AI-optimized PostgreSQL expertise with semantic search across official docs and Timescale extension guides.

🎯

design-postgis-tables🎯Skill

Skill

🔌

pg🔌Plugin

Plugin