PostgreSQL Extension Catalogue

587 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version	Stars
hunspell_pt_pt	1.0	Portuguese Hunspell Dictionary	FTS	PostgreSQL	Data	14–18	68
hunspell_ru_ru	1.0	Russian Hunspell Dictionary	FTS	PostgreSQL	Data	14–18	68
hunspell_ru_ru_aot	1.0	Russian Hunspell Dictionary (from AOT.ru group)	FTS	PostgreSQL	Data	14–18	68
sr_plan	1.2	Planner-hook extension that records, displays, and reuses saved execution plans, including parameterized-plan templates.	ADMIN	PostgreSQL	C	10–11	64
influxdb_fdw	1.3	Foreign data wrapper for querying InfluxDB from PostgreSQL.	FDW	PostgreSQL	C	13–17	62
pg_sorted_heap	0.14.0	Sorted heap table AM with zone map scan pruning and built-in vector search	OLAP	PostgreSQL	C	16–18	60
hashlib	1.1	Stable hash functions for Postgres	UTIL	PostgreSQL	C	14–18	59
bytea_plphp	1.0	Binary-safe transform between bytea and PHP strings for PL/php	LANG	PostgreSQL	C	11–18	56
hstore_plphp	1.0	Transform between hstore and PHP associative arrays for PL/php	LANG	PostgreSQL	C	11–18	56
jsonb_plphp	1.0	Transform between jsonb and native PHP values for PL/php	LANG	PostgreSQL	C	11–18	56
plphp	2.6	Embed PHP 8 as an untrusted PostgreSQL procedural language	LANG	PostgreSQL	C	11–18	56
ptrack	2.4	Tracks changed PostgreSQL blocks for incremental backup using a shared-memory map and core storage hooks.	ADMIN	PostgreSQL	C	11–18	56
pg_track_settings	2.1.2	Track settings changes	STAT	PostgreSQL	SQL	14–18	55
recall	0.9.6	Tracks table changes in per-table _log tables for timestamp-based history queries.	TIME	PostgreSQL	SQL	10–18	55
dsef	2024.4.9	DiffStats and ExplainFull: detailed SQL reports for third party help & support	STAT	PostgreSQL	SQL	—	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
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
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
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
pre_prepare	0.9	Pre Prepare your Statement server side	ADMIN	PostgreSQL	C	14–18	46
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
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_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
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
fixeddecimal	1.1.0	Fixed-precision decimal type optimized for performance and storage.	TYPE	PostgreSQL	C	10–18	36
pg_keeper	2.0	Background-worker based clustering module for monitoring streaming replication, changing synchronous replication mode and promoting a standby on failure.	ADMIN	PostgreSQL	C	—	36
pgbouncer_fdw	1.4.0	Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions	FDW	PostgreSQL	SQL	14–18	36
pgedge_vectorizer	1.1	Asynchronous text chunking and embedding generation for PostgreSQL using background workers and pgvector.	RAG	PostgreSQL	C	14–18	36
ldap_fdw	0.1.1	Foreign data wrapper for querying LDAP servers	FDW	PostgreSQL	C	—	35
bgw_replstatus	1.0.8	Small PostgreSQL background worker to report whether a node is a replication master or standby	STAT	PostgreSQL	C	14–18	34
first_last_agg	0.1.4	first() and last() aggregate functions	FUNC	PostgreSQL	C	14–18	34
icu_ext	1.11.0	Access ICU functions	UTIL	PostgreSQL	C	14–18	34
jsonbx	1.0	Jsonb extension functions for PostgreSQL 9.4	FUNC	PostgreSQL	C	—	34
couchdb_fdw	1.0	Foreign data wrapper for querying CouchDB from PostgreSQL.	FDW	PostgreSQL	C	—	32
pg_cryogen	0.1	Experimental append-only compressed table access method for PostgreSQL 12 and later.	OLAP	PostgreSQL	C	12–18	32
db2_fdw	18.2.0	foreign data wrapper for DB2 access	FDW	PostgreSQL	C	14–18	31
extra_window_functions	1.0	Extra Window Functions for PostgreSQL	FUNC	PostgreSQL	C	14–18	31
file_textarray_fdw	1.0.1	Foreign data wrapper returning each text-file row as a text array.	FDW	PostgreSQL	C	—	31

Quick links

PostgreSQL Extension Catalogue