PostgreSQL Extension Catalogue

395 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version	Stars
pgh_raster	6.6	Raster hydrology extension for PgHydro	GIS	GPL-2.0	SQL	14–18	47
pghydro	6.6	Drainage network analysis core for PostgreSQL and PostGIS	GIS	GPL-2.0	SQL	14–18	47
external_file	1.2	Access external server-side files through PostgreSQL functions	UTIL	PostgreSQL	SQL	14–18	41
mysqlcompat	0.0.7	MySQL compatibility functions, aggregates, operators, and casts for PostgreSQL porting.	SIM	—	SQL	—	39
pgbouncer_fdw	1.4.0	Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions	FDW	PostgreSQL	SQL	14–18	36
pg_headerkit	1.0	PostgreSQL SQL functions for reading PostgREST request headers inside database code	UTIL	ISC	SQL	—	35
pagevis	0.1	Visualise database pages in ascii code	STAT	MIT	SQL	14–18	31
town	0.1.0	Minimal PL/pgSQL helper that creates JSONB-and-array time-series tables with GIN and GiST indexes.	TIME	MIT	SQL	—	31
eql	2.2.1	Encrypt Query Language provides PostgreSQL types, functions, operators, and index support for searchable encrypted data.	SEC	MIT	SQL	14–17	29
recursively_delete	0.1.5	Recursively delete rows and their foreign-key dependents	ADMIN	MIT	SQL	10–13	29
check_access	0.1	Functions and views to facilitate PostgreSQL object access inspection	SEC	PostgreSQL	SQL	10–18	28
cigration	1.1	Online migration and rebalancing of colocated Citus shards for cluster expansion, contraction, and worker replacement.	ETL	Apache-2.0	SQL	10–13	28
db_migrator	1.0.0	Tools to migrate other databases to PostgreSQL	ETL	BSD-3-Clause	SQL	14–18	28
pgtelemetry	1.7	Provides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics.	STAT	PostgreSQL	SQL	10–17	27
lostgis	1.0.2	LostGIS spatial helper functions and types	GIS	BSD-3-Clause	SQL	10–18	26
cdb_geocoder	0.0.2	Archived CARTO geocoder extension for administrative, postal, IP, and named-place lookups.	GIS	—	SQL	—	25
pgchronos	1.0.2	SQL functions and operators for union, intersection, and difference over daterange and tstzrange arrays.	TIME	BSD-3-Clause	SQL	10–18	25
meta	0.4.0	Normalized, friendlier system catalog for PostgreSQL	STAT	BSD-2-Clause	SQL	14–18	24
sparql	1.0	Query SPARQL datasource with SQL	UTIL	Apache-2.0	SQL	14–18	23
pg_message_queue	0.2.1	Listen/Notify-based PostgreSQL message queue extension	FEAT	PostgreSQL	SQL	10–18	21
custom_properties	0.0.3	Supabase RLS helper tables and functions for managing user properties and custom claims.	SEC	—	SQL	—	20
pgbouncer_wrapper	1.2.2	Monitor and control the PgBouncer administration console through SQL views and functions backed by dblink_fdw	ADMIN	MIT	SQL	—	20
pg_stats	1.0	Customized statistics views	STAT	—	SQL	—	19
ast_postgis	1.1.1	Advanced spatial data types and spatial integrity constraints for PostGIS.	GIS	MIT	SQL	15–17	18
mpartman	0.1.1	Modern partition manager for PostgreSQL	OLAP	MIT-0	SQL	—	17
pg_doc_store	0.2.1	Provides a JSONB document-store API with full-text search.	FEAT	PostgreSQL	SQL	10–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
italian_fts	1.2	Italian full-text search dictionary	FTS	GPL-2.0	SQL	—	14
pg_dispatch	0.1.5	Asynchronous SQL dispatcher built on pg_cron	TIME	PostgreSQL	SQL	14–18	14
pg_part	0.1.0	Table partitioning utility for PostgreSQL	OLAP	GPL-2.0	SQL	—	14
webauthn	1.6	Pure-SQL PostgreSQL implementation of WebAuthn credential registration and assertion verification.	SEC	MIT	SQL	—	14
explanation	0.3.0	EXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree.	STAT	BSD-3-Clause	SQL	10–14	13
pg_dbms_metadata	1.0.0	Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL	SIM	PostgreSQL	SQL	14–18	13
pg_readme	0.7.1	Generate a Markdown README from PostgreSQL COMMENT objects	UTIL	PostgreSQL	SQL	14–18	13
pg_readme_test_extension	0.7.1	Fixture extension used to test pg_readme document generation	UTIL	PostgreSQL	SQL	14–18	13
veil2	0.9.3	Provides the basis for a Virtual Private Database implementation.	SEC	GPL-3.0	SQL	—	12
veil2_demo	0.9.3	Provides a demo database for the veil2 extension.	SEC	GPL-3.0	SQL	—	12
veil2_minimal_demo	0.9.3	Provides a minimal but complete demo database for the veil2 extension.	SEC	GPL-3.0	SQL	—	12
fuzzywuzzy	0.0.2	fuzzywuzzy ratio for postgres	FTS	PostgreSQL	SQL	—	11
generic_plan	1.0	Generate a generic plan for a parameterized SQL statement.	STAT	PostgreSQL	SQL	—	11
l10n_table_dependent_extension	0.8.3	PostgreSQL l10n toolbox	TYPE	PostgreSQL	SQL	14–18	11
pg_xenophile	0.8.3	More than the bare necessities for PostgreSQL i18n and l10n.	TYPE	PostgreSQL	SQL	14–18	11
tsp_semantic_headline	1.0	Phrase highlighting and improved semantics for ts_headline	FTS	GPL-3.0	SQL	14–18	11
lambda	1.0.5	Lambda function for Postgres	LANG	BSD-2-Clause	SQL	—	10
pg_audit	0.1.3	An extension for creating audit tables	SEC	BSD-2-Clause	SQL	10–18	10
pgsql_rrule	0.0.4	Pure SQL PostgreSQL data types and functions for parsing and expanding RFC 5545 recurrence rules.	TYPE	PostgreSQL	SQL	10–18	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
data2pg	0.7	Migration framework for discovering, copying, and comparing non-PostgreSQL database content through foreign data wrappers.	ETL	—	SQL	—	9
grants_manager	0.0.1	Declarative PL/pgSQL toolkit for snapshotting, reporting, and aligning database object grants.	SEC	—	SQL	—	9
json_query	0.9	Generate PostgreSQL WHERE clause predicates from JSONB filter objects.	FUNC	PostgreSQL	SQL	10–18	9

Quick links

PostgreSQL Extension Catalogue