select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

vector · vector data type and ivfflat and hnsw access methods · 0.8.6 · AI and vectors · PostgreSQL · C · Packagedgp_sparse_vector · Sparse vector implementation for Greenplum-family databases. · 1.0.1 · AI and vectors · Apache-2.0 · C · Not packagedembedding · HNSW vector similarity search extension for PostgreSQL real[] embeddings. · 0.3.6 · AI and vectors · Apache-2.0 · C · Not packagedpg_similarity · support similarity queries · 1.0 · AI and vectors · BSD-3-Clause · C · Packagedpg_gist_hamming · support for indexing common datatypes in GiST · 1.0 · AI and vectors · BSD-3-Clause · C · Not packagedvptree · VP-tree implementation · 1.0 · AI and vectors · BSD-3-Clause · C · Not packagednr_model · AI-powered Autonomous Data System · 1.0.0 · AI and vectors · Unknown · C · Not packagedsmlar · Effective similarity search · 1.0 · AI and vectors · Unknown · C · Packagedkmeans · K-means clustering window function for PostgreSQL · 1.1.0 · AI and vectors · PostgreSQL · C · Not packagedtypesafe · SQL client for TypeSafe AI classification and scoring · 0.0.1 · AI and vectors · MIT · C · Not packagedneurondb · AI database extension for vector search, ML inference, hybrid search, and RAG in PostgreSQL. · 4.0.0-devel · AI and vectors · Proprietary · C · Not packagedpase · PostgreSQL ultra-high dimensional approximate nearest neighbor search extension. · 0.0.1 · AI and vectors · Unknown · C · Not packagedpgedge_vectorizer · Asynchronous text chunking and embedding generation for PostgreSQL using background workers and pgvector. · 1.1 · AI and vectors · PostgreSQL · C · Not packagedpgafis · AFIS Support for PostgreSQL · 1.2 · AI and vectors · GPL-2.0 · C · Not packagedpg_ai · PostgreSQL extension that provides (RAG capable)SQL functions to interpret data using multi modal LLMs and vectors. · 0.0.1 · AI and vectors · Apache-2.0 · C · Not packagedpg_turboquant · Compact TurboQuant approximate-nearest-neighbor index access method for pgvector vector and halfvec data. · 0.1.0 · AI and vectors · MIT · C · Not packagedpg4ml · Machine learning framework for PostgreSQL · 2.0 · AI and vectors · AGPL-3.0 · C · Packagedpg_phash · Calculate Hamming distance between decimal-encoded perceptual image hashes · 1.0 · AI and vectors · GPL-3.0 · C · Not packagedllama_embed · llama.cpp embedding extension for dense and multivector search · 0.1.0 · AI and vectors · PostgreSQL · C · Not packagedpg_colbert_llama · ColBERT embedding companion extension for pgturbohybrid · 0.1.0 · AI and vectors · PostgreSQL · C · Not packagedpgturbohybrid · hybrid vector and BM25 search for PostgreSQL on top of pgvector · 0.2.0 · AI and vectors · PostgreSQL · C · Not packagedpgturbohybrid_experimental · experimental sparse and multivector features for pgturbohybrid · 0.2.0 · AI and vectors · PostgreSQL · C · Not packagedmaludb_core · A memory DBMS for long-term institutional memory, human-AI knowledge sharing, and contextual recall. PostgreSQL 17 extension. · 0.104.0 · AI and vectors · Unknown · C · Not packagedpg_semantic_cache · Caches query results and retrieves semantically similar results using pgvector embeddings and configurable eviction policies. · 0.1.0-beta4 · AI and vectors · PostgreSQL · C · Not packagedsveddy · A PostgreSQL extension for collaborative filtering using low-rank matrix approximation techniques. · 0.1.0 · AI and vectors · MIT · C · Not packagedbktree · SP-GiST BK-tree index extension for 64-bit perceptual hashes and Hamming-distance searches. · 1.0 · AI and vectors · Unknown · C · Not packagedhamming_distance · Hamming distance and similarity functions for hexadecimal feature-vector strings. · 0.0.1 · AI and vectors · MIT · C · Not packagedpg_cuvs · ⚡ Blazing-fast GPU vector search for PostgreSQL powered by NVIDIA cuVS. · 0.5.0 · AI and vectors · PostgreSQL · C · Not packagedmtree · Metric-space index access method derived from PostgreSQL GiST · 0.0.1 · AI and vectors · Unknown · C · Not packagedpg_tiktoken_c · Fast tiktoken BPE tokenizer for PostgreSQL implemented in C · 1.1 · AI and vectors · Apache-2.0 · C · Packagedaqua · In-database neural user-defined functions for machine-learning inference. · 0.0.1 · AI and vectors · Unknown · C · Not packagedsparse_vector · C data type and functions for sparse float vectors, normalization, dot product, and cosine similarity. · 0.1 · AI and vectors · MIT · C · Not packagedsvs · SVS Vamana approximate-nearest-neighbor index with LeanVec and LVQ compression for pgvector. · 0.1.0 · AI and vectors · PostgreSQL · C · Not packagedhclust · C function for agglomerative or divisive hierarchical clustering that writes cluster assignments back to a table. · 0.0.1 · AI and vectors · Unknown · C · Not packagedpaves · Filtered L2 vector search with CPU and optional GPU execution · 0.1 · AI and vectors · Unknown · C · Not packagedpg_pageindex · PageIndex document-tree construction and tree search for PDF and Markdown through a C/Go bridge. · 1.0 · AI and vectors · MIT · C · Not packagedpostgresml · Exposes tsvector lexemes and position counts for an experimental naive Bayes text-classification demo. · 1.0 · AI and vectors · Unknown · C · Not packagedalloydb_scann · AlloyDB ScaNN extension for approximate nearest-neighbor vector indexes. · AI and vectors · Unknown · C · Not packagedalohadb_nl2sql · Natural language to SQL translation via LLM API · 1.0 · AI and vectors · MIT · C · Not packagedaws_ml · Amazon Aurora PostgreSQL extension for invoking Amazon Comprehend, SageMaker AI, and Bedrock services from SQL. · 2.0 · AI and vectors · Unknown · C · Not packagedazure_ai · Azure Database for PostgreSQL extension for in-database calls to Azure AI, Azure OpenAI, Cognitive Services, and Azure Machine Learning. · 2.0.0 · AI and vectors · Unknown · C · Not packagedcatboost · machine learning module using CatBoost · 0.1 · AI and vectors · Unknown · C · Not packagedglia · A PostgreSQL extension for data mining. · 0.0.1 · AI and vectors · AGPL-3.0 · C · Not packagedgoogle_ml_integration · Google Cloud machine learning integration extension for registering model endpoints, generating embeddings, and invoking predictions from SQL. · 1.4.3 · AI and vectors · Unknown · C · Not packagedpg_diskann · Azure Database for PostgreSQL extension for DiskANN approximate-nearest-neighbor vector indexes. · 0.6.5 · AI and vectors · Unknown · C · Not packagedpg_gembed · Generate embeddings inside PostgreSQL · 1.0.0 · AI and vectors · Apache-2.0 · C · Not packagedpg_hybrid · hybrid storage engine: columnar, vector, fulltext · 1.0 · AI and vectors · Apache-2.0 · C · Not packagedpg_kmersearch · 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 · 1.0 · AI and vectors · MIT · C · Not packagedpgchy_similarity · Chemical structure similarity functions for PostgreSQL using Chython and PL/Python. · 1.0 · AI and vectors · MIT · C · Not packagedpgv · Minimal vector extension · 0.0.1 · AI and vectors · Unknown · C · Not packagedpgvecutils · This project is a PostgreSQL extension that provides vector manipulation utilities. · 0.0.1 · AI and vectors · MIT · C · Not packagedrds_ai · Alibaba Cloud RDS extension for calling LLMs, generating embeddings, semantic retrieval, and end-to-end RAG from SQL · 1.0.0 · AI and vectors · Unknown · C · Not packagedrds_embedding · Alibaba Cloud RDS text-to-vector model invocation extension · 1.0 · AI and vectors · Unknown · C · Not packagedtencentdb_ai · TencentDB extension for calling large-model APIs and building in-database RAG workflows. · 1.3 · AI and vectors · Unknown · C · Not packaged

54 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
vector 0.8.6 vector data type and ivfflat and hnsw access methods RAG PostgreSQL C 14–18 23k
gp_sparse_vector 1.0.1 Sparse vector implementation for Greenplum-family databases. RAG Apache-2.0 C 1.4k
embedding 0.3.6 HNSW vector similarity search extension for PostgreSQL real[] embeddings. RAG Apache-2.0 C 12–16 579
pg_similarity 1.0 support similarity queries RAG BSD-3-Clause C 14–18 402
pg_gist_hamming 1.0 support for indexing common datatypes in GiST RAG BSD-3-Clause C 185
vptree 1.0 VP-tree implementation RAG BSD-3-Clause C 185
nr_model 1.0.0 AI-powered Autonomous Data System RAG C 148
smlar 1.0 Effective similarity search RAG C 14–18 128
kmeans 1.1.0 K-means clustering window function for PostgreSQL RAG PostgreSQL C 10–18 106
typesafe 0.0.1 SQL client for TypeSafe AI classification and scoring RAG MIT C 16–17 76
neurondb 4.0.0-devel AI database extension for vector search, ML inference, hybrid search, and RAG in PostgreSQL. RAG Proprietary C 16–18 50
pase 0.0.1 PostgreSQL ultra-high dimensional approximate nearest neighbor search extension. RAG C 50
pgedge_vectorizer 1.1 Asynchronous text chunking and embedding generation for PostgreSQL using background workers and pgvector. RAG PostgreSQL C 14–18 36
pgafis 1.2 AFIS Support for PostgreSQL RAG GPL-2.0 C 28
pg_ai 0.0.1 PostgreSQL extension that provides (RAG capable)SQL functions to interpret data using multi modal LLMs and vectors. RAG Apache-2.0 C 25
pg_turboquant 0.1.0 Compact TurboQuant approximate-nearest-neighbor index access method for pgvector vector and halfvec data. RAG MIT C 16–17 14
pg4ml 2.0 Machine learning framework for PostgreSQL RAG AGPL-3.0 C 14–18 13
pg_phash 1.0 Calculate Hamming distance between decimal-encoded perceptual image hashes RAG GPL-3.0 C 10
llama_embed 0.1.0 llama.cpp embedding extension for dense and multivector search RAG PostgreSQL C 9
pg_colbert_llama 0.1.0 ColBERT embedding companion extension for pgturbohybrid RAG PostgreSQL C 9
pgturbohybrid 0.2.0 hybrid vector and BM25 search for PostgreSQL on top of pgvector RAG PostgreSQL C 9
pgturbohybrid_experimental 0.2.0 experimental sparse and multivector features for pgturbohybrid RAG PostgreSQL C 9
maludb_core 0.104.0 A memory DBMS for long-term institutional memory, human-AI knowledge sharing, and contextual recall. PostgreSQL 17 extension. RAG C 8
pg_semantic_cache 0.1.0-beta4 Caches query results and retrieves semantically similar results using pgvector embeddings and configurable eviction policies. RAG PostgreSQL C 14–18 8
sveddy 0.1.0 A PostgreSQL extension for collaborative filtering using low-rank matrix approximation techniques. RAG MIT C 8
bktree 1.0 SP-GiST BK-tree index extension for 64-bit perceptual hashes and Hamming-distance searches. RAG C 15 7
hamming_distance 0.0.1 Hamming distance and similarity functions for hexadecimal feature-vector strings. RAG MIT C 7
pg_cuvs 0.5.0 ⚡ Blazing-fast GPU vector search for PostgreSQL powered by NVIDIA cuVS. RAG PostgreSQL C 7
mtree 0.0.1 Metric-space index access method derived from PostgreSQL GiST RAG C 3
pg_tiktoken_c 1.1 Fast tiktoken BPE tokenizer for PostgreSQL implemented in C RAG Apache-2.0 C 14–18 3
aqua 0.0.1 In-database neural user-defined functions for machine-learning inference. RAG C 2
sparse_vector 0.1 C data type and functions for sparse float vectors, normalization, dot product, and cosine similarity. RAG MIT C 10–18 2
svs 0.1.0 SVS Vamana approximate-nearest-neighbor index with LeanVec and LVQ compression for pgvector. RAG PostgreSQL C 2
hclust 0.0.1 C function for agglomerative or divisive hierarchical clustering that writes cluster assignments back to a table. RAG C 1
paves 0.1 Filtered L2 vector search with CPU and optional GPU execution RAG C 14 1
pg_pageindex 1.0 PageIndex document-tree construction and tree search for PDF and Markdown through a C/Go bridge. RAG MIT C 16 1
postgresml 1.0 Exposes tsvector lexemes and position counts for an experimental naive Bayes text-classification demo. RAG C 1
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
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
pg_diskann 0.6.5 Azure Database for PostgreSQL extension for DiskANN approximate-nearest-neighbor vector indexes. RAG C 14–18
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_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
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