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.
aggs_for_arrays 1.3.2 PostgreSQL math arithmetic arrays vectors Various functions for computing statistics on arrays of numbers
aggs_for_vecs 1.2.1 PostgreSQL math arithmetic arrays vectors aggregates statistics Various functions for computing statistics on vectors (arrays) of numbers
bedquilt 2.1.0 PostgreSQL json object store document store jsonb json store bedquilt bedquiltdb A json document store
citus 10.1-1 10.2-2 PostgreSQL multi-tenant sharding distributed-database citus database-cluster citus-extension Citus distributed database
colnames 1.1.0 PostgreSQL column names columns colnames record row composite Lists the column names in a PostgreSQL RECORD value
adminpack 2.0 2.1 PostgreSQL contrib administrative functions for PostgreSQL
amcheck 1.2 1.3 1.1 PostgreSQL contrib functions for verifying relation integrity
autoinc 1.0 PostgreSQL contrib functions for autoincrementing fields
bloom 1.0 PostgreSQL contrib bloom access method - signature file based index
btree_gin 1.3 PostgreSQL contrib support for indexing common datatypes in GIN
btree_gist 1.5 1.6 PostgreSQL contrib support for indexing common datatypes in GiST
citext 1.6 1.5 PostgreSQL contrib data type for case-insensitive character strings
cube 1.4 1.5 PostgreSQL contrib data type for multidimensional cubes
dblink 1.2 PostgreSQL contrib connect to other PostgreSQL databases from within a database
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
fuzzystrmatch 1.1 PostgreSQL contrib determine similarities and distance between strings
hstore 1.6 1.7 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
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.2 1.3 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
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
lo 1.1 PostgreSQL contrib Large Object maintenance
ltree 1.1 1.2 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
moddatetime 1.0 PostgreSQL contrib functions for tracking last modification time
pageinspect 1.7 1.8 1.9 PostgreSQL contrib inspect the contents of database pages at a low level
pg_buffercache 1.3 PostgreSQL contrib examine the shared buffer cache
pg_freespacemap 1.2 PostgreSQL contrib examine the free space map (FSM)
pg_prewarm 1.2 PostgreSQL contrib prewarm relation data
pg_stat_statements 1.7 1.8 1.9 1.6 PostgreSQL contrib track execution statistics of all SQL statements executed
pg_trgm 1.4 1.5 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
pgcrypto 1.3 PostgreSQL contrib cryptographic functions
pgrowlocks 1.2 PostgreSQL contrib show row-level locking information
pgstattuple 1.5 PostgreSQL contrib show tuple-level statistics
postgres_fdw 1.0 1.1 PostgreSQL contrib foreign-data wrapper for remote PostgreSQL servers
refint 1.0 PostgreSQL contrib functions for implementing referential integrity (obsolete)
seg 1.3 1.4 PostgreSQL contrib data type for representing line segments or floating-point intervals
sslinfo 1.2 PostgreSQL contrib information about SSL certificates
tablefunc 1.0 PostgreSQL contrib functions that manipulate whole tables, including crosstab
tcn 1.0 PostgreSQL contrib Triggered change notifications
tsm_system_rows 1.0 PostgreSQL contrib TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time 1.0 PostgreSQL contrib TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent 1.1 PostgreSQL contrib text search dictionary that removes accents
uuid-ossp 1.1 PostgreSQL contrib generate universally unique identifiers (UUIDs)
xml2 1.1 PostgreSQL contrib XPath querying and XSLT
bool_plperl 1.0 PostgreSQL contrib transform between bool and plperl
bool_plperlu 1.0 PostgreSQL contrib transform between bool and plperlu
old_snapshot 1.0 PostgreSQL contrib utilities in support of old_snapshot_threshold
pg_surgery 1.0 PostgreSQL contrib extension to perform surgery on a damaged relation
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
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
cryptint 1.0.0 PostgreSQL crypto sequence Encryption functions for int and bigint values
db_info 0.1.0 PostgreSQL info Extension to get information about the database: size, owner, name,tablespces, ext, obj count,etc
financial 1.0.1 PostgreSQL financial finance rate of return xirr aggregate functions excel investment Financial aggregate functions
floatvec 1.0.1 PostgreSQL math arithmetic arrays vectors Math for vectors (arrays) of numbers
fuzzywuzzy 0.0.2 PostgreSQL match ratio similar fuzzywuzzy ratio for postgres
generate_date_series 1.0.0 PostgreSQL parallel meta generate_series() for pure date values
geoip 0.2.4 PostgreSQL geolocation geoip ip An IP geolocation extension (a wrapper around the MaxMind GeoLite dataset)
hexgrid 1.0.3 PostgreSQL hexgrid morton code Hexgrid
hostname 1.0.0 PostgreSQL hostname host gethostbyname Get the server host name
hypopg 1.3.1 PostgreSQL index hypothetical Hypothetical indexes for PostgreSQL
icu_ext 1.6 PostgreSQL icu unicode collation Access ICU functions
inetrange 1.0.1 PostgreSQL range inet ip networking Range type for inet
json_utils 0.1 PostgreSQL json operator Extension to work with json type
jsonb_deep_sum 0.0.2 PostgreSQL jsonb jsonb deep sum
jx_io 0.1.1 PostgreSQL json xml datatype Extension to export and import json and xml from/to postgres
lostgis 1.0.2 PostgreSQL gis tpv spatial temporal spatiotemporal LostGIS
md5hash 1.0.1 PostgreSQL md5 hash data type type for storing 128-bit binary data inline
mimeo 1.5.1 PostgreSQL replication table per-table logical Extension for specialized, per-table replication between PostgreSQL instances
mysqlcompat 0.0.7 PostgreSQL mysql compatibility conversion functions 2ndQuadrant MySQL compatibility functions
noset 0.1.0 0.2.0 PostgreSQL set permissions reset nosuperuser module to avoid SET command for specific user
permuteseq 1.2 PostgreSQL sequence feistel crypto Pseudo-randomly permute sequences with a format-preserving encryption on elements
pg_auditor 0.2 PostgreSQL pg_auditor audit audit log auditing log logging flashback transaction flashback rollback Audit data changes and provide flashback ability
pg_cron 1.4 PostgreSQL crontab scheduler periodic-jobs Job scheduler for PostgreSQL
pg_fkpart 1.7 PostgreSQL partitioning table partitioning foreign key Table partitioning by foreign key utility
pg_healpix 1.0 PostgreSQL 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 Extension for logging and monitoring functions in PostgreSQL
pg_monitoring 0.1 PostgreSQL monitoring An extension to provide basic monitoring functions for Postgres
pg_natural_sort_order 1.0.1 PostgreSQL natural sort order sorting human-friendly pg_natural_sort_order allows for natural sort ordering on a standard index.
q3c 2.0.0 PostgreSQL q3c sky indexing q3c sky indexing plugin
pg_readonly 0.0.1 PostgreSQL read only cluster cluster database read only
pg_repack 1.4.7 1.4.6 PostgreSQL repack vacuum reorganize lock Reorganize tables in PostgreSQL databases with minimal locks
pg_sqlog 1.4 PostgreSQL csvlog csv logging log fdw Provide SQL interface to logs
pg_timeout 1.0 PostgreSQL timeout idle session pg_timeout extension
pg_track_settings 2.0.1 PostgreSQL monitoring administration Track settings changes
pgbouncer_fdw 0.2 PostgreSQL pgbouncer fdw Extension for querying pgbouncer stats from normal SQL views
pgcozy 1.0 PostgreSQL function performance shared buffers caching Extension for pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
pgmemento 0.7.2 PostgreSQL audit auditing trail log logging history versioning journaling pgmemento Audit trail with schema versioning for PostgreSQL using transaction-based logging
pg_sphere 1.0 PostgreSQL pg_sphere r-tree gist sphere spherical objects with useful functions, operators and index support
pgtap 1.1.0 PostgreSQL testing unit testing tap tddd test driven database development Unit testing for PostgreSQL
pgtt 2.4.0 PostgreSQL global temporary table Extension to add Global Temporary Tables feature to PostgreSQL
pgwaffles 1.0.1 PostgreSQL waffles fosdem
plpgsql_check 2.0 PostgreSQL plpgsql analyzer validate development profiler extended check for plpgsql functions
postgis 3.0.1 3.1.4 PostgreSQL postgis spatial geographic PostGIS geometry, geography, and raster spatial types and functions
postgis_raster 3.0.1 3.1.4 PostgreSQL postgis spatial geographic PostGIS raster types and functions
postgis_tiger_geocoder 3.0.1 3.1.4 PostgreSQL postgis spatial geographic PostGIS tiger geocoder and reverse geocoder
postgis_topology 3.0.1 3.1.4 PostgreSQL postgis spatial geographic PostGIS topology spatial types and functions
qgres 0.1.2 PostgreSQL queue queuing PgQ A simple queue system. http://github.com/decibel/Qgres
resetsequence 1.0.0 PostgreSQL reset sequences function functions utility maintenance administration resetsequence functions to reset sequences to values contained in tables
sequential_uuids 1.0.1 PostgreSQL UUID generator generator of sequential UUIDs
shacrypt 1.1 PostgreSQL crypt hash sha256-crypt sha512-crypt Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
short_ids 0.1.0 PostgreSQL default random Extension to generate short, textual, unique id strings
test_factory 0.3.1 PostgreSQL testing unit test tests test data test factory A framework for managing test data
timescaledb 1.7.4 2.2.1 2.3.1 2.2.0 PostgreSQL timescale time series Enables scalable inserts and complex queries for time-series data
unnest_ordinality 1.0.1 PostgreSQL array unnest ordinality row_number unnest function with ordinality
vacuum_utils 0.1.0 PostgreSQL info maintenance to get information and execute statement about VACUUM and ANALYZE on tables
vector 0.1.8 PostgreSQL vectors datatype nearest neighbor search approximate nearest neighbors vector data type and ivfflat access method
timetravel 1.0 PostgreSQL contrib functions for implementing time travel

Do you feel any extension is missing? Please create an issue and let us know. If you are an extension creator/maintainer and would like to see your extension added, please contact us on the #extensions channel in our Community Slack.