Postgres Semantic Search

Quality score: 80/100 · Category: Engineering · Sub-category: databases

PostgreSQL-based semantic and hybrid search with pgvector and ParadeDB. Use when implementing vector search, semantic search, hybrid search, or full-text search in PostgreSQL. Covers pgvector setup, indexing (HNSW, IVFFlat), hybrid search (FTS + BM25 + RRF), ParadeDB as Elasticsearch alternative, and re-ranking with Cohere/cross-encoders. Supports vector(1536) and halfvec(3072) types for OpenAI embeddings.

What this skill does

Postgres Semantic Search is a well-rated Claude Code skill (quality score 80/100) in the databases sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/postgres-semantic-search/ and loads when your prompt matches the skill's trigger.

When to invoke it: Use when implementing vector search, semantic search, hybrid search, or full-text search in PostgreSQL. Covers pgvector setup, indexing (HNSW, IVFFlat), hybrid search (FTS + BM25 + RRF), ParadeDB as Elasticsearch alternative, and re-ranking with Cohere/cross-encoders.

Who uses this skill

The Postgres Semantic Search skill is built for software engineers, backend developers, full-stack teams, and technical leads building and maintaining production systems. It is part of the open ClaudSkills registry, a community-curated catalog of 15,000+ capabilities you can install for Claude Code — the Claude CLI agent.

How to install

Free

Manual install (2 steps)

mkdir -p ~/.claude/skills/postgres-semantic-search
curl -L https://claudskills.com/skills/postgres-semantic-search/SKILL.md \
  -o ~/.claude/skills/postgres-semantic-search/SKILL.md

Or just download SKILL.md directly and drop it into ~/.claude/skills/postgres-semantic-search/. Claude Code auto-discovers it on next session.

Skills live at ~/.claude/skills/postgres-semantic-search/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\postgres-semantic-search\SKILL.md on Windows. See the full install guide for step-by-step instructions.

Pro

One-click install via the desktop app

The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.

More Engineering skills

Browse all Engineering skills in the ClaudSkills registry, or explore these top-rated picks from the same category:

Browse all Engineering skills → Top 100 skills

Part of ClaudSkills — the open registry for Claude Code skills. · What's New · Install guide · About · llms.txt

Part of Acreator Store — Adam Lankamer's AI tools: GifPerfect · AspectPerfect · SlomoPerfect · Ucaption · UTagger · AutoXPoster · TestYourSkills