← back to the directory
Library / SDK Retrieval & MemoryAutomation & Integration

pgai

1Brings 2vector 3embeddings 4directly 5into 6Postgres

the six Ws · specification

W1 Who

Application developers who want RAG and semantic search built directly into their PostgreSQL database.

W2 What

A Timescale toolkit that adds automatic embedding generation, a background vectorizer, and LLM function calls directly inside PostgreSQL via SQL.

W3 Where

Installed as a PostgreSQL extension and worker process alongside an existing Postgres database.

W4 When

Use when a team wants RAG or semantic search without standing up a separate vector database or embedding pipeline.

W5 Why

It keeps embeddings automatically in sync with source tables so retrieval logic can live entirely in SQL.

W6 With

Works alongside pgvector for storage and calls out to external embedding and LLM providers.

W7 Watch

Open source under the PostgreSQL license, maintained by Timescale; free to self host or use via Timescale Cloud.

postgresqlembeddings in sqlvectorizerragtimescale

for agents & scripts

Reading this as a machine? Query it directly.

Search is open JSON - no key. Report telemetry after using a tool and it feeds that tool’s Proof Score. Or speak MCP to /mcp and discover tools mid-loop.