PostgreSQL Extension Catalogue

1476 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version	Stars
libx509pq	1.3	X.509 certificate parsing library for PostgreSQL	SEC	GPL-3.0	C	12–18	54
dsef	2024.4.9	DiffStats and ExplainFull: detailed SQL reports for third party help & support	STAT	PostgreSQL	SQL	—	52
pg_check	0.1.0	Provides basic integrity checks for data files.	ADMIN	BSD-3-Clause	C	10–18	52
pg_tiktoken	0.0.1	tiktoken tokenizer for use with OpenAI models in postgres	RAG	Apache-2.0	Rust	14–18	52
url_encode	1.2.5	url_encode, url_decode functions	UTIL	PostgreSQL	C	14–18	52
pg_idx_advisor	0.1.2	PostgreSQL index advisor	FEAT	PostgreSQL	C	10–18	51
pg_stat_plans	2.1.0	Track per-plan call counts, execution times, and example EXPLAIN texts.	STAT	PostgreSQL	C	16–18	51
sphinx	0.3	C connector for querying and updating an external SphinxSearch server from PostgreSQL.	FTS	MIT	C	—	51
badapple	1.0.0	Play "Bad Apple!!" in the psql client.	FEAT	—	C	—	50
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
pg_kalam	0.5.5-rc.1	KalamDB PostgreSQL extension and FDW callback layer for SQL access to KalamDB.	FDW	Apache-2.0	Rust	13–18	50
prometheus_fdw	0.2.1	A Rust/pgrx foreign data wrapper that queries Prometheus metrics through PostgreSQL foreign tables.	FDW	PostgreSQL	Rust	14–17	50
temporal	0.7.1	C extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support.	TIME	PostgreSQL	C	—	50
git_fdw	1.1.0	PostgreSQL Git Foreign Data Wrapper	FDW	MIT	C	10–18	49
plsci	1.0	PostgreSQL procedural language handler for Clojure via SCI	LANG	EPL-1.0	Rust	—	49
coldfront	1.0	Transparent hot and cold tiering between PostgreSQL partitions and writable Apache Iceberg tables	OLAP	PostgreSQL	C	16–18	48
lolor	1.2.2	Logical-replication-friendly replacement for PostgreSQL large objects	ETL	PostgreSQL	C	15–18	48
ch_fdw	1.0	Foreign data wrapper for federated access from PostgreSQL to ClickHouse.	FDW	MIT	C	13	47
pg-audit-json	1.0.2	Trigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs.	SEC	PostgreSQL	SQL	10–18	47
pghydro	6.6	Drainage network analysis core for PostgreSQL and PostGIS	GIS	GPL-2.0	SQL	14–18	47
emailaddr	0	Email address type for PostgreSQL	TYPE	—	C	14–18	46
pg_when	0.1.10	Natural language time parsing for PostgreSQL	TIME	MIT	Rust	13–18	46
pre_prepare	0.9	Pre Prepare your Statement server side	ADMIN	PostgreSQL	C	14–18	46
scan	1.0	Visual Studio Code - Development Container - PostgreSQL	FEAT	Apache-2.0	C	—	45
pg_ferroid	2.0.0	PostgreSQL ULID type and generation functions backed by ferroid	TYPE	MIT	Rust	13–18	44
pgclone	4.4.2	Clone PostgreSQL databases, schemas, tables, and functions across environments	ETL	PostgreSQL	C	14–18	44
firebird_fdw	1.4.2	Foreign data wrapper for Firebird	FDW	PostgreSQL	C	14–18	43
pg_dbms_job	2.0	Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL	SIM	PostgreSQL	C	14–18	43
zstd	1.1.2	Zstandard compression algorithm implementation in PostgreSQL	UTIL	ISC	C	14–18	43
pgpu	2.1.0	GPU acceleration for PostgreSQL vector index builds using NVIDIA CUDA/cuVS and VectorChord.	RAG	AGPL-3.0	Rust	14–18	42
external_file	1.2	Access external server-side files through PostgreSQL functions	UTIL	PostgreSQL	SQL	14–18	41
monetdb_fdw	0.0	MonetDB foreign data wrapper	FDW	PostgreSQL	C	—	41
pg_cjk_parser	0.1.0	CJK bigram parser derived from PostgreSQL full-text search	FTS	PostgreSQL	C	14–18	41
pg_scws	1.0	a parser for full-text search of Chinese	FTS	BSD-3-Clause	C	—	41
thai_parser	1.0.0	Thai-language parser and text search configuration for PostgreSQL full-text search.	FTS	—	C	10–18	41
jalali_utils	0.0.1	Convert Gregorian dates and timestamps to Jalali calendar values.	TIME	—	C	12–18	40
pg_roast	1.0	Opinionated PostgreSQL database auditor	SEC	PostgreSQL	C	14–18	40
yezzey	1.8.11	Offload Greenplum and Cloudberry append-only tables to S3	OLAP	PostgreSQL	C++	—	40
bigtable	0.1.0	Rust PostgreSQL FDW for Google Bigtable	FDW	MIT	Rust	10–18	39
kt_fdw	0.0.1	Foreign data wrapper for reading and writing Kyoto Tycoon key-value stores.	FDW	MIT	C	—	39
mysqlcompat	0.0.7	MySQL compatibility functions, aggregates, operators, and casts for PostgreSQL porting.	SIM	—	SQL	—	39
permuteseq	1.2.2	Pseudo-randomly permute sequences with a format-preserving encryption on elements	FUNC	PostgreSQL	C	14–18	39
pg_cheat_funcs	1.0	Provides cheat (but useful) functions	ADMIN	PostgreSQL	C	14–18	39
clerk_fdw	0.3.3	Foreign data wrapper for querying the Clerk user-management API from PostgreSQL.	FDW	PostgreSQL	Rust	14–17	37
dynamodb_fdw	1.1	Foreign data wrapper for querying and modifying Amazon DynamoDB tables from PostgreSQL.	FDW	PostgreSQL	C	13–17	37
kor_search	1.0.0	A PostgreSQL extension for Korean-English text search.	FTS	MIT	C	16	37
pgflake	0.0.1	Extension for fdw memory	FUNC	Apache-2.0	C	11–18	37
texcaller	0	PostgreSQL functions for converting TeX or LaTeX source to DVI or PDF.	UTIL	MIT	C	10–18	37
fixeddecimal	1.1.0	Fixed-precision decimal type optimized for performance and storage.	TYPE	PostgreSQL	C	10–18	36

Quick links

PostgreSQL Extension Catalogue