PostgreSQL Extension Catalogue

395 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version	Stars
meta_triggers	0.5.0	Insert, update and delete triggers for the meta system catalog	FEAT	BSD-2-Clause	SQL	—	9
pg_auditor	0.2	Audit data changes and provide flashback ability	SEC	BSD-3-Clause	SQL	14–18	9
pgaut	1.0.0	Auto Update Timestamp for PostgreSQL	FUNC	PostgreSQL	SQL	10–11	9
pggit	0.1.3	Git-like version control for PostgreSQL schemas	ADMIN	MIT	SQL	—	9
json_model	2.0	JSON Model PL/pgSQL Runtime - JSON value validation	FEAT	Public Domain	SQL	—	8
pg_extra_time	2.1.0	Some date time functions and operators that,	UTIL	PostgreSQL	SQL	14–18	8
pg_mockable	1.1.0	Create mockable wrappers for PostgreSQL functions in tests	LANG	PostgreSQL	SQL	14–18	8
pg_rowalesce	0.1.12	rowalesce() is like coalesce(), but for rows and other composite types.	FUNC	PostgreSQL	SQL	—	8
pgmock	0.2	SQL/PLpgSQL extension for mocking function and table dependencies in PostgreSQL unit tests	FEAT	MIT	SQL	10	8
drop_role_helper	1.0	Generates SQL to revoke all privileges held by a role in the current database.	SEC	PostgreSQL	SQL	—	7
norm	0.0.1	No-ORM helper extension that generates simple CRUD functions.	FEAT	GPL-3.0	SQL	—	7
pg_drop_events	0.1.0	logs transaction ids of drop table, drop column, drop materialized view statements	ADMIN	PostgreSQL	SQL	14–18	7
pg_landmetrics	0.0.1	A PostgreSQL/PostGIS extension for calculating landscape metrics.	GIS	GPL-3.0	SQL	—	7
pg_partition	0.2.0	Generate and manage timestamp-based PostgreSQL table partitions	OLAP	MIT	SQL	10–18	7
pg_safer_settings	1.0.0	Functions and mechanisms for handling PostgreSQL settings more safely.	ADMIN	PostgreSQL	SQL	—	7
pg_safer_settings_table_dependent_extension	forever	A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer.	ADMIN	—	SQL	—	7
pg_safer_settings_table_dependent_subextension	monover	A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer.	ADMIN	—	SQL	—	7
pg_sqlog	1.6	Provide SQL interface to logs	STAT	BSD-3-Clause	SQL	14–18	7
pg_text_semver	1.2.1	Semantic version domain and comparison operators for PostgreSQL	TYPE	PostgreSQL	SQL	14–18	7
pgfr_control	2.28.1	Vacuum diagnostics, autovacuum scale-factor recommendations, and table bloat analysis for pgfr_record.	ADMIN	—	SQL	—	7
pggeojson	1.0	A GeoJSON generating extension for PostGIS	GIS	Apache-2.0	SQL	—	7
db2fce	0.0.17	DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.	SIM	PostgreSQL	SQL	14–18	6
dbpatch	1.3.0	PostgreSQL database patch change management extension	ADMIN	BSD-3-Clause	SQL	—	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
pg_datatype_password	0.0.1	SQL-only password data type and operators using pgcrypto Blowfish hashes, with trigger-based encryption before storage.	TYPE	MIT	SQL	10–18	6
pg_dbms_lock	2.0	Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL	SIM	PostgreSQL	SQL	14–18	6
pg_html5_email_address	1.2.3	PostgreSQL email validation that is consistent with the HTML5 spec	UTIL	PostgreSQL	SQL	14–18	6
pg_utl_smtp	1.0.0	Oracle UTL_SMTP compatibility extension for PostgreSQL	SIM	PostgreSQL	SQL	14–18	6
pgmnemo	0.20.0	Single-plan multimodal agent memory for PostgreSQL	RAG	Apache-2.0	SQL	17–18	6
roleman	0.3.0	Parameterized role and privilege management functions for PostgreSQL.	SEC	PostgreSQL	SQL	10–18	6
workalendar	1.0.0	PostgreSQL extension for Workalendar	TIME	—	SQL	—	6
brainfuck	4.2.0	Run Brainfuck programs inside PostgreSQL using a PLV8 trusted language extension.	LANG	Apache-2.0	SQL	15–18	5
ddl_versioning	1.0	DDL object versioning with event triggers for tables, indexes, functions, and views.	ADMIN	GPL-3.0	SQL	13–18	5
email_guard	0.35.0	Supabase Auth signup guard that blocks disposable email domains and normalizes Gmail addresses.	SEC	Apache-2.0	SQL	—	5
historical_geocoding	1.0	SQL toolkit for geocoding historical addresses by combining textual, temporal, and spatial evidence.	GIS	MIT	SQL	—	5
mysql_migrator	0.3.0	Tools for MySQL to PostgreSQL migration	ETL	PostgreSQL	SQL	—	5
pg_eyes	1.4	SQL monitoring functions and views for PostgreSQL database activity	STAT	MIT	SQL	10–18	5
pg_fkpart	1.7.0	Table partitioning by foreign key utility	OLAP	GPL-2.0	SQL	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
postgis_letters	0.0.5	convert text letters into PostGIS geometries using packaged vector fonts	GIS	MIT	SQL	10–18	5
rikai	0.1	rikai ML extensions	RAG	Apache-2.0	SQL	—	5
uniphant	1.5	PostgreSQL-centric authentication and authorization demo integrating WebAuthn, PostgREST, and role-based access control.	SEC	MIT	SQL	13	5
ac	0.0.1	Access Control Postgres extension (with dev environment)	SEC	—	SQL	—	4
cidr	1.0	Transform an IPv4 or IPv6 address range into the minimal set of CIDR blocks	FUNC	MIT	SQL	—	4
db_info	0.2.0	Functions and views reporting database size, ownership, tablespaces, extensions, and object counts.	STAT	PostgreSQL	SQL	11–18	4
ddl_historization	0.2	Historize the ddl changes inside PostgreSQL database	UTIL	GPL-2.0	SQL	14–18	4
geoip2lookup	0.0.3	Look up IP-address info in MaxMind GeoIP2 MMDB files	GIS	BSD-2-Clause	SQL	10–18	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
istoria	1.1	Table history management with non-linear undo/redo	TIME	GPL-3.0	SQL	—	4

Quick links

PostgreSQL Extension Catalogue