Extensions

Extensions are Postgres most loved feature. Augment your database functionality in every imaginable way! And benefit from an ecosystem of hundreds of open source extensions.

StackGres supports dynamically loading extensions into your Postgres cluster's pods. StackGres supports 100+ extensions, with the list growing every day. No allow list, no small set of extensions available. StackGres is the Postgres platform with the most extensions available. Search/browse them below:

Name Versions License Tags Description
Your request didn't match any extension.
address_standardizer 3.2.1 3.3.2 GPL-2.0 postgis spatial geographic Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. .
address_standardizer_data_us 3.2.1 3.3.2 GPL-2.0 postgis spatial geographic Address Standardizer US dataset example .
adminpack 2.1 2.0 PostgreSQL contrib Administrative functions for PostgreSQL.
aggs_for_arrays 1.3.2 MIT math arithmetic arrays vectors Functions to compute statistics on arrays of numbers.
aggs_for_vecs 1.2.1 MIT math arithmetic arrays vectors aggregates statistics Aggregate functions for vectors (arrays) of numbers.
amcheck 1.2 1.3 1.1 PostgreSQL contrib Functions for verifying relation integrity.
autoinc 1.0 PostgreSQL contrib Functions for autoincrementing fields.
bedquilt 2.1.0 MIT json object store document store jsonb json store bedquilt bedquiltdb A json document store.
bloom 1.0 PostgreSQL contrib Bloom access method - signature file based index.
bool_plperl 1.0 PostgreSQL contrib Transform between bool and plperl.
bool_plperlu 1.0 PostgreSQL contrib Transform between bool and plperlu.
btree_gin 1.3 PostgreSQL contrib Support for indexing common datatypes in GIN.
btree_gist 1.5 1.6 1.7 PostgreSQL contrib Support for indexing common datatypes in GiST.
citext 1.6 1.5 PostgreSQL contrib Data type for case-insensitive character strings.
citus 10.2.5 11.0.5 10.1-1 10.2-4 11.0-2 10.2-2 11.0-4 11.1-1 10.2-5 11.2-1 AGPL-3.0 multi-tenant sharding distributed-database citus database-cluster citus-extension Scalable PostgreSQL for real-time workloads.
citus_columnar 11.1-1 11.2-1 AGPL-3.0 multi-tenant sharding distributed-database citus database-cluster citus-extension Scalable PostgreSQL for real-time workloads.
colnames 1.1.0 PostgreSQL column names columns colnames record row composite Lists the column names in a PostgreSQL RECORD value.
cryptint 1.0.0 PostgreSQL crypto sequence Encryption functions for int and bigint values.
cube 1.4 1.5 PostgreSQL contrib Data type for multidimensional cubes.
db_info 0.2.0 0.1.0 PostgreSQL info Information about the database: size, owner, name, tablespces, ext, obj count, etc.
dblink 1.2 PostgreSQL contrib Connect to other PostgreSQL databases from within a database.
decoderbufs 2.1.2 MIT plugin postgres protobuf replication decoderbufs Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format.
dict_int 1.0 PostgreSQL contrib Text search dictionary template for integers.
dict_xsyn 1.0 PostgreSQL contrib Text search dictionary template for extended synonym processing.
earthdistance 1.1 PostgreSQL contrib Calculate great-circle distances on the surface of the Earth.
file_fdw 1.0 PostgreSQL contrib Foreign-data wrapper for flat file access.
financial 1.0.1 PostgreSQL financial finance rate of return xirr aggregate functions excel investment Financial aggregate functions.
floatvec 1.0.1 MIT math arithmetic arrays vectors Math for vectors (arrays) of numbers.
fuzzystrmatch 1.1 PostgreSQL contrib Determine similarities and distance between strings.
fuzzywuzzy 0.0.2 PostgreSQL match ratio similar Fuzzywuzzy ratio for postgres.
generate_date_series 1.0.0 PostgreSQL parallel meta Generate series for date types.
geoip 0.2.4 BSD 2-CLAUSE geolocation geoip ip Geolocation using GeoIP.
hexgrid 1.0.3 BSD 3-CLAUSE hexgrid morton code Configurable hexgrid.
hll 2.17 Apache-2.0 hyperloglog data-type postgresql-extension Type for storing hyperloglog data .
hostname 1.0.0 PostgreSQL hostname host gethostbyname Get the server host name.
hstore 1.7 1.6 1.8 1.5 PostgreSQL contrib Data type for storing sets of (key, value) pairs.
hstore_plperl 1.0 PostgreSQL contrib Transform between hstore and plperl.
hstore_plperlu 1.0 PostgreSQL contrib Transform between hstore and plperlu.
hstore_plpython2u 1.0 PostgreSQL contrib Transform between hstore and plpython2u.
hstore_plpython3u 1.0 PostgreSQL contrib Transform between hstore and plpython3u.
hstore_plpythonu 1.0 PostgreSQL contrib Transform between hstore and plpythonu.
http 1.5 MIT http postgresql-extension HTTP client for PostgreSQL, allows web page retrieval inside the database.
hunspell_cs_cz 1.0 PostgreSQL hunspell dictionaries postgresql-extension Czech Hunspell Dictionary .
hunspell_de_de 1.0 PostgreSQL hunspell dictionaries postgresql-extension German Hunspell Dictionary .
hunspell_en_us 1.0 PostgreSQL hunspell dictionaries postgresql-extension En_US Hunspell Dictionary .
hunspell_fr 1.0 PostgreSQL hunspell dictionaries postgresql-extension French Hunspell Dictionary .
hunspell_ne_np 1.0 PostgreSQL hunspell dictionaries postgresql-extension Nepali Hunspell Dictionary .
hunspell_nl_nl 1.0 PostgreSQL hunspell dictionaries postgresql-extension Dutch Hunspell Dictionary .
hunspell_nn_no 1.0 PostgreSQL hunspell dictionaries postgresql-extension Norwegian (norsk) Hunspell Dictionary .
hunspell_pt_pt 1.0 PostgreSQL hunspell dictionaries postgresql-extension Portuguese Hunspell Dictionary .
hunspell_ru_ru 1.0 PostgreSQL hunspell dictionaries postgresql-extension Russian Hunspell Dictionary .
hunspell_ru_ru_aot 1.0 PostgreSQL hunspell dictionaries postgresql-extension Russian Hunspell Dictionary (from AOT.ru group) .
hypopg 1.3.1 PostgreSQL index hypothetical An extension adding hypothetical indexes in PostgreSQL.
icu_ext 1.6.2 1.6 PostgreSQL icu unicode collation Access ICU functions.
inetrange 1.0.1 MIT range inet ip networking Range type for inet.
insert_username 1.0 PostgreSQL contrib Functions for tracking who changed a table.
intagg 1.1 PostgreSQL contrib Integer aggregator and enumerator (obsolete).
intarray 1.3 1.2 1.5 PostgreSQL contrib Functions, operators, and index support for 1-D arrays of integers.
isn 1.2 PostgreSQL contrib Data types for international product numbering standards.
json_utils 0.1 PostgreSQL json operator Extension to work with json type.
jsonb_deep_sum 0.0.2 MIT jsonb Sum jsonbs recursively.
jsonb_plperl 1.0 PostgreSQL contrib Transform between jsonb and plperl.
jsonb_plperlu 1.0 PostgreSQL contrib Transform between jsonb and plperlu.
jsonb_plpython2u 1.0 PostgreSQL contrib Transform between jsonb and plpython2u.
jsonb_plpython3u 1.0 PostgreSQL contrib Transform between jsonb and plpython3u.
jsonb_plpythonu 1.0 PostgreSQL contrib Transform between jsonb and plpythonu.
jx_io 0.1.1 PostgreSQL json xml datatype Extension to export and import json and xml from/to postgres .
lo 1.1 PostgreSQL contrib Large Object maintenance.
lostgis 1.0.2 BSD 3-CLAUSE gis tpv spatial temporal spatiotemporal LostGIS.
ltree 1.2 1.1 PostgreSQL contrib Data type for hierarchical tree-like structures.
ltree_plpython2u 1.0 PostgreSQL contrib Transform between ltree and plpython2u.
ltree_plpython3u 1.0 PostgreSQL contrib Transform between ltree and plpython3u.
ltree_plpythonu 1.0 PostgreSQL contrib Transform between ltree and plpythonu.
md5hash 1.0.1 BSD 2-CLAUSE md5 hash data type Efficient inline storage of 128-bit binary data (e.g. MD5 hashes).
mimeo 1.5.1 PostgreSQL replication table per-table logical Extension for specialized, per-table replication between PostgreSQL databases.
moddatetime 1.0 PostgreSQL contrib Functions for tracking last modification time.
mysql_fdw 2.8.0 1.1 1.2 PostgreSQL mysql fdw extensions PostgreSQL foreign data wrapper for MySQL .
mysqlcompat 0.0.7 UNRESTRICTED mysql compatibility conversion functions 2ndQuadrant MySQL compatibility functions.
noset 0.3.0 0.1.0 0.2.0 AGPL-3.0 set permissions reset nosuperuser Module for blocking SET variables for non-super users.
old_snapshot 1.0 PostgreSQL contrib Utilities in support of old_snapshot_threshold.
pageinspect 1.8 1.7 1.9 1.10 1.11 PostgreSQL contrib Inspect the contents of database pages at a low level.
permuteseq 1.2 PostgreSQL sequence feistel crypto Extension to manage scalable pseudo-random permutations of sequences.
pg_auditor 0.2 BSD 3-CLAUSE pg_auditor audit audit log auditing log logging flashback transaction flashback rollback Auditing extension that records each data modification statement and allows partial or complete flashback of transactions.
pg_buffercache 1.3 PostgreSQL contrib Examine the shared buffer cache.
pg_cron 1.4 PostgreSQL crontab scheduler periodic-jobs Job scheduler for PostgreSQL.
pg_fkpart 1.7 GPL-2.0 partitioning table partitioning foreign key Table partitioning by foreign key utility for PostgreSQL.
pg_freespacemap 1.2 PostgreSQL contrib Examine the free space map (FSM).
pg_graphql 1.0.2 1.1.0 Apache-2.0 api graphql postgres sql graphql-server postgresql-extension Pg_graphql: GraphQL support .
pg_hashids 1.3 MIT hashid postgresql-extension Pg_hashids.
pg_healpix 1.0 HEALPIX healpix sphere HEALPIX functions for PostgreSQL.
pg_jobmon 1.4.1 PostgreSQL function functions function logging function monitoring job jobs job logging job monitoring log logging monitoring autonomous transactions Job logging and monitoring extension.
pg_jsonschema 0.1.4 Apache-2.0 json-schema json jsonb postgres sql postgresql-extension supabase Pg_jsonschema .
pg_monitoring 0.1 PostgreSQL monitoring An extension to provide basic monitoring functions for Postgres.
pg_natural_sort_order 1.0.1 MIT natural sort order sorting human-friendly Natural Sort Order for PostgreSQL 9.
pg_net 0.2 0.7.1 APACHE-2.0 network curl async postgresql-extension Async HTTP.
pg_prewarm 1.2 PostgreSQL contrib Prewarm relation data.
pg_proctab 0.0.10 PostgreSQL process os postgresql-extension Access operating system process table .
pg_readonly 0.0.1 PostgreSQL read only cluster Set all cluster databases in read only.
pg_repack 1.4.7 1.4.6 1.4.8 BSD 3-CLAUSE repack vacuum reorganize lock PostgreSQL module for data reorganization.
pg_sphere 1.0 BSD 3-CLAUSE pg_sphere r-tree gist sphere Spherical objects with useful functions, operators and index support.
pg_sqlog 1.5 1.4 BSD 3-CLAUSE csvlog csv logging log fdw An extension providing access to PostgreSQL logs through SQL interface.
pg_stat_kcache 2.2.1 PostgreSQL postgresql Kernel statistics gathering.
pg_stat_statements 1.8 1.7 1.9 1.6 1.10 PostgreSQL contrib Track planning and execution statistics of all SQL statements executed.
pg_surgery 1.0 PostgreSQL contrib Extension to perform surgery on a damaged relation.
pg_timeout 1.0 PostgreSQL timeout idle session Timeout for idle database session.
pg_tle 1.0.1 Apache-2.0 tle trusted language postgresql-extension pg-tle Trusted-Language Extensions for PostgreSQL .
pg_track_settings 2.0.1 PostgreSQL monitoring administration A simple extension which keep track of postgresql settings modifications.
pg_trgm 1.5 1.4 1.6 PostgreSQL contrib Text similarity measurement and index searching based on trigrams.
pg_visibility 1.2 PostgreSQL contrib Examine the visibility map (VM) and page-level visibility info.
pg_wait_sampling 1.1 PostgreSQL postgres Pg_wait_sampling is an extension for collecting sampling statistics of wait events.
pg_walinspect 1.0 PostgreSQL contrib Functions to inspect contents of PostgreSQL Write-Ahead Log .
pgaudit 1.4.3 1.5.2 1.6.2 1.7 PostgreSQL extension database postgresql audit audit-log Provides auditing functionality.
pgbouncer_fdw 0.2 PostgreSQL pgbouncer fdw Extension for querying pgbouncer stats from normal SQL views.
pgcozy 1.0.0 1.0 PostgreSQL function performance shared buffers caching Shared buffer snapshot and prewarm extension.
pgcrypto 1.3 PostgreSQL contrib Cryptographic functions.
pgjwt 0.2.0 MIT pgjwt JSON Web Token API for Postgresql.
pgmemento 0.7.2 LGPL-3.0 audit auditing trail log logging history versioning journaling pgmemento Audit trail with schema versioning for PostgreSQL using transaction-based logging.
pgrowlocks 1.2 PostgreSQL contrib Show row-level locking information.
pgsodium 2.0.0 3.1.5 PostgreSQL libsodium cryptography encryption decryption postgresql-extension Postgres extension for libsodium functions.
pgstattuple 1.5 PostgreSQL contrib Show tuple-level statistics.
pgtap 1.1.0 1.2.0 PostgreSQL testing unit testing tap tddd test driven database development Unit testing for PostgreSQL.
pgtt 2.4.0 ISC global temporary table Extension to add Global Temporary Tables feature to PostgreSQL.
pgwaffles 1.0.1 PostgreSQL waffles fosdem
plperl 1.0 PostgreSQL core language PL/Perl procedural language.
plperlu 1.0 PostgreSQL core language PL/PerlU untrusted procedural language.
plpgsql 1.0 PostgreSQL core language PL/pgSQL procedural language.
plpgsql_check 2.0 2.3 BSD 2-CLAUSE plpgsql analyzer validate development profiler Additional tools for plpgsql functions validation.
plpython3u 1.0 PostgreSQL core language PL/Python3U untrusted procedural language.
pltcl 1.0 PostgreSQL core language PL/Tcl procedural language.
pltclu 1.0 PostgreSQL core language PL/TclU untrusted procedural language.
postgis 3.0.5 3.1.5 3.2.1 3.0.1 3.1.4 3.3.2 GPL-2.0 postgis spatial geographic PostGIS geometry, geography, and raster spatial types and functions.
postgis_raster 3.0.5 3.1.5 3.2.1 3.0.1 3.1.4 3.3.2 GPL-2.0 postgis spatial geographic PostGIS raster types and functions.