postgres-semantic-search
Builds and tunes PostgreSQL retrieval with pgvector, full-text search, pg_trgm, hybrid fusion, ParadeDB BM25 and reranking. Use for search/RAG implementation, weak results, filtered ANN scans, non-English corpora or retrieval evaluation. For general schema, RLS and query tuning unrelated to retrieval, use supabase-postgres-best-practices.
Pinned to revision 642453129152, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/postgres-semantic-search/SKILL.md
- skills/postgres-semantic-search/references/evaluation.md
- skills/postgres-semantic-search/references/hybrid-search.md
- skills/postgres-semantic-search/references/keyword-search.md
- skills/postgres-semantic-search/references/pgvector.md
- skills/postgres-semantic-search/references/reranking.md
- skills/postgres-semantic-search/scripts/fuzzy_search.sql
- skills/postgres-semantic-search/scripts/hybrid_search_bm25.sql
- skills/postgres-semantic-search/scripts/hybrid_search_fts.sql
- skills/postgres-semantic-search/scripts/indexes.sql
- skills/postgres-semantic-search/scripts/prefix_tsquery.sql
- skills/postgres-semantic-search/scripts/semantic_search.sql
- skills/postgres-semantic-search/scripts/setup.sql
Every link opens the file at its source, pinned to the revision this page describes.