PostgreSQL Extension Catalogue

1803 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version	Stars
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_sample_ext	1.0.2	A Sample PostgreSQL extension	FUNC	PostgreSQL	SQL	—	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_sexp_rs	0.1.0	PostgreSQL extension to add support for s-expressions store, query, index.	TYPE	Apache-2.0	Rust	—	2
pg_ssl	1.0	Create base64-encoded PKCS#7 signatures from PEM certificates and private keys in PostgreSQL	SEC	MIT	C	—	2
pg_str	0.3.1	Add Laravel-inspired string manipulation functions to PostgreSQL using pgrx	FUNC	MIT	Rust	11–15	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_table_range	0.1.1	Planning-time partition pruning by per-partition data ranges, including non-key columns.	OLAP	MIT	Rust	16–18	2
pg_tamagotchi	0.1.0	A pet for your postgres db	FEAT	—	C	—	2
pg_tamperlog	1.1	Tamper-evident append-only audit logging with hash chaining	SEC	—	SQL	—	2
pg_tamperlog_rust	1.0.0	Rust pgrx helper extension for pg_tamperlog fast SHA-256 hash-chain calculations.	SEC	—	Rust	—	2
pg_thud	0.1.0	Framework extending pgtap with scaffolding and test-data helpers for database unit tests.	FEAT	PostgreSQL	SQL	10–18	2
pg_tms	0.0.4	functions to tile rasters in TMS format	GIS	MIT	SQL	10–18	2
pg_toastinspect	1.0	Low-level inspection of TOAST chunk identifiers, sizes, and stored values.	ADMIN	PostgreSQL	C	—	2
pg_trex	0.1.0	pg trex: PostgreSQL extension for distributed trexsql	OLAP	—	Rust	—	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
pgembed	0.1.0	Generate vector embeddings through Ollama, OpenAI, or custom HTTP services	RAG	LicenseRef-Tecnisys-Community-1.0	Python	13–18	2
pgerror	0.2.1	Tools for better error handling	UTIL	MIT	SQL	—	2
pgfga	0.1.0	Experimental ReBAC/Zanzibar-style fine-grained authorization functions for PostgreSQL.	SEC	MIT	Rust	11–16	2
pghll	1.0	Provides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters.	FUNC	MIT	C	—	2
pgocrypto	1.0	encrypt data between Go and PG	SEC	—	SQL	—	2
pgparts	0.0.15	SQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers	OLAP	BSD-3-Clause	SQL	—	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
pgstrtranslate	1.0	Adds multi-character string replacement and text-array element removal functions.	FUNC	—	C	—	2
pgtoken	1.0	PostgreSQL extension for compact, codebook-compressed LLM token ID storage. Encode once, retrieve forever. O(1) token count without decoding.	RAG	MIT	Python	—	2
pguri	1.0	provide indexable URI and domain-name types and URI text search	TYPE	PostgreSQL	C	—	2
pgxc_dns	1.0	PostgreSQL-XC coordinator DNS views and weighting functions for BIND SDB load balancing and failover.	ADMIN	PostgreSQL	C	—	2
pigiaminja	0.1.0	PostgreSQL extension to export using Jinja templates	ETL	PostgreSQL	Rust	—	2
pjpg	1.0	provide general-purpose SQL utilities for time zones and ranges	UTIL	MIT	SQL	—	2
pljulia	0.8	Embeds Julia as an untrusted PostgreSQL procedural language with SPI access, DO blocks, triggers, arrays, and composite-type conversion.	LANG	PostgreSQL	C	14–18	2
plpy_venv	1.0	Select and manage Python virtual environments for PL/Python functions.	LANG	—	SQL	—	2
postllm	0.1.0	postllm: PostgreSQL-native access to OpenAI-compatible and local LLM runtimes	RAG	MIT	Rust	13–18	2
postr	0.1.0	Embeds Ruby as an untrusted PostgreSQL procedural language supporting functions, DO blocks, triggers, and set-returning functions.	LANG	MIT	Rust	13–18	2
product_logic	1.1.0	Provides operators to evaluate fuzzy logic expressions according to product logic.	FUNC	BSD-3-Clause	SQL	—	2
proven	0.5.0	proven: PostgreSQL C bindings for formally verified safety functions from libproven	FUNC	MPL-2.0	C	—	2
rasterdb	0.1	rasterdb: filesystem-backed PostGIS raster foreign data wrapper	FDW	—	C	—	2
resources	0.1.0	Linux server resource monitoring views backed by file_fdw PROGRAM foreign tables.	STAT	—	SQL	10–18	2

Quick links

PostgreSQL Extension Catalogue