PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
pgsloth	0.0.0	Intentionally delays every query by a random 100 to 9,999 milliseconds through an executor hook.	FEAT	—	Rust	12–17	24
pg_kaboom	0.0.1	Blow things up in interesting and useful^W^W ways	FEAT	Apache-2.0	C	—	22
pg_shared_plans	0.0.1	Proof-of-concept shared-memory execution-plan cache for PostgreSQL	FEAT	PostgreSQL	C	12–17	22
pg_message_queue	0.2.1	Listen/Notify-based PostgreSQL message queue extension	FEAT	PostgreSQL	SQL	10–18	21
solverapi	1.2	SolveDB: A PostgreSQL-based DBMS for optimization applications	FEAT	Apache-2.0	Shell	—	18
base36_gist	1.0	PostgreSQL base36 data type input/output support, internally a bigint.	FEAT	—	C	—	17
hstore_ops	1.1	Alternative GIN operator classes for hstore, optimized for smaller indexes and faster containment queries.	FEAT	GPL-2.0	C	—	16
undam	0.1	UNDO storage table access method with in-place updates	FEAT	—	C	—	16
pg_doc_store	0.2.1	Provides a JSONB document-store API with full-text search.	FEAT	PostgreSQL	SQL	10–18	15
pgrdf	0.6.36	RDF, SPARQL, SHACL, and OWL reasoning for PostgreSQL	FEAT	MIT	Rust	14–18	15
supa_queue	1.0.4	Simple PostgreSQL job queue that dispatches asynchronous HTTP requests with pg_net, schedules processing and retries with pg_cron, and stores endpoint credentials in Supabase Vault.	FEAT	Apache-2.0	SQL	10–18	15
ulak	0.2.0	Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery	FEAT	Apache-2.0	C	14–18	15
postgresconf	1.0	pgrx webinar example demonstrating SQL functions, iterators, enums, and composite results.	FEAT	—	Rust	—	14
pg_variables	1.2.5	Session-scoped variables with scalar, array, and record types	FEAT	PostgreSQL	C	14–18	13
pgchess	0.1.7	A Chess extension	FEAT	GPL-3.0	C	—	13
json_schema_validate	0.1.0	Validate JSON and JSONB data against JSON Schema in PostgreSQL	FEAT	PostgreSQL	C	14–18	12
pg_oltp_bench	1.0	Helper function and pgbench scripts for a sysbench-style OLTP benchmark.	FEAT	—	C	—	12
pg_ripple	0.128.0	Provides an RDF knowledge-graph engine with SPARQL, SHACL, Datalog reasoning, federation, and graph analytics inside PostgreSQL 18.	FEAT	Apache-2.0	Rust	18	11
schema_triggers	0.1	Archived C hook extension adding relation, column, and trigger schema-change events to PostgreSQL event triggers.	FEAT	BSD-2-Clause	C	10–18	11
mv_rewrite	0.6.2	Query rewriting extension that transparently rewrites queries to use lower-cost materialized views.	FEAT	—	C	—	10
postgres_ci	0.3	Implements the database backend for the defunct Postgres-CI service, including users, projects, builds, hooks, sessions, and notifications.	FEAT	MIT	SQL	—	10
saio	0.0.1	Experimental load-only planner hook that searches PostgreSQL join orders with simulated annealing as an alternative to GEQO	FEAT	PostgreSQL	C	—	10
accel_ext	1.0	Fine-grained accelerator offload runtime that overlaps GPU, HSM, or inference work with other PostgreSQL requests.	FEAT	MIT	C	—	9
meta_triggers	0.5.0	Insert, update and delete triggers for the meta system catalog	FEAT	BSD-2-Clause	SQL	—	9
notify_now	1.0	PostgreSQL Extension to send multiple responses from one SQL Query using LISTEN/NOFITY API	FEAT	MIT	C	—	9
pgweb	0.0.1	Simple HTTP server to help build intuition for MemoryContexts in Postgres	FEAT	MIT	C	—	9
rule_engine_postgre_extensions	2.0.0	Rust/pgrx rule-engine extension supporting GRL rules, RETE and forward/backward chaining, versioned rule repositories, triggers, and optional external integrations.	FEAT	MIT	Rust	16–18	9
json_model	2.0	JSON Model PL/pgSQL Runtime - JSON value validation	FEAT	Public Domain	SQL	—	8
pg_no_seqscan	0.1.1	Prevents or reports sequential scans in development and CI by inspecting query plans.	FEAT	MIT	Rust	14–18	8
pgmock	0.2	SQL/PLpgSQL extension for mocking function and table dependencies in PostgreSQL unit tests	FEAT	MIT	SQL	10	8
fhirpath	1.0	data type for jsonb inspection	FEAT	—	C	—	7
norm	0.0.1	No-ORM helper extension that generates simple CRUD functions.	FEAT	GPL-3.0	SQL	—	7
pg_debug_scan	0.1.0	Debug PostgreSQL table scans with custom MVCC snapshot definitions.	FEAT	Apache-2.0	Rust	11–16	7
traceam	0.1	Simple table access method that just prints out what functions in the access methods and related functions that are called.	FEAT	Apache-2.0	C	—	7
bztree	1.0	BzTree index access method with equality operator classes for common PostgreSQL scalar types.	FEAT	Apache-2.0	C++	—	6
fetchq	4.0.2	Postgres extension that enables FetchQ capabilities	FEAT	MIT	SQL	—	6
konfigraf	0.0.2	Git based application configuration	FEAT	MIT	SQL	—	6
micromanage	0.0.1	example extension to inject plans	FEAT	—	C	—	6
pg_disorder	0.1.0	Perturb unordered SELECT row order to expose order-dependent tests	FEAT	PostgreSQL	C	14–18	6
pg_dropbuffers	0.0.1	Drop PostgreSQL shared buffers and the operating-system page cache for testing	FEAT	PostgreSQL	C	—	6
pg_hello	1.0	Postgres "Hello world" extension	FEAT	MIT	C	—	6
pgmer2	0.8.0	PostgreSQL connector for the MeritRank graph ranking service	FEAT	MIT	Rust	17	6
ctidscan	1.1	Example custom scan provider for CTID range predicates.	FEAT	—	C	—	5
ftree	0.1	atree extension for postgresql	FEAT	—	C	—	5
memoryam	0.0.1	In-memory TableAM implementation	FEAT	PostgreSQL	C	—	5
pg_ladybug	1.0	Cypher queries over PostgreSQL tables through an embedded Ladybug graph engine.	FEAT	PostgreSQL	C	17–18	5
pg_mentat	1.5.7	Datomic-compatible data model and Datalog query engine inside PostgreSQL	FEAT	Apache-2.0	Rust	14–18	5
pgwebhook	0.1.2	A very powerful extension to use webhooks and interact with Supabase Edge Functions	FEAT	Apache-2.0	SQL	—	5
cadfix	1.0	OCC interface implementation in JavaScript	FEAT	—	C++	—	4
csv_tam	0.0.1	CSV table access method for PostgreSQL that stores table tuples in CSV-formatted relation files.	FEAT	—	C	—	4

pgsloth

0.0.0

Intentionally delays every query by a random 100 to 9,999 milliseconds through an executor hook.

—

12–17

0.0.1

Blow things up in interesting and useful^W^W ways

—

0.0.1

Proof-of-concept shared-memory execution-plan cache for PostgreSQL

12–17

0.2.1

Listen/Notify-based PostgreSQL message queue extension

10–18

1.2

SolveDB: A PostgreSQL-based DBMS for optimization applications

—

1.0

PostgreSQL base36 data type input/output support, internally a bigint.

—

—

1.1

Alternative GIN operator classes for hstore, optimized for smaller indexes and faster containment queries.

FEAT

—

0.1

UNDO storage table access method with in-place updates

—

—

0.2.1

Provides a JSONB document-store API with full-text search.

10–18

0.6.36

RDF, SPARQL, SHACL, and OWL reasoning for PostgreSQL

14–18

1.0.4

Simple PostgreSQL job queue that dispatches asynchronous HTTP requests with pg_net, schedules processing and retries with pg_cron, and stores endpoint credentials in Supabase Vault.

10–18

0.2.0

Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery

14–18

1.0

pgrx webinar example demonstrating SQL functions, iterators, enums, and composite results.

—

—

1.2.5

Session-scoped variables with scalar, array, and record types

14–18

0.1.7

A Chess extension

—

0.1.0

Validate JSON and JSONB data against JSON Schema in PostgreSQL

14–18

1.0

Helper function and pgbench scripts for a sysbench-style OLTP benchmark.

—

—

0.128.0

Provides an RDF knowledge-graph engine with SPARQL, SHACL, Datalog reasoning, federation, and graph analytics inside PostgreSQL 18.

18

0.1

Archived C hook extension adding relation, column, and trigger schema-change events to PostgreSQL event triggers.

10–18

0.6.2

Query rewriting extension that transparently rewrites queries to use lower-cost materialized views.

—

—

0.3

Implements the database backend for the defunct Postgres-CI service, including users, projects, builds, hooks, sessions, and notifications.

—

0.0.1

Experimental load-only planner hook that searches PostgreSQL join orders with simulated annealing as an alternative to GEQO

—

1.0

Fine-grained accelerator offload runtime that overlaps GPU, HSM, or inference work with other PostgreSQL requests.

—

0.5.0

Insert, update and delete triggers for the meta system catalog

—

1.0

PostgreSQL Extension to send multiple responses from one SQL Query using LISTEN/NOFITY API

—

0.0.1

Simple HTTP server to help build intuition for MemoryContexts in Postgres

—

rule_engine_postgre_extensions

2.0.0

Rust/pgrx rule-engine extension supporting GRL rules, RETE and forward/backward chaining, versioned rule repositories, triggers, and optional external integrations.

16–18

2.0

JSON Model PL/pgSQL Runtime - JSON value validation

FEAT

Public Domain

SQL

—