PostgreSQL Extension Catalogue

1803 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version	Stars
pg_digest	1.0	Data type for efficient storage of hash digests in PostgreSQL.	TYPE	GPL-3.0	C	—	1
pg_dropcache	1.0.0	Invalidate PostgreSQL shared_buffers cache for a database or relation	ADMIN	PostgreSQL	C	11–16	1
pg_fela	1.0.0	The holy grail of AutoML for PG - self classifying and regressing tabular data!	RAG	—	Rust	—	1
pg_fiu	0.0.1	Fault-injection extension for PostgreSQL using libfiu	FEAT	MIT	C	10–18	1
pg_flashback	0.1.0	Table-level point-in-time restore and time-travel queries for PostgreSQL using trigger or WAL capture.	TIME	MIT	Rust	13–18	1
pg_foobar	1.0	Demonstrates PostgreSQL parallel workers by launching workers that write configurable foo and bar messages to the server log.	FEAT	—	C	10	1
pg_frozen	0.0.1	Exposes a frozen(tid) function that explains if a tuple has been frozen	ADMIN	—	C	—	1
pg_gen_query	1.0	A PostgreSQL extension written in C++ that adds no-maintenance GenAI querying functionality using Clickhouse's AI SDK	RAG	MIT	C++	—	1
pg_git	0.4.0	Implements Git-like repositories, commits, branches, merges and remote operations using PostgreSQL-native data and functions.	FEAT	PostgreSQL	SQL	12–18	1
pg_global_catalog	0.0.1	PostgreSQL global catalog	ADMIN	PostgreSQL	C	—	1
pg_grex	0.1.0	A dynamic regex builder for PgSQL	UTIL	MIT	Rust	—	1
pg_grpc	1.0	PostgreSQL gRPC	UTIL	MIT	C	—	1
pg_injection	1.0.0	PostgreSQL injection	SEC	MIT	C	—	1
pg_jq	1.0	Toy extension exposing libjq filters for PostgreSQL json and jsonb values.	UTIL	—	Rust	—	1
pg_json_diff	1.0	JSONB diff, JSON Patch, and merge-patch functions for PostgreSQL	FUNC	MIT	C++	12–18	1
pg_ledger	0.2.0	Provides a double-entry accounting engine with immutable journals, fiscal periods, currencies and posting rules inside PostgreSQL.	FEAT	Matroid	Rust	14–18	1
pg_lexo	0.6.0	Provides a Base62 lexicographic position type and helper functions for stable list ordering and reordering without bulk row updates.	TYPE	MIT	Rust	16–18	1
pg_logfmt	0.0.0	Parse logfmt strings into JSONB and key sets	UTIL	MIT	Rust	14–15	1
pg_mem_counters	1.0	Maintains named total and requests-per-minute counters in PostgreSQL shared memory.	STAT	MIT	C	10–11	1
pg_misc_functions	1.0	Administrative test functions for backend errors, PANIC, crashes, and failover exercises.	ADMIN	PostgreSQL	C	—	1
pg_monetdb	1.4	MonetDB foreign-data wrapper with stronger analytical pushdown	FDW	MPL-2.0	C	—	1
pg_msgpack	0.0.1	MessagePack data type with JSON and bytea casts and access operators	TYPE	PostgreSQL	C	—	1
pg_nanp	1.0	Validated and consistently formatted North American Numbering Plan data type	TYPE	PostgreSQL	C	—	1
pg_neon_sudo	0.0.1	Provides Neon-specific trusted sudo wrappers that run PostgreSQL Anonymizer dynamic-masking start and stop operations as the bootstrap superuser.	SEC	—	C	16–18	1
pg_nowhere	0.1	A PostgreSQL extension to disallow UPDATE and DELETE queries without a WHERE clause.	ADMIN	Public Domain	C	—	1
pg_ocr	0.0.1	Self-contained OCR functions via PL/Python	RAG	—	Python	—	1
pg_open_meteo	0.0.0	Prototype Rust/pgrx PostgreSQL extension associated with Open-Meteo weather data.	FUNC	—	Rust	12–17	1
pg_opencc	1.0	Converts text among Simplified Chinese, Traditional Chinese regional variants and Japanese Shinjitai using OpenCC.	UTIL	Apache-2.0	C	13	1
pg_optigraph	0.1.0	pg Optigraph is a PostgreSQL extension which uses OptiGraph ML model.	RAG	MIT	Python	—	1
pg_ortools	0.2.0	Constraint optimization extension using the HiGHS MIP/LP solver from PostgreSQL, with optional async execution.	FUNC	Matroid	Rust	14–18	1
pg_outrider	1.0	Dynamically launches a background worker that extends a relation when its free-space watermark is crossed.	ADMIN	—	C	—	1
pg_pageindex	1.0	PageIndex document-tree construction and tree search for PDF and Markdown through a C/Go bridge.	RAG	MIT	C	16	1
pg_plan_guard	1.1	Detect drift from approved PostgreSQL 19 plan-advice baselines	STAT	PostgreSQL	PLpgSQL	19	1
pg_postal_code_ca	1.0	an efficient, validated, formatted Canadian postal code type	TYPE	PostgreSQL	C	—	1
pg_prob	0.2.0	Probabilistic data types for PostgreSQL - Monte Carlo simulation in SQL	TYPE	Matroid	Rust	14–18	1
pg_promise_guard	0.2.0	Catalog-only checks for schema guarantees that are no longer enforced	ADMIN	PostgreSQL	SQL	13–19	1
pg_prttn_tools	0.5	Provides PL/pgSQL tools for managing inheritance-based partition tables.	OLAP	MIT	SQL	—	1
pg_py_ext	1.0.0	A PostgreSQL extension using PL/Python3U to add numbers	FUNC	PostgreSQL	SQL	—	1
pg_rand_ext	1.0	Functions that generate random values for PostgreSQL	FUNC	PostgreSQL	C	—	1
pg_random_string	0.0.1	Generates an alphanumeric string of a requested length with a C function.	FUNC	—	C	—	1
pg_recall_guard	0.2.0	Measure ANN index recall and detect drift from an approved baseline	RAG	PostgreSQL	PLpgSQL	13–19	1
pg_recyclebin	0.1.0	Intercepts DROP TABLE and TRUNCATE to retain recoverable table data and metadata in a recycle-bin schema.	ADMIN	MIT	Rust	14–18	1
pg_registry	0.2.0	Stores and validates JSON Schemas, generates schemas from tables, and binds schemas to Kafka topics.	FEAT	Matroid	Rust	14–18	1
pg_reject_truncate	1.0	Rejects or prevents TRUNCATE operations in PostgreSQL.	ADMIN	—	C	—	1
pg_reversi	1.0	Reversi game implemented as a PostgreSQL extension.	FEAT	—	C	—	1
pg_rlimit	1.0	setrlimit/getrlimit functions	ADMIN	BSD-3-Clause	C	10–18	1
pg_sats	0.1.0	Per-role query metering and optional enforcement using satoshi-denominated balances.	ADMIN	MIT	C	14–18	1
pg_semantius	0.4.0	Database-first application backend with RBAC, RLS, data dictionary, and message queue.	FEAT	MIT	SQL	18	1
pg_sequence	0.2.0	ERP document numbering with formatted, scoped, auto-incrementing sequences	FUNC	—	Rust	—	1
pg_sessions	1.3	Tracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory.	STAT	GPL-3.0	C	—	1

Quick links

PostgreSQL Extension Catalogue