PostgreSQL Extension Catalogue

1445 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version	Stars
pg_background_queue	1.0	Topic-aware background SQL task queue with concurrency limits and retries.	TIME	GPL-3.0	C	13–18	2
pg_bitcoin_address	2.1	Bitcoin address types plus Base58Check and Bech32/Bech32m codecs.	TYPE	WTFPL	C	—	2
pg_block_if_slow	1.0	Abort queries that are taking too long based on EXPLAIN estimates.	ADMIN	—	C	—	2
pg_change_point_detection	1.0	A Postgres extension to detect change points in time series data	TIME	—	C	—	2
pg_checkdestroy	1.0	check sql drop&delete&truncate table	ADMIN	—	C	—	2
pg_connlimit	1.0	Limits per-role connection counts from filesystem configuration without catalog access.	ADMIN	BSD-2-Clause	C	—	2
pg_contextdump	1.0	Reports allocated-memory statistics for PostgreSQL memory contexts.	STAT	—	C	11	2
pg_cooldown	0.1	remove buffered pages for specific relations	ADMIN	Apache-2.0	C	14–18	2
pg_coredump	1.0	Easier core dump collection for PostgreSQL	ADMIN	—	C	—	2
pg_dirty_hands	1.0	Provides functions to freeze individual heap tuples, including an unlogged variant.	ADMIN	—	C	—	2
pg_etag	1.0	Fast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates.	FUNC	BSD-3-Clause	C	—	2
pg_follower	1.0	Educational logical-replication extension that captures and applies database changes	ETL	—	C	—	2
pg_fsql	1.1.0	Recursive SQL template engine with JSONB-driven execution	UTIL	PostgreSQL	C	14–18	2
pg_genotype	1.0	Provides a compact one-byte genotype type that preserves allele order and supports insertion and deletion symbols.	TYPE	PostgreSQL	C	—	2
pg_geohash_extra	0.0.1	Additional geohash functions for PostGIS	GIS	GPL-3.0	C	—	2
pg_get_queryid	1.0	get last queryid generated/used by pg_stat_statements for a given backend pid	STAT	PostgreSQL	C	10–18	2
pg_imputed_genotype	1.0	Store imputed-genotype probability triples in a packed four-byte PostgreSQL type.	TYPE	PostgreSQL	C	—	2
pg_inet_addr	1.0	Lists the IPv4 and IPv6 addresses and netmasks assigned to the PostgreSQL server host network interfaces.	STAT	BSD-3-Clause	C	10–18	2
pg_intmap	0.1	Compressed integer-to-integer map	TYPE	—	C	—	2
pg_liquid	0.1.7	Liquid-inspired Datalog graph query extension for PostgreSQL	FEAT	MIT	C	14–18	2
pg_log	1.0.0	displays log content from SQL	STAT	PostgreSQL	C	—	2
pg_login_stat	1.0	Per-user and per-database successful and failed authentication counters.	STAT	—	C	15–17	2
pg_median_utils	0.0.1	Median filter and iterative median filter window functions for PostgreSQL	FUNC	MIT	C	10–18	2
pg_metrics	1.0	Collects named counters from PostgreSQL backends in shared memory and exposes them through SQL metric functions.	STAT	—	C	—	2
pg_pageinspect_plus	1.0	Decode heap tuple data obtained with PostgreSQL pageinspect helpers	ADMIN	BSD-3-Clause	C	10–18	2
pg_procfs	0.0.1	displays /proc data from SQL	STAT	PostgreSQL	C	—	2
pg_promoter	1.0	pg promoter is simplified clustering module based on bgworker.	ADMIN	—	C	—	2
pg_pwhash	1.0	Advanced password hashing methods for PostgreSQL	SEC	MIT	C	14–18	2
pg_querylog	0.1	Captures current and recently completed backend queries in shared memory for SQL inspection.	STAT	—	C	10–12	2
pg_repeater	0.1	Replicates utility statements and serialized query plans to a remote PostgreSQL node over postgres_fdw.	ETL	PostgreSQL	C	—	2
pg_set_level	0.0.1	trigger action for SET statement	ADMIN	PostgreSQL	C	—	2
pg_sexp	0.1.0	Adds a compact S-expression type with parsing, list operations, matching, containment, and hash/GIN indexing.	TYPE	Apache-2.0	C	14–18	2
pg_ssl	1.0	Create base64-encoded PKCS#7 signatures from PEM certificates and private keys in PostgreSQL	SEC	MIT	C	—	2
pg_strverscmp	1.0	Natural-sort comparison functions, text operators, and a btree operator class based on a strverscmp-like order.	FUNC	ISC	C	—	2
pg_tamagotchi	0.1.0	A pet for your postgres db	FEAT	—	C	—	2
pg_toastinspect	1.0	Low-level inspection of TOAST chunk identifiers, sizes, and stored values.	ADMIN	PostgreSQL	C	—	2
pg_visibilitymap	1.0	Inspect relation visibility-map bits on historical PostgreSQL releases.	ADMIN	—	C	—	2
pg_wal_ext	1.0	Read WAL files and possibly generate the SQL	ETL	MIT	C	—	2
pg_web	0.1.0	Run an embedded HTTP server from a PostgreSQL background worker	FEAT	MIT	C	—	2
pg_xclaim	1.0.0-rc1	High-cardinality transaction-scoped logical claim primitive for PostgreSQL	FEAT	PostgreSQL	C	—	2
pgcodec7	1.0	C extension that encodes and decodes bytea values using compact 7-bit or 6-bit text grouping.	UTIL	—	C	11	2
pghll	1.0	Provides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters.	FUNC	MIT	C	—	2
pgpm-base32	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	UTIL	MIT	C	—	2
pgpm-defaults	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	SEC	MIT	C	—	2
pgpm-faker	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	FUNC	MIT	C	—	2
pgpm-inflection	0.30.0	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	FUNC	MIT	C	—	2
pgpm-measurements	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	FEAT	MIT	C	—	2
pgpm-types	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	TYPE	MIT	C	—	2
pgqbw	1.0	postgres queue backgound worker	FEAT	—	C	—	2
pgsqlauditengine	1.0	SQL policy checks with an embedded rule and audit REST API	SEC	GPL-3.0-only	C	11–18	2

Quick links

PostgreSQL Extension Catalogue