PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
pgtensor	0.0.0	Run inference on ONNX models inside your Postgres database (and a Tensor type)	RAG	MIT	Rust	—	1
pgvector	0.0.0	Custom vector type with Euclidean distance, cosine similarity, and prototype IVFFlat helpers.	RAG	—	Rust	—	1
postgresml	1.0	Exposes tsvector lexemes and position counts for an experimental naive Bayes text-classification demo.	RAG	—	C	—	1
aidb	7	In-database AI pipelines for chunking, embedding, retrieval, and generation.	RAG	Proprietary	—	—
alloydb_scann	—	AlloyDB ScaNN extension for approximate nearest-neighbor vector indexes.	RAG	—	C	14–17
alohadb_nl2sql	1.0	Natural language to SQL translation via LLM API	RAG	MIT	C	—
aws_ml	2.0	Amazon Aurora PostgreSQL extension for invoking Amazon Comprehend, SageMaker AI, and Bedrock services from SQL.	RAG	—	C	14–18
azure_ai	2.0.0	Azure Database for PostgreSQL extension for in-database calls to Azure AI, Azure OpenAI, Cognitive Services, and Azure Machine Learning.	RAG	—	C	12–18
catboost	0.1	machine learning module using CatBoost	RAG	—	C	—
embedding_search	1.1.0	LangChain/Supabase helper package for storing and searching document embeddings with pgvector.	RAG	—	SQL	—
glia	0.0.1	A PostgreSQL extension for data mining.	RAG	AGPL-3.0	C	—
google_ml_integration	1.4.3	Google Cloud machine learning integration extension for registering model endpoints, generating embeddings, and invoking predictions from SQL.	RAG	—	C	12–18
jessevent@ai_sql	1.0.0	AI inference SQL functions for Supabase. Self-deploys its own edge function via ai.deploy().	RAG	—	SQL	—
jessevent@supa_aisql	1.0.0	AI inference SQL functions for Supabase. Self-deploys its own edge function via ai.deploy().	RAG	—	SQL	—
mcp_postgrest	0.1.2	PostgreSQL extension to define AI tools compatible with Anthropic's Model Context Protocol (MCP). Fully customizable, schema-agnostic, secure, and integrated with PostgREST.	RAG	—	SQL	—
ollama	1.0	Ollama client for PostgreSQL	RAG	MIT	SQL	15
pg_ai_sdk	1.0	Translate natural language to SQL using Clickhouse ai-sdk-cpp	RAG	—	C++	—
pg_diskann	0.6.5	Azure Database for PostgreSQL extension for DiskANN approximate-nearest-neighbor vector indexes.	RAG	—	C	14–18
pg_embed	1.0	Generate and store OpenAI embeddings in-place	RAG	—	SQL	—
pg_emd	0.1.0	Fast approximate Earth Mover's Distance using dynamic tree embeddings	RAG	—	Rust	17
pg_gembed	1.0.0	Generate embeddings inside PostgreSQL	RAG	Apache-2.0	C	18
pg_hybrid	1.0	hybrid storage engine: columnar, vector, fulltext	RAG	Apache-2.0	C	—
pg_ivfflat	0.1.0	Experimental pgrx extension providing a Vector type and an in-memory IVFFlat index access method.	RAG	—	Rust	17
pg_kmersearch	1.0	A PostgreSQL extension adding 2 datatypes of 2-bit or 4-bit per 1-mer for nucleotide sequence data and GIN index based on k-mer	RAG	MIT	C	—
pg_llm	1.1	Integrates local and remote large-language models with chat, sessions, text-to-SQL, audit and vector-backed knowledge features.	RAG	PostgreSQL	C++	14–18
pg_llm_bgw	0.1.0	example of Rust implementation of background workder to call LLM from within PostGres client DML SQL	RAG	MIT	Rust	—
pg_sag_rag	0.1.0	Pure-SQL multi-hop event/entity retrieval, query routing, and in-database RAG evaluation.	RAG	Apache-2.0	SQL	14–17
pgchy_similarity	1.0	Chemical structure similarity functions for PostgreSQL using Chython and PL/Python.	RAG	MIT	C	—
pgv	0.0.1	Minimal vector extension	RAG	—	C	—
pgvecutils	0.0.1	This project is a PostgreSQL extension that provides vector manipulation utilities.	RAG	MIT	C	—
postvec	0.2.0	Automatic embeddings, hybrid search, and embedding model migration	RAG	PostgreSQL	Rust	16–18
rds_ai	1.0.0	Alibaba Cloud RDS extension for calling LLMs, generating embeddings, semantic retrieval, and end-to-end RAG from SQL	RAG	—	C	14–18
rds_embedding	1.0	Alibaba Cloud RDS text-to-vector model invocation extension	RAG	—	C	14–17
tencentdb_ai	1.3	TencentDB extension for calling large-model APIs and building in-database RAG workflows.	RAG	—	C	14–18

pgtensor

0.0.0

Run inference on ONNX models inside your Postgres database (and a Tensor type)

—

0.0.0

Custom vector type with Euclidean distance, cosine similarity, and prototype IVFFlat helpers.

—

—

1.0

Exposes tsvector lexemes and position counts for an experimental naive Bayes text-classification demo.

—

—

7

In-database AI pipelines for chunking, embedding, retrieval, and generation.

RAG

Proprietary

—

alloydb_scann

—

AlloyDB ScaNN extension for approximate nearest-neighbor vector indexes.

RAG

—

C

14–17

alohadb_nl2sql

1.0

Natural language to SQL translation via LLM API

—

2.0

Amazon Aurora PostgreSQL extension for invoking Amazon Comprehend, SageMaker AI, and Bedrock services from SQL.

RAG

—

C

14–18

azure_ai

2.0.0

Azure Database for PostgreSQL extension for in-database calls to Azure AI, Azure OpenAI, Cognitive Services, and Azure Machine Learning.

RAG

—

C

12–18

catboost

0.1

machine learning module using CatBoost

RAG

—

C

—

embedding_search

1.1.0

LangChain/Supabase helper package for storing and searching document embeddings with pgvector.

RAG

—

SQL

—

glia

0.0.1

A PostgreSQL extension for data mining.

RAG

AGPL-3.0

C

—

google_ml_integration

1.4.3

Google Cloud machine learning integration extension for registering model endpoints, generating embeddings, and invoking predictions from SQL.

RAG

—

C

12–18

jessevent@ai_sql

1.0.0

AI inference SQL functions for Supabase. Self-deploys its own edge function via ai.deploy().

RAG

—

SQL

—

jessevent@supa_aisql

1.0.0

AI inference SQL functions for Supabase. Self-deploys its own edge function via ai.deploy().

RAG

—

SQL

—

mcp_postgrest

0.1.2

PostgreSQL extension to define AI tools compatible with Anthropic's Model Context Protocol (MCP). Fully customizable, schema-agnostic, secure, and integrated with PostgREST.

RAG

—

SQL

—

ollama

1.0

Ollama client for PostgreSQL

15