Language

Extensions by programming language

Language	C	Rust	SQL	Data	C++	Python	Java
Count	363	41	40	10	7	2	1

C

Extensions written in C (363)

Extension	Package	Version	Type	License	Description
`timescaledb`	`timescaledb`	`2.25.2`	TIME	Timescale	Enables scalable inserts and complex queries for time-series data
`periods`	`periods`	`1.2.3`	TIME	PostgreSQL	Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
`temporal_tables`	`temporal_tables`	`1.2.2`	TIME	BSD 2-Clause	temporal tables
`pg_cron`	`pg_cron`	`1.6.7`	TIME	PostgreSQL	Job scheduler for PostgreSQL
`pg_task`	`pg_task`	`1.0.0`	TIME	MIT	execute any sql command at any specific time at background
`pg_background`	`pg_background`	`1.8`	TIME	GPL-3.0	Run SQL queries in the background
`postgis`	`postgis`	`3.6.2`	GIS	GPL-2.0	PostGIS geometry and geography spatial types and functions
`postgis_topology`	`postgis`	`3.6.2`	GIS	GPL-2.0	PostGIS topology spatial types and functions
`postgis_raster`	`postgis`	`3.6.2`	GIS	GPL-2.0	PostGIS raster types and functions
`postgis_sfcgal`	`postgis`	`3.6.2`	GIS	GPL-2.0	PostGIS SFCGAL functions
`postgis_tiger_geocoder`	`postgis`	`3.6.2`	GIS	GPL-2.0	PostGIS tiger geocoder and reverse geocoder
`address_standardizer`	`postgis`	`3.6.2`	GIS	GPL-2.0	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	GPL-2.0	Address Standardizer US dataset example
`pointcloud`	`pointcloud`	`1.2.5`	GIS	BSD 3-Clause	data type for lidar point clouds
`pointcloud_postgis`	`pointcloud`	`1.2.5`	GIS	BSD 3-Clause	integration for pointcloud LIDAR data and PostGIS geometry data
`h3`	`pg_h3`	`4.2.3`	GIS	Apache-2.0	H3 bindings for PostgreSQL
`h3_postgis`	`pg_h3`	`4.2.3`	GIS	Apache-2.0	H3 PostGIS integration
`q3c`	`q3c`	`2.0.2`	GIS	GPL-2.0	q3c sky indexing plugin
`ogr_fdw`	`ogr_fdw`	`1.1.7`	GIS	MIT	foreign-data wrapper for GIS data access
`pg_geohash`	`pg_geohash`	`1.0`	GIS	MIT	Handle geohash based functionality for spatial coordinates
`mobilitydb`	`mobilitydb`	`1.3.0`	GIS	GPL-3.0	MobilityDB geospatial trajectory data management & analysis platform
`earthdistance`	`earthdistance`	`1.2`	GIS	PostgreSQL	calculate great-circle distances on the surface of the Earth
`vector`	`pgvector`	`0.8.2`	RAG	PostgreSQL	vector data type and ivfflat and hnsw access methods
`pg_similarity`	`pg_similarity`	`1.0`	RAG	BSD 3-Clause	support similarity queries
`smlar`	`smlar`	`1.0`	RAG	PostgreSQL	Effective similarity search
`pg4ml`	`pg4ml`	`2.0`	RAG	AGPL-3.0	Machine learning framework for PostgreSQL
`pgroonga`	`pgroonga`	`4.0.4`	FTS	PostgreSQL	Use Groonga as index, fast full text search platform for all languages!
`pgroonga_database`	`pgroonga`	`4.0.4`	FTS	PostgreSQL	PGroonga database management module
`pg_bigm`	`pg_bigm`	`1.2`	FTS	PostgreSQL	create 2-gram (bigram) index for faster full text search.
`zhparser`	`zhparser`	`2.3`	FTS	PostgreSQL	a parser for full-text search of Chinese
`biscuit`	`pg_biscuit`	`2.2.2`	FTS	MIT	IAM-LIKE pattern matching with bitmap indexing
`pg_textsearch`	`pg_textsearch`	`0.5.0`	FTS	PostgreSQL	Full-text search with BM25 ranking
`fuzzystrmatch`	`fuzzystrmatch`	`1.2`	FTS	PostgreSQL	determine similarities and distance between strings
`pg_trgm`	`pg_trgm`	`1.6`	FTS	PostgreSQL	text similarity measurement and index searching based on trigrams
`citus`	`citus`	`14.0.0`	OLAP	AGPL-3.0	Distributed PostgreSQL as an extension
`citus_columnar`	`citus`	`14.0.0`	OLAP	AGPL-3.0	Citus columnar storage engine
`columnar`	`hydra`	`1.1.2`	OLAP	AGPL-3.0	Hydra Columnar extension
`duckdb_fdw`	`duckdb_fdw`	`1.1.2`	OLAP	MIT	DuckDB Foreign Data Wrapper
`pg_partman`	`pg_partman`	`5.4.3`	OLAP	PostgreSQL	Extension to manage partitioned tables by time or ID
`plproxy`	`plproxy`	`2.11.0`	OLAP	BSD 0-Clause	Database partitioning implemented as procedural language
`pg_strom`	`pg_strom`	`6.1`	OLAP	PostgreSQL	PG-Strom - big-data processing acceleration using GPU and NVME
`tablefunc`	`tablefunc`	`1.0`	OLAP	PostgreSQL	functions that manipulate whole tables, including crosstab
`age`	`age`	`1.7.0`	FEAT	Apache-2.0	AGE graph database extension
`rum`	`rum`	`1.3.15`	FEAT	PostgreSQL	RUM index access method
`pg_ttl_index`	`pg_ttl_index`	`2.0.0`	FEAT	PostgreSQL	Automatic data expiration with TTL indexes
`jsquery`	`jsquery`	`1.2`	FEAT	PostgreSQL	data type for jsonb inspection
`pg_hint_plan`	`pg_hint_plan`	`1.8.0`	FEAT	BSD 3-Clause	Give PostgreSQL ability to manually force some decisions in execution plans.
`hypopg`	`hypopg`	`1.4.2`	FEAT	PostgreSQL	Hypothetical indexes for PostgreSQL
`plan_filter`	`pg_plan_filter`	`0.0.1`	FEAT	PostgreSQL	filter statements by their execution plans.
`imgsmlr`	`imgsmlr`	`1.0`	FEAT	PostgreSQL	Image similarity with haar
`pg_ivm`	`pg_ivm`	`1.13`	FEAT	PostgreSQL	incremental view maintenance on PostgreSQL
`pg_incremental`	`pg_incremental`	`1.4.1`	FEAT	PostgreSQL	Incremental Processing by Crunchy Data
`pgq`	`pgq`	`3.5.1`	FEAT	ISC	Generic queue for PostgreSQL
`orioledb`	`orioledb`	`1.6`	FEAT	PostgreSQL	OrioleDB, the next generation transactional engine
`omni`	`omnigres`	`0.2.14`	FEAT	Apache-2.0	Advanced adapter for Postgres extensions
`omni_auth`	`omnigres`	`0.1.3`	FEAT	Apache-2.0	Basic session management
`omni_aws`	`omnigres`	`0.1.2`	FEAT	Apache-2.0	Amazon Web Services APIs (S3)
`omni_cloudevents`	`omnigres`	`0.1.0`	FEAT	Apache-2.0	CloudEvents support
`omni_containers`	`omnigres`	`0.2.0`	FEAT	Apache-2.0	Docker container management
`omni_credentials`	`omnigres`	`0.2.0`	FEAT	Apache-2.0	Application credential management
`omni_csv`	`omni_csv`	`0.1.1`	FEAT	Apache-2.0	CSV toolkit
`omni_datasets`	`omni_datasets`	`0.1.0`	FEAT	Apache-2.0	Dataset provisioning
`omni_email`	`omnigres`	`0.1.0`	FEAT	Apache-2.0	E-mail framework
`omni_http`	`omnigres`	`0.1.0`	FEAT	Apache-2.0	Basic HTTP types
`omni_httpc`	`omnigres`	`0.1.10`	FEAT	Apache-2.0	HTTP client
`omni_httpd`	`omnigres`	`0.4.11`	FEAT	Apache-2.0	HTTP server
`omni_id`	`omnigres`	`0.4.3`	FEAT	Apache-2.0	Identity types
`omni_json`	`omnigres`	`0.1.1`	FEAT	Apache-2.0	JSON toolkit
`omni_kube`	`omnigres`	`0.4.2`	FEAT	Apache-2.0	Kubernetes (k8s) integration
`omni_ledger`	`omnigres`	`0.1.3`	FEAT	Apache-2.0	Financial ledger
`omni_manifest`	`omnigres`	`0.1.2`	FEAT	Apache-2.0	Package installation manifests
`omni_mimetypes`	`omnigres`	`0.1.0`	FEAT	Apache-2.0	MIME types
`omni_os`	`omnigres`	`0.1.1`	FEAT	Apache-2.0	Operating system integration
`omni_polyfill`	`omnigres`	`0.2.2`	FEAT	Apache-2.0	Postgres API polyfills
`omni_python`	`omnigres`	`0.1.1`	FEAT	Apache-2.0	First-class Python support
`omni_regex`	`omnigres`	`0.1.0`	FEAT	Apache-2.0	PCRE-compatible regular expressions
`omni_rest`	`omnigres`	`0.1.1`	FEAT	Apache-2.0	REST API toolkit (with PostgREST support)
`omni_schema`	`omnigres`	`0.3.0`	FEAT	Apache-2.0	Advanced schema management tooling
`omni_seq`	`omnigres`	`0.1.1`	FEAT	Apache-2.0	Distributed integer sequences
`omni_service`	`omnigres`	`0.1.0`	FEAT	Apache-2.0	Service management
`omni_session`	`omnigres`	`0.2.0`	FEAT	Apache-2.0	Session management
`omni_shmem`	`omni_shmem`	`0.1.0`	FEAT	Apache-2.0	Shared Memory Management
`omni_sql`	`omnigres`	`0.5.3`	FEAT	Apache-2.0	Programmatic SQL manipulation
`omni_sqlite`	`omnigres`	`0.2.2`	FEAT	Apache-2.0	Embedded SQLite
`omni_test`	`omnigres`	`0.4.0`	FEAT	Apache-2.0	Testing framework
`omni_txn`	`omnigres`	`0.5.0`	FEAT	Apache-2.0	Transaction management
`omni_types`	`omnigres`	`0.3.6`	FEAT	Apache-2.0	Advanced types
`omni_var`	`omnigres`	`0.3.0`	FEAT	Apache-2.0	Scoped variables
`omni_vfs`	`omnigres`	`0.2.2`	FEAT	Apache-2.0	Virtual File System
`omni_vfs_types_v1`	`omnigres`	`0.1.0`	FEAT	Apache-2.0	Virtual File System types (v1)
`omni_web`	`omnigres`	`0.3.0`	FEAT	Apache-2.0	Common web stack primitives
`omni_worker`	`omnigres`	`0.2.1`	FEAT	Apache-2.0	Generalized worker pool
`omni_xml`	`omnigres`	`0.1.2`	FEAT	Apache-2.0	XML toolkit
`omni_yaml`	`omnigres`	`0.1.0`	FEAT	Apache-2.0	YAML toolkit
`bloom`	`bloom`	`1.0`	FEAT	PostgreSQL	bloom access method - signature file based index
`pg_tle`	`pg_tle`	`1.5.2`	LANG	Apache-2.0	Trusted Language Extensions for PostgreSQL
`pljs`	`pljs`	`1.0.5`	LANG	PostgreSQL	PL/JS trusted procedural language
`pllua`	`pllua`	`2.0.12`	LANG	MIT	Lua as a procedural language
`hstore_pllua`	`pllua`	`2.0.12`	LANG	MIT	Hstore transform for Lua
`plluau`	`pllua`	`2.0.12`	LANG	MIT	Lua as an untrusted procedural language
`hstore_plluau`	`pllua`	`2.0.12`	LANG	MIT	Hstore transform for untrusted Lua
`pldbgapi`	`pldebugger`	`1.9`	LANG	Artistic	server-side support for debugging PL/pgSQL functions
`plpgsql_check`	`plpgsql_check`	`2.8.11`	LANG	MIT	extended check for plpgsql functions
`plprofiler`	`plprofiler`	`4.2.5`	LANG	Artistic	server-side support for profiling PL/pgSQL functions
`plsh`	`plsh`	`1.20220917`	LANG	MIT	PL/sh procedural language
`plr`	`plr`	`8.4.8`	LANG	GPL-2.0	load R interpreter and execute R script from within a database
`plxslt`	`plxslt`	`0.20140221`	LANG	PostgreSQL	XSLT procedural language for PostgreSQL
`pgtap`	`pgtap`	`1.3.4`	LANG	PostgreSQL	Unit testing for PostgreSQL
`dbt2`	`dbt2`	`0.61.7`	LANG	Artistic	OSDL-DBT-2 test kit
`pltcl`	`pltcl`	`1.0`	LANG	PostgreSQL	PL/Tcl procedural language
`pltclu`	`pltcl`	`1.0`	LANG	PostgreSQL	PL/TclU untrusted procedural language
`plperl`	`plperl`	`1.0`	LANG	PostgreSQL	PL/Perl procedural language
`bool_plperl`	`plperl`	`1.0`	LANG	PostgreSQL	transform between bool and plperl
`hstore_plperl`	`plperl`	`1.0`	LANG	PostgreSQL	transform between hstore and plperl
`jsonb_plperl`	`plperl`	`1.0`	LANG	PostgreSQL	transform between jsonb and plperl
`plperlu`	`plperlu`	`1.0`	LANG	PostgreSQL	PL/PerlU untrusted procedural language
`bool_plperlu`	`plperlu`	`1.0`	LANG	PostgreSQL	transform between bool and plperlu
`jsonb_plperlu`	`plperlu`	`1.0`	LANG	PostgreSQL	transform between jsonb and plperlu
`hstore_plperlu`	`plperlu`	`1.0`	LANG	PostgreSQL	transform between hstore and plperlu
`plpgsql`	`plpgsql`	`1.0`	LANG	PostgreSQL	PL/pgSQL procedural language
`plpython3u`	`plpython3u`	`1.0`	LANG	PostgreSQL	PL/Python3U untrusted procedural language
`jsonb_plpython3u`	`plpython3u`	`1.0`	LANG	PostgreSQL	transform between jsonb and plpython3u
`ltree_plpython3u`	`plpython3u`	`1.0`	LANG	PostgreSQL	transform between ltree and plpython3u
`hstore_plpython3u`	`plpython3u`	`1.0`	LANG	PostgreSQL	transform between hstore and plpython3u
`prefix`	`pg_prefix`	`1.2.10`	TYPE	PostgreSQL	Prefix Range module for PostgreSQL
`semver`	`pg_semver`	`0.41.0`	TYPE	PostgreSQL	Semantic version data type
`unit`	`pgunit`	`7.10`	TYPE	GPL-2.0	SI units extension
`pgpdf`	`pgpdf`	`0.1.0`	TYPE	GPL-3.0	PDF type with meta admin & Full-Text Search
`md5hash`	`md5hash`	`1.0.1`	TYPE	BSD 2-Clause	type for storing 128-bit binary data inline
`asn1oid`	`asn1oid`	`1.6`	TYPE	GPL-3.0	asn1oid extension
`roaringbitmap`	`pg_roaringbitmap`	`1.1.0`	TYPE	Apache-2.0	support for Roaring Bitmaps
`pg_sphere`	`pgsphere`	`1.5.2`	TYPE	BSD 3-Clause	spherical objects with useful functions, operators and index support
`country`	`pg_country`	`0.0.3`	TYPE	PostgreSQL	Country data type, ISO 3166-1
`currency`	`pg_currency`	`0.0.3`	TYPE	MIT	Custom PostgreSQL currency type in 1Byte
`collection`	`pgcollection`	`1.1.1`	TYPE	Apache-2.0	Memory optimized data type to be used inside of plpglsql func
`pgmp`	`pgmp`	`1.0.5`	TYPE	LGPL-3.0	Multiple Precision Arithmetic extension
`numeral`	`numeral`	`1.3`	TYPE	GPL-2.0	numeral datatypes extension
`pg_rational`	`pg_rational`	`0.0.2`	TYPE	MIT	bigint fractions
`uint`	`pguint`	`1.20250815`	TYPE	PostgreSQL	unsigned integer types
`uint128`	`pg_uint128`	`1.2.0`	TYPE	PostgreSQL	Native uint128 type
`hashtypes`	`hashtypes`	`0.1.5`	TYPE	PostgreSQL	sha1, md5 and other data types for PostgreSQL
`ip4r`	`ip4r`	`2.4.2`	TYPE	PostgreSQL	IPv4/v6 and IPv4/v6 range index type for PostgreSQL
`pg_duration`	`pg_duration`	`1.0.2`	TYPE	MIT	data type for representing durations
`uri`	`pg_uri`	`1.20251029`	TYPE	PostgreSQL	URI Data type for PostgreSQL
`emailaddr`	`pg_emailaddr`	`0`	TYPE	PostgreSQL	Email address type for PostgreSQL
`acl`	`pg_acl`	`1.0.4`	TYPE	BSD 2-Clause	ACL Data type
`pg_rrule`	`pg_rrule`	`0.3.0`	TYPE	MIT	RRULE field type for PostgreSQL
`timestamp9`	`timestamp9`	`1.4.0`	TYPE	MIT	timestamp nanosecond resolution
`chkpass`	`chkpass`	`1.0`	TYPE	PostgreSQL	data type for auto-encrypted passwords
`isn`	`isn`	`1.2`	TYPE	PostgreSQL	data types for international product numbering standards
`seg`	`seg`	`1.4`	TYPE	PostgreSQL	data type for representing line segments or floating-point intervals
`cube`	`cube`	`1.5`	TYPE	PostgreSQL	data type for multidimensional cubes
`ltree`	`ltree`	`1.3`	TYPE	PostgreSQL	data type for hierarchical tree-like structures
`hstore`	`hstore`	`1.8`	TYPE	PostgreSQL	data type for storing sets of (key, value) pairs
`citext`	`citext`	`1.6`	TYPE	PostgreSQL	data type for case-insensitive character strings
`xml2`	`xml2`	`1.1`	TYPE	PostgreSQL	XPath querying and XSLT
`gzip`	`pg_gzip`	`1.0.0`	UTIL	MIT	gzip and gunzip functions.
`bzip`	`pg_bzip`	`1.0.0`	UTIL	MIT	Bzip compression and decompression
`zstd`	`pg_zstd`	`1.1.2`	UTIL	ISC	Zstandard compression algorithm implementation in PostgreSQL
`http`	`pg_http`	`1.7.0`	UTIL	MIT	HTTP client for PostgreSQL, allows web page retrieval inside the database.
`pg_net`	`pg_net`	`0.20.2`	UTIL	Apache-2.0	Async HTTP Requests
`pg_curl`	`pg_curl`	`2.4.5`	UTIL	MIT	Run curl actions for data transfer in URL syntax
`pg_retry`	`pg_retry`	`1.0.0`	UTIL	PostgreSQL	Retry SQL statements on transient errors with exponential backoff
`pgjq`	`pgjq`	`0.1.0`	UTIL	MIT	Use jq in Postgres
`url_encode`	`url_encode`	`1.2.5`	UTIL	PostgreSQL	url_encode, url_decode functions
`pgpcre`	`pgpcre`	`0.20190509`	UTIL	PostgreSQL	Perl Compatible Regular Expression functions
`icu_ext`	`icu_ext`	`1.10.0`	UTIL	PostgreSQL	Access ICU functions
`pgqr`	`pgqr`	`1.0`	UTIL	BSD 3-Clause	QR Code generator from PostgreSQL
`pg_protobuf`	`pg_protobuf`	`1.0`	UTIL	MIT	Protobuf support for PostgreSQL
`envvar`	`pg_envvar`	`1.0.1`	UTIL	PostgreSQL	Fetch the value of an environment variable
`floatfile`	`floatfile`	`1.3.1`	UTIL	MIT	Simple file storage for arrays of floats
`pg_readme`	`pg_readme`	`0.7.0`	UTIL	PostgreSQL	Generate a README.md document for a database extension or schema
`pg_readme_test_extension`	`pg_readme`	`0.7.0`	UTIL	PostgreSQL	Test generating a README.md document for extension or schema
`hashlib`	`pg_hashlib`	`1.1`	UTIL	PostgreSQL	Stable hash functions for Postgres
`xxhash`	`pg_xxhash`	`0.0.1`	UTIL	BSD 2-Clause	xxhash functions for PostgreSQL
`shacrypt`	`shacrypt`	`1.1`	UTIL	PostgreSQL	Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
`cryptint`	`cryptint`	`1.0.0`	UTIL	PostgreSQL	Encryption functions for int and bigint values
`pguecc`	`pg_ecdsa`	`1.0`	UTIL	BSD 2-Clause	uECC bindings for Postgres
`pg_uuidv7`	`pg_uuidv7`	`1.7.0`	FUNC	MPL-2.0	Create UUIDv7 values in postgres
`permuteseq`	`permuteseq`	`1.2.2`	FUNC	PostgreSQL	Pseudo-randomly permute sequences with a format-preserving encryption on elements
`pg_hashids`	`pg_hashids`	`1.3`	FUNC	MIT	Short unique id generator for PostgreSQL, using hashids
`sequential_uuids`	`sequential_uuids`	`1.0.3`	FUNC	MIT	generator of sequential UUIDs
`snowflake`	`snowflake`	`2.4`	FUNC	PostgreSQL	Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL
`topn`	`topn`	`2.7.0`	FUNC	AGPL-3.0	type for top-n JSONB
`quantile`	`quantile`	`1.1.8`	FUNC	BSD 2-Clause	Quantile aggregation function
`lower_quantile`	`lower_quantile`	`1.0.3`	FUNC	BSD 2-Clause	Lower quantile aggregate function
`count_distinct`	`count_distinct`	`3.0.2`	FUNC	BSD 2-Clause	An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
`omnisketch`	`omnisketch`	`1.0.2`	FUNC	PostgreSQL	data structure for on-line agg of data into approximate sketch
`ddsketch`	`ddsketch`	`1.0.1`	FUNC	PostgreSQL	Provides ddsketch aggregate function
`vasco`	`vasco`	`0.1.0`	FUNC	GPL-3.0	discover hidden correlations in your data with MIC
`xicor`	`pgxicor`	`0.1.0`	FUNC	GPL-3.0	XI Correlation Coefficient in Postgres
`weighted_statistics`	`pg_weighted_statistics`	`1.0.0`	FUNC	PostgreSQL	High-performance weighted statistics functions for sparse data
`tdigest`	`tdigest`	`1.4.3`	FUNC	Apache-2.0	Provides tdigest aggregate function.
`first_last_agg`	`first_last_agg`	`0.1.4`	FUNC	PostgreSQL	first() and last() aggregate functions
`extra_window_functions`	`extra_window_functions`	`1.0`	FUNC	PostgreSQL	Extra Window Functions for PostgreSQL
`floatvec`	`floatvec`	`1.1.1`	FUNC	MIT	Math for vectors (arrays) of numbers
`aggs_for_vecs`	`aggs_for_vecs`	`1.4.1`	FUNC	MIT	Aggregate functions for array inputs
`aggs_for_arrays`	`aggs_for_arrays`	`1.3.3`	FUNC	MIT	Various functions for computing statistics on arrays of numbers
`pg_csv`	`pg_csv`	`1.0.1`	FUNC	MIT	Flexible CSV processing for Postgres
`arraymath`	`pg_arraymath`	`1.1`	FUNC	MIT	Array math and operators that work element by element on the contents of arrays
`pg_math`	`pg_math`	`1.1.0`	FUNC	GPL-3.0	GSL statistical functions for postgresql
`random`	`pg_random`	`2.0.0`	FUNC	PostgreSQL	random data generator
`base36`	`pg_base36`	`1.0.0`	FUNC	MIT	Integer Base36 types
`base62`	`pg_base62`	`0.0.1`	FUNC	MIT	Base62 extension for PostgreSQL
`financial`	`pg_financial`	`1.0.1`	FUNC	PostgreSQL	Financial aggregate functions
`refint`	`refint`	`1.0`	FUNC	PostgreSQL	functions for implementing referential integrity (obsolete)
`autoinc`	`autoinc`	`1.0`	FUNC	PostgreSQL	functions for autoincrementing fields
`insert_username`	`insert_username`	`1.0`	FUNC	PostgreSQL	functions for tracking who changed a table
`moddatetime`	`moddatetime`	`1.0`	FUNC	PostgreSQL	functions for tracking last modification time
`tsm_system_time`	`tsm_system_time`	`1.0`	FUNC	PostgreSQL	TABLESAMPLE method which accepts time in milliseconds as a limit
`dict_xsyn`	`dict_xsyn`	`1.0`	FUNC	PostgreSQL	text search dictionary template for extended synonym processing
`tsm_system_rows`	`tsm_system_rows`	`1.0`	FUNC	PostgreSQL	TABLESAMPLE method which accepts number of rows as a limit
`tcn`	`tcn`	`1.0`	FUNC	PostgreSQL	Triggered change notifications
`uuid-ossp`	`uuid-ossp`	`1.1`	FUNC	PostgreSQL	generate universally unique identifiers (UUIDs)
`btree_gist`	`btree_gist`	`1.7`	FUNC	PostgreSQL	support for indexing common datatypes in GiST
`btree_gin`	`btree_gin`	`1.3`	FUNC	PostgreSQL	support for indexing common datatypes in GIN
`intarray`	`intarray`	`1.5`	FUNC	PostgreSQL	functions, operators, and index support for 1-D arrays of integers
`intagg`	`intagg`	`1.1`	FUNC	PostgreSQL	integer aggregator and enumerator (obsolete)
`dict_int`	`dict_int`	`1.0`	FUNC	PostgreSQL	text search dictionary template for integers
`unaccent`	`unaccent`	`1.1`	FUNC	PostgreSQL	text search dictionary that removes accents
`pg_repack`	`pg_repack`	`1.5.3`	ADMIN	PostgreSQL	Reorganize tables in PostgreSQL databases with minimal locks
`pg_rewrite`	`pg_rewrite`	`2.1.0`	ADMIN	BSD 3-Clause	Tool allows read write to the table during the rewriting
`pg_squeeze`	`pg_squeeze`	`1.9.1`	ADMIN	BSD 2-Clause	A tool to remove unused space from a relation.
`pg_dirtyread`	`pg_dirtyread`	`2.7`	ADMIN	BSD 3-Clause	Read dead but unvacuumed rows from table
`pgfincore`	`pgfincore`	`1.3.1`	ADMIN	BSD 3-Clause	examine and manage the os buffer cache
`pg_cooldown`	`pg_cooldown`	`0.1`	ADMIN	Apache-2.0	remove buffered pages for specific relations
`prioritize`	`pg_prioritize`	`1.0.4`	ADMIN	PostgreSQL	get and set the priority of PostgreSQL backends
`pg_checksums`	`pg_checksums`	`1.3`	ADMIN	BSD 2-Clause	Activate/deactivate/verify checksums in offline Postgres clusters
`pg_readonly`	`pg_readonly`	`1.0.4`	ADMIN	PostgreSQL	cluster database read only
`pgautofailover`	`pgautofailover`	`2.2`	ADMIN	PostgreSQL	pg_auto_failover
`pg_catcheck`	`pg_catcheck`	`1.6.0`	ADMIN	BSD 3-Clause	Diagnosing system catalog corruption
`pre_prepare`	`preprepare`	`0.9`	ADMIN	PostgreSQL	Pre Prepare your Statement server side
`pg_orphaned`	`pg_orphaned`	`1.0`	ADMIN	PostgreSQL	Deal with orphaned files
`pg_crash`	`pg_crash`	`1.0`	ADMIN	BSD 3-Clause	Send random signals to random processes
`pg_cheat_funcs`	`pg_cheat_funcs`	`1.0`	ADMIN	PostgreSQL	Provides cheat (but useful) functions
`fio`	`pg_fio`	`1.0`	ADMIN	BSD 3-Clause	PostgreSQL File I/O Functions
`qos`	`pg_qos`	`1.0`	ADMIN	GPL-3.0	QoS resource governor extension for PostgreSQL sessions and queries
`pg_savior`	`pg_savior`	`0.0.1`	ADMIN	Apache-2.0	Postgres extension to save OOPS mistakes
`safeupdate`	`safeupdate`	`1.5`	ADMIN	ISC	Require criteria for UPDATE and DELETE
`table_log`	`table_log`	`0.6.4`	ADMIN	PostgreSQL	record table modification logs and PITR for table/row
`pgagent`	`pgagent`	`4.2.3`	ADMIN	PostgreSQL	A PostgreSQL job scheduler
`pg_prewarm`	`pg_prewarm`	`1.2`	ADMIN	PostgreSQL	prewarm relation data
`pgpool_adm`	`pgpool`	`4.7.1`	ADMIN	PostgreSQL	Administrative functions for pgPool
`pgpool_recovery`	`pgpool`	`4.7.1`	ADMIN	PostgreSQL	recovery functions for pgpool-II for V4.3
`pgpool_regclass`	`pgpool`	`4.7.1`	ADMIN	PostgreSQL	replacement for regclass
`lo`	`lo`	`1.1`	ADMIN	PostgreSQL	Large Object maintenance
`basic_archive`	`basic_archive`	`-`	ADMIN	PostgreSQL	an example of an archive module
`basebackup_to_shell`	`basebackup_to_shell`	`-`	ADMIN	PostgreSQL	adds a custom basebackup target called shell
`old_snapshot`	`old_snapshot`	`1.0`	ADMIN	PostgreSQL	utilities in support of old_snapshot_threshold
`adminpack`	`adminpack`	`2.1`	ADMIN	PostgreSQL	administrative functions for PostgreSQL
`amcheck`	`amcheck`	`1.4`	ADMIN	PostgreSQL	functions for verifying relation integrity
`pg_surgery`	`pg_surgery`	`1.0`	ADMIN	PostgreSQL	extension to perform surgery on a damaged relation
`pg_profile`	`pg_profile`	`4.11`	STAT	BSD 2-Clause	PostgreSQL load profile repository and report builder
`pg_tracing`	`pg_tracing`	`0.1.3`	STAT	MIT	Distributed Tracing for PostgreSQL
`pg_show_plans`	`pg_show_plans`	`2.1.7`	STAT	PostgreSQL	show query plans of all currently running SQL statements
`pg_stat_kcache`	`pg_stat_kcache`	`2.3.1`	STAT	BSD 3-Clause	Kernel statistics gathering
`pg_stat_monitor`	`pg_stat_monitor`	`2.3.2`	STAT	BSD 3-Clause	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	BSD 3-Clause	An extension collecting statistics about quals
`pg_store_plans`	`pg_store_plans`	`1.9`	STAT	BSD 3-Clause	track plan statistics of all SQL statements executed
`pg_track_optimizer`	`pg_track_optimizer`	`0.9.1`	STAT	MIT	Track planning decisions in comparison with execution reality
`pg_wait_sampling`	`pg_wait_sampling`	`1.1.9`	STAT	PostgreSQL	sampling based statistics of wait events
`pgsentinel`	`pgsentinel`	`1.4.0`	STAT	PostgreSQL	active session history
`system_stats`	`system_stats`	`3.2`	STAT	PostgreSQL	EnterpriseDB system statistics for PostgreSQL
`pgnodemx`	`pgnodemx`	`1.7`	STAT	Apache-2.0	Capture node OS metrics via SQL queries
`pg_proctab`	`pgnodemx`	`1.7`	STAT	BSD 3-Clause	PostgreSQL extension to access the OS process table
`bgw_replstatus`	`bgw_replstatus`	`1.0.8`	STAT	PostgreSQL	Small PostgreSQL background worker to report whether a node is a replication master or standby
`pgmeminfo`	`pgmeminfo`	`1.0.0`	STAT	MIT	show memory usage
`toastinfo`	`toastinfo`	`1.5`	STAT	PostgreSQL	show details on toasted datums
`pg_relusage`	`pg_relusage`	`0.0.1`	STAT	PostgreSQL	Log all the queries that reference a particular column
`pg_overexplain`	`pg_overexplain`	`1.0`	STAT	PostgreSQL	Allow EXPLAIN to dump even more details
`pg_logicalinspect`	`pg_logicalinspect`	`1.0`	STAT	PostgreSQL	Logical decoding components inspection
`pageinspect`	`pageinspect`	`1.12`	STAT	PostgreSQL	inspect the contents of database pages at a low level
`pgrowlocks`	`pgrowlocks`	`1.2`	STAT	PostgreSQL	show row-level locking information
`sslinfo`	`sslinfo`	`1.2`	STAT	PostgreSQL	information about SSL certificates
`pg_buffercache`	`pg_buffercache`	`1.5`	STAT	PostgreSQL	examine the shared buffer cache
`pg_walinspect`	`pg_walinspect`	`1.1`	STAT	PostgreSQL	functions to inspect contents of PostgreSQL Write-Ahead Log
`pg_freespacemap`	`pg_freespacemap`	`1.2`	STAT	PostgreSQL	examine the free space map (FSM)
`pg_visibility`	`pg_visibility`	`1.2`	STAT	PostgreSQL	examine the visibility map (VM) and page-level visibility info
`pgstattuple`	`pgstattuple`	`1.5`	STAT	PostgreSQL	show tuple-level statistics
`auto_explain`	`auto_explain`	`-`	STAT	PostgreSQL	Provides a means for logging execution plans of slow statements automatically
`pg_stat_statements`	`pg_stat_statements`	`1.11`	STAT	PostgreSQL	track planning and execution statistics of all SQL statements executed
`passwordcheck_cracklib`	`passwordcheck_cracklib`	`3.1.0`	SEC	LGPL-2.1	Strengthen PostgreSQL user password checks with cracklib
`supautils`	`supautils`	`3.1.0`	SEC	Apache-2.0	Extension that secures a cluster on a cloud environment
`pgsodium`	`pgsodium`	`3.1.9`	SEC	BSD 3-Clause	Postgres extension for libsodium functions
`supabase_vault`	`pg_vault`	`0.3.1`	SEC	Apache-2.0	Supabase Vault Extension
`pgaudit`	`pgaudit`	`18.0`	SEC	PostgreSQL	provides auditing functionality
`pgauditlogtofile`	`pgauditlogtofile`	`1.8.0`	SEC	PostgreSQL	pgAudit addon to redirect audit log to an independent file
`logerrors`	`logerrors`	`2.1.5`	SEC	BSD 3-Clause	Function for collecting statistics about messages in logfile
`pg_auth_mon`	`pg_auth_mon`	`3.0`	SEC	MIT	monitor connection attempts per user
`credcheck`	`credcheck`	`4.6`	SEC	MIT	credcheck - postgresql plain text credential checker
`pgcryptokey`	`pgcryptokey`	`0.85`	SEC	PostgreSQL	cryptographic key management
`pg_pwhash`	`pg_pwhash`	`1.0`	SEC	MIT	Advanced password hashing methods for PostgreSQL
`login_hook`	`login_hook`	`1.7`	SEC	GPL-3.0	login_hook - hook to execute login_hook.login() at login time
`set_user`	`set_user`	`4.2.0`	SEC	PostgreSQL	similar to SET ROLE but with added logging
`pg_snakeoil`	`pg_snakeoil`	`1.4`	SEC	PostgreSQL	The PostgreSQL Antivirus
`pgextwlist`	`pgextwlist`	`1.19`	SEC	PostgreSQL	PostgreSQL Extension Whitelisting
`sslutils`	`sslutils`	`1.4`	SEC	PostgreSQL	A Postgres extension for managing SSL certificates through SQL
`noset`	`pg_noset`	`0.3.0`	SEC	AGPL-3.0	Module for blocking SET variables for non-super users.
`pg_tde`	`pg_tde`	`2.1`	SEC	MIT	Percona pg_tde access method
`sepgsql`	`sepgsql`	`-`	SEC	PostgreSQL	label-based mandatory access control (MAC) based on SELinux security policy.
`auth_delay`	`auth_delay`	`-`	SEC	PostgreSQL	pause briefly before reporting authentication failure
`pgcrypto`	`pgcrypto`	`1.3`	SEC	PostgreSQL	cryptographic functions
`passwordcheck`	`passwordcheck`	`-`	SEC	PostgreSQL	checks user passwords and reject weak password
`multicorn`	`multicorn`	`3.2`	FDW	PostgreSQL	Fetch foreign data in Python in your PostgreSQL server.
`odbc_fdw`	`odbc_fdw`	`0.5.1`	FDW	PostgreSQL	Foreign data wrapper for accessing remote databases using ODBC
`jdbc_fdw`	`jdbc_fdw`	`0.4.0`	FDW	PostgreSQL	foreign-data wrapper for remote servers available over JDBC
`pgspider_ext`	`pgspider_ext`	`1.3.0`	FDW	PostgreSQL	foreign-data wrapper for remote PGSpider servers
`mysql_fdw`	`mysql_fdw`	`2.9.3`	FDW	BSD 3-Clause	Foreign data wrapper for querying a MySQL server
`oracle_fdw`	`oracle_fdw`	`2.8.0`	FDW	PostgreSQL	foreign data wrapper for Oracle access
`tds_fdw`	`tds_fdw`	`2.0.5`	FDW	PostgreSQL	Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
`db2_fdw`	`db2_fdw`	`18.1.1`	FDW	PostgreSQL	foreign data wrapper for DB2 access
`sqlite_fdw`	`sqlite_fdw`	`2.5.0`	FDW	PostgreSQL	SQLite Foreign Data Wrapper
`informix_fdw`	`informix_fdw`	`0.6.3`	FDW	PostgreSQL	Foreign data wrapper for Informix access
`nominatim_fdw`	`nominatim_fdw`	`1.1.0`	FDW	MIT	Nominatim Foreign Data Wrapper for PostgreSQL
`mongo_fdw`	`mongo_fdw`	`5.5.3`	FDW	LGPL-3.0	foreign data wrapper for MongoDB access
`redis_fdw`	`redis_fdw`	`1.0`	FDW	PostgreSQL	Foreign data wrapper for querying a Redis server
`redis`	`pg_redis_pubsub`	`0.0.1`	FDW	MIT	Send redis pub/sub messages to Redis from PostgreSQL Directly
`kafka_fdw`	`kafka_fdw`	`0.0.3`	FDW	PostgreSQL	kafka Foreign Data Wrapper for CSV formatted messages
`hdfs_fdw`	`hdfs_fdw`	`2.3.3`	FDW	BSD 3-Clause	foreign-data wrapper for remote hdfs servers
`firebird_fdw`	`firebird_fdw`	`1.4.1`	FDW	PostgreSQL	Foreign data wrapper for Firebird
`log_fdw`	`log_fdw`	`1.4`	FDW	Apache-2.0	foreign-data wrapper for Postgres log file access
`dblink`	`dblink`	`1.2`	FDW	PostgreSQL	connect to other PostgreSQL databases from within a database
`file_fdw`	`file_fdw`	`1.0`	FDW	PostgreSQL	foreign-data wrapper for flat file access
`postgres_fdw`	`postgres_fdw`	`1.1`	FDW	PostgreSQL	foreign-data wrapper for remote PostgreSQL servers
`documentdb`	`documentdb`	`0.109`	SIM	MIT	API surface for DocumentDB for PostgreSQL
`documentdb_core`	`documentdb`	`0.109`	SIM	MIT	Core API surface for DocumentDB for PostgreSQL
`documentdb_distributed`	`documentdb`	`0.109`	SIM	MIT	Multi-Node API surface for DocumentDB
`documentdb_extended_rum`	`documentdb`	`0.109`	SIM	MIT	DocumentDB Extended RUM index access method
`orafce`	`orafce`	`4.16.5`	SIM	BSD 0-Clause	Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
`pgtt`	`pgtt`	`4.4`	SIM	ISC	Extension to add Global Temporary Tables feature to PostgreSQL
`session_variable`	`session_variable`	`3.4`	SIM	GPL-3.0	Registration and manipulation of session variables and constants
`pg_statement_rollback`	`pg_statement_rollback`	`1.5`	SIM	ISC	Server side rollback at statement level for PostgreSQL like Oracle or DB2
`ivorysql_ora`	`ivorysql`	`1.0`	SIM	Apache-2.0	Oracle Compatible extension on Postgres Database
`ora_btree_gin`	`ivorysql`	`1.0`	SIM	Apache-2.0	Support for indexing oracle datatypes in GIN
`ora_btree_gist`	`ivorysql`	`1.0`	SIM	Apache-2.0	Support for oracle indexing common datatypes in GiST
`pg_get_functiondef`	`ivorysql`	`1.0`	SIM	Apache-2.0	Get function’s definition
`plisql`	`ivorysql`	`1.0`	SIM	Apache-2.0	PL/iSQL procedural language
`gb18030_2022`	`ivorysql`	`1.0`	SIM	Apache-2.0	Support GB18030-2022 and UTF-8 conversion
`pg_dbms_errlog`	`pg_dbms_errlog`	`2.2`	SIM	ISC	Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
`babelfishpg_common`	`babelfish`	`5.5.0`	SIM	Apache-2.0	SQL Server Transact SQL Datatype Support
`babelfishpg_tsql`	`babelfish`	`5.5.0`	SIM	Apache-2.0	SQL Server Transact SQL compatibility
`babelfishpg_tds`	`babelfish`	`1.0.0`	SIM	Apache-2.0	SQL Server TDS protocol extension
`babelfishpg_money`	`babelfish`	`1.1.0`	SIM	Apache-2.0	SQL Server Money Data Type
`spat`	`spat`	`0.1.0a4`	SIM	AGPL-3.0	Redis-like In-Memory DB Embedded in Postgres
`pgmemcache`	`pgmemcache`	`2.3.0`	SIM	MIT	memcached interface
`aux_mysql`	`openhalo`	`1.5`	SIM	GPL-3.0	MySQL Supplementary Extension
`pglogical`	`pglogical`	`2.4.6`	ETL	PostgreSQL	PostgreSQL Logical Replication
`pglogical_origin`	`pglogical`	`2.4.6`	ETL	PostgreSQL	Dummy extension for compatibility when upgrading from Postgres 9.4
`pglogical_ticker`	`pglogical_ticker`	`1.4.1`	ETL	PostgreSQL	Have an accurate view on pglogical replication delay
`pgl_ddl_deploy`	`pgl_ddl_deploy`	`2.2.1`	ETL	MIT	automated ddl deployment using pglogical
`pg_failover_slots`	`pg_failover_slots`	`1.2.0`	ETL	PostgreSQL	PG Failover Slots extension
`pgactive`	`pgactive`	`2.1.7`	ETL	Apache-2.0	Active-Active Replication Extension for PostgreSQL
`spock`	`spock`	`5.0.5`	ETL	PostgreSQL	Multi-master logical replication extension for PostgreSQL
`lolor`	`lolor`	`1.2.2`	ETL	PostgreSQL	Logical-replication-friendly replacement for PostgreSQL large objects
`wal2json`	`wal2json`	`2.6`	ETL	BSD 3-Clause	Changing data capture in JSON format
`wal2mongo`	`wal2mongo`	`1.0.7`	ETL	Apache-2.0	PostgreSQL logical decoding output plugin for MongoDB
`decoderbufs`	`decoderbufs`	`3.4.1`	ETL	MIT	Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
`decoder_raw`	`decoder_raw`	`1.0`	ETL	PostgreSQL	Output plugin for logical replication in Raw SQL format
`repmgr`	`repmgr`	`5.5.0`	ETL	GPL-3.0	Replication manager for PostgreSQL
`pg_fact_loader`	`pg_fact_loader`	`2.0.1`	ETL	MIT	build fact tables with Postgres
`pg_bulkload`	`pg_bulkload`	`3.1.23`	ETL	BSD 3-Clause	pg_bulkload is a high speed data loading utility for PostgreSQL
`test_decoding`	`test_decoding`	`-`	ETL	PostgreSQL	SQL-based test/example module for WAL logical decoding
`pgoutput`	`pgoutput`	`-`	ETL	PostgreSQL	Logical Replication output plugin

Rust

Extensions written in Rust (41)

Extension	Package	Version	PGRX	Type	License	Description
`timescaledb_toolkit`	`timescaledb_toolkit`	`1.22.0`	`0.16.1`	TIME	Timescale	Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities
`pg_later`	`pg_later`	`0.4.0`	`0.16.1`	TIME	PostgreSQL	Run queries now and get results later
`pg_polyline`	`pg_polyline`	`0.0.1`	`0.16.1`	GIS	MIT	Fast Google Encoded Polyline encoding & decoding for postgres
`pg_eviltransform`	`pg_eviltransform`	`0.0.2`	`0.17.0`	GIS	MIT	Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
`tzf`	`pg_tzf`	`0.2.3`	`0.16.1`	GIS	MIT	Fast lookup timezone name by GPS coordinates
`vchord`	`vchord`	`1.1.1`	`0.17.0`	RAG	AGPL-3.0	Vector database plugin for Postgres, written in Rust
`vectorscale`	`pgvectorscale`	`0.9.0`	`0.16.1`	RAG	PostgreSQL	Advanced indexing for vector data with DiskANN
`vectorize`	`pg_vectorize`	`0.26.0`	`0.16.1`	RAG	PostgreSQL	The simplest way to do vector search on Postgres
`pg_summarize`	`pg_summarize`	`0.0.1`	`0.16.1`	RAG	PostgreSQL	Text Summarization using LLMs. Built using pgrx
`pg_tiktoken`	`pg_tiktoken`	`0.0.1`	`0.16.1`	RAG	Apache-2.0	tiktoken tokenizer for use with OpenAI models in postgres
`pgml`	`pgml`	`2.10.0`	`0.12.9`	RAG	MIT	Run AL/ML workloads with SQL interface
`pg_search`	`pg_search`	`0.21.12`	`0.16.1`	FTS	AGPL-3.0	Full text search for PostgreSQL using BM25
`pg_bestmatch`	`pg_bestmatch`	`0.0.2`	`0.16.1`	FTS	Apache-2.0	Generate BM25 sparse vector inside PostgreSQL
`vchord_bm25`	`vchord_bm25`	`0.3.0`	`0.16.1`	FTS	AGPL-3.0	A postgresql extension for bm25 ranking algorithm
`pg_tokenizer`	`pg_tokenizer`	`0.1.1`	`0.16.1`	FTS	Apache-2.0	Tokenizers for full-text search
`pg_pinyin`	`pg_pinyin`	`0.0.2`	`0.17.0`	FTS	MIT	Pinyin romanization and search helpers for PostgreSQL
`pg_analytics`	`pg_analytics`	`0.3.7`	`0.13.0`	OLAP	PostgreSQL	Postgres for analytics, powered by DuckDB
`pg_mooncake`	`pg_mooncake`	`0.2.0`	`0.16.1`	OLAP	MIT	Columnstore Table in Postgres
`pg_parquet`	`pg_parquet`	`0.5.1`	`0.16.1`	OLAP	PostgreSQL	copy data between Postgres and Parquet
`pg_graphql`	`pg_graphql`	`1.5.12`	`0.16.1`	FEAT	Apache-2.0	Add in-database GraphQL support
`pg_jsonschema`	`pg_jsonschema`	`0.3.4`	`0.16.1`	FEAT	Apache-2.0	PostgreSQL extension providing JSON Schema validation
`pg_cardano`	`pg_cardano`	`1.1.1`	`0.16.1`	FEAT	MIT	A suite of Cardano-related tools
`plprql`	`plprql`	`18.0.1`	`0.16.1`	LANG	Apache-2.0	Use PRQL in PostgreSQL - Pipelined Relational Query Language
`pglite_fusion`	`pglite_fusion`	`0.0.6`	`0.16.1`	TYPE	MIT	Embed an SQLite database in your PostgreSQL table
`pg_smtp_client`	`pg_smtp_client`	`0.2.1`	`0.16.1`	UTIL	MIT	PostgreSQL extension to send email using SMTP
`pg_render`	`pg_render`	`0.1.3`	`0.16.1`	UTIL	MIT	Render HTML in SQL
`pg_idkit`	`pg_idkit`	`0.4.0`	`0.16.1`	FUNC	Apache-2.0	multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
`pgx_ulid`	`pgx_ulid`	`0.2.2`	`0.16.1`	FUNC	MIT	ulid type and methods
`typeid`	`pg_typeid`	`0.3.0`	`0.16.1`	FUNC	MIT	Allows to use TypeIDs in Postgres natively
`pg_base58`	`pg_base58`	`0.0.1`	`0.16.1`	FUNC	MIT	Base58 Encoder/Decoder Extension for PostgreSQL
`convert`	`pg_convert`	`0.1.0`	`0.16.1`	FUNC	MIT	conversion functions for spatial, routing and other specialized uses
`pglinter`	`pglinter`	`1.1.1`	`0.16.1`	ADMIN	PostgreSQL	PostgreSQL Linting and Analysis Extension
`pgdd`	`pgdd`	`0.6.1`	`0.16.1`	ADMIN	MIT	Introspect pg data dictionary via standard SQL
`pg_strict`	`pg_strict`	`1.0.2`	`0.16.1`	ADMIN	MIT	Prevent dangerous UPDATE and DELETE without WHERE clause
`explain_ui`	`pg_explain_ui`	`0.0.2`	`0.16.1`	STAT	PostgreSQL	easily jump into a visual plan UI for any SQL query
`pg_session_jwt`	`pg_session_jwt`	`0.4.0`	`0.16.1`	SEC	Apache-2.0	Manage authentication sessions using JWTs
`anon`	`pg_anon`	`3.0.1`	`0.16.1`	SEC	PostgreSQL	PostgreSQL Anonymizer (anon) extension
`pgsmcrypto`	`pgsmcrypto`	`0.1.1`	`0.16.1`	SEC	MIT	PostgreSQL SM Algorithm Extension
`pg_enigma`	`pg_enigma`	`0.5.0`	`0.16.1`	SEC	MIT	Encrypted postgres data type
`wrappers`	`wrappers`	`0.5.7`	`0.16.1`	FDW	Apache-2.0	Foreign data wrappers developed by Supabase
`etcd_fdw`	`etcd_fdw`	`0.0.0`	`0.16.1`	FDW	MIT	Foreign data wrapper for etcd

SQL

Extensions written in SQL (40)

Extension	Package	Version	Type	License	Description
`timeseries`	`pg_timeseries`	`0.2.0`	TIME	PostgreSQL	Convenience API for time series stack
`emaj`	`emaj`	`4.7.1`	TIME	GPL-3.0	Enables fine-grained write logging and time travel on subsets of the database.
`table_version`	`table_version`	`1.11.1`	TIME	BSD 3-Clause	PostgreSQL table versioning extension
`geoip`	`geoip`	`0.3.0`	GIS	BSD 2-Clause	IP-based geolocation query
`mobilitydb_datagen`	`mobilitydb`	`1.3.0`	GIS	GPL-3.0	MobilityDB random data generator functions
`pg_fkpart`	`pg_fkpart`	`1.7.0`	OLAP	GPL-2.0	Table partitioning by foreign key utility
`index_advisor`	`index_advisor`	`0.2.0`	FEAT	PostgreSQL	Query index advisor
`pgmb`	`pgmb`	`1.0.0`	FEAT	PostgreSQL	A simple PostgreSQL Message Broker system
`pgmq`	`pgmq`	`1.11.0`	FEAT	PostgreSQL	A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
`pgfaceting`	`pgfaceting`	`0.2.0`	TYPE	BSD 3-Clause	fast faceting queries using an inverted index
`pg_xenophile`	`pg_xenophile`	`0.8.3`	TYPE	PostgreSQL	More than the bare necessities for PostgreSQL i18n and l10n.
`l10n_table_dependent_extension`	`pg_xenophile`	`0.8.3`	TYPE	PostgreSQL	PostgreSQL l10n toolbox
`debversion`	`debversion`	`1.2.0`	TYPE	PostgreSQL	Debian version number data type
`pgjwt`	`pgjwt`	`0.2.0`	UTIL	MIT	JSON Web Token API for Postgresql
`pg_html5_email_address`	`pg_html5_email_address`	`1.2.3`	UTIL	PostgreSQL	PostgreSQL email validation that is consistent with the HTML5 spec
`pgsql_tweaks`	`pgsql_tweaks`	`1.0.2`	UTIL	PostgreSQL	Some functions and views for daily usage
`pg_extra_time`	`pg_extra_time`	`2.0.0`	UTIL	PostgreSQL	Some date time functions and operators that,
`ddl_historization`	`ddl_historization`	`0.0.7`	UTIL	GPL-2.0	Historize the ddl changes inside PostgreSQL database
`data_historization`	`data_historization`	`1.1.0`	UTIL	PostgreSQL	PLPGSQL Script to historize data in partitionned table
`schedoc`	`pg_schedoc`	`0.0.1`	UTIL	GPL-3.0	Cross documentation between Django and DBT projects
`sparql`	`pgsparql`	`1.0`	UTIL	Apache-2.0	Query SPARQL datasource with SQL
`ddlx`	`pg_ddlx`	`0.30`	ADMIN	PostgreSQL	DDL eXtractor functions
`pg_permissions`	`pg_permissions`	`1.4`	ADMIN	BSD 2-Clause	view object permissions and compare them with the desired state
`pg_upless`	`pg_upless`	`0.0.3`	ADMIN	PostgreSQL	Detect Useless UPDATE
`pgcozy`	`pgcozy`	`1.0`	ADMIN	PostgreSQL	Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
`pg_drop_events`	`pg_drop_events`	`0.1.0`	ADMIN	PostgreSQL	logs transaction ids of drop table, drop column, drop materialized view statements
`pg_track_settings`	`pg_track_settings`	`2.1.2`	STAT	PostgreSQL	Track settings changes
`meta`	`pg_meta`	`0.4.0`	STAT	BSD 2-Clause	Normalized, friendlier system catalog for PostgreSQL
`pg_sqlog`	`pg_sqlog`	`1.6`	STAT	BSD 3-Clause	Provide SQL interface to logs
`pagevis`	`pagevis`	`0.1`	STAT	MIT	Visualise database pages in ascii code
`pg_auditor`	`pg_auditor`	`0.2`	SEC	BSD 3-Clause	Audit data changes and provide flashback ability
`pg_jobmon`	`pg_jobmon`	`1.4.1`	SEC	PostgreSQL	Extension for logging and monitoring functions in PostgreSQL
`pgbouncer_fdw`	`pgbouncer_fdw`	`1.4.0`	FDW	PostgreSQL	Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
`aws_s3`	`aws_s3`	`0.0.1`	FDW	Apache-2.0	aws_s3 postgres extension to import/export data from/to s3
`pg_dbms_metadata`	`pg_dbms_metadata`	`1.0.0`	SIM	PostgreSQL	Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
`pg_dbms_lock`	`pg_dbms_lock`	`1.0`	SIM	PostgreSQL	Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
`pg_dbms_job`	`pg_dbms_job`	`1.5`	SIM	PostgreSQL	Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
`pg_utl_smtp`	`pg_utl_smtp`	`1.0.0`	SIM	PostgreSQL	Oracle UTL_SMTP compatibility extension for PostgreSQL
`db_migrator`	`db_migrator`	`1.0.0`	ETL	BSD 3-Clause	Tools to migrate other databases to PostgreSQL
`mimeo`	`mimeo`	`1.5.1`	ETL	PostgreSQL	Extension for specialized, per-table replication between PostgreSQL instances

Data

Extensions written in Data (10)

Extension	Package	Version	Type	License	Description
`hunspell_cs_cz`	`hunspell_cs_cz`	`1.0`	FTS	PostgreSQL	Czech Hunspell Dictionary
`hunspell_de_de`	`hunspell_de_de`	`1.0`	FTS	PostgreSQL	German Hunspell Dictionary
`hunspell_en_us`	`hunspell_en_us`	`1.0`	FTS	PostgreSQL	en_US Hunspell Dictionary
`hunspell_fr`	`hunspell_fr`	`1.0`	FTS	PostgreSQL	French Hunspell Dictionary
`hunspell_ne_np`	`hunspell_ne_np`	`1.0`	FTS	PostgreSQL	Nepali Hunspell Dictionary
`hunspell_nl_nl`	`hunspell_nl_nl`	`1.0`	FTS	PostgreSQL	Dutch Hunspell Dictionary
`hunspell_nn_no`	`hunspell_nn_no`	`1.0`	FTS	PostgreSQL	Norwegian (norsk) Hunspell Dictionary
`hunspell_pt_pt`	`hunspell_pt_pt`	`1.0`	FTS	PostgreSQL	Portuguese Hunspell Dictionary
`hunspell_ru_ru`	`hunspell_ru_ru`	`1.0`	FTS	PostgreSQL	Russian Hunspell Dictionary
`hunspell_ru_ru_aot`	`hunspell_ru_ru_aot`	`1.0`	FTS	PostgreSQL	Russian Hunspell Dictionary (from AOT.ru group)

C++

Extensions written in C++ (7)

Extension	Package	Version	Type	License	Description
`pgrouting`	`pgrouting`	`4.0.1`	GIS	GPL-2.0	pgRouting Extension
`pg_duckdb`	`pg_duckdb`	`1.1.1`	OLAP	MIT	DuckDB Embedded in Postgres
`pg_clickhouse`	`pg_clickhouse`	`0.1.4`	OLAP	Apache-2.0	Interfaces to query ClickHouse databases from PostgreSQL
`hll`	`hll`	`2.19`	FEAT	Apache-2.0	type for storing hyperloglog data
`pg_ai_query`	`pg_ai_query`	`0.1.1`	FEAT	Apache-2.0	AI-powered SQL query generation for PostgreSQL
`rdkit`	`rdkit`	`202503.1`	FEAT	BSD 3-Clause	Cheminformatics functionality for PostgreSQL.
`plv8`	`plv8`	`3.2.4`	LANG	PostgreSQL	PL/JavaScript (v8) trusted procedural language

Python

Extensions written in Python (2)

Extension	Package	Version	Type	License	Description
`faker`	`faker`	`0.5.3`	LANG	PostgreSQL	Wrapper for the Faker Python library
`powa`	`powa`	`5.1.1`	STAT	PostgreSQL	PostgreSQL Workload Analyser-core

Java

Extensions written in Java (1)

Extension	Package	Version	Type	License	Description
`pljava`	`pljava`	`1.6.10`	LANG	BSD 3-Clause	PL/Java procedural language

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)