PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
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_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
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
demopgextension	0.0.1	Sample Postgres Extension - pg_cmake	FEAT	Apache-2.0	C	—	4
fmodel_rust_postgres	1.0.0	Run f{model} event-sourced domain models inside PostgreSQL as a pgrx extension.	FEAT	Apache-2.0	Rust	13–16	4
implicit_schema	0.1	Event-trigger extension that automatically creates a schema when a table or view is created in a missing schema.	FEAT	MIT	C	—	4
index_analyzer	0.1.0	PL/pgSQL functions for evaluating existing and prospective indexes and checking foreign-key indexing.	FEAT	BSD-2-Clause	SQL	—	4
mbus	1.1	simple message bus for pg	FEAT	—	SQL	—	4
pg_validator	1.0	PostgreSQL extension to validate data with trigger	FEAT	—	C	—	4
ags	1.0	Advanced Generalized Search access method, a GiST-based advanced index.	FEAT	—	C	11–12	3
geqo_extension	0.0.1	Load-only extraction of PostgreSQL's Genetic Query Optimizer with a planner hook and configurable GEQO behavior.	FEAT	—	C	—	3
optpaths	0.1	Planner hook extension for adding paths and removing self joins	FEAT	BSD-3-Clause	C	—	3
pg_os	1.0	PostgreSQL extension providing operating system-level functionality directly through SQL, enabling process management, file system operations, IPC, and system monitoring within the database environment.	FEAT	MIT	SQL	—	3
pgque	0.1.0	Pure SQL PostgreSQL job queue that orders jobs by priority and claims them with advisory locks.	FEAT	—	SQL	—	3
pgx_json_schema	1.0	JSON Schema validation for Postgres	FEAT	—	Rust	—	3
qgres	0.1.2	Simple queue system	FEAT	PostgreSQL	SQL	—	3
repeat	0.0.1	A testing repo comparing an SRF that is dually implemented as ValuePerCall and Materialize	FEAT	—	C	—	3
session_variables	0.0.4	SQL functions for storing and retrieving session-scoped values through custom PostgreSQL settings.	FEAT	PostgreSQL	SQL	10–18	3
append_only_heap	1.0	PostgreSQL table access method that avoids fragmentation of variable-length append-only data.	FEAT	MIT	C	—	2
cbtree	1.0	counted btree access method	FEAT	—	C	10	2
cpg	0.1	Dépôt relatif aux journées de hacking sur PostgreSQL	FEAT	—	C	—	2
fsm	0.3	Trigger-enforced finite state machines for application tables.	FEAT	GPL-3.0-only	C	10–18	2
job_queue	1.0	Proof-of-concept database-side asynchronous job queue using dynamic PostgreSQL background workers.	FEAT	—	C	—	2
my_extension	1.1.0	A Basic PostgreSQL Extension	FEAT	PostgreSQL	SQL	—	2

mv_rewrite

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

—

0.1.1

Prevents or reports sequential scans in development and CI by inspecting query plans.

14–18

0.2

SQL/PLpgSQL extension for mocking function and table dependencies in PostgreSQL unit tests

10

1.0

data type for jsonb inspection

—

—

0.0.1

No-ORM helper extension that generates simple CRUD functions.

FEAT

—

0.1.0

Debug PostgreSQL table scans with custom MVCC snapshot definitions.

11–16

0.1

Simple table access method that just prints out what functions in the access methods and related functions that are called.

—

1.0

BzTree index access method with equality operator classes for common PostgreSQL scalar types.

—

4.0.2

Postgres extension that enables FetchQ capabilities

—

0.0.2

Git based application configuration

—

0.0.1

example extension to inject plans

—

—

0.0.1

Drop PostgreSQL shared buffers and the operating-system page cache for testing

—

1.0

Postgres "Hello world" extension

—

0.8.0

PostgreSQL connector for the MeritRank graph ranking service

17

1.1

Example custom scan provider for CTID range predicates.

—

—

0.1

atree extension for postgresql

—

—

0.0.1

In-memory TableAM implementation

—

1.0

Cypher queries over PostgreSQL tables through an embedded Ladybug graph engine.

17–18

0.1.2

A very powerful extension to use webhooks and interact with Supabase Edge Functions

—

1.0

OCC interface implementation in JavaScript

—

—

0.0.1

CSV table access method for PostgreSQL that stores table tuples in CSV-formatted relation files.

—

—

0.0.1

Sample Postgres Extension - pg_cmake

—

1.0.0

Run f{model} event-sourced domain models inside PostgreSQL as a pgrx extension.

13–16

0.1

Event-trigger extension that automatically creates a schema when a table or view is created in a missing schema.

—

0.1.0

PL/pgSQL functions for evaluating existing and prospective indexes and checking foreign-key indexing.

—

1.1

simple message bus for pg

—

—

1.0

PostgreSQL extension to validate data with trigger

—

—

1.0

Advanced Generalized Search access method, a GiST-based advanced index.

—

11–12

0.0.1

Load-only extraction of PostgreSQL's Genetic Query Optimizer with a planner hook and configurable GEQO behavior.

—

—

0.1

Planner hook extension for adding paths and removing self joins

—

1.0

PostgreSQL extension providing operating system-level functionality directly through SQL, enabling process management, file system operations, IPC, and system monitoring within the database environment.

—

0.1.0

Pure SQL PostgreSQL job queue that orders jobs by priority and claims them with advisory locks.

FEAT

—

SQL

—