License

Extensions by open-source license

License	MIT	ISC	PostgreSQL	BSD 0-Clause	BSD 2-Clause	BSD 3-Clause	Artistic	Apache-2.0	MPL-2.0
Permissive	71	6	213	2	14	30	3	80	1
License	GPL-2.0	GPL-3.0	LGPL-2.1	LGPL-3.0	AGPL-3.0	Timescale
Copyleft	14	15	1	2	10	2

MIT

Extensions using MIT license (71)

Extension	Package	Version	Type	Language	Description
`pg_task`	`pg_task`	`1.0.0`	TIME	C	execute any sql command at any specific time at background
`ogr_fdw`	`ogr_fdw`	`1.1.7`	GIS	C	foreign-data wrapper for GIS data access
`pg_polyline`	`pg_polyline`	`0.0.1`	GIS	Rust	Fast Google Encoded Polyline encoding & decoding for postgres
`pg_eviltransform`	`pg_eviltransform`	`0.0.2`	GIS	Rust	Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
`pg_geohash`	`pg_geohash`	`1.0`	GIS	C	Handle geohash based functionality for spatial coordinates
`tzf`	`pg_tzf`	`0.2.3`	GIS	Rust	Fast lookup timezone name by GPS coordinates
`pgml`	`pgml`	`2.10.0`	RAG	Rust	Run AL/ML workloads with SQL interface
`biscuit`	`pg_biscuit`	`2.2.2`	FTS	C	IAM-LIKE pattern matching with bitmap indexing
`pg_pinyin`	`pg_pinyin`	`0.0.2`	FTS	Rust	Pinyin romanization and search helpers for PostgreSQL
`pg_duckdb`	`pg_duckdb`	`1.1.1`	OLAP	C++	DuckDB Embedded in Postgres
`pg_mooncake`	`pg_mooncake`	`0.2.0`	OLAP	Rust	Columnstore Table in Postgres
`duckdb_fdw`	`duckdb_fdw`	`1.1.2`	OLAP	C	DuckDB Foreign Data Wrapper
`pg_cardano`	`pg_cardano`	`1.1.1`	FEAT	Rust	A suite of Cardano-related tools
`pllua`	`pllua`	`2.0.12`	LANG	C	Lua as a procedural language
`hstore_pllua`	`pllua`	`2.0.12`	LANG	C	Hstore transform for Lua
`plluau`	`pllua`	`2.0.12`	LANG	C	Lua as an untrusted procedural language
`hstore_plluau`	`pllua`	`2.0.12`	LANG	C	Hstore transform for untrusted Lua
`plpgsql_check`	`plpgsql_check`	`2.8.11`	LANG	C	extended check for plpgsql functions
`plsh`	`plsh`	`1.20220917`	LANG	C	PL/sh procedural language
`pglite_fusion`	`pglite_fusion`	`0.0.6`	TYPE	Rust	Embed an SQLite database in your PostgreSQL table
`currency`	`pg_currency`	`0.0.3`	TYPE	C	Custom PostgreSQL currency type in 1Byte
`pg_rational`	`pg_rational`	`0.0.2`	TYPE	C	bigint fractions
`pg_duration`	`pg_duration`	`1.0.2`	TYPE	C	data type for representing durations
`pg_rrule`	`pg_rrule`	`0.3.0`	TYPE	C	RRULE field type for PostgreSQL
`timestamp9`	`timestamp9`	`1.4.0`	TYPE	C	timestamp nanosecond resolution
`gzip`	`pg_gzip`	`1.0.0`	UTIL	C	gzip and gunzip functions.
`bzip`	`pg_bzip`	`1.0.0`	UTIL	C	Bzip compression and decompression
`http`	`pg_http`	`1.7.0`	UTIL	C	HTTP client for PostgreSQL, allows web page retrieval inside the database.
`pg_curl`	`pg_curl`	`2.4.5`	UTIL	C	Run curl actions for data transfer in URL syntax
`pgjq`	`pgjq`	`0.1.0`	UTIL	C	Use jq in Postgres
`pgjwt`	`pgjwt`	`0.2.0`	UTIL	SQL	JSON Web Token API for Postgresql
`pg_smtp_client`	`pg_smtp_client`	`0.2.1`	UTIL	Rust	PostgreSQL extension to send email using SMTP
`pg_protobuf`	`pg_protobuf`	`1.0`	UTIL	C	Protobuf support for PostgreSQL
`floatfile`	`floatfile`	`1.3.1`	UTIL	C	Simple file storage for arrays of floats
`pg_render`	`pg_render`	`0.1.3`	UTIL	Rust	Render HTML in SQL
`pgx_ulid`	`pgx_ulid`	`0.2.2`	FUNC	Rust	ulid type and methods
`pg_hashids`	`pg_hashids`	`1.3`	FUNC	C	Short unique id generator for PostgreSQL, using hashids
`sequential_uuids`	`sequential_uuids`	`1.0.3`	FUNC	C	generator of sequential UUIDs
`typeid`	`pg_typeid`	`0.3.0`	FUNC	Rust	Allows to use TypeIDs in Postgres natively
`floatvec`	`floatvec`	`1.1.1`	FUNC	C	Math for vectors (arrays) of numbers
`aggs_for_vecs`	`aggs_for_vecs`	`1.4.1`	FUNC	C	Aggregate functions for array inputs
`aggs_for_arrays`	`aggs_for_arrays`	`1.3.3`	FUNC	C	Various functions for computing statistics on arrays of numbers
`pg_csv`	`pg_csv`	`1.0.1`	FUNC	C	Flexible CSV processing for Postgres
`arraymath`	`pg_arraymath`	`1.1`	FUNC	C	Array math and operators that work element by element on the contents of arrays
`base36`	`pg_base36`	`1.0.0`	FUNC	C	Integer Base36 types
`base62`	`pg_base62`	`0.0.1`	FUNC	C	Base62 extension for PostgreSQL
`pg_base58`	`pg_base58`	`0.0.1`	FUNC	Rust	Base58 Encoder/Decoder Extension for PostgreSQL
`convert`	`pg_convert`	`0.1.0`	FUNC	Rust	conversion functions for spatial, routing and other specialized uses
`pgdd`	`pgdd`	`0.6.1`	ADMIN	Rust	Introspect pg data dictionary via standard SQL
`pg_strict`	`pg_strict`	`1.0.2`	ADMIN	Rust	Prevent dangerous UPDATE and DELETE without WHERE clause
`pg_tracing`	`pg_tracing`	`0.1.3`	STAT	C	Distributed Tracing for PostgreSQL
`pg_track_optimizer`	`pg_track_optimizer`	`0.9.1`	STAT	C	Track planning decisions in comparison with execution reality
`pgmeminfo`	`pgmeminfo`	`1.0.0`	STAT	C	show memory usage
`pagevis`	`pagevis`	`0.1`	STAT	SQL	Visualise database pages in ascii code
`pgsmcrypto`	`pgsmcrypto`	`0.1.1`	SEC	Rust	PostgreSQL SM Algorithm Extension
`pg_enigma`	`pg_enigma`	`0.5.0`	SEC	Rust	Encrypted postgres data type
`pg_auth_mon`	`pg_auth_mon`	`3.0`	SEC	C	monitor connection attempts per user
`credcheck`	`credcheck`	`4.6`	SEC	C	credcheck - postgresql plain text credential checker
`pg_pwhash`	`pg_pwhash`	`1.0`	SEC	C	Advanced password hashing methods for PostgreSQL
`pg_tde`	`pg_tde`	`2.1`	SEC	C	Percona pg_tde access method
`etcd_fdw`	`etcd_fdw`	`0.0.0`	FDW	Rust	Foreign data wrapper for etcd
`nominatim_fdw`	`nominatim_fdw`	`1.1.0`	FDW	C	Nominatim Foreign Data Wrapper for PostgreSQL
`redis`	`pg_redis_pubsub`	`0.0.1`	FDW	C	Send redis pub/sub messages to Redis from PostgreSQL Directly
`documentdb`	`documentdb`	`0.109`	SIM	C	API surface for DocumentDB for PostgreSQL
`documentdb_core`	`documentdb`	`0.109`	SIM	C	Core API surface for DocumentDB for PostgreSQL
`documentdb_distributed`	`documentdb`	`0.109`	SIM	C	Multi-Node API surface for DocumentDB
`documentdb_extended_rum`	`documentdb`	`0.109`	SIM	C	DocumentDB Extended RUM index access method
`pgmemcache`	`pgmemcache`	`2.3.0`	SIM	C	memcached interface
`pgl_ddl_deploy`	`pgl_ddl_deploy`	`2.2.1`	ETL	C	automated ddl deployment using pglogical
`decoderbufs`	`decoderbufs`	`3.4.1`	ETL	C	Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
`pg_fact_loader`	`pg_fact_loader`	`2.0.1`	ETL	C	build fact tables with Postgres

ISC

Extensions using ISC license (6)

Extension	Package	Version	Type	Language	Description
`pgq`	`pgq`	`3.5.1`	FEAT	C	Generic queue for PostgreSQL
`zstd`	`pg_zstd`	`1.1.2`	UTIL	C	Zstandard compression algorithm implementation in PostgreSQL
`safeupdate`	`safeupdate`	`1.5`	ADMIN	C	Require criteria for UPDATE and DELETE
`pgtt`	`pgtt`	`4.4`	SIM	C	Extension to add Global Temporary Tables feature to PostgreSQL
`pg_statement_rollback`	`pg_statement_rollback`	`1.5`	SIM	C	Server side rollback at statement level for PostgreSQL like Oracle or DB2
`pg_dbms_errlog`	`pg_dbms_errlog`	`2.2`	SIM	C	Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.

PostgreSQL

Extensions using PostgreSQL license (213)

Extension	Package	Version	Type	Language	Description
`timeseries`	`pg_timeseries`	`0.2.0`	TIME	SQL	Convenience API for time series stack
`periods`	`periods`	`1.2.3`	TIME	C	Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
`pg_cron`	`pg_cron`	`1.6.7`	TIME	C	Job scheduler for PostgreSQL
`pg_later`	`pg_later`	`0.4.0`	TIME	Rust	Run queries now and get results later
`earthdistance`	`earthdistance`	`1.2`	GIS	C	calculate great-circle distances on the surface of the Earth
`vector`	`pgvector`	`0.8.2`	RAG	C	vector data type and ivfflat and hnsw access methods
`vectorscale`	`pgvectorscale`	`0.9.0`	RAG	Rust	Advanced indexing for vector data with DiskANN
`vectorize`	`pg_vectorize`	`0.26.0`	RAG	Rust	The simplest way to do vector search on Postgres
`smlar`	`smlar`	`1.0`	RAG	C	Effective similarity search
`pg_summarize`	`pg_summarize`	`0.0.1`	RAG	Rust	Text Summarization using LLMs. Built using pgrx
`pgroonga`	`pgroonga`	`4.0.4`	FTS	C	Use Groonga as index, fast full text search platform for all languages!
`pgroonga_database`	`pgroonga`	`4.0.4`	FTS	C	PGroonga database management module
`pg_bigm`	`pg_bigm`	`1.2`	FTS	C	create 2-gram (bigram) index for faster full text search.
`zhparser`	`zhparser`	`2.3`	FTS	C	a parser for full-text search of Chinese
`pg_textsearch`	`pg_textsearch`	`0.5.0`	FTS	C	Full-text search with BM25 ranking
`hunspell_cs_cz`	`hunspell_cs_cz`	`1.0`	FTS	Data	Czech Hunspell Dictionary
`hunspell_de_de`	`hunspell_de_de`	`1.0`	FTS	Data	German Hunspell Dictionary
`hunspell_en_us`	`hunspell_en_us`	`1.0`	FTS	Data	en_US Hunspell Dictionary
`hunspell_fr`	`hunspell_fr`	`1.0`	FTS	Data	French Hunspell Dictionary
`hunspell_ne_np`	`hunspell_ne_np`	`1.0`	FTS	Data	Nepali Hunspell Dictionary
`hunspell_nl_nl`	`hunspell_nl_nl`	`1.0`	FTS	Data	Dutch Hunspell Dictionary
`hunspell_nn_no`	`hunspell_nn_no`	`1.0`	FTS	Data	Norwegian (norsk) Hunspell Dictionary
`hunspell_pt_pt`	`hunspell_pt_pt`	`1.0`	FTS	Data	Portuguese Hunspell Dictionary
`hunspell_ru_ru`	`hunspell_ru_ru`	`1.0`	FTS	Data	Russian Hunspell Dictionary
`hunspell_ru_ru_aot`	`hunspell_ru_ru_aot`	`1.0`	FTS	Data	Russian Hunspell Dictionary (from AOT.ru group)
`fuzzystrmatch`	`fuzzystrmatch`	`1.2`	FTS	C	determine similarities and distance between strings
`pg_trgm`	`pg_trgm`	`1.6`	FTS	C	text similarity measurement and index searching based on trigrams
`pg_analytics`	`pg_analytics`	`0.3.7`	OLAP	Rust	Postgres for analytics, powered by DuckDB
`pg_parquet`	`pg_parquet`	`0.5.1`	OLAP	Rust	copy data between Postgres and Parquet
`pg_partman`	`pg_partman`	`5.4.3`	OLAP	C	Extension to manage partitioned tables by time or ID
`pg_strom`	`pg_strom`	`6.1`	OLAP	C	PG-Strom - big-data processing acceleration using GPU and NVME
`tablefunc`	`tablefunc`	`1.0`	OLAP	C	functions that manipulate whole tables, including crosstab
`rum`	`rum`	`1.3.15`	FEAT	C	RUM index access method
`pg_ttl_index`	`pg_ttl_index`	`2.0.0`	FEAT	C	Automatic data expiration with TTL indexes
`jsquery`	`jsquery`	`1.2`	FEAT	C	data type for jsonb inspection
`hypopg`	`hypopg`	`1.4.2`	FEAT	C	Hypothetical indexes for PostgreSQL
`index_advisor`	`index_advisor`	`0.2.0`	FEAT	SQL	Query index advisor
`plan_filter`	`pg_plan_filter`	`0.0.1`	FEAT	C	filter statements by their execution plans.
`imgsmlr`	`imgsmlr`	`1.0`	FEAT	C	Image similarity with haar
`pg_ivm`	`pg_ivm`	`1.13`	FEAT	C	incremental view maintenance on PostgreSQL
`pg_incremental`	`pg_incremental`	`1.4.1`	FEAT	C	Incremental Processing by Crunchy Data
`pgmb`	`pgmb`	`1.0.0`	FEAT	SQL	A simple PostgreSQL Message Broker system
`pgmq`	`pgmq`	`1.11.0`	FEAT	SQL	A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
`orioledb`	`orioledb`	`1.6`	FEAT	C	OrioleDB, the next generation transactional engine
`bloom`	`bloom`	`1.0`	FEAT	C	bloom access method - signature file based index
`plv8`	`plv8`	`3.2.4`	LANG	C++	PL/JavaScript (v8) trusted procedural language
`pljs`	`pljs`	`1.0.5`	LANG	C	PL/JS trusted procedural language
`plxslt`	`plxslt`	`0.20140221`	LANG	C	XSLT procedural language for PostgreSQL
`pgtap`	`pgtap`	`1.3.4`	LANG	C	Unit testing for PostgreSQL
`faker`	`faker`	`0.5.3`	LANG	Python	Wrapper for the Faker Python library
`pltcl`	`pltcl`	`1.0`	LANG	C	PL/Tcl procedural language
`pltclu`	`pltcl`	`1.0`	LANG	C	PL/TclU untrusted procedural language
`plperl`	`plperl`	`1.0`	LANG	C	PL/Perl procedural language
`bool_plperl`	`plperl`	`1.0`	LANG	C	transform between bool and plperl
`hstore_plperl`	`plperl`	`1.0`	LANG	C	transform between hstore and plperl
`jsonb_plperl`	`plperl`	`1.0`	LANG	C	transform between jsonb and plperl
`plperlu`	`plperlu`	`1.0`	LANG	C	PL/PerlU untrusted procedural language
`bool_plperlu`	`plperlu`	`1.0`	LANG	C	transform between bool and plperlu
`jsonb_plperlu`	`plperlu`	`1.0`	LANG	C	transform between jsonb and plperlu
`hstore_plperlu`	`plperlu`	`1.0`	LANG	C	transform between hstore and plperlu
`plpgsql`	`plpgsql`	`1.0`	LANG	C	PL/pgSQL procedural language
`plpython3u`	`plpython3u`	`1.0`	LANG	C	PL/Python3U untrusted procedural language
`jsonb_plpython3u`	`plpython3u`	`1.0`	LANG	C	transform between jsonb and plpython3u
`ltree_plpython3u`	`plpython3u`	`1.0`	LANG	C	transform between ltree and plpython3u
`hstore_plpython3u`	`plpython3u`	`1.0`	LANG	C	transform between hstore and plpython3u
`prefix`	`pg_prefix`	`1.2.10`	TYPE	C	Prefix Range module for PostgreSQL
`semver`	`pg_semver`	`0.41.0`	TYPE	C	Semantic version data type
`country`	`pg_country`	`0.0.3`	TYPE	C	Country data type, ISO 3166-1
`pg_xenophile`	`pg_xenophile`	`0.8.3`	TYPE	SQL	More than the bare necessities for PostgreSQL i18n and l10n.
`l10n_table_dependent_extension`	`pg_xenophile`	`0.8.3`	TYPE	SQL	PostgreSQL l10n toolbox
`uint`	`pguint`	`1.20250815`	TYPE	C	unsigned integer types
`uint128`	`pg_uint128`	`1.2.0`	TYPE	C	Native uint128 type
`hashtypes`	`hashtypes`	`0.1.5`	TYPE	C	sha1, md5 and other data types for PostgreSQL
`ip4r`	`ip4r`	`2.4.2`	TYPE	C	IPv4/v6 and IPv4/v6 range index type for PostgreSQL
`uri`	`pg_uri`	`1.20251029`	TYPE	C	URI Data type for PostgreSQL
`emailaddr`	`pg_emailaddr`	`0`	TYPE	C	Email address type for PostgreSQL
`debversion`	`debversion`	`1.2.0`	TYPE	SQL	Debian version number data type
`chkpass`	`chkpass`	`1.0`	TYPE	C	data type for auto-encrypted passwords
`isn`	`isn`	`1.2`	TYPE	C	data types for international product numbering standards
`seg`	`seg`	`1.4`	TYPE	C	data type for representing line segments or floating-point intervals
`cube`	`cube`	`1.5`	TYPE	C	data type for multidimensional cubes
`ltree`	`ltree`	`1.3`	TYPE	C	data type for hierarchical tree-like structures
`hstore`	`hstore`	`1.8`	TYPE	C	data type for storing sets of (key, value) pairs
`citext`	`citext`	`1.6`	TYPE	C	data type for case-insensitive character strings
`xml2`	`xml2`	`1.1`	TYPE	C	XPath querying and XSLT
`pg_retry`	`pg_retry`	`1.0.0`	UTIL	C	Retry SQL statements on transient errors with exponential backoff
`pg_html5_email_address`	`pg_html5_email_address`	`1.2.3`	UTIL	SQL	PostgreSQL email validation that is consistent with the HTML5 spec
`url_encode`	`url_encode`	`1.2.5`	UTIL	C	url_encode, url_decode functions
`pgsql_tweaks`	`pgsql_tweaks`	`1.0.2`	UTIL	SQL	Some functions and views for daily usage
`pg_extra_time`	`pg_extra_time`	`2.0.0`	UTIL	SQL	Some date time functions and operators that,
`pgpcre`	`pgpcre`	`0.20190509`	UTIL	C	Perl Compatible Regular Expression functions
`icu_ext`	`icu_ext`	`1.10.0`	UTIL	C	Access ICU functions
`envvar`	`pg_envvar`	`1.0.1`	UTIL	C	Fetch the value of an environment variable
`pg_readme`	`pg_readme`	`0.7.0`	UTIL	C	Generate a README.md document for a database extension or schema
`pg_readme_test_extension`	`pg_readme`	`0.7.0`	UTIL	C	Test generating a README.md document for extension or schema
`data_historization`	`data_historization`	`1.1.0`	UTIL	SQL	PLPGSQL Script to historize data in partitionned table
`hashlib`	`pg_hashlib`	`1.1`	UTIL	C	Stable hash functions for Postgres
`shacrypt`	`shacrypt`	`1.1`	UTIL	C	Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
`cryptint`	`cryptint`	`1.0.0`	UTIL	C	Encryption functions for int and bigint values
`permuteseq`	`permuteseq`	`1.2.2`	FUNC	C	Pseudo-randomly permute sequences with a format-preserving encryption on elements
`snowflake`	`snowflake`	`2.4`	FUNC	C	Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL
`omnisketch`	`omnisketch`	`1.0.2`	FUNC	C	data structure for on-line agg of data into approximate sketch
`ddsketch`	`ddsketch`	`1.0.1`	FUNC	C	Provides ddsketch aggregate function
`weighted_statistics`	`pg_weighted_statistics`	`1.0.0`	FUNC	C	High-performance weighted statistics functions for sparse data
`first_last_agg`	`first_last_agg`	`0.1.4`	FUNC	C	first() and last() aggregate functions
`extra_window_functions`	`extra_window_functions`	`1.0`	FUNC	C	Extra Window Functions for PostgreSQL
`random`	`pg_random`	`2.0.0`	FUNC	C	random data generator
`financial`	`pg_financial`	`1.0.1`	FUNC	C	Financial aggregate functions
`refint`	`refint`	`1.0`	FUNC	C	functions for implementing referential integrity (obsolete)
`autoinc`	`autoinc`	`1.0`	FUNC	C	functions for autoincrementing fields
`insert_username`	`insert_username`	`1.0`	FUNC	C	functions for tracking who changed a table
`moddatetime`	`moddatetime`	`1.0`	FUNC	C	functions for tracking last modification time
`tsm_system_time`	`tsm_system_time`	`1.0`	FUNC	C	TABLESAMPLE method which accepts time in milliseconds as a limit
`dict_xsyn`	`dict_xsyn`	`1.0`	FUNC	C	text search dictionary template for extended synonym processing
`tsm_system_rows`	`tsm_system_rows`	`1.0`	FUNC	C	TABLESAMPLE method which accepts number of rows as a limit
`tcn`	`tcn`	`1.0`	FUNC	C	Triggered change notifications
`uuid-ossp`	`uuid-ossp`	`1.1`	FUNC	C	generate universally unique identifiers (UUIDs)
`btree_gist`	`btree_gist`	`1.7`	FUNC	C	support for indexing common datatypes in GiST
`btree_gin`	`btree_gin`	`1.3`	FUNC	C	support for indexing common datatypes in GIN
`intarray`	`intarray`	`1.5`	FUNC	C	functions, operators, and index support for 1-D arrays of integers
`intagg`	`intagg`	`1.1`	FUNC	C	integer aggregator and enumerator (obsolete)
`dict_int`	`dict_int`	`1.0`	FUNC	C	text search dictionary template for integers
`unaccent`	`unaccent`	`1.1`	FUNC	C	text search dictionary that removes accents
`pg_repack`	`pg_repack`	`1.5.3`	ADMIN	C	Reorganize tables in PostgreSQL databases with minimal locks
`ddlx`	`pg_ddlx`	`0.30`	ADMIN	SQL	DDL eXtractor functions
`pglinter`	`pglinter`	`1.1.1`	ADMIN	Rust	PostgreSQL Linting and Analysis Extension
`prioritize`	`pg_prioritize`	`1.0.4`	ADMIN	C	get and set the priority of PostgreSQL backends
`pg_readonly`	`pg_readonly`	`1.0.4`	ADMIN	C	cluster database read only
`pgautofailover`	`pgautofailover`	`2.2`	ADMIN	C	pg_auto_failover
`pre_prepare`	`preprepare`	`0.9`	ADMIN	C	Pre Prepare your Statement server side
`pg_upless`	`pg_upless`	`0.0.3`	ADMIN	SQL	Detect Useless UPDATE
`pgcozy`	`pgcozy`	`1.0`	ADMIN	SQL	Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
`pg_orphaned`	`pg_orphaned`	`1.0`	ADMIN	C	Deal with orphaned files
`pg_cheat_funcs`	`pg_cheat_funcs`	`1.0`	ADMIN	C	Provides cheat (but useful) functions
`pg_drop_events`	`pg_drop_events`	`0.1.0`	ADMIN	SQL	logs transaction ids of drop table, drop column, drop materialized view statements
`table_log`	`table_log`	`0.6.4`	ADMIN	C	record table modification logs and PITR for table/row
`pgagent`	`pgagent`	`4.2.3`	ADMIN	C	A PostgreSQL job scheduler
`pg_prewarm`	`pg_prewarm`	`1.2`	ADMIN	C	prewarm relation data
`pgpool_adm`	`pgpool`	`4.7.1`	ADMIN	C	Administrative functions for pgPool
`pgpool_recovery`	`pgpool`	`4.7.1`	ADMIN	C	recovery functions for pgpool-II for V4.3
`pgpool_regclass`	`pgpool`	`4.7.1`	ADMIN	C	replacement for regclass
`lo`	`lo`	`1.1`	ADMIN	C	Large Object maintenance
`basic_archive`	`basic_archive`	`-`	ADMIN	C	an example of an archive module
`basebackup_to_shell`	`basebackup_to_shell`	`-`	ADMIN	C	adds a custom basebackup target called shell
`old_snapshot`	`old_snapshot`	`1.0`	ADMIN	C	utilities in support of old_snapshot_threshold
`adminpack`	`adminpack`	`2.1`	ADMIN	C	administrative functions for PostgreSQL
`amcheck`	`amcheck`	`1.4`	ADMIN	C	functions for verifying relation integrity
`pg_surgery`	`pg_surgery`	`1.0`	ADMIN	C	extension to perform surgery on a damaged relation
`pg_show_plans`	`pg_show_plans`	`2.1.7`	STAT	C	show query plans of all currently running SQL statements
`pg_track_settings`	`pg_track_settings`	`2.1.2`	STAT	SQL	Track settings changes
`pg_wait_sampling`	`pg_wait_sampling`	`1.1.9`	STAT	C	sampling based statistics of wait events
`pgsentinel`	`pgsentinel`	`1.4.0`	STAT	C	active session history
`system_stats`	`system_stats`	`3.2`	STAT	C	EnterpriseDB system statistics for PostgreSQL
`bgw_replstatus`	`bgw_replstatus`	`1.0.8`	STAT	C	Small PostgreSQL background worker to report whether a node is a replication master or standby
`toastinfo`	`toastinfo`	`1.5`	STAT	C	show details on toasted datums
`explain_ui`	`pg_explain_ui`	`0.0.2`	STAT	Rust	easily jump into a visual plan UI for any SQL query
`pg_relusage`	`pg_relusage`	`0.0.1`	STAT	C	Log all the queries that reference a particular column
`powa`	`powa`	`5.1.1`	STAT	Python	PostgreSQL Workload Analyser-core
`pg_overexplain`	`pg_overexplain`	`1.0`	STAT	C	Allow EXPLAIN to dump even more details
`pg_logicalinspect`	`pg_logicalinspect`	`1.0`	STAT	C	Logical decoding components inspection
`pageinspect`	`pageinspect`	`1.12`	STAT	C	inspect the contents of database pages at a low level
`pgrowlocks`	`pgrowlocks`	`1.2`	STAT	C	show row-level locking information
`sslinfo`	`sslinfo`	`1.2`	STAT	C	information about SSL certificates
`pg_buffercache`	`pg_buffercache`	`1.5`	STAT	C	examine the shared buffer cache
`pg_walinspect`	`pg_walinspect`	`1.1`	STAT	C	functions to inspect contents of PostgreSQL Write-Ahead Log
`pg_freespacemap`	`pg_freespacemap`	`1.2`	STAT	C	examine the free space map (FSM)
`pg_visibility`	`pg_visibility`	`1.2`	STAT	C	examine the visibility map (VM) and page-level visibility info
`pgstattuple`	`pgstattuple`	`1.5`	STAT	C	show tuple-level statistics
`auto_explain`	`auto_explain`	`-`	STAT	C	Provides a means for logging execution plans of slow statements automatically
`pg_stat_statements`	`pg_stat_statements`	`1.11`	STAT	C	track planning and execution statistics of all SQL statements executed
`anon`	`pg_anon`	`3.0.1`	SEC	Rust	PostgreSQL Anonymizer (anon) extension
`pgaudit`	`pgaudit`	`18.0`	SEC	C	provides auditing functionality
`pgauditlogtofile`	`pgauditlogtofile`	`1.8.0`	SEC	C	pgAudit addon to redirect audit log to an independent file
`pg_jobmon`	`pg_jobmon`	`1.4.1`	SEC	SQL	Extension for logging and monitoring functions in PostgreSQL
`pgcryptokey`	`pgcryptokey`	`0.85`	SEC	C	cryptographic key management
`set_user`	`set_user`	`4.2.0`	SEC	C	similar to SET ROLE but with added logging
`pg_snakeoil`	`pg_snakeoil`	`1.4`	SEC	C	The PostgreSQL Antivirus
`pgextwlist`	`pgextwlist`	`1.19`	SEC	C	PostgreSQL Extension Whitelisting
`sslutils`	`sslutils`	`1.4`	SEC	C	A Postgres extension for managing SSL certificates through SQL
`sepgsql`	`sepgsql`	`-`	SEC	C	label-based mandatory access control (MAC) based on SELinux security policy.
`auth_delay`	`auth_delay`	`-`	SEC	C	pause briefly before reporting authentication failure
`pgcrypto`	`pgcrypto`	`1.3`	SEC	C	cryptographic functions
`passwordcheck`	`passwordcheck`	`-`	SEC	C	checks user passwords and reject weak password
`multicorn`	`multicorn`	`3.2`	FDW	C	Fetch foreign data in Python in your PostgreSQL server.
`odbc_fdw`	`odbc_fdw`	`0.5.1`	FDW	C	Foreign data wrapper for accessing remote databases using ODBC
`jdbc_fdw`	`jdbc_fdw`	`0.4.0`	FDW	C	foreign-data wrapper for remote servers available over JDBC
`pgspider_ext`	`pgspider_ext`	`1.3.0`	FDW	C	foreign-data wrapper for remote PGSpider servers
`oracle_fdw`	`oracle_fdw`	`2.8.0`	FDW	C	foreign data wrapper for Oracle access
`tds_fdw`	`tds_fdw`	`2.0.5`	FDW	C	Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
`db2_fdw`	`db2_fdw`	`18.1.1`	FDW	C	foreign data wrapper for DB2 access
`sqlite_fdw`	`sqlite_fdw`	`2.5.0`	FDW	C	SQLite Foreign Data Wrapper
`pgbouncer_fdw`	`pgbouncer_fdw`	`1.4.0`	FDW	SQL	Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
`informix_fdw`	`informix_fdw`	`0.6.3`	FDW	C	Foreign data wrapper for Informix access
`redis_fdw`	`redis_fdw`	`1.0`	FDW	C	Foreign data wrapper for querying a Redis server
`kafka_fdw`	`kafka_fdw`	`0.0.3`	FDW	C	kafka Foreign Data Wrapper for CSV formatted messages
`firebird_fdw`	`firebird_fdw`	`1.4.1`	FDW	C	Foreign data wrapper for Firebird
`dblink`	`dblink`	`1.2`	FDW	C	connect to other PostgreSQL databases from within a database
`file_fdw`	`file_fdw`	`1.0`	FDW	C	foreign-data wrapper for flat file access
`postgres_fdw`	`postgres_fdw`	`1.1`	FDW	C	foreign-data wrapper for remote PostgreSQL servers
`pg_dbms_metadata`	`pg_dbms_metadata`	`1.0.0`	SIM	SQL	Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
`pg_dbms_lock`	`pg_dbms_lock`	`1.0`	SIM	SQL	Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
`pg_dbms_job`	`pg_dbms_job`	`1.5`	SIM	SQL	Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
`pg_utl_smtp`	`pg_utl_smtp`	`1.0.0`	SIM	SQL	Oracle UTL_SMTP compatibility extension for PostgreSQL
`pglogical`	`pglogical`	`2.4.6`	ETL	C	PostgreSQL Logical Replication
`pglogical_origin`	`pglogical`	`2.4.6`	ETL	C	Dummy extension for compatibility when upgrading from Postgres 9.4
`pglogical_ticker`	`pglogical_ticker`	`1.4.1`	ETL	C	Have an accurate view on pglogical replication delay
`pg_failover_slots`	`pg_failover_slots`	`1.2.0`	ETL	C	PG Failover Slots extension
`spock`	`spock`	`5.0.5`	ETL	C	Multi-master logical replication extension for PostgreSQL
`lolor`	`lolor`	`1.2.2`	ETL	C	Logical-replication-friendly replacement for PostgreSQL large objects
`decoder_raw`	`decoder_raw`	`1.0`	ETL	C	Output plugin for logical replication in Raw SQL format
`mimeo`	`mimeo`	`1.5.1`	ETL	SQL	Extension for specialized, per-table replication between PostgreSQL instances
`test_decoding`	`test_decoding`	`-`	ETL	C	SQL-based test/example module for WAL logical decoding
`pgoutput`	`pgoutput`	`-`	ETL	C	Logical Replication output plugin

BSD 0-Clause

Extensions using BSD 0-Clause license (2)

Extension	Package	Version	Type	Language	Description
`plproxy`	`plproxy`	`2.11.0`	OLAP	C	Database partitioning implemented as procedural language
`orafce`	`orafce`	`4.16.5`	SIM	C	Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS

BSD 2-Clause

Extensions using BSD 2-Clause license (14)

Extension	Package	Version	Type	Language	Description
`temporal_tables`	`temporal_tables`	`1.2.2`	TIME	C	temporal tables
`geoip`	`geoip`	`0.3.0`	GIS	SQL	IP-based geolocation query
`md5hash`	`md5hash`	`1.0.1`	TYPE	C	type for storing 128-bit binary data inline
`acl`	`pg_acl`	`1.0.4`	TYPE	C	ACL Data type
`xxhash`	`pg_xxhash`	`0.0.1`	UTIL	C	xxhash functions for PostgreSQL
`pguecc`	`pg_ecdsa`	`1.0`	UTIL	C	uECC bindings for Postgres
`quantile`	`quantile`	`1.1.8`	FUNC	C	Quantile aggregation function
`lower_quantile`	`lower_quantile`	`1.0.3`	FUNC	C	Lower quantile aggregate function
`count_distinct`	`count_distinct`	`3.0.2`	FUNC	C	An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
`pg_squeeze`	`pg_squeeze`	`1.9.1`	ADMIN	C	A tool to remove unused space from a relation.
`pg_checksums`	`pg_checksums`	`1.3`	ADMIN	C	Activate/deactivate/verify checksums in offline Postgres clusters
`pg_permissions`	`pg_permissions`	`1.4`	ADMIN	SQL	view object permissions and compare them with the desired state
`pg_profile`	`pg_profile`	`4.11`	STAT	C	PostgreSQL load profile repository and report builder
`meta`	`pg_meta`	`0.4.0`	STAT	SQL	Normalized, friendlier system catalog for PostgreSQL

BSD 3-Clause

Extensions using BSD 3-Clause license (30)

Extension	Package	Version	Type	Language	Description
`table_version`	`table_version`	`1.11.1`	TIME	SQL	PostgreSQL table versioning extension
`pointcloud`	`pointcloud`	`1.2.5`	GIS	C	data type for lidar point clouds
`pointcloud_postgis`	`pointcloud`	`1.2.5`	GIS	C	integration for pointcloud LIDAR data and PostGIS geometry data
`pg_similarity`	`pg_similarity`	`1.0`	RAG	C	support similarity queries
`pg_hint_plan`	`pg_hint_plan`	`1.8.0`	FEAT	C	Give PostgreSQL ability to manually force some decisions in execution plans.
`rdkit`	`rdkit`	`202503.1`	FEAT	C++	Cheminformatics functionality for PostgreSQL.
`pljava`	`pljava`	`1.6.10`	LANG	Java	PL/Java procedural language
`pgfaceting`	`pgfaceting`	`0.2.0`	TYPE	SQL	fast faceting queries using an inverted index
`pg_sphere`	`pgsphere`	`1.5.2`	TYPE	C	spherical objects with useful functions, operators and index support
`pgqr`	`pgqr`	`1.0`	UTIL	C	QR Code generator from PostgreSQL
`pg_rewrite`	`pg_rewrite`	`2.1.0`	ADMIN	C	Tool allows read write to the table during the rewriting
`pg_dirtyread`	`pg_dirtyread`	`2.7`	ADMIN	C	Read dead but unvacuumed rows from table
`pgfincore`	`pgfincore`	`1.3.1`	ADMIN	C	examine and manage the os buffer cache
`pg_catcheck`	`pg_catcheck`	`1.6.0`	ADMIN	C	Diagnosing system catalog corruption
`pg_crash`	`pg_crash`	`1.0`	ADMIN	C	Send random signals to random processes
`fio`	`pg_fio`	`1.0`	ADMIN	C	PostgreSQL File I/O Functions
`pg_stat_kcache`	`pg_stat_kcache`	`2.3.1`	STAT	C	Kernel statistics gathering
`pg_stat_monitor`	`pg_stat_monitor`	`2.3.2`	STAT	C	The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
`pg_qualstats`	`pg_qualstats`	`2.1.3`	STAT	C	An extension collecting statistics about quals
`pg_store_plans`	`pg_store_plans`	`1.9`	STAT	C	track plan statistics of all SQL statements executed
`pg_proctab`	`pgnodemx`	`1.7`	STAT	C	PostgreSQL extension to access the OS process table
`pg_sqlog`	`pg_sqlog`	`1.6`	STAT	SQL	Provide SQL interface to logs
`pgsodium`	`pgsodium`	`3.1.9`	SEC	C	Postgres extension for libsodium functions
`pg_auditor`	`pg_auditor`	`0.2`	SEC	SQL	Audit data changes and provide flashback ability
`logerrors`	`logerrors`	`2.1.5`	SEC	C	Function for collecting statistics about messages in logfile
`mysql_fdw`	`mysql_fdw`	`2.9.3`	FDW	C	Foreign data wrapper for querying a MySQL server
`hdfs_fdw`	`hdfs_fdw`	`2.3.3`	FDW	C	foreign-data wrapper for remote hdfs servers
`db_migrator`	`db_migrator`	`1.0.0`	ETL	SQL	Tools to migrate other databases to PostgreSQL
`wal2json`	`wal2json`	`2.6`	ETL	C	Changing data capture in JSON format
`pg_bulkload`	`pg_bulkload`	`3.1.23`	ETL	C	pg_bulkload is a high speed data loading utility for PostgreSQL

Artistic

Extensions using Artistic license (3)

Extension	Package	Version	Type	Language	Description
`pldbgapi`	`pldebugger`	`1.9`	LANG	C	server-side support for debugging PL/pgSQL functions
`plprofiler`	`plprofiler`	`4.2.5`	LANG	C	server-side support for profiling PL/pgSQL functions
`dbt2`	`dbt2`	`0.61.7`	LANG	C	OSDL-DBT-2 test kit

Apache-2.0

Extensions using Apache-2.0 license (80)

Extension	Package	Version	Type	Language	Description
`h3`	`pg_h3`	`4.2.3`	GIS	C	H3 bindings for PostgreSQL
`h3_postgis`	`pg_h3`	`4.2.3`	GIS	C	H3 PostGIS integration
`pg_tiktoken`	`pg_tiktoken`	`0.0.1`	RAG	Rust	tiktoken tokenizer for use with OpenAI models in postgres
`pg_bestmatch`	`pg_bestmatch`	`0.0.2`	FTS	Rust	Generate BM25 sparse vector inside PostgreSQL
`pg_tokenizer`	`pg_tokenizer`	`0.1.1`	FTS	Rust	Tokenizers for full-text search
`pg_clickhouse`	`pg_clickhouse`	`0.1.4`	OLAP	C++	Interfaces to query ClickHouse databases from PostgreSQL
`age`	`age`	`1.7.0`	FEAT	C	AGE graph database extension
`hll`	`hll`	`2.19`	FEAT	C++	type for storing hyperloglog data
`pg_ai_query`	`pg_ai_query`	`0.1.1`	FEAT	C++	AI-powered SQL query generation for PostgreSQL
`pg_graphql`	`pg_graphql`	`1.5.12`	FEAT	Rust	Add in-database GraphQL support
`pg_jsonschema`	`pg_jsonschema`	`0.3.4`	FEAT	Rust	PostgreSQL extension providing JSON Schema validation
`omni`	`omnigres`	`0.2.14`	FEAT	C	Advanced adapter for Postgres extensions
`omni_auth`	`omnigres`	`0.1.3`	FEAT	C	Basic session management
`omni_aws`	`omnigres`	`0.1.2`	FEAT	C	Amazon Web Services APIs (S3)
`omni_cloudevents`	`omnigres`	`0.1.0`	FEAT	C	CloudEvents support
`omni_containers`	`omnigres`	`0.2.0`	FEAT	C	Docker container management
`omni_credentials`	`omnigres`	`0.2.0`	FEAT	C	Application credential management
`omni_csv`	`omni_csv`	`0.1.1`	FEAT	C	CSV toolkit
`omni_datasets`	`omni_datasets`	`0.1.0`	FEAT	C	Dataset provisioning
`omni_email`	`omnigres`	`0.1.0`	FEAT	C	E-mail framework
`omni_http`	`omnigres`	`0.1.0`	FEAT	C	Basic HTTP types
`omni_httpc`	`omnigres`	`0.1.10`	FEAT	C	HTTP client
`omni_httpd`	`omnigres`	`0.4.11`	FEAT	C	HTTP server
`omni_id`	`omnigres`	`0.4.3`	FEAT	C	Identity types
`omni_json`	`omnigres`	`0.1.1`	FEAT	C	JSON toolkit
`omni_kube`	`omnigres`	`0.4.2`	FEAT	C	Kubernetes (k8s) integration
`omni_ledger`	`omnigres`	`0.1.3`	FEAT	C	Financial ledger
`omni_manifest`	`omnigres`	`0.1.2`	FEAT	C	Package installation manifests
`omni_mimetypes`	`omnigres`	`0.1.0`	FEAT	C	MIME types
`omni_os`	`omnigres`	`0.1.1`	FEAT	C	Operating system integration
`omni_polyfill`	`omnigres`	`0.2.2`	FEAT	C	Postgres API polyfills
`omni_python`	`omnigres`	`0.1.1`	FEAT	C	First-class Python support
`omni_regex`	`omnigres`	`0.1.0`	FEAT	C	PCRE-compatible regular expressions
`omni_rest`	`omnigres`	`0.1.1`	FEAT	C	REST API toolkit (with PostgREST support)
`omni_schema`	`omnigres`	`0.3.0`	FEAT	C	Advanced schema management tooling
`omni_seq`	`omnigres`	`0.1.1`	FEAT	C	Distributed integer sequences
`omni_service`	`omnigres`	`0.1.0`	FEAT	C	Service management
`omni_session`	`omnigres`	`0.2.0`	FEAT	C	Session management
`omni_shmem`	`omni_shmem`	`0.1.0`	FEAT	C	Shared Memory Management
`omni_sql`	`omnigres`	`0.5.3`	FEAT	C	Programmatic SQL manipulation
`omni_sqlite`	`omnigres`	`0.2.2`	FEAT	C	Embedded SQLite
`omni_test`	`omnigres`	`0.4.0`	FEAT	C	Testing framework
`omni_txn`	`omnigres`	`0.5.0`	FEAT	C	Transaction management
`omni_types`	`omnigres`	`0.3.6`	FEAT	C	Advanced types
`omni_var`	`omnigres`	`0.3.0`	FEAT	C	Scoped variables
`omni_vfs`	`omnigres`	`0.2.2`	FEAT	C	Virtual File System
`omni_vfs_types_v1`	`omnigres`	`0.1.0`	FEAT	C	Virtual File System types (v1)
`omni_web`	`omnigres`	`0.3.0`	FEAT	C	Common web stack primitives
`omni_worker`	`omnigres`	`0.2.1`	FEAT	C	Generalized worker pool
`omni_xml`	`omnigres`	`0.1.2`	FEAT	C	XML toolkit
`omni_yaml`	`omnigres`	`0.1.0`	FEAT	C	YAML toolkit
`pg_tle`	`pg_tle`	`1.5.2`	LANG	C	Trusted Language Extensions for PostgreSQL
`plprql`	`plprql`	`18.0.1`	LANG	Rust	Use PRQL in PostgreSQL - Pipelined Relational Query Language
`roaringbitmap`	`pg_roaringbitmap`	`1.1.0`	TYPE	C	support for Roaring Bitmaps
`collection`	`pgcollection`	`1.1.1`	TYPE	C	Memory optimized data type to be used inside of plpglsql func
`pg_net`	`pg_net`	`0.20.2`	UTIL	C	Async HTTP Requests
`sparql`	`pgsparql`	`1.0`	UTIL	SQL	Query SPARQL datasource with SQL
`pg_idkit`	`pg_idkit`	`0.4.0`	FUNC	Rust	multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
`tdigest`	`tdigest`	`1.4.3`	FUNC	C	Provides tdigest aggregate function.
`pg_cooldown`	`pg_cooldown`	`0.1`	ADMIN	C	remove buffered pages for specific relations
`pg_savior`	`pg_savior`	`0.0.1`	ADMIN	C	Postgres extension to save OOPS mistakes
`pgnodemx`	`pgnodemx`	`1.7`	STAT	C	Capture node OS metrics via SQL queries
`supautils`	`supautils`	`3.1.0`	SEC	C	Extension that secures a cluster on a cloud environment
`supabase_vault`	`pg_vault`	`0.3.1`	SEC	C	Supabase Vault Extension
`pg_session_jwt`	`pg_session_jwt`	`0.4.0`	SEC	Rust	Manage authentication sessions using JWTs
`wrappers`	`wrappers`	`0.5.7`	FDW	Rust	Foreign data wrappers developed by Supabase
`aws_s3`	`aws_s3`	`0.0.1`	FDW	SQL	aws_s3 postgres extension to import/export data from/to s3
`log_fdw`	`log_fdw`	`1.4`	FDW	C	foreign-data wrapper for Postgres log file access
`ivorysql_ora`	`ivorysql`	`1.0`	SIM	C	Oracle Compatible extension on Postgres Database
`ora_btree_gin`	`ivorysql`	`1.0`	SIM	C	Support for indexing oracle datatypes in GIN
`ora_btree_gist`	`ivorysql`	`1.0`	SIM	C	Support for oracle indexing common datatypes in GiST
`pg_get_functiondef`	`ivorysql`	`1.0`	SIM	C	Get function’s definition
`plisql`	`ivorysql`	`1.0`	SIM	C	PL/iSQL procedural language
`gb18030_2022`	`ivorysql`	`1.0`	SIM	C	Support GB18030-2022 and UTF-8 conversion
`babelfishpg_common`	`babelfish`	`5.5.0`	SIM	C	SQL Server Transact SQL Datatype Support
`babelfishpg_tsql`	`babelfish`	`5.5.0`	SIM	C	SQL Server Transact SQL compatibility
`babelfishpg_tds`	`babelfish`	`1.0.0`	SIM	C	SQL Server TDS protocol extension
`babelfishpg_money`	`babelfish`	`1.1.0`	SIM	C	SQL Server Money Data Type
`pgactive`	`pgactive`	`2.1.7`	ETL	C	Active-Active Replication Extension for PostgreSQL
`wal2mongo`	`wal2mongo`	`1.0.7`	ETL	C	PostgreSQL logical decoding output plugin for MongoDB

MPL-2.0

Extensions using MPL-2.0 license (1)

Extension	Package	Version	Type	Language	Description
`pg_uuidv7`	`pg_uuidv7`	`1.7.0`	FUNC	C	Create UUIDv7 values in postgres

GPL-2.0

Extensions using GPL-2.0 license (14)

Extension	Package	Version	Type	Language	Description
`postgis`	`postgis`	`3.6.2`	GIS	C	PostGIS geometry and geography spatial types and functions
`postgis_topology`	`postgis`	`3.6.2`	GIS	C	PostGIS topology spatial types and functions
`postgis_raster`	`postgis`	`3.6.2`	GIS	C	PostGIS raster types and functions
`postgis_sfcgal`	`postgis`	`3.6.2`	GIS	C	PostGIS SFCGAL functions
`postgis_tiger_geocoder`	`postgis`	`3.6.2`	GIS	C	PostGIS tiger geocoder and reverse geocoder
`address_standardizer`	`postgis`	`3.6.2`	GIS	C	Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
`address_standardizer_data_us`	`postgis`	`3.6.2`	GIS	C	Address Standardizer US dataset example
`pgrouting`	`pgrouting`	`4.0.1`	GIS	C++	pgRouting Extension
`q3c`	`q3c`	`2.0.2`	GIS	C	q3c sky indexing plugin
`pg_fkpart`	`pg_fkpart`	`1.7.0`	OLAP	SQL	Table partitioning by foreign key utility
`plr`	`plr`	`8.4.8`	LANG	C	load R interpreter and execute R script from within a database
`unit`	`pgunit`	`7.10`	TYPE	C	SI units extension
`numeral`	`numeral`	`1.3`	TYPE	C	numeral datatypes extension
`ddl_historization`	`ddl_historization`	`0.0.7`	UTIL	SQL	Historize the ddl changes inside PostgreSQL database

GPL-3.0

Extensions using GPL-3.0 license (15)

Extension	Package	Version	Type	Language	Description
`emaj`	`emaj`	`4.7.1`	TIME	SQL	Enables fine-grained write logging and time travel on subsets of the database.
`pg_background`	`pg_background`	`1.8`	TIME	C	Run SQL queries in the background
`mobilitydb`	`mobilitydb`	`1.3.0`	GIS	C	MobilityDB geospatial trajectory data management & analysis platform
`mobilitydb_datagen`	`mobilitydb`	`1.3.0`	GIS	SQL	MobilityDB random data generator functions
`pgpdf`	`pgpdf`	`0.1.0`	TYPE	C	PDF type with meta admin & Full-Text Search
`asn1oid`	`asn1oid`	`1.6`	TYPE	C	asn1oid extension
`schedoc`	`pg_schedoc`	`0.0.1`	UTIL	SQL	Cross documentation between Django and DBT projects
`vasco`	`vasco`	`0.1.0`	FUNC	C	discover hidden correlations in your data with MIC
`xicor`	`pgxicor`	`0.1.0`	FUNC	C	XI Correlation Coefficient in Postgres
`pg_math`	`pg_math`	`1.1.0`	FUNC	C	GSL statistical functions for postgresql
`qos`	`pg_qos`	`1.0`	ADMIN	C	QoS resource governor extension for PostgreSQL sessions and queries
`login_hook`	`login_hook`	`1.7`	SEC	C	login_hook - hook to execute login_hook.login() at login time
`session_variable`	`session_variable`	`3.4`	SIM	C	Registration and manipulation of session variables and constants
`aux_mysql`	`openhalo`	`1.5`	SIM	C	MySQL Supplementary Extension
`repmgr`	`repmgr`	`5.5.0`	ETL	C	Replication manager for PostgreSQL

LGPL-2.1

Extensions using LGPL-2.1 license (1)

Extension	Package	Version	Type	Language	Description
`passwordcheck_cracklib`	`passwordcheck_cracklib`	`3.1.0`	SEC	C	Strengthen PostgreSQL user password checks with cracklib

LGPL-3.0

Extensions using LGPL-3.0 license (2)

Extension	Package	Version	Type	Language	Description
`pgmp`	`pgmp`	`1.0.5`	TYPE	C	Multiple Precision Arithmetic extension
`mongo_fdw`	`mongo_fdw`	`5.5.3`	FDW	C	foreign data wrapper for MongoDB access

AGPL-3.0

Extensions using AGPL-3.0 license (10)

Extension	Package	Version	Type	Language	Description
`vchord`	`vchord`	`1.1.1`	RAG	Rust	Vector database plugin for Postgres, written in Rust
`pg4ml`	`pg4ml`	`2.0`	RAG	C	Machine learning framework for PostgreSQL
`pg_search`	`pg_search`	`0.21.12`	FTS	Rust	Full text search for PostgreSQL using BM25
`vchord_bm25`	`vchord_bm25`	`0.3.0`	FTS	Rust	A postgresql extension for bm25 ranking algorithm
`citus`	`citus`	`14.0.0`	OLAP	C	Distributed PostgreSQL as an extension
`citus_columnar`	`citus`	`14.0.0`	OLAP	C	Citus columnar storage engine
`columnar`	`hydra`	`1.1.2`	OLAP	C	Hydra Columnar extension
`topn`	`topn`	`2.7.0`	FUNC	C	type for top-n JSONB
`noset`	`pg_noset`	`0.3.0`	SEC	C	Module for blocking SET variables for non-super users.
`spat`	`spat`	`0.1.0a4`	SIM	C	Redis-like In-Memory DB Embedded in Postgres

Timescale

Extensions using Timescale license (2)

Extension	Package	Version	Type	Language	Description
`timescaledb`	`timescaledb`	`2.25.2`	TIME	C	Enables scalable inserts and complex queries for time-series data
`timescaledb_toolkit`	`timescaledb_toolkit`	`1.22.0`	TIME	Rust	Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities

Feedback

Was this page helpful?

Thanks for the feedback! Please let us know how we can improve.

Sorry to hear that. Please let us know how we can improve.

Last Modified 2026-03-12: add pg extension catalog (95749bf)