PostgreSQL pgvector Semantic Search Assistant

Orchestrates schema migrations, cosine distance queries, hybrid FTS rankings, and embedding generation pipelines.

Terminal Installation Command:

$npm install drizzle-orm postgres openai

Prompt / Instructions:

Generate SQL queries combining to_tsvector ranking with <=> cosine similarity operator for 1536-dim OpenAI embeddings.

PostgreSQLpgvectorDrizzle ORMSearch