Back to browse
GitHub Repository

Zero-config semantic search for any PostgreSQL database. pip install pgsemantic, three commands, done

48 starsPython

Pgsemantic – Point at your Postgres DB, get vector search instantly

by varmabudharaju·Mar 25, 2026·18 points·1 comment

AI Analysis

●●SolidSolve My ProblemSlick

Automates pgvector sync triggers so you skip boilerplate for existing tables.

Strengths
  • Automatic trigger generation keeps embeddings in sync without requiring manual ETL pipelines.
  • UI wizard scores column quality before you commit to any schema changes.
  • Built-in MCP server exposes your search directly to AI agents like Claude.
Weaknesses
  • Requires the pgvector extension to be installed on your target database server.
  • Trigger overhead could impact your write performance on high-throughput transactional tables significantly.
Target Audience

Backend developers maintaining PostgreSQL databases

Similar To

pgvector · LanceDB · Weaviate

Similar Projects