Extensions

There are 431 available PostgreSQL extensions:

Extension PG Versions Attribute Category Description
timescaledb
18 17 16 15 14 13
--sLd--
TIME
Enables scalable inserts and complex queries for time-series data
timescaledb_toolkit
18 17 16 15 14 13
--s-dt-
TIME
Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities
pg_timeseries
18 17 16 15 14 13
----d--
TIME
Convenience API for time series stack
periods
18 17 16 15 14 13
--s-d--
TIME
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal_tables
18 17 16 15 14 13
--s-d-r
TIME
temporal tables
emaj
18 17 16 15 14 13
--s-d--
TIME
Enables fine-grained write logging and time travel on subsets of the database.
table_version
18 17 16 15 14 13
--s-d--
TIME
PostgreSQL table versioning extension
pg_cron
18 17 16 15 14 13
--sLd--
TIME
Job scheduler for PostgreSQL
pg_task
18 17 16 15 14 13
--sL---
TIME
execute any sql command at any specific time at background
pg_later
18 17 16 15 14 13
--s-d--
TIME
Run queries now and get results later
pg_background
18 17 16 15 14 13
--s-d-r
TIME
Run SQL queries in the background
postgis
18 17 16 15 14 13
--s-d--
GIS
PostGIS geometry and geography spatial types and functions
postgis
18 17 16 15 14 13
--s-d--
GIS
PostGIS topology spatial types and functions
postgis
18 17 16 15 14 13
--s-d--
GIS
PostGIS raster types and functions
postgis
18 17 16 15 14 13
--s-d-r
GIS
PostGIS SFCGAL functions
postgis
18 17 16 15 14 13
--s-dt-
GIS
PostGIS tiger geocoder and reverse geocoder
postgis
18 17 16 15 14 13
--s-d-r
GIS
Used to parse an address into constituent elements. Generally used to support geocoding address norm
postgis
18 17 16 15 14 13
--s-d-r
GIS
Address Standardizer US dataset example
pgrouting
18 17 16 15 14 13
--s-d-r
GIS
pgRouting Extension
pointcloud
18 17 16 15 14 13
--s-d--
GIS
data type for lidar point clouds
pointcloud
18 17 16 15 14 13
--s-dt-
GIS
integration for pointcloud LIDAR data and PostGIS geometry data
pg_h3
18 17 16 15 14 13
--s-d-r
GIS
H3 bindings for PostgreSQL
pg_h3
18 17 16 15 14 13
--s-d-r
GIS
H3 PostGIS integration
q3c
18 17 16 15 14 13
--s-d-r
GIS
q3c sky indexing plugin
ogr_fdw
18 17 16 15 14 13
--s-d-r
GIS
foreign-data wrapper for GIS data access
geoip
18 17 16 15 14 13
--s-d--
GIS
IP-based geolocation query
pg_polyline
18 17 16 15 14 13
--s-dt-
GIS
Fast Google Encoded Polyline encoding & decoding for postgres
pg_geohash
18 17 16 15 14 13
--s-d-r
GIS
Handle geohash based functionality for spatial coordinates
mobilitydb
18 17 16 15 14 13
--s-d-r
GIS
MobilityDB geospatial trajectory data management & analysis platform
pg_tzf
18 17 16 15 14 13
--s-d--
GIS
Fast lookup timezone name by GPS coordinates
earthdistance
18 17 16 15 14 13
c-s-d--
GIS
calculate great-circle distances on the surface of the Earth
pgvector
18 17 16 15 14 13
--s-d-r
RAG
vector data type and ivfflat and hnsw access methods
vchord
18 17 16 15 14 13
--sLd-r
RAG
Vector database plugin for Postgres, written in Rust
pgvectorscale
18 17 16 15 14 13
--s-d--
RAG
Advanced indexing for vector data with DiskANN
pg_vectorize
18 17 16 15 14 13
--s-d--
RAG
The simplest way to do vector search on Postgres
pg_similarity
18 17 16 15 14 13
--s-d-r
RAG
support similarity queries
smlar
18 17 16 15 14 13
--s-d-r
RAG
Effective similarity search
pg_summarize
18 17 16 15 14 13
--s-d--
RAG
Text Summarization using LLMs. Built using pgrx
pg_tiktoken
18 17 16 15 14 13
--s-d--
RAG
tiktoken tokenizer for use with OpenAI models in postgres
pg4ml
18 17 16 15 14 13
----dtr
RAG
Machine learning framework for PostgreSQL
pgml
18 17 16 15 14 13
--sLd--
RAG
Run AL/ML workloads with SQL interface
pg_search
18 17 16 15 14 13
--s-dt-
FTS
Full text search for PostgreSQL using BM25
pgroonga
18 17 16 15 14 13
--s-dtr
FTS
Use Groonga as index, fast full text search platform for all languages!
pgroonga
18 17 16 15 14 13
--s-dtr
FTS
PGroonga database management module
pg_bigm
18 17 16 15 14 13
--s-d-r
FTS
create 2-gram (bigram) index for faster full text search.
zhparser
18 17 16 15 14 13
--s-d-r
FTS
a parser for full-text search of Chinese
pg_bestmatch
18 17 16 15 14 13
--sLd--
FTS
Generate BM25 sparse vector inside PostgreSQL
vchord_bm25
18 17 16 15 14 13
--sLd--
FTS
A postgresql extension for bm25 ranking algorithm
pg_tokenizer
18 17 16 15 14 13
--s-dt-
FTS
Tokenizers for full-text search
hunspell_cs_cz
18 17 16 15 14 13
----d-r
FTS
Czech Hunspell Dictionary
hunspell_de_de
18 17 16 15 14 13
----d-r
FTS
German Hunspell Dictionary
hunspell_en_us
18 17 16 15 14 13
----d-r
FTS
en_US Hunspell Dictionary
hunspell_fr
18 17 16 15 14 13
----d-r
FTS
French Hunspell Dictionary
hunspell_ne_np
18 17 16 15 14 13
----d-r
FTS
Nepali Hunspell Dictionary
hunspell_nl_nl
18 17 16 15 14 13
----d-r
FTS
Dutch Hunspell Dictionary
hunspell_nn_no
18 17 16 15 14 13
----d-r
FTS
Norwegian (norsk) Hunspell Dictionary
hunspell_pt_pt
18 17 16 15 14 13
----d-r
FTS
Portuguese Hunspell Dictionary
hunspell_ru_ru
18 17 16 15 14 13
----d-r
FTS
Russian Hunspell Dictionary
hunspell_ru_ru_aot
18 17 16 15 14 13
----d-r
FTS
Russian Hunspell Dictionary (from AOT.ru group)
fuzzystrmatch
18 17 16 15 14 13
c-s-dt-
FTS
determine similarities and distance between strings
pg_trgm
18 17 16 15 14 13
c-s-d--
FTS
text similarity measurement and index searching based on trigrams
citus
18 17 16 15 14 13
--sLd--
OLAP
Distributed PostgreSQL as an extension
citus
18 17 16 15 14 13
--s-d--
OLAP
Citus columnar storage engine
hydra
18 17 16 15 14 13
--s-d--
OLAP
Hydra Columnar extension
pg_analytics
18 17 16 15 14 13
--s-dt-
OLAP
Postgres for analytics, powered by DuckDB
pg_duckdb
18 17 16 15 14 13
--sLd--
OLAP
DuckDB Embedded in Postgres
pg_mooncake
18 17 16 15 14 13
---Ld--
OLAP
Columnstore Table in Postgres
duckdb_fdw
18 17 16 15 14 13
--s-d-r
OLAP
DuckDB Foreign Data Wrapper
pg_parquet
18 17 16 15 14 13
--sLdt-
OLAP
copy data between Postgres and Parquet
pg_fkpart
18 17 16 15 14 13
----d--
OLAP
Table partitioning by foreign key utility
pg_partman
18 17 16 15 14 13
--s-d--
OLAP
Extension to manage partitioned tables by time or ID
plproxy
18 17 16 15 14 13
--s-d--
OLAP
Database partitioning implemented as procedural language
pg_strom
18 17 16 15 14 13
--s-d--
OLAP
PG-Strom - big-data processing acceleration using GPU and NVME
tablefunc
18 17 16 15 14 13
c-s-dt-
OLAP
functions that manipulate whole tables, including crosstab
age
18 17 16 15 14 13
--s-d--
FEAT
AGE graph database extension
hll
18 17 16 15 14 13
--s-d--
FEAT
type for storing hyperloglog data
rum
18 17 16 15 14 13
--s-d-r
FEAT
RUM index access method
pg_graphql
18 17 16 15 14 13
--s-d--
FEAT
Add in-database GraphQL support
pg_jsonschema
18 17 16 15 14 13
----d--
FEAT
PostgreSQL extension providing JSON Schema validation
jsquery
18 17 16 15 14 13
--s-d-r
FEAT
data type for jsonb inspection
pg_hint_plan
18 17 16 15 14 13
--s-d--
FEAT
Give PostgreSQL ability to manually force some decisions in execution plans.
hypopg
18 17 16 15 14 13
--s-d-r
FEAT
Hypothetical indexes for PostgreSQL
index_advisor
18 17 16 15 14 13
----d-r
FEAT
Query index advisor
pg_plan_filter
18 17 16 15 14 13
--sL---
FEAT
filter statements by their execution plans.
imgsmlr
18 17 16 15 14 13
--s-d-r
FEAT
Image similarity with haar
pg_ivm
18 17 16 15 14 13
--s-d--
FEAT
incremental view maintenance on PostgreSQL
pg_incremental
18 17 16 15 14 13
--s-d--
FEAT
Incremental Processing by Crunchy Data
pgmq
18 17 16 15 14 13
--s-dt-
FEAT
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgq
18 17 16 15 14 13
--s-d--
FEAT
Generic queue for PostgreSQL
orioledb
18 17 16 15 14 13
--sLd-r
FEAT
OrioleDB, the next generation transactional engine
pg_cardano
18 17 16 15 14 13
--s-d--
FEAT
A suite of Cardano-related tools
rdkit
18 17 16 15 14 13
--s-d-r
FEAT
Cheminformatics functionality for PostgreSQL.
omnigres
18 17 16 15 14 13
--sLd--
FEAT
Advanced adapter for Postgres extensions
omnigres
18 17 16 15 14 13
----d--
FEAT
Basic session management
omnigres
18 17 16 15 14 13
----dt-
FEAT
Amazon Web Services APIs (S3)
omnigres
18 17 16 15 14 13
----dt-
FEAT
CloudEvents support
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Docker container management
omnigres
18 17 16 15 14 13
----d--
FEAT
Application credential management
omni_csv
18 17 16 15 14 13
--s-d--
FEAT
CSV toolkit
omni_datasets
18 17 16 15 14 13
----d--
FEAT
Dataset provisioning
omnigres
18 17 16 15 14 13
----d--
FEAT
E-mail framework
omnigres
18 17 16 15 14 13
----d--
FEAT
Basic HTTP types
omnigres
18 17 16 15 14 13
--s-d--
FEAT
HTTP client
omnigres
18 17 16 15 14 13
--s-d--
FEAT
HTTP server
omnigres
18 17 16 15 14 13
--s-d-r
FEAT
Identity types
omnigres
18 17 16 15 14 13
----dt-
FEAT
JSON toolkit
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Kubernetes (k8s) integration
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Financial ledger
omnigres
18 17 16 15 14 13
----d--
FEAT
Package installation manifests
omnigres
18 17 16 15 14 13
----d--
FEAT
MIME types
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Operating system integration
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Postgres API polyfills
omnigres
18 17 16 15 14 13
--s-d--
FEAT
First-class Python support
omnigres
18 17 16 15 14 13
--s-d-r
FEAT
PCRE-compatible regular expressions
omnigres
18 17 16 15 14 13
----d--
FEAT
REST API toolkit (with PostgREST support)
omnigres
18 17 16 15 14 13
----d--
FEAT
Advanced schema management tooling
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Distributed integer sequences
omnigres
18 17 16 15 14 13
----d--
FEAT
Service management
omnigres
18 17 16 15 14 13
----d--
FEAT
Session management
omni_shmem
18 17 16 15 14 13
--s-d--
FEAT
Shared Memory Management
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Programmatic SQL manipulation
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Embedded SQLite
omnigres
18 17 16 15 14 13
----d--
FEAT
Testing framework
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Transaction management
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Advanced types
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Scoped variables
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Virtual File System
omnigres
18 17 16 15 14 13
----d--
FEAT
Virtual File System types (v1)
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Common web stack primitives
omnigres
18 17 16 15 14 13
--s-d--
FEAT
Generalized worker pool
omnigres
18 17 16 15 14 13
--s-d--
FEAT
XML toolkit
omnigres
18 17 16 15 14 13
--s-d--
FEAT
YAML toolkit
omnisketch
18 17 16 15 14 13
--s-d-r
FUNC
data structure for on-line agg of data into approximate sketch
bloom
18 17 16 15 14 13
c-s-d--
FEAT
bloom access method - signature file based index
pg_tle
18 17 16 15 14 13
--sLd--
LANG
Trusted Language Extensions for PostgreSQL
plv8
18 17 16 15 14 13
--s-d--
LANG
PL/JavaScript (v8) trusted procedural language
pljs
18 17 16 15 14 13
--s-d--
LANG
PL/JS trusted procedural language
pllua
18 17 16 15 14 13
--s-d--
LANG
Lua as a procedural language
pllua
18 17 16 15 14 13
--s-d-r
LANG
Hstore transform for Lua
pllua
18 17 16 15 14 13
--s-d--
LANG
Lua as an untrusted procedural language
pllua
18 17 16 15 14 13
--s-d-r
LANG
Hstore transform for untrusted Lua
plprql
18 17 16 15 14 13
--s-d--
LANG
Use PRQL in PostgreSQL - Pipelined Relational Query Language
pldebugger
18 17 16 15 14 13
--s-d-r
LANG
server-side support for debugging PL/pgSQL functions
plpgsql_check
18 17 16 15 14 13
--sLd--
LANG
extended check for plpgsql functions
plprofiler
18 17 16 15 14 13
--s-d-r
LANG
server-side support for profiling PL/pgSQL functions
plsh
18 17 16 15 14 13
--s-d-r
LANG
PL/sh procedural language
pljava
18 17 16 15 14 13
--s-d--
LANG
PL/Java procedural language
plr
18 17 16 15 14 13
--s-d--
LANG
load R interpreter and execute R script from within a database
plxslt
18 17 16 15 14 13
--s-d-r
LANG
XSLT procedural language for PostgreSQL
pgtap
18 17 16 15 14 13
--s-d--
LANG
Unit testing for PostgreSQL
faker
18 17 16 15 14 13
--s-d--
LANG
Wrapper for the Faker Python library
dbt2
18 17 16 15 14 13
--s-d--
LANG
OSDL-DBT-2 test kit
pltcl
18 17 16 15 14 13
c-s-d--
LANG
PL/Tcl procedural language
pltcl
18 17 16 15 14 13
c---d--
LANG
PL/TclU untrusted procedural language
plperl
18 17 16 15 14 13
c-s-d--
LANG
PL/Perl procedural language
plperl
18 17 16 15 14 13
c-s-d--
LANG
transform between bool and plperl
plperl
18 17 16 15 14 13
c-s-d--
LANG
transform between hstore and plperl
plperl
18 17 16 15 14 13
c---d--
LANG
transform between jsonb and plperl
plperlu
18 17 16 15 14 13
c-s-d--
LANG
PL/PerlU untrusted procedural language
plperlu
18 17 16 15 14 13
c---d--
LANG
transform between bool and plperlu
plperlu
18 17 16 15 14 13
c---d--
LANG
transform between jsonb and plperlu
plperlu
18 17 16 15 14 13
c---d--
LANG
transform between hstore and plperlu
plpgsql
18 17 16 15 14 13
c-s-d--
LANG
PL/pgSQL procedural language
plpython3u
18 17 16 15 14 13
c-s-d--
LANG
PL/Python3U untrusted procedural language
plpython3u
18 17 16 15 14 13
c---d-r
LANG
transform between jsonb and plpython3u
plpython3u
18 17 16 15 14 13
c-s-d-r
LANG
transform between ltree and plpython3u
plpython3u
18 17 16 15 14 13
c---d-r
LANG
transform between hstore and plpython3u
pg_prefix
18 17 16 15 14 13
--s-d-r
TYPE
Prefix Range module for PostgreSQL
pg_semver
18 17 16 15 14 13
--s-d-r
TYPE
Semantic version data type
pgunit
18 17 16 15 14 13
--s-d--
TYPE
SI units extension
pgpdf
18 17 16 15 14 13
--sLdtr
TYPE
PDF type with meta admin & Full-Text Search
pglite_fusion
18 17 16 15 14 13
--sLd--
TYPE
Embed an SQLite database in your PostgreSQL table
md5hash
18 17 16 15 14 13
--s-d-r
TYPE
type for storing 128-bit binary data inline
asn1oid
18 17 16 15 14 13
--s-d-r
TYPE
asn1oid extension
pg_roaringbitmap
18 17 16 15 14 13
--s-d-r
TYPE
support for Roaring Bitmaps
pgfaceting
18 17 16 15 14 13
----dt-
TYPE
fast faceting queries using an inverted index
pgsphere
18 17 16 15 14 13
--s-d-r
TYPE
spherical objects with useful functions, operators and index support
pg_country
18 17 16 15 14 13
--s-d-r
TYPE
Country data type, ISO 3166-1
pg_xenophile
18 17 16 15 14 13
----d--
TYPE
More than the bare necessities for PostgreSQL i18n and l10n.
pg_xenophile
18 17 16 15 14 13
----dtr
TYPE
PostgreSQL l10n toolbox
pg_currency
18 17 16 15 14 13
--s-d-r
TYPE
Custom PostgreSQL currency type in 1Byte
pgcollection
18 17 16 15 14 13
--s-d-r
TYPE
Memory optimized data type to be used inside of plpglsql func
pgmp
18 17 16 15 14 13
--s-d-r
TYPE
Multiple Precision Arithmetic extension
numeral
18 17 16 15 14 13
--s-d-r
TYPE
numeral datatypes extension
pg_rational
18 17 16 15 14 13
--s-d--
TYPE
bigint fractions
pguint
18 17 16 15 14 13
--s-d-r
TYPE
unsigned integer types
pg_uint128
18 17 16 15 14 13
--s-d-r
TYPE
Native uint128 type
hashtypes
18 17 16 15 14 13
--s-d--
TYPE
sha1, md5 and other data types for PostgreSQL
ip4r
18 17 16 15 14 13
--s-d-r
TYPE
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
pg_duration
18 17 16 15 14 13
--s-d-r
TYPE
data type for representing durations
pg_uri
18 17 16 15 14 13
--s-d-r
TYPE
URI Data type for PostgreSQL
pg_emailaddr
18 17 16 15 14 13
--s-d--
TYPE
Email address type for PostgreSQL
pg_acl
18 17 16 15 14 13
--s-d-r
TYPE
ACL Data type
debversion
18 17 16 15 14 13
--s-d-r
TYPE
Debian version number data type
pg_rrule
18 17 16 15 14 13
--s-d-r
TYPE
RRULE field type for PostgreSQL
timestamp9
18 17 16 15 14 13
--s-d--
TYPE
timestamp nanosecond resolution
chkpass
18 17 16 15 14 13
--s-d--
TYPE
data type for auto-encrypted passwords
isn
18 17 16 15 14 13
c-s-dt-
TYPE
data types for international product numbering standards
seg
18 17 16 15 14 13
c-s-dt-
TYPE
data type for representing line segments or floating-point intervals
cube
18 17 16 15 14 13
c-s-d--
TYPE
data type for multidimensional cubes
ltree
18 17 16 15 14 13
c-s-dt-
TYPE
data type for hierarchical tree-like structures
hstore
18 17 16 15 14 13
c-s-dt-
TYPE
data type for storing sets of (key, value) pairs
citext
18 17 16 15 14 13
c-s-dt-
TYPE
data type for case-insensitive character strings
xml2
18 17 16 15 14 13
c---d--
TYPE
XPath querying and XSLT
pg_gzip
18 17 16 15 14 13
--s-d-r
UTIL
gzip and gunzip functions.
pg_bzip
18 17 16 15 14 13
--s-d--
UTIL
Bzip compression and decompression
pg_zstd
18 17 16 15 14 13
--s-d-r
UTIL
Zstandard compression algorithm implementation in PostgreSQL
pg_http
18 17 16 15 14 13
--s-d--
UTIL
HTTP client for PostgreSQL, allows web page retrieval inside the database.
pg_net
18 17 16 15 14 13
--sLd--
UTIL
Async HTTP Requests
pg_curl
18 17 16 15 14 13
--s-d-r
UTIL
Run curl actions for data transfer in URL syntax
pgjq
18 17 16 15 14 13
--s-dtr
UTIL
Use jq in Postgres
pgjwt
18 17 16 15 14 13
--s-dt-
UTIL
JSON Web Token API for Postgresql
pg_smtp_client
18 17 16 15 14 13
--s-dt-
UTIL
PostgreSQL extension to send email using SMTP
pg_html5_email_address
18 17 16 15 14 13
----d-r
UTIL
PostgreSQL email validation that is consistent with the HTML5 spec
url_encode
18 17 16 15 14 13
--s-d-r
UTIL
url_encode, url_decode functions
pgsql_tweaks
18 17 16 15 14 13
--s-d-r
UTIL
Some functions and views for daily usage
pg_extra_time
18 17 16 15 14 13
--s-dtr
UTIL
Some date time functions and operators that,
pgpcre
18 17 16 15 14 13
--s-d-r
UTIL
Perl Compatible Regular Expression functions
icu_ext
18 17 16 15 14 13
--s-d-r
UTIL
Access ICU functions
pgqr
18 17 16 15 14 13
--s-d-r
UTIL
QR Code generator from PostgreSQL
pg_protobuf
18 17 16 15 14 13
--s-d-r
UTIL
Protobuf support for PostgreSQL
pg_envvar
18 17 16 15 14 13
--s-d--
UTIL
Fetch the value of an environment variable
floatfile
18 17 16 15 14 13
--s-d-r
UTIL
Simple file storage for arrays of floats
pg_render
18 17 16 15 14 13
--s-d--
UTIL
Render HTML in SQL
pg_readme
18 17 16 15 14 13
----dtr
UTIL
Generate a README.md document for a database extension or schema
pg_readme
18 17 16 15 14 13
----dtr
UTIL
Test generating a README.md document for extension or schema
ddl_historization
18 17 16 15 14 13
----d--
UTIL
Historize the ddl changes inside PostgreSQL database
data_historization
18 17 16 15 14 13
----dt-
UTIL
PLPGSQL Script to historize data in partitionned table
pg_schedoc
18 17 16 15 14 13
----d--
UTIL
Cross documentation between Django and DBT projects
pg_hashlib
18 17 16 15 14 13
--s-dtr
UTIL
Stable hash functions for Postgres
pg_xxhash
18 17 16 15 14 13
--s-dtr
UTIL
xxhash functions for PostgreSQL
shacrypt
18 17 16 15 14 13
--s-d-r
UTIL
Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptint
18 17 16 15 14 13
--s-d-r
UTIL
Encryption functions for int and bigint values
pg_ecdsa
18 17 16 15 14 13
--s-d-r
UTIL
uECC bindings for Postgres
pgsparql
18 17 16 15 14 13
----d--
UTIL
Query SPARQL datasource with SQL
pg_idkit
18 17 16 15 14 13
--s-d--
FUNC
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pgx_ulid
18 17 16 15 14 13
--sLd--
FUNC
ulid type and methods
pg_uuidv7
18 17 16 15 14 13
--s-d-r
FUNC
Create UUIDv7 values in postgres
permuteseq
18 17 16 15 14 13
--s-d-r
FUNC
Pseudo-randomly permute sequences with a format-preserving encryption on elements
pg_hashids
18 17 16 15 14 13
--s-d-r
FUNC
Short unique id generator for PostgreSQL, using hashids
sequential_uuids
18 17 16 15 14 13
--s-d-r
FUNC
generator of sequential UUIDs
topn
18 17 16 15 14 13
--s-d--
FUNC
type for top-n JSONB
quantile
18 17 16 15 14 13
--s-d--
FUNC
Quantile aggregation function
lower_quantile
18 17 16 15 14 13
--s-d--
FUNC
Lower quantile aggregate function
count_distinct
18 17 16 15 14 13
--s-d-r
FUNC
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
ddsketch
18 17 16 15 14 13
--s-d-r
FUNC
Provides ddsketch aggregate function
vasco
18 17 16 15 14 13
--s-d-r
FUNC
discover hidden correlations in your data with MIC
pgxicor
18 17 16 15 14 13
--s-dtr
FUNC
XI Correlation Coefficient in Postgres
tdigest
18 17 16 15 14 13
--s-d-r
FUNC
Provides tdigest aggregate function.
first_last_agg
18 17 16 15 14 13
--s-d-r
FUNC
first() and last() aggregate functions
extra_window_functions
18 17 16 15 14 13
--s-d-r
FUNC
Extra Window Functions for PostgreSQL
floatvec
18 17 16 15 14 13
--s-d-r
FUNC
Math for vectors (arrays) of numbers
aggs_for_vecs
18 17 16 15 14 13
--s-d-r
FUNC
Aggregate functions for array inputs
aggs_for_arrays
18 17 16 15 14 13
--s-d-r
FUNC
Various functions for computing statistics on arrays of numbers
pg_csv
18 17 16 15 14 13
--s-dtr
FUNC
Flexible CSV processing for Postgres
pg_arraymath
18 17 16 15 14 13
--s-d-r
FUNC
Array math and operators that work element by element on the contents of arrays
pg_math
18 17 16 15 14 13
--s-d-r
FUNC
GSL statistical functions for postgresql
pg_random
18 17 16 15 14 13
--s-d-r
FUNC
random data generator
pg_base36
18 17 16 15 14 13
--s-d--
FUNC
Integer Base36 types
pg_base62
18 17 16 15 14 13
--s-d--
FUNC
Base62 extension for PostgreSQL
pg_base58
18 17 16 15 14 13
--s-d--
FUNC
Base58 Encoder/Decoder Extension for PostgreSQL
pg_financial
18 17 16 15 14 13
--s-d-r
FUNC
Financial aggregate functions
pg_convert
18 17 16 15 14 13
--s-dt-
FUNC
conversion functions for spatial, routing and other specialized uses
refint
18 17 16 15 14 13
c-s-d--
FUNC
functions for implementing referential integrity (obsolete)
autoinc
18 17 16 15 14 13
c-s-d--
FUNC
functions for autoincrementing fields
insert_username
18 17 16 15 14 13
c-s-d--
FUNC
functions for tracking who changed a table
moddatetime
18 17 16 15 14 13
c-s-d--
FUNC
functions for tracking last modification time
tsm_system_time
18 17 16 15 14 13
c-s-dt-
FUNC
TABLESAMPLE method which accepts time in milliseconds as a limit
dict_xsyn
18 17 16 15 14 13
c-s-d--
FUNC
text search dictionary template for extended synonym processing
tsm_system_rows
18 17 16 15 14 13
c-s-dt-
FUNC
TABLESAMPLE method which accepts number of rows as a limit
tcn
18 17 16 15 14 13
c-s-dt-
FUNC
Triggered change notifications
uuid-ossp
18 17 16 15 14 13
c-s-dt-
FUNC
generate universally unique identifiers (UUIDs)
btree_gist
18 17 16 15 14 13
c-s-dt-
FUNC
support for indexing common datatypes in GiST
btree_gin
18 17 16 15 14 13
c-s-dt-
FUNC
support for indexing common datatypes in GIN
intarray
18 17 16 15 14 13
c---dt-
FUNC
functions, operators, and index support for 1-D arrays of integers
intagg
18 17 16 15 14 13
c---d--
FUNC
integer aggregator and enumerator (obsolete)
dict_int
18 17 16 15 14 13
c-s-dt-
FUNC
text search dictionary template for integers
unaccent
18 17 16 15 14 13
c-s-dt-
FUNC
text search dictionary that removes accents
pg_repack
18 17 16 15 14 13
-bs-d--
ADMIN
Reorganize tables in PostgreSQL databases with minimal locks
pg_rewrite
18 17 16 15 14 13
--sLd-r
ADMIN
Tool allows read write to the table during the rewriting
pg_squeeze
18 17 16 15 14 13
--sLd--
ADMIN
A tool to remove unused space from a relation.
pg_dirtyread
18 17 16 15 14 13
--s-d-r
ADMIN
Read dead but unvacuumed rows from table
pgfincore
18 17 16 15 14 13
--s-d-r
ADMIN
examine and manage the os buffer cache
pg_cooldown
18 17 16 15 14 13
--s-d-r
ADMIN
remove buffered pages for specific relations
pg_ddlx
18 17 16 15 14 13
--s-d--
ADMIN
DDL eXtractor functions
pg_prioritize
18 17 16 15 14 13
--s-d-r
ADMIN
get and set the priority of PostgreSQL backends
pg_checksums
18 17 16 15 14 13
--s---r
ADMIN
Activate/deactivate/verify checksums in offline Postgres clusters
pg_readonly
18 17 16 15 14 13
--s-d--
ADMIN
cluster database read only
pgdd
18 17 16 15 14 13
--s-dt-
ADMIN
Introspect pg data dictionary via standard SQL
pg_permissions
18 17 16 15 14 13
--s-dt-
ADMIN
view object permissions and compare them with the desired state
pgautofailover
18 17 16 15 14 13
--sLd--
ADMIN
pg_auto_failover
pg_catcheck
18 17 16 15 14 13
--s-d--
ADMIN
Diagnosing system catalog corruption
preprepare
18 17 16 15 14 13
--s-d-r
ADMIN
Pre Prepare your Statement server side
pg_upless
18 17 16 15 14 13
----dt-
ADMIN
Detect Useless UPDATE
pgcozy
18 17 16 15 14 13
----d--
ADMIN
Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
pg_orphaned
18 17 16 15 14 13
--s-d--
ADMIN
Deal with orphaned files
pg_crash
18 17 16 15 14 13
--sL---
ADMIN
Send random signals to random processes
pg_cheat_funcs
18 17 16 15 14 13
--s-d-r
ADMIN
Provides cheat (but useful) functions
pg_fio
18 17 16 15 14 13
--s-d-r
ADMIN
PostgreSQL File I/O Functions
pg_savior
18 17 16 15 14 13
--s-d-r
ADMIN
Postgres extension to save OOPS mistakes
safeupdate
18 17 16 15 14 13
--sL---
ADMIN
Require criteria for UPDATE and DELETE
pg_drop_events
18 17 16 15 14 13
----d--
ADMIN
logs transaction ids of drop table, drop column, drop materialized view statements
table_log
18 17 16 15 14 13
--s-d--
ADMIN
record table modification logs and PITR for table/row
pgagent
18 17 16 15 14 13
--s-d--
ADMIN
A PostgreSQL job scheduler
pg_prewarm
18 17 16 15 14 13
c-sLd--
ADMIN
prewarm relation data
pgpool
18 17 16 15 14 13
----d--
ADMIN
Administrative functions for pgPool
pgpool
18 17 16 15 14 13
----d--
ADMIN
recovery functions for pgpool-II for V4.3
pgpool
18 17 16 15 14 13
----d--
ADMIN
replacement for regclass
lo
18 17 16 15 14 13
c-s-dt-
ADMIN
Large Object maintenance
basic_archive
18 17 16 15 14 13
c-s----
ADMIN
an example of an archive module
basebackup_to_shell
18 17 16 15 14 13
c-s----
ADMIN
adds a custom basebackup target called shell
old_snapshot
18 17 16 15 14 13
c-s-d--
ADMIN
utilities in support of old_snapshot_threshold
adminpack
18 17 16 15 14 13
c-s-d--
ADMIN
administrative functions for PostgreSQL
amcheck
18 17 16 15 14 13
c-s-d--
ADMIN
functions for verifying relation integrity
pg_surgery
18 17 16 15 14 13
c-s-d--
ADMIN
extension to perform surgery on a damaged relation
pg_profile
18 17 16 15 14 13
--s-d--
STAT
PostgreSQL load profile repository and report builder
pg_tracing
18 17 16 15 14 13
--sLd-r
STAT
Distributed Tracing for PostgreSQL
pg_show_plans
18 17 16 15 14 13
--s-d-r
STAT
show query plans of all currently running SQL statements
pg_stat_kcache
18 17 16 15 14 13
--sLd-r
STAT
Kernel statistics gathering
pg_stat_monitor
18 17 16 15 14 13
--sLd-r
STAT
The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib m
pg_qualstats
18 17 16 15 14 13
--sLd--
STAT
An extension collecting statistics about quals
pg_store_plans
18 17 16 15 14 13
--sLd-r
STAT
track plan statistics of all SQL statements executed
pg_track_settings
18 17 16 15 14 13
--s-dt-
STAT
Track settings changes
pg_wait_sampling
18 17 16 15 14 13
--sLd-r
STAT
sampling based statistics of wait events
pgsentinel
18 17 16 15 14 13
--sLd-r
STAT
active session history
system_stats
18 17 16 15 14 13
--s-d-r
STAT
EnterpriseDB system statistics for PostgreSQL
pg_meta
18 17 16 15 14 13
----d-r
STAT
Normalized, friendlier system catalog for PostgreSQL
pgnodemx
18 17 16 15 14 13
--s-d-r
STAT
Capture node OS metrics via SQL queries
pgnodemx
18 17 16 15 14 13
--s-d-r
STAT
PostgreSQL extension to access the OS process table
pg_sqlog
18 17 16 15 14 13
--s-d--
STAT
Provide SQL interface to logs
bgw_replstatus
18 17 16 15 14 13
--sL---
STAT
Small PostgreSQL background worker to report whether a node is a replication master or standby
pgmeminfo
18 17 16 15 14 13
--s-d--
STAT
show memory usage
toastinfo
18 17 16 15 14 13
--s-d-r
STAT
show details on toasted datums
pg_explain_ui
18 17 16 15 14 13
--s-dt-
STAT
easily jump into a visual plan UI for any SQL query
pg_relusage
18 17 16 15 14 13
--sL---
STAT
Log all the queries that reference a particular column
pagevis
18 17 16 15 14 13
----d-r
STAT
Visualise database pages in ascii code
powa
18 17 16 15 14 13
--s-d--
STAT
PostgreSQL Workload Analyser-core
pg_overexplain
18 17 16 15 14 13
c-sL---
STAT
Allow EXPLAIN to dump even more details
pg_logicalinspect
18 17 16 15 14 13
c-s-d--
STAT
Logical decoding components inspection
pageinspect
18 17 16 15 14 13
c-s-d--
STAT
inspect the contents of database pages at a low level
pgrowlocks
18 17 16 15 14 13
c-s-d--
STAT
show row-level locking information
sslinfo
18 17 16 15 14 13
c-s-d--
STAT
information about SSL certificates
pg_buffercache
18 17 16 15 14 13
c-s-d--
STAT
examine the shared buffer cache
pg_walinspect
18 17 16 15 14 13
c-s-d--
STAT
functions to inspect contents of PostgreSQL Write-Ahead Log
pg_freespacemap
18 17 16 15 14 13
c-s-d--
STAT
examine the free space map (FSM)
pg_visibility
18 17 16 15 14 13
c-s-d--
STAT
examine the visibility map (VM) and page-level visibility info
pgstattuple
18 17 16 15 14 13
c-s-d--
STAT
show tuple-level statistics
auto_explain
18 17 16 15 14 13
c-sL---
STAT
Provides a means for logging execution plans of slow statements automatically
pg_stat_statements
18 17 16 15 14 13
c-sLd--
STAT
track planning and execution statistics of all SQL statements executed
passwordcheck_cracklib
18 17 16 15 14 13
--sL---
SEC
Strengthen PostgreSQL user password checks with cracklib
supautils
18 17 16 15 14 13
--sL---
SEC
Extension that secures a cluster on a cloud environment
pgsodium
18 17 16 15 14 13
--sLd--
SEC
Postgres extension for libsodium functions
pg_vault
18 17 16 15 14 13
--s-d--
SEC
Supabase Vault Extension
pg_session_jwt
18 17 16 15 14 13
--s-dt-
SEC
Manage authentication sessions using JWTs
pg_anon
18 17 16 15 14 13
--sLd--
SEC
PostgreSQL Anonymizer (anon) extension
pg_tde
18 17 16 15 14 13
--sLd-r
SEC
Percona pg_tde access method
pgsmcrypto
18 17 16 15 14 13
--s-d--
SEC
PostgreSQL SM Algorithm Extension
pgaudit
18 17 16 15 14 13
--sLd-r
SEC
provides auditing functionality
pgauditlogtofile
18 17 16 15 14 13
--s-d-r
SEC
pgAudit addon to redirect audit log to an independent file
pg_auth_mon
18 17 16 15 14 13
--s-d-r
SEC
monitor connection attempts per user
credcheck
18 17 16 15 14 13
--sLd--
SEC
credcheck - postgresql plain text credential checker
pgcryptokey
18 17 16 15 14 13
--s-d-r
SEC
cryptographic key management
pg_jobmon
18 17 16 15 14 13
--s-d--
SEC
Extension for logging and monitoring functions in PostgreSQL
logerrors
18 17 16 15 14 13
--s-d-r
SEC
Function for collecting statistics about messages in logfile
login_hook
18 17 16 15 14 13
--s-d--
SEC
login_hook - hook to execute login_hook.login() at login time
set_user
18 17 16 15 14 13
--s-d--
SEC
similar to SET ROLE but with added logging
pg_snakeoil
18 17 16 15 14 13
--sL--r
SEC
The PostgreSQL Antivirus
pgextwlist
18 17 16 15 14 13
--sL---
SEC
PostgreSQL Extension Whitelisting
pg_auditor
18 17 16 15 14 13
----d-r
SEC
Audit data changes and provide flashback ability
sslutils
18 17 16 15 14 13
--s-d--
SEC
A Postgres extension for managing SSL certificates through SQL
pg_noset
18 17 16 15 14 13
--sLd-r
SEC
Module for blocking SET variables for non-super users.
sepgsql
18 17 16 15 14 13
c-sL---
SEC
label-based mandatory access control (MAC) based on SELinux security policy.
auth_delay
18 17 16 15 14 13
c-sL---
SEC
pause briefly before reporting authentication failure
pgcrypto
18 17 16 15 14 13
c-s-dt-
SEC
cryptographic functions
passwordcheck
18 17 16 15 14 13
c-sL---
SEC
checks user passwords and reject weak password
wrappers
18 17 16 15 14 13
--s-dt-
FDW
Foreign data wrappers developed by Supabase
multicorn
18 17 16 15 14 13
--s-d--
FDW
Fetch foreign data in Python in your PostgreSQL server.
odbc_fdw
18 17 16 15 14 13
--s-d-r
FDW
Foreign data wrapper for accessing remote databases using ODBC
jdbc_fdw
18 17 16 15 14 13
--s-d-r
FDW
foreign-data wrapper for remote servers available over JDBC
pgspider_ext
18 17 16 15 14 13
--s-d-r
FDW
foreign-data wrapper for remote PGSpider servers
mysql_fdw
18 17 16 15 14 13
--s-d-r
FDW
Foreign data wrapper for querying a MySQL server
oracle_fdw
18 17 16 15 14 13
--s-d--
FDW
foreign data wrapper for Oracle access
tds_fdw
18 17 16 15 14 13
--s-d-r
FDW
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
db2_fdw
18 17 16 15 14 13
--s-d--
FDW
foreign data wrapper for DB2 access
sqlite_fdw
18 17 16 15 14 13
--s-d-r
FDW
SQLite Foreign Data Wrapper
pgbouncer_fdw
18 17 16 15 14 13
--s-d--
FDW
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from norma
mongo_fdw
18 17 16 15 14 13
--s-d--
FDW
foreign data wrapper for MongoDB access
redis_fdw
18 17 16 15 14 13
--s-d-r
FDW
Foreign data wrapper for querying a Redis server
pg_redis_pubsub
18 17 16 15 14 13
--s-d-r
FDW
Send redis pub/sub messages to Redis from PostgreSQL Directly
kafka_fdw
18 17 16 15 14 13
--s-d-r
FDW
kafka Foreign Data Wrapper for CSV formatted messages
hdfs_fdw
18 17 16 15 14 13
--s-d--
FDW
foreign-data wrapper for remote hdfs servers
firebird_fdw
18 17 16 15 14 13
--s-d-r
FDW
Foreign data wrapper for Firebird
aws_s3
18 17 16 15 14 13
----d-r
FDW
aws_s3 postgres extension to import/export data from/to s3
log_fdw
18 17 16 15 14 13
--s-d--
FDW
foreign-data wrapper for Postgres log file access
dblink
18 17 16 15 14 13
c-s-d--
FDW
connect to other PostgreSQL databases from within a database
file_fdw
18 17 16 15 14 13
c-s-d--
FDW
foreign-data wrapper for flat file access
postgres_fdw
18 17 16 15 14 13
c-s-d--
FDW
foreign-data wrapper for remote PostgreSQL servers
documentdb
18 17 16 15 14 13
--sLd--
SIM
API surface for DocumentDB for PostgreSQL
documentdb
18 17 16 15 14 13
--sLd--
SIM
Core API surface for DocumentDB for PostgreSQL
documentdb
18 17 16 15 14 13
--sLd--
SIM
Multi-Node API surface for DocumentDB
orafce
18 17 16 15 14 13
--s-d--
SIM
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pgtt
18 17 16 15 14 13
--s-d--
SIM
Extension to add Global Temporary Tables feature to PostgreSQL
session_variable
18 17 16 15 14 13
--s-d-r
SIM
Registration and manipulation of session variables and constants
pg_statement_rollback
18 17 16 15 14 13
--sL---
SIM
Server side rollback at statement level for PostgreSQL like Oracle or DB2
pg_dbms_metadata
18 17 16 15 14 13
--s-d--
SIM
Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
pg_dbms_lock
18 17 16 15 14 13
--s-d--
SIM
Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
pg_dbms_job
18 17 16 15 14 13
--s-d--
SIM
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
pg_dbms_errlog
18 17 16 15 14 13
--s-d--
SIM
Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
babelfishpg_common
18 17 16 15 14 13
--s-d-r
SIM
SQL Server Transact SQL Datatype Support
babelfishpg_tsql
18 17 16 15 14 13
--s-d-r
SIM
SQL Server Transact SQL compatibility
babelfishpg_tds
18 17 16 15 14 13
--sLd-r
SIM
SQL Server TDS protocol extension
babelfishpg_money
18 17 16 15 14 13
--s-dt-
SIM
SQL Server Money Data Type
spat
18 17 16 15 14 13
--s-d-r
SIM
Redis-like In-Memory DB Embedded in Postgres
pgmemcache
18 17 16 15 14 13
--s-d-r
SIM
memcached interface
pglogical
18 17 16 15 14 13
--sLd--
ETL
PostgreSQL Logical Replication
pglogical
18 17 16 15 14 13
--s-d--
ETL
Dummy extension for compatibility when upgrading from Postgres 9.4
pglogical_ticker
18 17 16 15 14 13
--sLd--
ETL
Have an accurate view on pglogical replication delay
pgl_ddl_deploy
18 17 16 15 14 13
--s-d--
ETL
automated ddl deployment using pglogical
pg_failover_slots
18 17 16 15 14 13
--sL--r
ETL
PG Failover Slots extension
db_migrator
18 17 16 15 14 13
----dt-
ETL
Tools to migrate other databases to PostgreSQL
pgactive
18 17 16 15 14 13
-bsLd--
ETL
Active-Active Replication Extension for PostgreSQL
wal2json
18 17 16 15 14 13
--s----
ETL
Changing data capture in JSON format
wal2mongo
18 17 16 15 14 13
--s----
ETL
PostgreSQL logical decoding output plugin for MongoDB
decoderbufs
18 17 16 15 14 13
--s----
ETL
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
decoder_raw
18 17 16 15 14 13
--s----
ETL
Output plugin for logical replication in Raw SQL format
mimeo
18 17 16 15 14 13
----d--
ETL
Extension for specialized, per-table replication between PostgreSQL instances
repmgr
18 17 16 15 14 13
--s-d--
ETL
Replication manager for PostgreSQL
pg_fact_loader
18 17 16 15 14 13
--s-d--
ETL
build fact tables with Postgres
pg_bulkload
18 17 16 15 14 13
-bs-d--
ETL
pg_bulkload is a high speed data loading utility for PostgreSQL
test_decoding
18 17 16 15 14 13
c-s----
ETL
SQL-based test/example module for WAL logical decoding
pgoutput
18 17 16 15 14 13
c-s----
ETL
Logical Replication output plugin

Attribute Legend: c:contrib b:bin s:lib l:load d:ddl t:trusted r:relocatable

Last updated on