PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
pg_logqueryid	0.0.1	Logs pg_stat_statements query IDs alongside auto_explain output.	STAT	PostgreSQL	C	10–18	6
pg_metricus	1.0	Sends custom metrics from PL/pgSQL code to socket-based aggregators such as Brubeck or Graphite.	STAT	MIT	C	—	6
pg_mystem	1.0.1	Runs Yandex Mystem worker processes to provide Russian-language lemmatization from PostgreSQL queries.	FTS	MIT	C++	—	6
pg_particulous	1.0	Migrate tables between vanilla PostgreSQL and pg_pathman partitioning	OLAP	—	C	—	6
pg_pii_vault	0.0.0	PostgreSQL extension for GDPR-compliant column-level encryption using HashiCorp Vault Transit Engine.	SEC	MIT	Rust	13–18	6
pg_queryid	0.0.1	Compute configurable external query fingerprints for PostgreSQL	STAT	PostgreSQL	C	14–18	6
pg_semver	0.0.1	Version(SEMVER) data type for postgresql	TYPE	MIT	C	—	6
pg_stl	1.0.0	Time series analysis functions for PostgreSQL	TIME	PostgreSQL	C	16–18	6
pg_summarize	0.0.1	Text Summarization using LLMs. Built using pgrx	RAG	—	Rust	14–18	6
pg_ta	1.0	TA-Lib technical-analysis functions exposed as PostgreSQL functions	FUNC	BSD-2-Clause	C	—	6
pg_utl_smtp	1.0.0	Oracle UTL_SMTP compatibility extension for PostgreSQL	SIM	PostgreSQL	SQL	14–18	6
pg_vault_tde	1.7.1	Transparent Data Encryption for PostgreSQL through custom table and index access methods	SEC	PostgreSQL	C	17–18	6
pg_wkhtmltopdf	1.0	Convert HTML pages to PDF bytea values inside PostgreSQL using wkhtmltopdf/QtWebKit.	UTIL	MIT	C	—	6
pgmer2	0.8.0	PostgreSQL connector for the MeritRank graph ranking service	FEAT	MIT	Rust	17	6
pgmnemo	0.20.0	Single-plan multimodal agent memory for PostgreSQL	RAG	Apache-2.0	SQL	17–18	6
pgseccomp	1.0	provide seccomp syscall filtering for PostgreSQL	SEC	PostgreSQL	C	—	6
pgsyswatch	1.0	Host process, CPU, memory, swap, network, and load statistics exposed through SQL.	STAT	Apache-2.0	C	—	6
pllju	0.1	LuaJIT FFI PostgreSQL language extension	LANG	MIT	C	—	6
postcode	1.3.0	Store UK postcodes in a compact 32-bit type with validation, formatting, partial matching, and B-tree indexing	TYPE	BSD-2-Clause	C	—	6
psl	1.0.0	Returns the registrable domain for a hostname using a compiled-in Public Suffix List.	FUNC	PostgreSQL	C	11–15	6
querymem	1.0	pgEdge Labs: The querymem Postgres extension for estimating query memory usage	STAT	PostgreSQL	C	—	6
roleman	0.3.0	Parameterized role and privilege management functions for PostgreSQL.	SEC	PostgreSQL	SQL	10–18	6
router	0.0.1	Experimental C extension that routes PostgreSQL OLTP queries across shards.	OLAP	PostgreSQL	C	—	6
shbf	1.0.0	C extension providing Bloom filter, shifting Bloom filter, and count-min sketch PostgreSQL data types and functions.	FUNC	—	C	—	6
snowball_bilingual	1.0	snowball_bilingual - add-on dictionary template using the combined results of two snowball stemmers	FTS	AGPL-3.0	C	—	6
tsearch_extras	1.0	Full-text-search helpers for returning match locations and extracting tsvector lexemes.	FTS	PostgreSQL	C	10–11	6
uuid-freebsd	2.0	UUID generation functions for PostgreSQL on FreeBSD.	FUNC	PostgreSQL	C	10–18	6
workalendar	1.0.0	PostgreSQL extension for Workalendar	TIME	—	SQL	—	6
a5pg	0.6.1	Equal-area A5 spatial index functions for PostgreSQL.	GIS	Apache-2.0	Rust	13–18	5
accumulo_access_pg	0.1.5	PostgreSQL extension for parsing and evaluating Accumulo Access Expressions.	SEC	MIT	Rust	15	5
blake2b	1.0	PostgreSQL extension for fast secure hashing	SEC	MIT	C	—	5
brainfuck	4.2.0	Run Brainfuck programs inside PostgreSQL using a PLV8 trusted language extension.	LANG	Apache-2.0	SQL	15–18	5
ctidscan	1.1	Example custom scan provider for CTID range predicates.	FEAT	—	C	—	5
ddl_versioning	1.0	DDL object versioning with event triggers for tables, indexes, functions, and views.	ADMIN	GPL-3.0	SQL	13–18	5
dont_drop_db	1.0	Prevents DROP DATABASE for databases listed in the dont_drop_db.list setting.	ADMIN	—	C	13–18	5
email_guard	0.35.0	Supabase Auth signup guard that blocks disposable email domains and normalizes Gmail addresses.	SEC	Apache-2.0	SQL	—	5
explain_ui	0.0.2	easily jump into a visual plan UI for any SQL query	STAT	—	Rust	14–18	5
fnvhash	1.0	FNV hash functions for PostgreSQL.	FUNC	—	C	—	5
ftree	0.1	atree extension for postgresql	FEAT	—	C	—	5
greenplum_fdw	1.0	Foreign data wrapper for querying Greenplum from PostgreSQL using SERIALIZABLE remote transactions.	FDW	—	C	12–13	5
hba_fdw	1.0	Work-in-progress foreign data wrapper scaffold intended to expose pg_hba.conf through SQL.	FDW	BSD-3-Clause	C	—	5
historical_geocoding	1.0	SQL toolkit for geocoding historical addresses by combining textual, temporal, and spatial evidence.	GIS	MIT	SQL	—	5
jiebaparser	1.0	Postgresql full-text search extension for chinese (jiaba engine) using shared mem.	FTS	Apache-2.0	C++	—	5
jsonb_schema	1.0	jsonb with separately stored schema	TYPE	PostgreSQL	C	—	5
koldstore	0.1.0	PostgreSQL tiered-storage that moves historical rows to Parquet while keeping the original table fully queryable and supporting updates and deletes.	OLAP	Apache-2.0	Rust	—	5
launchql-inflection	0.0.2	inflection is a port of the functionality from Ruby on Rails' Active Support Inflection classes into PostgreSQL	FUNC	MIT	C	—	5
memoryam	0.0.1	In-memory TableAM implementation	FEAT	PostgreSQL	C	—	5
mysql_migrator	0.3.0	Tools for MySQL to PostgreSQL migration	ETL	PostgreSQL	SQL	—	5
natord_pg	0.0.0	Natural-order comparison operators and btree operator class for PostgreSQL text values.	FUNC	MIT	Rust	13–17	5
norasearch	1.0	NoraSearch is a high-performance search engine for PostgreSQL.	FTS	MIT	C	16–18	5

Quick links

PostgreSQL Extension Catalogue