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:

NameVersionsLicenseTagsDescription
Your request didn't match any extension.
address_standardizer3.2.1 3.3.2 3.2.6 3.3.5GPL-2.0postgis spatial geographicUsed to parse an address into constituent elements. Generally used to support geocoding address normalization step. .
address_standardizer_data_us3.2.1 3.3.2 3.2.6 3.3.5GPL-2.0postgis spatial geographicAddress Standardizer US dataset example .
adminpack2.1 2.0PostgreSQLcontribAdministrative functions for PostgreSQL.
aggs_for_arrays1.3.2MITmath arithmetic arrays vectorsFunctions to compute statistics on arrays of numbers.
aggs_for_vecs1.2.1MITmath arithmetic arrays vectors aggregates statisticsAggregate functions for vectors (arrays) of numbers.
amcheck1.2 1.3 1.1PostgreSQLcontribFunctions for verifying relation integrity.
autoinc1.0PostgreSQLcontribFunctions for autoincrementing fields.
bedquilt2.1.0MITjson object store document store jsonb json store bedquilt bedquiltdbA json document store.
bloom1.0PostgreSQLcontribBloom access method - signature file based index.
bool_plperl1.0PostgreSQLcontribTransform between bool and plperl.
bool_plperlu1.0PostgreSQLcontribTransform between bool and plperlu.
btree_gin1.3PostgreSQLcontribSupport for indexing common datatypes in GIN.
btree_gist1.5 1.6 1.7PostgreSQLcontribSupport for indexing common datatypes in GiST.
citext1.6 1.5PostgreSQLcontribData type for case-insensitive character strings.
citus10.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 11.2-2 11.3-1 12.0-1 12.1-1AGPL-3.0multi-tenant sharding distributed-database citus database-cluster citus-extensionScalable PostgreSQL for real-time workloads.
citus_columnar11.1-1 11.2-1 11.3-1AGPL-3.0multi-tenant sharding distributed-database citus database-cluster citus-extensionScalable PostgreSQL for real-time workloads.
colnames1.1.0PostgreSQLcolumn names columns colnames record row compositeLists the column names in a PostgreSQL RECORD value.
credcheck1.1.0 2.1.0 2.2.0 2.3.0MITcredential-checker password policy-enforcementCredcheck - postgresql plain text credential checker .
cryptint1.0.0PostgreSQLcrypto sequenceEncryption functions for int and bigint values.
cube1.4 1.5PostgreSQLcontribData type for multidimensional cubes.
db_info0.2.0 0.1.0PostgreSQLinfoInformation about the database: size, owner, name, tablespces, ext, obj count, etc.
dblink1.2PostgreSQLcontribConnect to other PostgreSQL databases from within a database.
decoderbufs2.1.2 2.2.0 2.3.0 2.4.0MITplugin postgres protobuf replication decoderbufsLogical decoding plugin that delivers WAL stream changes using a Protocol Buffer format.
dict_int1.0PostgreSQLcontribText search dictionary template for integers.
dict_xsyn1.0PostgreSQLcontribText search dictionary template for extended synonym processing.
earthdistance1.1PostgreSQLcontribCalculate great-circle distances on the surface of the Earth.
file_fdw1.0PostgreSQLcontribForeign-data wrapper for flat file access.
financial1.0.1PostgreSQLfinancial finance rate of return xirr aggregate functions excel investmentFinancial aggregate functions.
floatvec1.0.1MITmath arithmetic arrays vectorsMath for vectors (arrays) of numbers.
fuzzystrmatch1.1 1.2PostgreSQLcontribDetermine similarities and distance between strings.
fuzzywuzzy0.0.2PostgreSQLmatch ratio similarFuzzywuzzy ratio for postgres.
generate_date_series1.0.0PostgreSQLparallel metaGenerate series for date types.
geoip0.2.4BSD 2-CLAUSEgeolocation geoip ipGeolocation using GeoIP.
hexgrid1.0.3BSD 3-CLAUSEhexgrid morton codeConfigurable hexgrid.
hll2.17 2.18Apache-2.0hyperloglog data-type postgresql-extensionType for storing hyperloglog data .
hostname1.0.0PostgreSQLhostname host gethostbynameGet the server host name.
hstore1.7 1.6 1.8 1.5PostgreSQLcontribData type for storing sets of (key, value) pairs.
hstore_plperl1.0PostgreSQLcontribTransform between hstore and plperl.
hstore_plperlu1.0PostgreSQLcontribTransform between hstore and plperlu.
hstore_plpython2u1.0PostgreSQLcontribTransform between hstore and plpython2u.
hstore_plpython3u1.0PostgreSQLcontribTransform between hstore and plpython3u.
hstore_plpythonu1.0PostgreSQLcontribTransform between hstore and plpythonu.
http1.5 1.6MIThttp postgresql-extensionHTTP client for PostgreSQL, allows web page retrieval inside the database.
hunspell_cs_cz1.0PostgreSQLhunspell dictionaries postgresql-extensionCzech Hunspell Dictionary .
hunspell_de_de1.0PostgreSQLhunspell dictionaries postgresql-extensionGerman Hunspell Dictionary .
hunspell_en_us1.0PostgreSQLhunspell dictionaries postgresql-extensionEn_US Hunspell Dictionary .
hunspell_fr1.0PostgreSQLhunspell dictionaries postgresql-extensionFrench Hunspell Dictionary .
hunspell_ne_np1.0PostgreSQLhunspell dictionaries postgresql-extensionNepali Hunspell Dictionary .
hunspell_nl_nl1.0PostgreSQLhunspell dictionaries postgresql-extensionDutch Hunspell Dictionary .
hunspell_nn_no1.0PostgreSQLhunspell dictionaries postgresql-extensionNorwegian (norsk) Hunspell Dictionary .
hunspell_pt_pt1.0PostgreSQLhunspell dictionaries postgresql-extensionPortuguese Hunspell Dictionary .
hunspell_ru_ru1.0PostgreSQLhunspell dictionaries postgresql-extensionRussian Hunspell Dictionary .
hunspell_ru_ru_aot1.0PostgreSQLhunspell dictionaries postgresql-extensionRussian Hunspell Dictionary (from AOT.ru group) .
hypopg1.3.1PostgreSQLindex hypotheticalAn extension adding hypothetical indexes in PostgreSQL.
icu_ext1.6.2 1.6 1.7PostgreSQLicu unicode collationAccess ICU functions.
inetrange1.0.1MITrange inet ip networkingRange type for inet.
insert_username1.0PostgreSQLcontribFunctions for tracking who changed a table.
intagg1.1PostgreSQLcontribInteger aggregator and enumerator (obsolete).
intarray1.3 1.2 1.5PostgreSQLcontribFunctions, operators, and index support for 1-D arrays of integers.
isn1.2PostgreSQLcontribData types for international product numbering standards.
json_utils0.1PostgreSQLjson operatorExtension to work with json type.
jsonb_deep_sum0.0.2MITjsonbSum jsonbs recursively.
jsonb_plperl1.0PostgreSQLcontribTransform between jsonb and plperl.
jsonb_plperlu1.0PostgreSQLcontribTransform between jsonb and plperlu.
jsonb_plpython2u1.0PostgreSQLcontribTransform between jsonb and plpython2u.
jsonb_plpython3u1.0PostgreSQLcontribTransform between jsonb and plpython3u.
jsonb_plpythonu1.0PostgreSQLcontribTransform between jsonb and plpythonu.
jx_io0.1.1PostgreSQLjson xml datatypeExtension to export and import json and xml from/to postgres .
lo1.1PostgreSQLcontribLarge Object maintenance.
lostgis1.0.2BSD 3-CLAUSEgis tpv spatial temporal spatiotemporalLostGIS.
ltree1.2 1.1PostgreSQLcontribData type for hierarchical tree-like structures.
ltree_plpython2u1.0PostgreSQLcontribTransform between ltree and plpython2u.
ltree_plpython3u1.0PostgreSQLcontribTransform between ltree and plpython3u.
ltree_plpythonu1.0PostgreSQLcontribTransform between ltree and plpythonu.
md5hash1.0.1BSD 2-CLAUSEmd5 hash data typeEfficient inline storage of 128-bit binary data (e.g. MD5 hashes).
mimeo1.5.1PostgreSQLreplication table per-table logicalExtension for specialized, per-table replication between PostgreSQL databases.
moddatetime1.0PostgreSQLcontribFunctions for tracking last modification time.
mysql_fdw2.8.0 1.1 1.2PostgreSQLmysql fdw extensionsPostgreSQL foreign data wrapper for MySQL .
mysqlcompat0.0.7UNRESTRICTEDmysql compatibility conversion functions 2ndQuadrantMySQL compatibility functions.
noset0.3.0 0.1.0 0.2.0AGPL-3.0set permissions reset nosuperuserModule for blocking SET variables for non-super users.
old_snapshot1.0PostgreSQLcontribUtilities in support of old_snapshot_threshold.
orafce4.6PostgreSQLoracle-to-postgres orafce oracle postgresql-extension compatibilityOracle's compatibility functions and packages.
pageinspect1.8 1.7 1.9 1.10 1.11 1.12PostgreSQLcontribInspect the contents of database pages at a low level.
parquet_s3_fdw0.3PostgreSQLparquet fdw s3 parquet_s3_fdw foreign-data-wrapperParquet S3 Foreign Data Wrapper.
periods1.2PostgreSQLsystem-versioning periods sql-standardsPeriods and SYSTEM VERSIONING for PostgreSQL.
permuteseq1.2PostgreSQLsequence feistel cryptoExtension to manage scalable pseudo-random permutations of sequences.
pg_auditor0.2BSD 3-CLAUSEpg_auditor audit audit log auditing log logging flashback transaction flashback rollbackAuditing extension that records each data modification statement and allows partial or complete flashback of transactions.
pg_buffercache1.3 1.4PostgreSQLcontribExamine the shared buffer cache.
pg_cron1.4 1.4-1 1.5 1.6PostgreSQLcrontab scheduler periodic-jobsJob scheduler for PostgreSQL.
pg_fkpart1.7GPL-2.0partitioning table partitioning foreign keyTable partitioning by foreign key utility for PostgreSQL.
pg_freespacemap1.2PostgreSQLcontribExamine the free space map (FSM).
pg_graphql1.0.2 1.1.0 1.3.0 1.4.2Apache-2.0api graphql postgres sql graphql-server postgresql-extensionPg_graphql: GraphQL support .
pg_hashids1.3MIThashid postgresql-extensionPg_hashids.
pg_healpix1.0HEALPIXhealpix sphereHEALPIX functions for PostgreSQL.
pg_ivm1.6 1.7PostgreSQLpg_ivm ivm incremental-view-maintenance materialized-viewsIVM (Incremental View Maintenance) implementation as a PostgreSQL extension .
pg_jobmon1.4.1PostgreSQLfunction functions function logging function monitoring job jobs job logging job monitoring log logging monitoring autonomous transactionsJob logging and monitoring extension.
pg_jsonschema0.1.4Apache-2.0json-schema json jsonb postgres sql postgresql-extension supabasePg_jsonschema .
pg_monitoring0.1PostgreSQLmonitoringAn extension to provide basic monitoring functions for Postgres.
pg_natural_sort_order1.0.1MITnatural sort order sorting human-friendlyNatural Sort Order for PostgreSQL 9.
pg_net0.2 0.7.1APACHE-2.0network curl async postgresql-extensionAsync HTTP.
pg_partman4.7.3 4.7.4 5.0.0PostgreSQLpg-partition-manager partitioning background-worker plpgsql postgresql-extensionExtension to manage partitioned tables by time or ID .
pg_prewarm1.2PostgreSQLcontribPrewarm relation data.
pg_proctab0.0.10PostgreSQLprocess os postgresql-extensionAccess operating system process table .
pg_readonly0.0.1PostgreSQLread only clusterSet all cluster databases in read only.
pg_repack1.4.7 1.4.6 1.4.8 1.5.0BSD 3-CLAUSErepack vacuum reorganize lockPostgreSQL module for data reorganization.
pg_sphere1.0BSD 3-CLAUSEpg_sphere r-tree gist sphereSpherical objects with useful functions, operators and index support.
pg_sqlog1.5 1.4BSD 3-CLAUSEcsvlog csv logging log fdwAn extension providing access to PostgreSQL logs through SQL interface.
pg_stat_kcache2.2.1 2.2.2PostgreSQLpostgresqlKernel statistics gathering.
pg_stat_monitor2.0PostgreSQLpostgres query performance monitoring query-information statistics observabilityQuery Performance Monitoring Tool for PostgreSQL .
pg_stat_statements1.8 1.7 1.9 1.6 1.10PostgreSQLcontribTrack planning and execution statistics of all SQL statements executed.
pg_store_plans1.6.1 1.7PostgreSQL Licenseexecution plans tracking execution module pg_store_plans plan statisticsTrack plan statistics of all SQL statements executed .
pg_surgery1.0PostgreSQLcontribExtension to perform surgery on a damaged relation.
pg_timeout1.0PostgreSQLtimeout idle sessionTimeout for idle database session.
pg_tle1.0.1 1.2.0Apache-2.0tle trusted language postgresql-extension pg-tleTrusted-Language Extensions for PostgreSQL .
pg_track_settings2.0.1PostgreSQLmonitoring administrationA simple extension which keep track of postgresql settings modifications.
pg_trgm1.5 1.4 1.6PostgreSQLcontribText similarity measurement and index searching based on trigrams.
pg_visibility1.2PostgreSQLcontribExamine the visibility map (VM) and page-level visibility info.
pg_wait_sampling1.1PostgreSQLpostgresPg_wait_sampling is an extension for collecting sampling statistics of wait events.
pg_walinspect1.0 1.1PostgreSQLcontribFunctions to inspect contents of PostgreSQL Write-Ahead Log .
pgaudit1.4.3 1.5.2 1.6.2 1.7PostgreSQLextension database postgresql audit audit-logProvides auditing functionality.
pgbouncer_fdw0.2PostgreSQLpgbouncer fdwExtension for querying pgbouncer stats from normal SQL views.
pgcozy1.0.0 1.0PostgreSQLfunction performance shared buffers cachingShared buffer snapshot and prewarm extension.
pgcrypto1.3PostgreSQLcontribCryptographic functions.
pgjwt0.2.0MITpgjwtJSON Web Token API for Postgresql.
pgmemento0.7.2LGPL-3.0audit auditing trail log logging history versioning journaling pgmementoAudit trail with schema versioning for PostgreSQL using transaction-based logging.
pgrowlocks1.2PostgreSQLcontribShow row-level locking information.
pgsodium2.0.0 3.1.5 3.1.6 3.1.8PostgreSQLlibsodium cryptography encryption decryption postgresql-extensionPostgres extension for libsodium functions.
pgstattuple1.5PostgreSQLcontribShow tuple-level statistics.
pgtap1.1.0 1.2.0 1.3.0PostgreSQLtesting unit testing tap tddd test driven database developmentUnit testing for PostgreSQL.
pgtt2.4.0ISCglobal temporary tableExtension to add Global Temporary Tables feature to PostgreSQL.
pgwaffles1.0.1PostgreSQLwaffles fosdem
plperl1.0PostgreSQLcore languagePL/Perl procedural language.
plperlu1.0PostgreSQLcore languagePL/PerlU untrusted procedural language.
plpgsql1.0PostgreSQLcore languagePL/pgSQL procedural language.
plpgsql_check2.0 2.3 2.4 2.5BSD 2-CLAUSEplpgsql analyzer validate development profiler stored-procedures linterAdditional tools for plpgsql functions validation.
plpython3u1.0PostgreSQLcore languagePL/Python3U untrusted procedural language.
pltcl1.0PostgreSQLcore languagePL/Tcl procedural language.
pltclu1.0PostgreSQLcore languagePL/TclU untrusted procedural language.
postgis3.0.5 3.1.5 3.2.1 3.0.1 3.1.4 3.3.2 3.0.10 3.1.10 3.2.6 3.3.5GPL-2.0postgis spatial geographicPostGIS geometry, geography, and raster spatial types and functions.
postgis_raster3.0.5 3.1.5 3.2.1 3.0.1 3.1.4 3.3.2 3.0.10 3.1.10 3.2.6 3.3.5GPL-2.0postgis spatial geographicPostGIS raster types and functions.
postgis_tiger_geocoder3.0.5 3.1.5 3.2.1 3.0.1 3.1.4 3.3.2 3.0.10 3.1.10 3.2.6 3.3.5GPL-2.0postgis spatial geographicPostGIS tiger geocoder and reverse geocoder.
postgis_topology3.0.5 3.1.5 3.2.1 3.0.1 3.1.4 3.3.2 3.0.10 3.1.10 3.2.6 3.3.5GPL-2.0postgis spatial geographicPostGIS topology spatial types and functions.
postgres_fdw1.0 1.1PostgreSQLcontribForeign-data wrapper for remote PostgreSQL servers.
promscale0.5.4 0.6.0 0.7.0 0.8.0Timescale-2.0sql monitoring time-series storage metrics postgresql prometheus tracing observability promql jaeger opentelemetry prometheus-storage prom-migratorTables, types and functions supporting Promscale.
q3c2.0.0GPL-2.0q3c sky indexingQ3c sky indexing plugin.
qgres0.1.2PostgreSQLqueue queuing PgQA simple queue for Postgres.
refint1.0PostgreSQLcontribFunctions for implementing referential integrity (obsolete).
resetsequence1.0.0PostgreSQLreset sequences function functions utility maintenance administration resetsequenceFunctions to reset sequences.
rum1.3PostgreSQLindex fulltext-search access-method postgresql-extensionRUM index access method.
safeupdate1.4ISCsafeupdate protect-data sqlRequire criteria for UPDATE and DELETE .
seg1.3 1.4PostgreSQLcontribData type for representing line segments or floating-point intervals.
semver0.32.1PostgreSQLsemantic version semver version version numberA semantic version data type.
sequential_uuids1.0.1MITUUID generatorGenerator of sequential UUIDs.
shacrypt1.1PostgreSQLcrypt hash sha256-crypt sha512-cryptImplements SHA256-CRYPT and SHA512-CRYPT password encryption schemes.
short_ids0.1.0PostgreSQLdefault randomGenerator of short, unique, textual ids.
sslinfo1.2PostgreSQLcontribInformation about SSL certificates.
supautils0.1.0 1.7.2 1.9.0Apache-2.0supabase roles postgresql-extension supautilsSupabase standard library .
tablefunc1.0PostgreSQLcontribFunctions that manipulate whole tables, including crosstab.
tcn1.0PostgreSQLcontribTriggered change notifications.
tdigest1.4.0PostgreSQLpercentiles t-digest postgresql-extension tdigestProvides tdigest aggregate function. .
tds_fdw2.0.3PostgreSQLsql-server postgresql databases foreign-data-wrapper hacktoberfest postgresql-extension tds-fdw freetds foreign-serverForeign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) .
test_factory0.5.0 0.3.1BSD 2-CLAUSEtesting unit test tests test data test factoryFramework for managing test data.
timescaledb1.7.4 2.2.1 2.3.1 2.4.2 2.5.2 2.6.1 2.7.2 2.7.0 2.5.0 2.2.0 2.8.1 2.9.1 2.9.3 2.10.3 2.11.0 2.11.1 2.11.2 2.12.2 2.13.0APACHE-2.0timescale time series iot postgres sql database time-series analytics postgresql financial-analysis tsdb time-series-database timescaledbEnables scalable inserts and complex queries for time-series data.
timescaledb_toolkit1.8.0 1.17.0 1.18.0Timescale-2.0sql time-series postgresql timescale toolkitExtension for more hyperfunctions, fully compatible with TimescaleDB and PostgreSQL.
timescaledb_tsl1.7.4 2.2.1 2.3.1 2.4.2 2.5.2 2.6.1 2.7.2 2.7.0 2.10.3 2.11.0 2.9.1 2.9.3 2.11.1 2.11.2 2.12.2 2.13.0Timescale-2.0iot postgres sql database time-series analytics postgresql financial-analysis tsdb time-series-database timescaledbEnables scalable inserts and complex queries for time-series data.
timetravel1.0PostgreSQLcontribFunctions for implementing time travel.
tsm_system_rows1.0PostgreSQLcontribTABLESAMPLE method which accepts number of rows as a limit.
tsm_system_time1.0PostgreSQLcontribTABLESAMPLE method which accepts time in milliseconds as a limit.
unaccent1.1PostgreSQLcontribText search dictionary that removes accents.
unnest_ordinality1.0.1PostgreSQLarray unnest ordinality row_numberTurn an array into a set of (element_number, element) pairs.
uuid-ossp1.1PostgreSQLcontribGenerate universally unique identifiers (UUIDs).
vacuum_utils0.1.0PostgreSQLinfo maintenanceFunctions to get information and execute statement about VACUUM and ANALYZE on tables.
vector0.1.8 0.4.2 0.4.4 0.5.0 0.5.1PostgreSQLvectors datatype nearest neighbor search approximate nearest neighbors pgvectorVector data type and ivfflat access method.
wal2json2.4 2.5BSD 3-Clauseplugin postgres json replication"JSON output plugin for changeset extraction. " .
xml21.1PostgreSQLcontribXPath querying and XSLT.

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.