How many PostgreSQL extensions exist? There is a well-known community-maintained GitHub list with more than a thousand entries. The catalog I maintain currently tracks about 1,617 entries. But this number needs context. Some projects are active. Some are abandoned. Some only available on cloud. Some depend on a dedicated PG fork. Some are just ideas and examples. So it does not mean 1,617 installable extensions. It means the ecosystem boundary is large, and messy.

Part II : The Ecosystem Landscape

Galaxy

PIGSTY
1,617 / 1,617 extensions shownSorted by catalog ID
ExtensionCategoryLanguageLicenseDescription
timescaledbTIMECTimescaleEnables scalable inserts and complex queries for time-series data
timescaledb_toolkitTIMERustTimescaleLibrary of analytical hyperfunctions, time-series pipelining, and other SQL utilities
timeseriesTIMESQLPostgreSQLConvenience API for time series stack
periodsTIMECPostgreSQLProvide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal_tablesTIMECBSD 2-Clausetemporal tables
emajTIMESQLGPL-3.0Enables fine-grained write logging and time travel on subsets of the database.
table_versionTIMESQLBSD 3-ClausePostgreSQL table versioning extension
pg_cronTIMECPostgreSQLJob scheduler for PostgreSQL
pg_taskTIMECMITexecute any sql command at any specific time at background
pg_laterTIMERustPostgreSQLRun queries now and get results later
pg_dispatchTIMESQLPostgreSQLAsynchronous SQL dispatcher built on pg_cron
pg_backgroundTIMECGPL-3.0Run SQL queries in the background
pg_whenTIMERustMITNatural language time parsing for PostgreSQL
postgisGISCGPL-2.0PostGIS geometry and geography spatial types and functions
postgis_topologyGISCGPL-2.0PostGIS topology spatial types and functions
postgis_rasterGISCGPL-2.0PostGIS raster types and functions
postgis_sfcgalGISCGPL-2.0PostGIS SFCGAL functions
postgis_tiger_geocoderGISCGPL-2.0PostGIS tiger geocoder and reverse geocoder
address_standardizerGISCGPL-2.0Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_usGISCGPL-2.0Address Standardizer US dataset example
pgroutingGISC++GPL-2.0pgRouting Extension
pointcloudGISCBSD 3-Clausedata type for lidar point clouds
pointcloud_postgisGISCBSD 3-Clauseintegration for pointcloud LIDAR data and PostGIS geometry data
h3GISCApache-2.0H3 bindings for PostgreSQL
h3_postgisGISCApache-2.0H3 PostGIS integration
q3cGISCGPL-2.0q3c sky indexing plugin
ogr_fdwGISCMITforeign-data wrapper for GIS data access
geoipGISSQLBSD 2-ClauseIP-based geolocation query
pg_polylineGISRustMITFast Google Encoded Polyline encoding & decoding for postgres
pg_eviltransformGISRustMITCoordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
pg_geohashGISCMITHandle geohash based functionality for spatial coordinates
pghydroGISSQLGPL-2.0Drainage network analysis core for PostgreSQL and PostGIS
pgh_rasterGISSQLGPL-2.0Raster hydrology extension for PgHydro
pgh_hgmGISSQLGPL-2.0Hydrogeomorphological analysis extension for PgHydro
pgh_outputGISSQLGPL-2.0Output and reporting objects for PgHydro
pgh_output_en_auGISSQLGPL-2.0Australian English output pack for PgHydro
pgh_output_pt_brGISSQLGPL-2.0Brazilian Portuguese output pack for PgHydro
pgh_consistencyGISSQLGPL-2.0Pfafstetter consistency checks for PgHydro
mobilitydbGISCGPL-3.0MobilityDB geospatial trajectory data management & analysis platform
mobilitydb_datagenGISSQLGPL-3.0MobilityDB random data generator functions
tzfGISRustMITFast lookup timezone name by GPS coordinates
earthdistanceGISCPostgreSQLcalculate great-circle distances on the surface of the Earth
vectorRAGCPostgreSQLvector data type and ivfflat and hnsw access methods
vchordRAGRustAGPL-3.0Vector database plugin for Postgres, written in Rust
vectorscaleRAGRustPostgreSQLAdvanced indexing for vector data with DiskANN
vectorizeRAGRustPostgreSQLThe simplest way to do vector search on Postgres
pg_similarityRAGCBSD 3-Clausesupport similarity queries
pg_rrfRAGRustMITReciprocal rank fusion functions for hybrid search
smlarRAGCPostgreSQLEffective similarity search
pg_summarizeRAGRustPostgreSQLText Summarization using LLMs. Built using pgrx
pg_tiktokenRAGRustApache-2.0tiktoken tokenizer for use with OpenAI models in postgres
pg4mlRAGCAGPL-3.0Machine learning framework for PostgreSQL
pgmlRAGRustMITRun AL/ML workloads with SQL interface
pg_searchFTSRustAGPL-3.0Full text search for PostgreSQL using BM25
pgroongaFTSCPostgreSQLUse Groonga as index, fast full text search platform for all languages!
pgroonga_databaseFTSCPostgreSQLPGroonga database management module
pg_bigmFTSCPostgreSQLcreate 2-gram (bigram) index for faster full text search.
zhparserFTSCPostgreSQLa parser for full-text search of Chinese
pg_bestmatchFTSRustApache-2.0Generate BM25 sparse vector inside PostgreSQL
vchord_bm25FTSRustAGPL-3.0A postgresql extension for bm25 ranking algorithm
pg_tokenizerFTSRustApache-2.0Tokenizers for full-text search
biscuitFTSCMITIAM-LIKE pattern matching with bitmap indexing
pg_textsearchFTSCPostgreSQLFull-text search with BM25 ranking
pg_pinyinFTSRustMITPinyin romanization and search helpers for PostgreSQL
pg_kazsearchFTSRustLGPL-3.0Kazakh full-text search extension for PostgreSQL
psql_bm25sFTSCApache-2.0PostgreSQL extension for BM25-family lexical retrieval
hunspell_cs_czFTSDataPostgreSQLCzech Hunspell Dictionary
hunspell_de_deFTSDataPostgreSQLGerman Hunspell Dictionary
hunspell_en_usFTSDataPostgreSQLen_US Hunspell Dictionary
hunspell_frFTSDataPostgreSQLFrench Hunspell Dictionary
hunspell_ne_npFTSDataPostgreSQLNepali Hunspell Dictionary
hunspell_nl_nlFTSDataPostgreSQLDutch Hunspell Dictionary
hunspell_nn_noFTSDataPostgreSQLNorwegian (norsk) Hunspell Dictionary
hunspell_pt_ptFTSDataPostgreSQLPortuguese Hunspell Dictionary
hunspell_ru_ruFTSDataPostgreSQLRussian Hunspell Dictionary
hunspell_ru_ru_aotFTSDataPostgreSQLRussian Hunspell Dictionary (from AOT.ru group)
fuzzystrmatchFTSCPostgreSQLdetermine similarities and distance between strings
pg_trgmFTSCPostgreSQLtext similarity measurement and index searching based on trigrams
citusOLAPCAGPL-3.0Distributed PostgreSQL as an extension
citus_columnarOLAPCAGPL-3.0Citus columnar storage engine
columnarOLAPCAGPL-3.0Hydra Columnar extension
pg_analyticsOLAPRustPostgreSQLPostgres for analytics, powered by DuckDB
pg_duckdbOLAPC++MITDuckDB Embedded in Postgres
pg_mooncakeOLAPRustMITColumnstore Table in Postgres
storage_engineOLAPCAGPL-3.0colcompress and rowcompress Table Access Methods with vectorized execution
pg_clickhouseOLAPC++Apache-2.0Interfaces to query ClickHouse databases from PostgreSQL
duckdb_fdwOLAPCMITDuckDB Foreign Data Wrapper
pg_parquetOLAPRustPostgreSQLcopy data between Postgres and Parquet
pg_fkpartOLAPSQLGPL-2.0Table partitioning by foreign key utility
pg_partmanOLAPCPostgreSQLExtension to manage partitioned tables by time or ID
plproxyOLAPCBSD 0-ClauseDatabase partitioning implemented as procedural language
pg_stromOLAPCPostgreSQLPG-Strom - big-data processing acceleration using GPU and NVME
tablefuncOLAPCPostgreSQLfunctions that manipulate whole tables, including crosstab
ageFEATCApache-2.0AGE graph database extension
pg_liquidFEATCMITLiquid-inspired Datalog graph query extension for PostgreSQL
onesparseFEATCApache-2.0Sparse linear algebra and graph extension for PostgreSQL 18
pgqFEATCISCGeneric queue for PostgreSQL
pgmqFEATSQLPostgreSQLA lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgmbFEATSQLPostgreSQLA simple PostgreSQL Message Broker system
ulakFEATCApache-2.0Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery
hllFEATC++Apache-2.0type for storing hyperloglog data
rumFEATCPostgreSQLRUM index access method
pg_ai_queryFEATC++Apache-2.0AI-powered SQL query generation for PostgreSQL
pg_ttl_indexFEATCPostgreSQLAutomatic data expiration with TTL indexes
pg_graphqlFEATRustApache-2.0Add in-database GraphQL support
pg_jsonschemaFEATRustApache-2.0PostgreSQL extension providing JSON Schema validation
jsqueryFEATCPostgreSQLdata type for jsonb inspection
pg_hint_planFEATCBSD 3-ClauseGive PostgreSQL ability to manually force some decisions in execution plans.
hypopgFEATCPostgreSQLHypothetical indexes for PostgreSQL
index_advisorFEATSQLPostgreSQLQuery index advisor
plan_filterFEATCPostgreSQLfilter statements by their execution plans.
pg_variablesFEATCPostgreSQLSession-scoped variables with scalar, array, and record types
imgsmlrFEATCPostgreSQLImage similarity with haar
pg_ivmFEATCPostgreSQLincremental view maintenance on PostgreSQL
pg_incrementalFEATCPostgreSQLIncremental Processing by Crunchy Data
pg_trickleFEATRustApache-2.0Streaming tables and differential view maintenance for PostgreSQL 18
provsqlFEATC++MITSemiring provenance and uncertainty management for PostgreSQL
orioledbFEATCPostgreSQLOrioleDB, the next generation transactional engine
pg_cardanoFEATRustMITA suite of Cardano-related tools
rdkitFEATC++BSD 3-ClauseCheminformatics functionality for PostgreSQL.
omniFEATCApache-2.0Advanced adapter for Postgres extensions
omni_authFEATCApache-2.0Basic session management
omni_awsFEATCApache-2.0Amazon Web Services APIs (S3)
omni_cloudeventsFEATCApache-2.0CloudEvents support
omni_containersFEATCApache-2.0Docker container management
omni_credentialsFEATCApache-2.0Application credential management
omni_csvFEATCApache-2.0CSV toolkit
omni_datasetsFEATCApache-2.0Dataset provisioning
omni_emailFEATCApache-2.0E-mail framework
omni_httpFEATCApache-2.0Basic HTTP types
omni_httpcFEATCApache-2.0HTTP client
omni_httpdFEATCApache-2.0HTTP server
omni_idFEATCApache-2.0Identity types
omni_jsonFEATCApache-2.0JSON toolkit
omni_kubeFEATCApache-2.0Kubernetes (k8s) integration
omni_ledgerFEATCApache-2.0Financial ledger
omni_manifestFEATCApache-2.0Package installation manifests
omni_mimetypesFEATCApache-2.0MIME types
omni_osFEATCApache-2.0Operating system integration
omni_polyfillFEATCApache-2.0Postgres API polyfills
omni_pythonFEATCApache-2.0First-class Python support
omni_regexFEATCApache-2.0PCRE-compatible regular expressions
omni_restFEATCApache-2.0REST API toolkit (with PostgREST support)
omni_schemaFEATCApache-2.0Advanced schema management tooling
omni_seqFEATCApache-2.0Distributed integer sequences
omni_serviceFEATCApache-2.0Service management
omni_sessionFEATCApache-2.0Session management
omni_shmemFEATCApache-2.0Shared Memory Management
omni_sqlFEATCApache-2.0Programmatic SQL manipulation
omni_sqliteFEATCApache-2.0Embedded SQLite
omni_testFEATCApache-2.0Testing framework
omni_txnFEATCApache-2.0Transaction management
omni_typesFEATCApache-2.0Advanced types
omni_varFEATCApache-2.0Scoped variables
omni_vfsFEATCApache-2.0Virtual File System
omni_vfs_types_v1FEATCApache-2.0Virtual File System types (v1)
omni_webFEATCApache-2.0Common web stack primitives
omni_workerFEATCApache-2.0Generalized worker pool
omni_xmlFEATCApache-2.0XML toolkit
omni_yamlFEATCApache-2.0YAML toolkit
bloomFEATCPostgreSQLbloom access method - signature file based index
pg_tleLANGCApache-2.0Trusted Language Extensions for PostgreSQL
plv8LANGC++PostgreSQLPL/JavaScript (v8) trusted procedural language
pljsLANGCPostgreSQLPL/JS trusted procedural language
plluaLANGCMITLua as a procedural language
hstore_plluaLANGCMITHstore transform for Lua
plluauLANGCMITLua as an untrusted procedural language
hstore_plluauLANGCMITHstore transform for untrusted Lua
plprqlLANGRustApache-2.0Use PRQL in PostgreSQL - Pipelined Relational Query Language
pldbgapiLANGCArtisticserver-side support for debugging PL/pgSQL functions
plpgsql_checkLANGCMITextended check for plpgsql functions
plprofilerLANGCArtisticserver-side support for profiling PL/pgSQL functions
plshLANGCMITPL/sh procedural language
pljavaLANGJavaBSD 3-ClausePL/Java procedural language
plrLANGCGPL-2.0load R interpreter and execute R script from within a database
plxsltLANGCPostgreSQLXSLT procedural language for PostgreSQL
pgtapLANGCPostgreSQLUnit testing for PostgreSQL
fakerLANGPythonPostgreSQLWrapper for the Faker Python library
dbt2LANGCArtisticOSDL-DBT-2 test kit
pg_regresqlLANGCBSD 2-ClauseTrust pg_class statistics for planning instead of physical relation size
pltclLANGCPostgreSQLPL/Tcl procedural language
pltcluLANGCPostgreSQLPL/TclU untrusted procedural language
plperlLANGCPostgreSQLPL/Perl procedural language
bool_plperlLANGCPostgreSQLtransform between bool and plperl
hstore_plperlLANGCPostgreSQLtransform between hstore and plperl
jsonb_plperlLANGCPostgreSQLtransform between jsonb and plperl
plperluLANGCPostgreSQLPL/PerlU untrusted procedural language
bool_plperluLANGCPostgreSQLtransform between bool and plperlu
jsonb_plperluLANGCPostgreSQLtransform between jsonb and plperlu
hstore_plperluLANGCPostgreSQLtransform between hstore and plperlu
plpgsqlLANGCPostgreSQLPL/pgSQL procedural language
plpython3uLANGCPostgreSQLPL/Python3U untrusted procedural language
jsonb_plpython3uLANGCPostgreSQLtransform between jsonb and plpython3u
ltree_plpython3uLANGCPostgreSQLtransform between ltree and plpython3u
hstore_plpython3uLANGCPostgreSQLtransform between hstore and plpython3u
prefixTYPECPostgreSQLPrefix Range module for PostgreSQL
semverTYPECPostgreSQLSemantic version data type
pg_text_semverTYPESQLPostgreSQLSemantic version domain and comparison operators for PostgreSQL
unitTYPECGPL-2.0SI units extension
pgpdfTYPECGPL-3.0PDF type with meta admin & Full-Text Search
pglite_fusionTYPERustMITEmbed an SQLite database in your PostgreSQL table
md5hashTYPECBSD 2-Clausetype for storing 128-bit binary data inline
asn1oidTYPECGPL-3.0asn1oid extension
roaringbitmapTYPECApache-2.0support for Roaring Bitmaps
pgfacetingTYPESQLBSD 3-Clausefast faceting queries using an inverted index
pg_sphereTYPECBSD 3-Clausespherical objects with useful functions, operators and index support
countryTYPECPostgreSQLCountry data type, ISO 3166-1
pg_xenophileTYPESQLPostgreSQLMore than the bare necessities for PostgreSQL i18n and l10n.
l10n_table_dependent_extensionTYPESQLPostgreSQLPostgreSQL l10n toolbox
currencyTYPECMITCustom PostgreSQL currency type in 1Byte
collectionTYPECApache-2.0Memory optimized data type to be used inside of plpglsql func
pgmpTYPECLGPL-3.0Multiple Precision Arithmetic extension
numeralTYPECGPL-2.0numeral datatypes extension
pg_rationalTYPECMITbigint fractions
uintTYPECPostgreSQLunsigned integer types
uint128TYPECPostgreSQLNative uint128 type
hashtypesTYPECPostgreSQLsha1, md5 and other data types for PostgreSQL
ip4rTYPECPostgreSQLIPv4/v6 and IPv4/v6 range index type for PostgreSQL
uriTYPECPostgreSQLURI Data type for PostgreSQL
emailaddrTYPECPostgreSQLEmail address type for PostgreSQL
aclTYPECBSD 2-ClauseACL Data type
debversionTYPESQLPostgreSQLDebian version number data type
pg_durationTYPECMITdata type for representing durations
pg_bikram_sambatTYPECPostgreSQLBikram Sambat date type and AD/BS conversion functions
pg_rruleTYPECMITRRULE field type for PostgreSQL
pgcalendarTYPESQLMITRecurring calendar, schedule, and exception management for PostgreSQL
timestamp9TYPECMITtimestamp nanosecond resolution
pgbsonTYPECMITBSON data type and accessor functions for PostgreSQL
chkpassTYPECPostgreSQLdata type for auto-encrypted passwords
isnTYPECPostgreSQLdata types for international product numbering standards
segTYPECPostgreSQLdata type for representing line segments or floating-point intervals
cubeTYPECPostgreSQLdata type for multidimensional cubes
ltreeTYPECPostgreSQLdata type for hierarchical tree-like structures
hstoreTYPECPostgreSQLdata type for storing sets of (key, value) pairs
citextTYPECPostgreSQLdata type for case-insensitive character strings
xml2TYPECPostgreSQLXPath querying and XSLT
gzipUTILCMITgzip and gunzip functions.
bzipUTILCMITBzip compression and decompression
zstdUTILCISCZstandard compression algorithm implementation in PostgreSQL
httpUTILCMITHTTP client for PostgreSQL, allows web page retrieval inside the database.
pg_netUTILCApache-2.0Async HTTP Requests
pg_curlUTILCMITRun curl actions for data transfer in URL syntax
pg_retryUTILCPostgreSQLRetry SQL statements on transient errors with exponential backoff
pg_fsqlUTILCPostgreSQLRecursive SQL template engine with JSONB-driven execution
pg_protobufUTILCMITProtobuf support for PostgreSQL
pgprotoUTILCPostgreSQLNative Protobuf parsing, mutation, indexing, and JSON conversion support
pglockUTILSQLPostgreSQLLightweight distributed lock service inside PostgreSQL
pgjqUTILCMITUse jq in Postgres
pgjwtUTILSQLMITJSON Web Token API for Postgresql
pg_smtp_clientUTILRustMITPostgreSQL extension to send email using SMTP
pg_html5_email_addressUTILSQLPostgreSQLPostgreSQL email validation that is consistent with the HTML5 spec
url_encodeUTILCPostgreSQLurl_encode, url_decode functions
pgsql_tweaksUTILSQLPostgreSQLSome functions and views for daily usage
pg_extra_timeUTILSQLPostgreSQLSome date time functions and operators that,
pgpcreUTILCPostgreSQLPerl Compatible Regular Expression functions
re2UTILC++PostgreSQLClickHouse-compatible regex functions using RE2
icu_extUTILCPostgreSQLAccess ICU functions
pgqrUTILCBSD 3-ClauseQR Code generator from PostgreSQL
envvarUTILCPostgreSQLFetch the value of an environment variable
byteamagicUTILCBSD 2-ClauseDetect MIME types and file formats from PostgreSQL bytea values
floatfileUTILCMITSimple file storage for arrays of floats
external_fileUTILSQLPostgreSQLAccess external server-side files through PostgreSQL functions
pg_renderUTILRustMITRender HTML in SQL
pg_readmeUTILCPostgreSQLGenerate a README.md document for a database extension or schema
pg_readme_test_extensionUTILCPostgreSQLTest generating a README.md document for extension or schema
ddl_historizationUTILSQLGPL-2.0Historize the ddl changes inside PostgreSQL database
data_historizationUTILSQLPostgreSQLPLPGSQL Script to historize data in partitionned table
schedocUTILSQLGPL-3.0Cross documentation between Django and DBT projects
pg_isokUTILSQLAGPL-3.0Query-based data integrity management and soft alerting for PostgreSQL
hashlibUTILCPostgreSQLStable hash functions for Postgres
xxhashUTILCBSD 2-Clausexxhash functions for PostgreSQL
shacryptUTILCPostgreSQLImplements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptintUTILCPostgreSQLEncryption functions for int and bigint values
pgueccUTILCBSD 2-ClauseuECC bindings for Postgres
sparqlUTILSQLApache-2.0Query SPARQL datasource with SQL
pg_idkitFUNCRustApache-2.0multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pgx_ulidFUNCRustMITulid type and methods
pg_uuidv7FUNCCMPL-2.0Create UUIDv7 values in postgres
permuteseqFUNCCPostgreSQLPseudo-randomly permute sequences with a format-preserving encryption on elements
pg_hashidsFUNCCMITShort unique id generator for PostgreSQL, using hashids
pg_slug_genFUNCCMITGenerate cryptographically secure timestamp-based slugs
sequential_uuidsFUNCCMITgenerator of sequential UUIDs
typeidFUNCRustMITAllows to use TypeIDs in Postgres natively
snowflakeFUNCCPostgreSQLSnowflake-style 64-bit ID generator and sequence utilities for PostgreSQL
topnFUNCCAGPL-3.0type for top-n JSONB
quantileFUNCCBSD 2-ClauseQuantile aggregation function
lower_quantileFUNCCBSD 2-ClauseLower quantile aggregate function
count_distinctFUNCCBSD 2-ClauseAn alternative to COUNT(DISTINCT ...) aggregate, usable with HashAggregate
omnisketchFUNCCPostgreSQLdata structure for on-line agg of data into approximate sketch
ddsketchFUNCCPostgreSQLProvides ddsketch aggregate function
vascoFUNCCGPL-3.0discover hidden correlations in your data with MIC
xicorFUNCCGPL-3.0XI Correlation Coefficient in Postgres
weighted_statisticsFUNCCPostgreSQLHigh-performance weighted statistics functions for sparse data
datasketchesFUNCC++Apache-2.0Approximate analytics sketches and aggregates for PostgreSQL
tdigestFUNCCApache-2.0Provides tdigest aggregate function.
first_last_aggFUNCCPostgreSQLfirst() and last() aggregate functions
extra_window_functionsFUNCCPostgreSQLExtra Window Functions for PostgreSQL
floatvecFUNCCMITMath for vectors (arrays) of numbers
aggs_for_vecsFUNCCMITAggregate functions for array inputs
aggs_for_arraysFUNCCMITVarious functions for computing statistics on arrays of numbers
pg_csvFUNCCMITFlexible CSV processing for Postgres
arraymathFUNCCMITArray math and operators that work element by element on the contents of arrays
pg_mathFUNCCGPL-3.0GSL statistical functions for postgresql
randomFUNCCPostgreSQLrandom data generator
base36FUNCCMITInteger Base36 types
base62FUNCCMITBase62 extension for PostgreSQL
pg_base58FUNCRustMITBase58 Encoder/Decoder Extension for PostgreSQL
financialFUNCCPostgreSQLFinancial aggregate functions
pg_accumulatorFUNCCPostgreSQLAccumulation registers for balance and turnover tracking in PostgreSQL
convertFUNCRustMITconversion functions for spatial, routing and other specialized uses
parray_ginFUNCCPostgreSQLGIN index operator class and partial-match operators for text arrays
refintFUNCCPostgreSQLfunctions for implementing referential integrity (obsolete)
autoincFUNCCPostgreSQLfunctions for autoincrementing fields
insert_usernameFUNCCPostgreSQLfunctions for tracking who changed a table
moddatetimeFUNCCPostgreSQLfunctions for tracking last modification time
tsm_system_timeFUNCCPostgreSQLTABLESAMPLE method which accepts time in milliseconds as a limit
dict_xsynFUNCCPostgreSQLtext search dictionary template for extended synonym processing
tsm_system_rowsFUNCCPostgreSQLTABLESAMPLE method which accepts number of rows as a limit
tcnFUNCCPostgreSQLTriggered change notifications
uuid-osspFUNCCPostgreSQLgenerate universally unique identifiers (UUIDs)
btree_gistFUNCCPostgreSQLsupport for indexing common datatypes in GiST
btree_ginFUNCCPostgreSQLsupport for indexing common datatypes in GIN
intarrayFUNCCPostgreSQLfunctions, operators, and index support for 1-D arrays of integers
intaggFUNCCPostgreSQLinteger aggregator and enumerator (obsolete)
dict_intFUNCCPostgreSQLtext search dictionary template for integers
unaccentFUNCCPostgreSQLtext search dictionary that removes accents
pg_repackADMINCPostgreSQLReorganize tables in PostgreSQL databases with minimal locks
pg_rewriteADMINCBSD 3-ClauseTool allows read write to the table during the rewriting
pg_query_rewriteADMINCPostgreSQLRewrite SQL statements with a PostgreSQL ProcessUtility hook
pg_squeezeADMINCBSD 2-ClauseA tool to remove unused space from a relation.
pg_dirtyreadADMINCBSD 3-ClauseRead dead but unvacuumed rows from table
pgfincoreADMINCBSD 3-Clauseexamine and manage the os buffer cache
pg_cooldownADMINCApache-2.0remove buffered pages for specific relations
ddlxADMINSQLPostgreSQLDDL eXtractor functions
pglinterADMINRustPostgreSQLPostgreSQL Linting and Analysis Extension
prioritizeADMINCPostgreSQLget and set the priority of PostgreSQL backends
pg_checksumsADMINCBSD 2-ClauseActivate/deactivate/verify checksums in offline Postgres clusters
pg_readonlyADMINCPostgreSQLcluster database read only
pgddADMINRustMITIntrospect pg data dictionary via standard SQL
pg_permissionsADMINSQLBSD 2-Clauseview object permissions and compare them with the desired state
pgautofailoverADMINCPostgreSQLpg_auto_failover
pg_catcheckADMINCBSD 3-ClauseDiagnosing system catalog corruption
pre_prepareADMINCPostgreSQLPre Prepare your Statement server side
pg_uplessADMINSQLPostgreSQLDetect Useless UPDATE
pgcozyADMINSQLPostgreSQLPre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
pg_orphanedADMINCPostgreSQLDeal with orphaned files
pg_crashADMINCBSD 3-ClauseSend random signals to random processes
pg_cheat_funcsADMINCPostgreSQLProvides cheat (but useful) functions
fioADMINCBSD 3-ClausePostgreSQL File I/O Functions
qosADMINCGPL-3.0QoS resource governor extension for PostgreSQL sessions and queries
pg_pathcheckADMINCMITValidate planner Path trees for freed or corrupt memory
pg_saviorADMINCApache-2.0Postgres extension to save OOPS mistakes
safeupdateADMINCISCRequire criteria for UPDATE and DELETE
pg_strictADMINRustMITPrevent dangerous UPDATE and DELETE without WHERE clause
pg_drop_eventsADMINSQLPostgreSQLlogs transaction ids of drop table, drop column, drop materialized view statements
table_logADMINCPostgreSQLrecord table modification logs and PITR for table/row
pgelogADMINSQLPostgreSQLExtended logging via pseudo-autonomous transactions
pgagentADMINCPostgreSQLA PostgreSQL job scheduler
pg_prewarmADMINCPostgreSQLprewarm relation data
pgpool_admADMINCPostgreSQLAdministrative functions for pgPool
pgpool_recoveryADMINCPostgreSQLrecovery functions for pgpool-II for V4.3
pgpool_regclassADMINCPostgreSQLreplacement for regclass
loADMINCPostgreSQLLarge Object maintenance
basic_archiveADMINCPostgreSQLan example of an archive module
basebackup_to_shellADMINCPostgreSQLadds a custom basebackup target called shell
old_snapshotADMINCPostgreSQLutilities in support of old_snapshot_threshold
adminpackADMINCPostgreSQLadministrative functions for PostgreSQL
amcheckADMINCPostgreSQLfunctions for verifying relation integrity
pg_surgeryADMINCPostgreSQLextension to perform surgery on a damaged relation
pg_profileSTATCBSD 2-ClausePostgreSQL load profile repository and report builder
pg_tracingSTATCMITDistributed Tracing for PostgreSQL
pg_stat_chSTATC++Apache-2.0Export PostgreSQL query telemetry to ClickHouse
pg_show_plansSTATCPostgreSQLshow query plans of all currently running SQL statements
pg_stat_kcacheSTATCBSD 3-ClauseKernel statistics gathering
pg_stat_monitorSTATCBSD 3-ClauseThe 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_qualstatsSTATCBSD 3-ClauseAn extension collecting statistics about quals
pg_store_plansSTATCBSD 3-Clausetrack plan statistics of all SQL statements executed
pg_track_settingsSTATSQLPostgreSQLTrack settings changes
pg_track_optimizerSTATCMITTrack planning decisions in comparison with execution reality
pg_wait_samplingSTATCPostgreSQLsampling based statistics of wait events
pg_datasentinelSTATCBSD 3-ClauseObservability and activity monitoring extension for PostgreSQL
pgsentinelSTATCPostgreSQLactive session history
system_statsSTATCPostgreSQLEnterpriseDB system statistics for PostgreSQL
metaSTATSQLBSD 2-ClauseNormalized, friendlier system catalog for PostgreSQL
pgnodemxSTATCApache-2.0Capture node OS metrics via SQL queries
pg_proctabSTATCBSD 3-ClausePostgreSQL extension to access the OS process table
pg_sqlogSTATSQLBSD 3-ClauseProvide SQL interface to logs
bgw_replstatusSTATCPostgreSQLSmall PostgreSQL background worker to report whether a node is a replication master or standby
pgmeminfoSTATCMITshow memory usage
toastinfoSTATCPostgreSQLshow details on toasted datums
explain_uiSTATRustPostgreSQLeasily jump into a visual plan UI for any SQL query
pg_relusageSTATCPostgreSQLLog all the queries that reference a particular column
pagevisSTATSQLMITVisualise database pages in ascii code
powaSTATPythonPostgreSQLPostgreSQL Workload Analyser-core
pg_overexplainSTATCPostgreSQLAllow EXPLAIN to dump even more details
pg_logicalinspectSTATCPostgreSQLLogical decoding components inspection
pageinspectSTATCPostgreSQLinspect the contents of database pages at a low level
pgrowlocksSTATCPostgreSQLshow row-level locking information
sslinfoSTATCPostgreSQLinformation about SSL certificates
pg_buffercacheSTATCPostgreSQLexamine the shared buffer cache
pg_walinspectSTATCPostgreSQLfunctions to inspect contents of PostgreSQL Write-Ahead Log
pg_freespacemapSTATCPostgreSQLexamine the free space map (FSM)
pg_visibilitySTATCPostgreSQLexamine the visibility map (VM) and page-level visibility info
pgstattupleSTATCPostgreSQLshow tuple-level statistics
auto_explainSTATCPostgreSQLProvides a means for logging execution plans of slow statements automatically
pg_stat_statementsSTATCPostgreSQLtrack planning and execution statistics of all SQL statements executed
passwordcheck_cracklibSECCLGPL-2.1Strengthen PostgreSQL user password checks with cracklib
supautilsSECCApache-2.0Extension that secures a cluster on a cloud environment
pgsodiumSECCBSD 3-ClausePostgres extension for libsodium functions
column_encryptSECCPostgreSQLTransparent column-level encryption with encrypted_text and encrypted_bytea types
supabase_vaultSECCApache-2.0Supabase Vault Extension
pg_session_jwtSECRustApache-2.0Manage authentication sessions using JWTs
anonSECRustPostgreSQLPostgreSQL Anonymizer (anon) extension
pgsmcryptoSECRustMITPostgreSQL SM Algorithm Extension
pg_enigmaSECRustMITEncrypted postgres data type
pgauditSECCPostgreSQLprovides auditing functionality
pgauditlogtofileSECCPostgreSQLpgAudit addon to redirect audit log to an independent file
pg_auditorSECSQLBSD 3-ClauseAudit data changes and provide flashback ability
logerrorsSECCBSD 3-ClauseFunction for collecting statistics about messages in logfile
pg_auth_monSECCMITmonitor connection attempts per user
pg_jobmonSECSQLPostgreSQLExtension for logging and monitoring functions in PostgreSQL
credcheckSECCMITcredcheck - postgresql plain text credential checker
pgcryptokeySECCPostgreSQLcryptographic key management
pg_pwhashSECCMITAdvanced password hashing methods for PostgreSQL
login_hookSECCGPL-3.0login_hook - hook to execute login_hook.login() at login time
set_userSECCPostgreSQLsimilar to SET ROLE but with added logging
pg_snakeoilSECCPostgreSQLThe PostgreSQL Antivirus
pgextwlistSECCPostgreSQLPostgreSQL Extension Whitelisting
pg_command_fwSECRustBSD 3-ClauseDDL and utility command firewall for PostgreSQL
block_copy_commandSECRustBSD 3-ClauseBlock COPY commands via a configurable ProcessUtility hook
sslutilsSECCPostgreSQLA Postgres extension for managing SSL certificates through SQL
nosetSECCAGPL-3.0Module for blocking SET variables for non-super users.
pg_tdeSECCMITPercona pg_tde access method
sepgsqlSECCPostgreSQLlabel-based mandatory access control (MAC) based on SELinux security policy.
auth_delaySECCPostgreSQLpause briefly before reporting authentication failure
pgcryptoSECCPostgreSQLcryptographic functions
passwordcheckSECCPostgreSQLchecks user passwords and reject weak password
wrappersFDWRustApache-2.0Foreign data wrappers developed by Supabase
multicornFDWCPostgreSQLFetch foreign data in Python in your PostgreSQL server.
odbc_fdwFDWCPostgreSQLForeign data wrapper for accessing remote databases using ODBC
jdbc_fdwFDWCPostgreSQLforeign-data wrapper for remote servers available over JDBC
pgspider_extFDWCPostgreSQLforeign-data wrapper for remote PGSpider servers
mysql_fdwFDWCBSD 3-ClauseForeign data wrapper for querying a MySQL server
oracle_fdwFDWCPostgreSQLforeign data wrapper for Oracle access
tds_fdwFDWCPostgreSQLForeign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
db2_fdwFDWCPostgreSQLforeign data wrapper for DB2 access
sqlite_fdwFDWCPostgreSQLSQLite Foreign Data Wrapper
pgbouncer_fdwFDWSQLPostgreSQLExtension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
etcd_fdwFDWRustMITForeign data wrapper for etcd
informix_fdwFDWCPostgreSQLForeign data wrapper for Informix access
nominatim_fdwFDWCMITNominatim Foreign Data Wrapper for PostgreSQL
mongo_fdwFDWCLGPL-3.0foreign data wrapper for MongoDB access
redis_fdwFDWCPostgreSQLForeign data wrapper for querying a Redis server
redisFDWCMITSend redis pub/sub messages to Redis from PostgreSQL Directly
kafka_fdwFDWCPostgreSQLkafka Foreign Data Wrapper for CSV formatted messages
hdfs_fdwFDWCBSD 3-Clauseforeign-data wrapper for remote hdfs servers
firebird_fdwFDWCPostgreSQLForeign data wrapper for Firebird
rdf_fdwFDWCMITForeign data wrapper for RDF triplestores over SPARQL endpoints
aws_s3FDWSQLApache-2.0aws_s3 postgres extension to import/export data from/to s3
log_fdwFDWCApache-2.0foreign-data wrapper for Postgres log file access
dblinkFDWCPostgreSQLconnect to other PostgreSQL databases from within a database
file_fdwFDWCPostgreSQLforeign-data wrapper for flat file access
postgres_fdwFDWCPostgreSQLforeign-data wrapper for remote PostgreSQL servers
documentdbSIMCMITAPI surface for DocumentDB for PostgreSQL
documentdb_coreSIMCMITCore API surface for DocumentDB on PostgreSQL
documentdb_distributedSIMCMITMulti-Node API surface for DocumentDB
documentdb_extended_rumSIMCMITDocumentDB Extended RUM index access method
orafceSIMCBSD 0-ClauseFunctions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pgttSIMCISCExtension to add Global Temporary Tables feature to PostgreSQL
session_variableSIMCGPL-3.0Registration and manipulation of session variables and constants
pg_statement_rollbackSIMCISCServer side rollback at statement level for PostgreSQL like Oracle or DB2
ivorysql_oraSIMCApache-2.0Oracle Compatible extension on Postgres Database
ora_btree_ginSIMCApache-2.0Support for indexing oracle datatypes in GIN
ora_btree_gistSIMCApache-2.0Support for oracle indexing common datatypes in GiST
pg_get_functiondefSIMCApache-2.0Get function's definition
plisqlSIMCApache-2.0PL/iSQL procedural language
gb18030_2022SIMCApache-2.0Support GB18030-2022 and UTF-8 conversion
pg_dbms_metadataSIMSQLPostgreSQLExtension to add Oracle DBMS_METADATA compatibility to PostgreSQL
pg_dbms_lockSIMSQLPostgreSQLExtension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
pg_dbms_jobSIMSQLPostgreSQLExtension to add Oracle DBMS_JOB full compatibility to PostgreSQL
pg_dbms_errlogSIMCISCEmulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
pg_utl_smtpSIMSQLPostgreSQLOracle UTL_SMTP compatibility extension for PostgreSQL
babelfishpg_commonSIMCApache-2.0SQL Server Transact SQL Datatype Support
babelfishpg_tsqlSIMCApache-2.0SQL Server Transact SQL compatibility
babelfishpg_tdsSIMCApache-2.0SQL Server TDS protocol extension
babelfishpg_moneySIMCApache-2.0SQL Server Money Data Type
spatSIMCAGPL-3.0Redis-like In-Memory DB Embedded in Postgres
pgmemcacheSIMCMITmemcached interface
aux_mysqlSIMCGPL-3.0MySQL Supplementary Extension
pglogicalETLCPostgreSQLPostgreSQL Logical Replication
pglogical_originETLCPostgreSQLDummy extension for compatibility when upgrading from Postgres 9.4
pglogical_tickerETLCPostgreSQLHave an accurate view on pglogical replication delay
pgl_ddl_deployETLCMITautomated ddl deployment using pglogical
logical_ddlETLCMITReplicate supported DDL changes over PostgreSQL logical replication
pg_failover_slotsETLCPostgreSQLPG Failover Slots extension
db_migratorETLSQLBSD 3-ClauseTools to migrate other databases to PostgreSQL
pgactiveETLCApache-2.0Active-Active Replication Extension for PostgreSQL
spockETLCPostgreSQLMulti-master logical replication extension for PostgreSQL
lolorETLCPostgreSQLLogical-replication-friendly replacement for PostgreSQL large objects
pgcloneETLCPostgreSQLClone PostgreSQL databases, schemas, tables, and functions across environments
pgmqttETLRustELv2CDC-to-MQTT broker for PostgreSQL
wal2jsonETLCBSD 3-ClauseChanging data capture in JSON format
wal2mongoETLCApache-2.0PostgreSQL logical decoding output plugin for MongoDB
decoderbufsETLCMITLogical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
decoder_rawETLCPostgreSQLOutput plugin for logical replication in Raw SQL format
mimeoETLSQLPostgreSQLExtension for specialized, per-table replication between PostgreSQL instances
repmgrETLCGPL-3.0Replication manager for PostgreSQL
pg_fact_loaderETLCMITbuild fact tables with Postgres
pg_bulkloadETLCBSD 3-Clausepg_bulkload is a high speed data loading utility for PostgreSQL
test_decodingETLCPostgreSQLSQL-based test/example module for WAL logical decoding
pgoutputETLCPostgreSQLLogical Replication output plugin
pgmementoSECSQLLGPL-3.0Audit trail with schema versioning for PostgreSQL using transaction-based logging
sql_firewallSECCPostgreSQLSQL firewall extension that learns allowed queries and prevents or warns on unexpected query execution.
is_jsonb_validTYPECMITNative PostgreSQL extension for validating jsonb values against JSON Schema draft 4 and draft 7.
pg_blkchainTYPECMITC extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL.
imcsOLAPCApache-2.0In-Memory Columnar Store extension for PostgreSQL.
cstore_fdwOLAPCApache-2.0Columnar storage extension for PostgreSQL built as a foreign data wrapper
vopsOLAPCPostgreSQLVectorized operations for PostgreSQL OLAP queries
postgres-json-schemaTYPESQLPostgreSQLValidate JSON documents against JSON schemas in PostgreSQL
zsonTYPECMITTransparent JSONB compression extension for PostgreSQL
pg_pathmanOLAPCPostgreSQLPartitioning tool for PostgreSQL
pg_paxosETLCPostgreSQLPaxos distributed consensus functions and table replication for PostgreSQL
amqpETLCMPL-2.0Publish messages to AMQP brokers from PostgreSQL
pipelinedbOLAPCApache-2.0High-performance time-series aggregation with continuous SQL queries for PostgreSQL
zombodbFTSRustApache-2.0Elasticsearch-backed full-text search and indexing for PostgreSQL
aiRAGPythonPostgreSQLHelper functions for AI workflows in PostgreSQL
kafkaETLCMITProduce messages to Apache Kafka from PostgreSQL
clickhousedb_fdwFDWCPostgreSQLForeign data wrapper for remote ClickHouse servers
holycornFDWCLGPL-3.0Ruby foreign data wrapper provider
json_fdwFDWCGPL-3.0Foreign data wrapper for JSON file access
parquet_fdwFDWC++PostgreSQLRead-only foreign data wrapper for Apache Parquet files
www_fdwFDWCPostgreSQLForeign data wrapper for accessing web services from PostgreSQL.
pg_jiebaFTSC++BSD 3-ClauseChinese full-text search parser extension using Jieba tokenization.
pg_prometheusSTATCApache-2.0Prometheus metric sample type and helpers for PostgreSQL.
aqoFEATCAGPL-3.0Adaptive query optimization extension using execution statistics to improve cardinality estimation.
check_accessSECSQLPostgreSQLFunctions and views to facilitate PostgreSQL object access inspection
libx509pqSECCGPL-3.0X.509 certificate parsing library for PostgreSQL
pg-audit-jsonSECSQLPostgreSQLAn audit history tracker
pg_credereumSECCGPL-3.0pg_credereum PostgreSQL extension bringing some properties of blockchain to the relational DBMS
recallSECSQLPostgreSQLTracks table changes in per-table _log tables for timestamp-based history queries.
pg_query_stateSTATCPostgreSQLTool for query progress monitoring in PostgreSQL
postalGISCMITNormalizes and parses postal addresses in PostgreSQL using libpostal.
cartodbGISPythonBSD 3-ClauseArchived PostgreSQL extension for turning a database into a CartoDB user database.
argmFUNCCPostgreSQLCustom aggregate functions: argmax, argmin, and anyold
adaptive_counterFUNCCUnknownAggregation functions and data type for distinct estimation based on adaptive sampling.
bitmap_counterFUNCCUnknownAggregation functions and data type for distinct estimation based on s-bitmap.
hyperloglog_counterFUNCCUnknownAggregation functions and data type for distinct estimation based on HyperLogLog.
loglog_counterFUNCCBSD 2-ClauseAggregation functions and data type for distinct estimation based on LogLog.
pcsa_counterFUNCCUnknownAggregation functions and data type for distinct estimation based on PCSA.
probabilistic_counterFUNCCUnknownAggregate functions and a data type for distinct-count estimation using probabilistic counting.
superloglog_counterFUNCCUnknownAggregate functions and a data type for distinct-count estimation using SuperLogLog.
weighted_meanFUNCCPostgreSQLWeighted average aggregate function for PostgreSQL numeric values.
pg_themisSECCApache-2.0PostgreSQL encryption and decryption functions backed by the Themis cryptographic library.
pgspeckSECCMITSmall-block Speck symmetric encryption functions for PostgreSQL.
pg_dropcacheADMINCPostgreSQLAdministrative extension to invalidate PostgreSQL shared_buffers cache.
ptrackADMINCPostgreSQLBlock-level incremental backup engine for PostgreSQL.
ast_postgisGISSQLUnknownAdvanced spatial data types and spatial integrity constraints for PostGIS.
ccnumberTYPECUnknowndata type representing encrypted CC numbers
fixeddecimalTYPECPostgreSQLFixed-precision decimal type optimized for performance and storage.
hstore_opsTYPECGPL-2.0extra operator class for hstore extension
pg_libphonenumberTYPEC++Apache-2.0Stores and manipulates phone numbers using Google libphonenumber
pg_ulidTYPECUnknownULID datatype and functions
pg_simdjsonFUNCC++Apache-2.0Prototype PostgreSQL extension that parses JSON into jsonb using simdjson.
pg_xidTYPECMITPostgreSQL extension exposing xid generation functions
pg_cryogenOLAPCPostgreSQLCompressed append-only pluggable storage for PostgreSQL
pipeline_kafkaETLCGPL-3.0PipelineDB extension for Kafka support
vectorize_engineOLAPCPostgreSQLVectorized query execution extension for PostgreSQL
connection_limitsSECCBSD 2-ClauseConnection quotas per user, database, and IP address
istoreTYPECPostgreSQLInteger-to-integer key/value store for analytic workloads
pairTYPECPostgreSQLA key/value pair data type for PostgreSQL
monqTYPECUnknownMongoDB-like query support for jsonb data
bignumTYPECPostgreSQLUnlimited precision integers for PostgreSQL
emojiTYPESQLMITPure SQL PostgreSQL extension to encode and decode bytea/text as emoji
pgchronosTIMESQLBSD 3-ClauseSQL functions and operators for union, intersection, and difference over daterange and tstzrange arrays.
postgres_protobufTYPECMITProtocol Buffer query and JSON conversion functions for PostgreSQL bytea protobuf data.
temporalTIMECPostgreSQLTemporal period data type, operators, and functions for PostgreSQL.
range_aggTYPECMITAggregate functions to merge adjacent or overlapping PostgreSQL range values.
time_for_keysTIMECMITTemporal foreign key helper functions and triggers for state-time PostgreSQL tables.
addressing_dictionaryFTSSQLMITAddress handling dictionaries for PostgreSQL, applying smarter handling to addresses in text search.
shared_ispellFTSCUnknownProvides shared ispell dictionaries.
tsexampleFTSCUnknowntsexample - example of custom postgresql full text search parser, dictionaries and configuration
cigrationETLSQLApache-2.0Citus shards migration tool
dblink_plusETLCBSD 3-ClauseRun SQL against external PostgreSQL, Oracle, MySQL, and SQLite databases from PostgreSQL.
jsoncdcETLRustPostgreSQLJSON logical decoding output plugin
pg_message_queueETLSQLPostgreSQLListen/Notify-based PostgreSQL message queue extension
pg_lz4UTILCUnknownlz4 compression method for PostgreSQL
pgsocketETLCBSD 3-ClauseSend bytes from PostgreSQL to a TCP/IP socket
pg_dtmETLCUnknownPluggable distributed transaction manager
pg_keeperETLCPostgreSQLSimple background-worker based PostgreSQL clustering module
pg_partOLAPSQLGPL-2.0Table partitioning utility for PostgreSQL
pg_zlogETLCUnknownLogical table replication using Ceph and ZLog
advcopyETLPythonUnknownPL/Python PostgreSQL extension for copying data to and from S3.
cassandra2_fdwFDWCMITForeign data wrapper for querying Cassandra 2.x and newer from PostgreSQL.
ch_fdwFDWCMITForeign data wrapper for federated access from PostgreSQL to ClickHouse.
couchdb_fdwFDWCPostgreSQLForeign data wrapper for querying CouchDB from PostgreSQL.
dump_fdwFDWCBSD 3-ClauseForeign data wrapper for querying PostgreSQL custom dump files.
file_fixed_length_fdwFDWCUnknownForeign data wrapper for files with fixed-length fields.
timestampandtzTYPECMITTimestamp stored with timezone type
tinyintTYPECPostgreSQL1 byte integer data type
uidsTYPERustUnknownPostgreSQL extension to generate various types of universally unique IDs
wltreeTYPECMITdata type for hierarchical tree-like structures with wide character support
dict_voikkoFTSCUnknowntext search dictionary for Finnish using the Voikko dictionary
file_textarray_fdwFDWCPostgreSQLForeign data wrapper returning each text-file row as a text array.
git_fdwFDWCMITPostgreSQL Git Foreign Data Wrapper
go_fdwFDWCMITExperimental Go project template for PostgreSQL FDWs
bigtableFDWRustMITRust PostgreSQL FDW for Google Bigtable
griddb_fdwFDWCPostgreSQLGridDB Foreign Data Wrapper for PostgreSQL
hello_fdwFDWCUnknownforeign-data wrapper for hello world
influxdb_fdwFDWCPostgreSQLForeign data wrapper for querying InfluxDB from PostgreSQL
jdbc2_fdwFDWCUnknownforeign-data wrapper for remote servers available over JDBC
kt_fdwFDWCMITKt Foreign Data Wrapper
ldap_fdwFDWCPostgreSQLLDAP Foreign Data Wrapper
osm_fdwFDWCPostgreSQLForeign data wrapper for reading OpenStreetMap PBF files
kv_fdwFDWCApache-2.0Foreign data wrapper for key-value storage backed by RocksDB/VidarDB.
quasar_fdwFDWCApache-2.0Foreign data wrapper forwarding PostgreSQL queries to Quasar-supported backends.
s3_fdwFDWCPostgreSQLForeign data wrapper for reading Amazon S3 files through PostgreSQL COPY format.
twitter_fdwFDWCPostgreSQLtwitter search API wrapper
fuzzywuzzyFTSSQLPostgreSQLfuzzywuzzy ratio for postgres
sphinxFTSCMITConnector to SphinxSearch server
pg_scwsFTSCBSD 3-Clausea parser for full-text search of Chinese
pg_tsparserFTSCPostgreSQLParser for PostgreSQL text search
tsexactFTSCPostgreSQLPostgreSQL full text search exact match helper functions
tsvector2FTSCPostgreSQLExtended tsvector type for PostgreSQL
bg_monSTATCMITBackground worker for monitoring PostgreSQL
monetdb_fdwFDWCUnknownMonetDB foreign data wrapper
neo4j-fdwFDWPythonGPL-3.0Multicorn-based foreign data wrapper and Cypher functions for Neo4j.
neo4j_fdwFDWCUnknownC foreign data wrapper for Neo4j Cypher query results.
orc_fdwFDWCUnknownForeign data wrapper for reading ORC formatted files
pg_loggingSTATCPostgreSQLPostgreSQL logging interface
pg_sampletologSTATCPostgreSQLLog sample of statements or transactions
pg_sortstatsSTATCPostgreSQLAn extension collecting statistics about sorts
pgsamplerSTATCPostgreSQLtimeseries statistics collector for postgresql
statsdSTATCBSD 3-Clausestatsd client for PostgreSQL
pgtelemetrySTATSQLPostgreSQLUseful monitoring views for PostgreSQL, packaged as an extension
pg_checkSTATCBSD 3-ClauseProvides basic integrity checks for data files.
pg_grab_statementSTATCGPL-2.0Grab SQL statements
pg_healerADMINCPostgreSQLautomagical healing of database problems
pg_idx_advisorFEATCPostgreSQLPostgreSQL index advisor
pg_normalize_queryFEATCBSD 3-ClauseNormalize SQL statements in PostgreSQL
pg_plan_advsrFEATCUnknownAutomated execution plan tuning extension
sr_planFEATCPostgreSQLSave and restore query plans in PostgreSQL
kmeansFUNCCPostgreSQLK-means clustering window function for PostgreSQL
ora_migratorETLSQLPostgreSQLTools to migrate Oracle databases to PostgreSQL
pldotnetLANGCPostgreSQLProcedural language extension adding C# and F# support to PostgreSQL via .NET.
pljuliaLANGCPostgreSQLProcedural language handler allowing PostgreSQL functions in Julia.
plv8geoGISSQLMITPLV8 geospatial helper functions and bundled JavaScript libraries for PostGIS workflows.
pg_dbms_statsSTATCBSD 3-ClauseStatistics management extension for stabilizing PostgreSQL execution plans using fixed statistics.
recursively_deleteTYPESQLMITDelete records and foreign-key dependents, regardless of constraint type
pg_backtraceSTATCPostgreSQLShow backtrace for errors and signals
pg_doc_storeRAGSQLPostgreSQLExtension to give a document storage api to postgres
pg_oltp_benchFUNCCUnknownsupporting function for oltp benchmark
schema_triggersADMINCUnknownAdds schema-change event trigger events for relation, column, and trigger changes.
pg_simulaFUNCCUnknownDatabase system failure simulation tool
pgh3GISCApache-2.0Postgresql H3 bindings
s2GISPythonMITS2 cell id and token functions implemented in PL/Python using s2sphere.
zcurveGISCUnknownbit interleaving stuff
foreign_table_exposerFDWCApache-2.0expose foreign tables as a regular table
json_buildFUNCCPostgreSQLPostgreSQL extension; upstream metadata did not provide a specific description.
pgbouncer_wrapperFDWSQLMITWrap pgbouncer output in a FDW
pgfsmSTATSQLBSD 0-ClauseFinite State Machine enforcement with triggers and util functions.
jsonbxFUNCCPostgreSQLJsonb extension functions for PostgreSQL 9.4
jsonknifeFUNCCUnknownUseful jsonb inspection and transformation functions
lsmFDWCApache-2.0RocksDB foreign data wrapper for PostgreSQL
lsm3FEATCPostgreSQLLSM tree index access method based on PostgreSQL B-tree indexes
undamFEATCUnknownUndo table access method storage
nanomsgtopdbETLCUnknownReceive nanomsg messages into a PipelineDB stream.
pg_acceOLAPCUnknownpg_acce -- Accelerated Engine
pipeline_kinesisETLC++GPL-3.0PipelineDB extension for Kinesis support
dont_drop_dbSECCUnknowndont_drop_db prohibits to drop the databases listed in the dont_drop_db.list parameter.
drop_role_helperSECSQLPostgreSQLgenerate SQL to revoke all privileges of a role in the current database
istoriaUTILSQLGPL-3.0Table history management with non-linear undo/redo
login_refuseSECCUnknownAdd login check in postgres
non_truncateSECCUnknownDisables TRUNCATE by raising an error from a ProcessUtility hook
oblivpg_fdwFDWCUnknownOblivious foreign data wrapper for table access backed by trusted hardware and ORAM
passwordpolicySECCMITpasswordpolicy - strengthen user password checks
certSECCPostgreSQLX509 Digital Certificates
rolemanSECSQLPostgreSQLRole management extension with common helper functions.
webauthnSECSQLMITWebAuth server
pg_auditSECSQLUnknownAn extension for creating audit tables
auditSECSQLGPL-2.0Audits insert, update, and delete operations on PostgreSQL tables.
pg_audit_toolsSECSQLMITPostgreSQL extension for audit tables management
pg_block_systemcatalogSECCPostgreSQLPostgreSQL extension to block references to system catalogs.
check_chapmd5_passwordSECCApache-2.0check_chapmd5_password function
pg_checkdestroySECCUnknowncheck sql drop&delete&truncate table
pg_connlimitSECCUnknownlimit role connectivity count without catalog access
pg_control_prioritySECCPostgreSQLcontrol the priorities of PostgreSQL server processes
pg_ed25519SECCMITEd25519 tools
pg_feedbackSECCPostgreSQLPostgreSQL feedback plugin
grants_managerSECSQLUnknownPostgreSQL extension; upstream metadata did not provide a specific description.
pg_reject_truncateSECCUnknownRejects or prevents TRUNCATE operations in PostgreSQL.
pg_rlimitSECCBSD 3-Clausesetrlimit/getrlimit functions
bitstring_helpersFUNCCUnknownHelper C functions and aggregates for PostgreSQL bit varying data.
medianFUNCCUnknownMedian aggregate function for input sets
pg_secretSECCUnknownOrder-revealing encryption extension for PostgreSQL.
pg_setprioritySECCUnknownset the priority of PostgreSQL process
pg_sslSECCMITPostgreSQL SSL
pg_sulogSECCPostgreSQLPostgreSQL superuser operation logging and blocking extension
pg_visibilitymapADMINCUnknownExamine PostgreSQL visibility map state for relations
pgocryptoSECCUnknownencrypt data between Go and PG
pgseccompSECCPostgreSQLprovide seccomp syscall filtering for PostgreSQL
pgswordSECCUnknownQunar PostgreSQL audit tools
postgres_securitySECCUnknownsecurity enhancement for postgres
postgrest_authSECSQLMITAuthentication functionality for PostgREST
table_log_plADMINSQLUnknownpl/pgsql implementation for table_log: an extension to log table changes in PostgreSQL
tablelogSECSQLUnknownrecord table modification logs
tcleSECCPostgreSQLTransparent Cell-Level Encryption
pg_bmanADMINCPostgreSQLGet/Show archivging logs
pg_dropbuffersADMINCPostgreSQLDrop buffers, and probably lose data
pg_pageprepADMINCPostgreSQLPrepare pages for transformation to 64bit XID format
walreaderADMINCUnknownfunctions for reading wal
casTYPECUnknownCAS Registry Number data type for PostgreSQL.
colnamesTYPECPostgreSQLLists the column names in a PostgreSQL RECORD value
complexTYPECUnknowncomplex - Complex numbers
dammTYPESQLMITSQL implementation of the Damm check digit algorithm with a damm_code domain and helper functions.
data_rigTYPECUnknownMultidimensional OLAP fact data type with GiST indexing support.
fhir_jsonbTYPESQLUnknowntests for json b
fhirbaseTYPESQLMPL-2.0FHIR database
siguanet_questGISSQLGPL-3.0SIGUANET spatial aggregate reporting functions
trimmed_aggregatesFUNCCBSD 2-ClauseTrimmed aggregate functions for PostgreSQL
vectoraggFUNCCUnknownArray aggregation functions
frkn_avgFUNCCUnknownfrkn_avg function
fhirpathTYPECUnknowndata type for jsonb inspection
fibonacciFUNCCGPL-2.0Fibonacci extension for PostgreSQL.
fluxSECSQLUnknownLogs table data changes and reconstructs rows as they existed in the past.
fnvhashFUNCCUnknownFNV hash functions for PostgreSQL.
generate_date_seriesFUNCCPostgreSQLgenerate_series() for pure date values
inetrangeTYPECMITRange type for PostgreSQL inet values
italian_codesTYPESQLUnknownValidation domains for Italian fiscal and VAT codes
jsonbdTYPECUnknownCompression method for JSONB type
lpathtreeTYPECUnknowndata type for hierarchical tree-like structures
ntextTYPECUnknownJapanese normalized-comparison text type for UTF-8 strings
colorsTYPECPostgreSQLColors for PostgreSQL
device_typeTYPECPostgreSQLFixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes.
pg_digestTYPECGPL-3.0Data type for efficient storage of hash digests in PostgreSQL.
hash64TYPECPostgreSQLStable 64-bit hash function for PostgreSQL
hostnameTYPECPostgreSQLGet the server host name
languageTYPECPostgreSQLCustom PostgreSQL language enumeration type
nextidFUNCCMITGenerate Instagram-style sharded integer IDs.
numhstoreTYPECMITAdds inthstore and floathstore numeric hstore types and helpers
opensslSECCPostgreSQLPostgreSQL extension for cryptographic functions and types provided by OpenSSL
ruidTYPECPostgreSQLReadable and Usable Identifier
salesforce_idTYPECPostgreSQLCustom PostgreSQL type and operators for compact Salesforce ID storage and comparison.
spanTYPECPostgreSQLText span data type
sum_arrayFUNCCUnknownsum the contexts of a numeric array
loggingADMINCPostgreSQLAdministrative C function to enable or disable logging mode on relations.
ajboolTYPECPostgreSQLThree-valued boolean type with a pseudo-NULL unknown state for primary keys.
array_textsortFUNCCUnknownC functions for sorting and de-duplicating one-dimensional text arrays.
base32_4bTYPECPostgreSQLBase32 data type stored in four bytes with comparison operators.
boolean_cascadedTYPESQLPostgreSQLComposite boolean status type with operators and trigger helper for cascaded parent-child status.
numeric_domainsTYPESQLMITCustom numeric domains for PostgreSQL
passwordTYPECPostgreSQLPostgreSQL data type for passwords
ajversionTYPECPostgreSQLSemantic version type for PostgreSQL backed by compact integer storage.
cborTYPECPostgreSQLConcise Binary Object Representation data type for PostgreSQL.
pg_imputed_genotypeTYPECPostgreSQLan efficient, packed probability tuple suitable for imputed genotypes
pg_markdownTYPECPostgreSQLMarkdown datatype and processing
pg_nanpTYPECPostgreSQLan efficient, validated, formatted NANP type
ragRAGRustApache-2.0Tools to support Retrieval-Augmented Generation
rag_bge_small_en_v15RAGRustApache-2.0In-database embeddings generation using bge-small-en-v1.5
rag_jina_reranker_v1_tiny_enRAGRustApache-2.0In-database reranking using jina-reranker-v1-tiny-en
lostgisGISSQLBSD 3-ClauseLostGIS spatial helper functions and types
formatbaseFUNCCMITC functions to format numbers and parse strings by numeric base.
pg_fractionTYPECUnknownFraction data type with arithmetic, comparison, min/max, and btree support.
pg_gen_uidFUNCSQLUnknownPL/pgSQL helper function to generate random alphanumeric IDs using pgcrypto.
pg_genotypeTYPECPostgreSQLCompact genotype representation data type for PostgreSQL.
pg_gslFUNCCGPL-3.0Wrapper functions exposing selected GNU Scientific Library routines to PostgreSQL.
pg_postal_code_caTYPECPostgreSQLan efficient, validated, formatted Canadian postal code type
kissfftTYPECBSD 3-ClauseFast-Fourier transformer (fft)
pgflakeTYPECApache-2.0Extension for fdw memory
knxTYPECBSD 3-Clausedata types for KNX Addresses
libuuidTYPECPostgreSQLgenerate universally unique identifiers (UUIDs)
pgopenssltypesTYPECPostgreSQLPostgreSQL extension; upstream metadata did not provide a specific description.
pcg_randomTYPECApache-2.0pgsql-pcg-random
pg_colorTYPECApache-2.0Color data type for PostgreSQL
pg_datatype_passwordTYPESQLMITPostgreSQL data type for storing blowfish encrypted and salted passwords
pguriTYPECPostgreSQLuri and domainname parsing, types, and search
postcodeTYPECUnknownUK postcode type
uintsTYPECPostgreSQLUnsigned integer types
cidrFUNCSQLMITtransform ip range to cidr
evrTYPESQLGPL-3.0PostgreSQL extension for RPM epoch/version/release datatype parsing.
fast_guidFUNCCPostgreSQLFast GUID generator function for PostgreSQL.
hamradioTYPESQLPostgreSQLham radio extension
safecastTYPESQLApache-2.0SQL helper functions for safe casts that return NULL instead of raising errors.
tanimotoTYPECUnknowntanimoto on bit varying
telephoneTYPECPostgreSQLTelephone digits and international telephone number validation
text_domainsTYPESQLMITPostgreSQL extension; upstream metadata did not provide a specific description.
dict_excludeFTSCPostgreSQLtext search dictionary for regexp stopwords
dict_idFTSCPostgreSQLtext search dictionary to stem indonesian words
dict_regexFTSCUnknownDictionary with regular expression support
dict_romanFTSCUnknownDictionary for roman numerals
dict_translateFTSCUnknownText search dictionary template that normalizes lexemes and expands them to configured translations.
pg_strverscmpTYPECLGPL-2.1Natural-sort comparison functions, text operators, and a btree operator class based on a strverscmp-like order.
pg_sysdatetimeFUNCCBSD 2-ClauseHigh-precision SQL Server-style system datetime functions for PostgreSQL, mainly useful on older Windows builds.
pg_txn_statusTYPECUnknownOne-byte txn_status data type for storing transaction state values.
urlTYPESQLBSD 3-ClauseSQL and PL/pgSQL types and helper functions for URL parsing, encoding, decoding, and query-string key/value handling.
vercompTYPECMITVersion data type with comparison and compatibility operators
pgbrtypesTYPECUnknownBrazilian CPF and CNPJ data types with validation, formatting, casts, and indexing support
crockfordTYPECPostgreSQLCrockford Base32 encoded unsigned integer data types
decibelTYPECGPL-3.0Decibel data type with pressure conversions, arithmetic operators, comparisons, and aggregates
decimalTYPECUnknownDecimal32 and decimal64 decimal floating-point data types with arithmetic and casts
hunspell_xalFTSSQLBSD 3-ClauseKalmyk Hunspell dictionary for PostgreSQL full-text search
flateUTILCISCRaw DEFLATE compression and decompression functions for bytea
ibanTYPEC++GPL-3.0IBAN data type and validation functions for PostgreSQL
libversionTYPECMITVersion string comparison functions and versiontext type using libversion
numberTYPECMITVariable-width integer data type for PostgreSQL
popcountFUNCCMITPopulation-count functions for PostgreSQL bit(n) values.
vpackTYPEC++UnknownVelocyPack data type, path type, operators, casts, and JSON/BSON conversion support for PostgreSQL.
uniqueidentifierTYPECLGPL-2.1Legacy 16-byte uniqueidentifier data type, comparison operators, casts, and newid() generation for PostgreSQL.
unitsFUNCSQLUnknownUnit conversion table and PL/pgSQL conversion function for length units.
uuid-freebsdFUNCCPostgreSQLUUID generation functions for PostgreSQL on FreeBSD.
validadoresFUNCSQLPostgreSQLSQL validators for Brazilian CNPJ/CPF-style identifiers.
variantTYPECBSD 2-ClauseVariant data type that can store values from other PostgreSQL types.
pg_repeaterETLCPostgreSQLPass raw query plan to a remote node
ddl_replETLCUnknownReplicate DDL/DDC commands across cluster
pg_shardETLCLGPL-3.0extension for sharding across remote PostgreSQL servers
range_partitioningETLSQLPostgreSQLStatic range partitioning helpers for PostgreSQL tables, including partition split and merge operations.
replisomeETLCBSD 3-ClauseLogical decoding output plugin and Python consumer framework for exporting PostgreSQL row changes.
routerETLCPostgreSQLC sharding router extension for routing PostgreSQL queries across shards.
shard_managerETLSQLApache-2.0SQL and PL/pgSQL helpers for managing schema-based horizontal sharding.
synchronize_logical_slotsETLCUnknownSynchronizes logical replication slots to synchronous standby servers.
snowball_extFTSCPostgreSQLsnowball_ext - add-on dictionary template with natural language stemmers
autofailoverADMINCUnknownC extension exposing autofailover functions for role and WAL status checks, promotion, and synchronous replication setting changes.
bwcontrolETLCPostgreSQLBottledwater control extension
edb_foreignkeyconstraintmanagerADMINSQLUnknownEDB foreign key constraint manager for partitioned tables
gogudbETLCPostgreSQLPostgreSQL distributed database plugin
sys_syn_dblinkETLSQLPostgreSQLSystem Synchronization Processor - dblink
xl_global_viewsETLSQLPostgreSQLCreates global pgxl_ views over Postgres-XL nodes based on pg_ views.
datalinkETLCPostgreSQLfunctions and types to implement datalink in PostgreSQL server
pg_particulousOLAPCUnknownInstant migration between vanilla PostgreSQL and pg_pathman
pg_partitionOLAPSQLMITPartition management for PostgreSQL
pg_prttn_toolsOLAPSQLMITPartition table management tools
emailETLCPostgreSQLEmail address data type with validation, equality operators, and user/domain helper functions.
schedulerxETLCBSD 3-Clausescheduler
gunzipETLCUnknowna tool for gunzipping db-content
jx_ioETLSQLPostgreSQLExtension to export and import json and xml from/to postgres
kadb_fdwETLCApache-2.0Kafka-ADB foreign data wrapper
compressETLC++GPL-3.0A bundle of functions for compress/uncompress data with help of various algo
frapiETLSQLMITIn-databas api-wrapper functions for a collection of french administrtion data API
pg_grpcETLCMITPostgreSQL gRPC
pg_htmldocETLCMITPostgreSQL HTML to PDF
job_queueETLCUnknownSimple async queue mechanism
pg_kafka_eventsETLCApache-2.0PostgreSQL Kafka Events
pg_msgpackTYPECPostgreSQLMessagePack data type with JSON and bytea casts and access operators
pg_mupdfETLCMITConvert HTML to PDF inside PostgreSQL using MuPDF
pg_webETLCMITPostgreSQL extension which provide web interface for database
pg_wkhtmltopdfETLCMITPostgreSQL HTML to PDF
pg_wthtmltopdfETLC++MITPostgreSQL HTML to PDF
pgAutomatorETLSQLMITDatabase logic for the pgAutomator job scheduling system.
pgbrotliETLCUnknownBrotli compression and decompression functions for PostgreSQL.
pgcompressETLCGPL-3.0Provides deflate, inflate, gzip, and Brotli compression functions for bytea, text, json, and jsonb.
pgcurlETLCBSD 2-ClauseCalls curl/libcurl from PostgreSQL through a SQL function.
pgqueETLSQLUnknownJob queue using advisory locks
pgreadfileETLCUnknownreadfile interface
pgsmtpETLSQLPostgreSQLExtension to wsend mail by smtp using plpython
mypg_shardingOLAPCUnknownmypg sharding utilities for PostgreSQL
partman_to_cstoreOLAPSQLPostgreSQLMove old pg_partman partitions to cstore columnar storage.
pathman_shardingOLAPCPostgreSQLImproved sharding for pg_pathman.
cassandra_fdwFDWCUnknownforeign-data wrapper for querying Cassandra 3+
db2odbc_fdwFDWCApache-2.0Foreign data wrapper for accessing remote databases using DB2/ODBC
pg_shardmanETLCPostgreSQLPostgreSQL 10 sharding manager built on pg_pathman, postgres_fdw, and logical replication.
pgxc_dnsETLCPostgreSQLPostgreSQL-XC DNS helper functions returning coordinator zone/weight information.
pg_mustachFUNCCMITPostgreSQL implementation of Mustache templating
pg_redispubETLCMITPublish messages to Redis
pg_remote_execADMINCPostgreSQLRemote shell execution for non-superusers
pg_sendmailETLCApache-2.0Mail and sendmail functions
pg_thriftTYPECUnknownThrift support for PostgreSQL
hive_fdwFDWCUnknownForeign data wrapper for querying Apache Hive from PostgreSQL.
lua_fdwFDWCPostgreSQLLua Foreign Data Wrapper
ocgeo_fdwFDWCPostgreSQLForeign data wrapper for the OpenCageData API
douban_fdwFDWCMITA PostgreSQL's Foreign Data Wrapper (FDW) for retrieving the movie ranking data via the public API of douban.com
passwd-fdwFDWCPostgreSQLForeign data wrapper for Unix/Linux passwd and group databases.
mv_rewriteFEATCUnknownQuery rewriting extension that transparently rewrites queries to use lower-cost materialized views.
aerospike_fdwFDWCUnknownForeign Data Wrapper for Aerospike.
file_fdw_programFDWCPostgreSQLBackport of file_fdw PROGRAM support, exposing a file_fdw-like foreign data wrapper that reads from external commands.
greenplum_fdwFDWCUnknownClone of postgres-fdw, to query Greenplum DB from PostgreSQL. See master branch README!
rep_fdwFDWSQLUnknownExtension to replicate tables to other PostgreSQL server using FDW
treasuredata_fdwFDWCApache-2.0foreign-data wrapper for Treasure Data
tsf_fdwFDWCLGPL-3.0foreign data wrapper for TSF files provided by Golden Helix
tuple_fdwFDWCUnknownalternative heap tuple storage
wdb_fdwFDWCPostgreSQLWhiteDB Foreign Data Wrapper
all_substrings_tokenizerFUNCCUnknownTokenizes text to all substrings bigger than a fixed character length.
gtables_fdwFDWCAGPL-3.0Global tables across FDW API
hash_fdwFDWCUnknownForeign data wrapper for hash tables
hba_fdwFDWCBSD 3-ClauseForeign data wrapper to manage pg_hba.conf entries from SQL.
hbase_fdwFDWCUnknownForeign data wrapper for querying HBase from PostgreSQL.
pspacyFTSSQLUnknownMultilingual full-text-search helpers using Python spaCy through PL/Python.
jieba_parserFTSC++UnknownJieba parser for full-text search
ludia_funcsFTSCLGPL-2.1Ludia full-text search helper functions
mipt-asjSIMCMITImplementation of Tao-Deng-Stonebraker algorithm of approximate string JOINs with abbreviations
pg_libnumbertextFTSC++LGPL-3.0Integrates libnumbertext with PostgreSQL
pg_cjk_parserFTSCPostgreSQLFull-text search parser that splits CJK text into 2-gram tokens
pg_collkeyFUNCCMITICU collation function wrapper
content_utilsFTSSQLGPL-2.0utility functions for use with news management and full text search
pgsftiFTSCMITA Simple Fuzzy Time Interval data type.
pgunicollFTSCGPL-2.0Provides Unicode Collation Algorithm support
recommendFTSCUnknowncompute similary of any one-dimensional arrays
musicbrainz_collateFUNCCGPL-3.0Provides Unicode Collation Algorithm support
musicbrainz_unaccentFTSCGPL-3.0Removes accents from Unicode data
similaritySIMCGPL-2.0calculate similarities between strings
setrankFTSCUnknownRank using set of documents
sphinxlinkFTSCUnknownconnect to Sphinx extension
test_parserFTSCUnknownexample of a custom parser for full-text search
tsearch_extrasFTSCPostgreSQLPostgreSQL extension tsearch_extras
twitter_parserFTSCUnknowntwittter Hashtag and Mention parsing for full-text search
vgramFTSCPostgreSQLVariable-length grams
vmatchFTSCUnknownvague equal expression.
wildspeedFTSCGPL-2.0Wildspeed - fast wildcard search for LIKE operator
autoreindexADMINCUnknownShared-preload background-worker extension that scans for bloated indexes and performs concurrent reindexing work in the background.
autovacuum_informationsSTATCPostgreSQLPostgreSQL extension that adds functions for reporting the autovacuum launcher PID and autovacuum worker information.
config_logSTATCPostgreSQLcustom background worker process to log changes to postgresql.conf to a table
db_infoSTATSQLPostgreSQLExtension to get information about the database: size, owner, name,tablespces, ext, obj count,etc
dbstatSTATCMITDB Statistics Collector
filenode_map_inspectSTATCUnknownCheck and examine pg_filenode.map files
log_entriesSTATCUnknownRecords who changed a row and when.
loginfoSTATCGPL-3.0Functions and views for PostgreSQL to query the postgres log
memstatSTATCUnknownMemory context statistics for local and instance backends
monitoring_roleSTATSQLBSD 0-ClauseSpecial monitor functions
palloc_benchUTILCUnknownBenchmark function for PostgreSQL palloc memory allocation
pg_toastutilsSTATCPostgreSQLTOAST inspection utils for postgres
pg_dbo_timestampSTATSQLUnknownPostgreSQL extension for storing time and author of database structure modification.
pg_dbsmSTATCUnknowntrack database size
pg_dbwaSTATSQLMITPostgreSQL Database workload analizer
pg_decode_infomaskSTATCPostgreSQLSet of function to decode infomask hintbits
pg_eyesSTATSQLMITPostgreSQL extension for analyze database activity
pg_frozenSTATCUnknownExposes a frozen(tid) function that explains if a tuple has been frozen
pg_fuck_blockSTATCUnknownPostgreSQL extension; upstream metadata did not provide a specific description.
pg_log_statementsSTATCPostgreSQLPostgreSQL extension; upstream metadata did not provide a specific description.
pg_logfebeSTATCBSD 2-Clauselog via febe framing protocol to a unix socket
pg_logqueryidSTATCPostgreSQLLogs pg_stat_statements query IDs alongside auto_explain output.
pg_mem_countersSTATCMITKeeps named total and requests-per-minute counters in PostgreSQL shared memory.
pg_memorycontextSTATCPostgreSQLExamines PostgreSQL memory context information.
pg_contextdumpSTATCUnknownstats of memory context allocated memory usage
pg_metricsSTATCUnknownProvides shared-memory counters exposed through SQL metric functions.
pg_metricusSTATCMITSends custom metrics from PL/pgSQL code to socket-based aggregators such as Brubeck or Graphite.
pg_microbenchSTATCMITPerf stat-like hardware performance counters for PostgreSQL planner, executor, utility, and SPI query phases using Linux perf_event_open
pg_monSTATCMITPostgreSQL extension for query monitoring with execution-time histograms and plan information in a shared view
pg_octopusSTATCPostgreSQLBackground health checker
pg_pageinspect_plusSTATCBSD 3-ClauseTuple data inspection helpers for PostgreSQL pageinspect
pg_stat_statements2STATCPostgreSQLtrack execution statistics of all SQL statements executed
pg_stat_usageSTATCUnknowntrack usage statistics of stored procedure calls
pg_statsSTATSQLUnknownCustomized statistics views
pg_subtrans_infosSTATCPostgreSQLPostgreSQL extension pg_subtrans_infos
pg_track_slow_queriesSTATCPostgreSQLTracks slow queries and their execution plans
pgcovSTATCMITTracks test coverage in PL/PgSQL functions and requires shared_preload_libraries.
pg_monitoringSTATSQLPostgreSQLA collection of basic monitoring functions for PostgreSQL
track_renamesSTATCPostgreSQLDatabase object rename tracking extension
resourcesSTATSQLUnknownExtension to get information server resources: CPU, MEM, Partitions, SO, postgres process, etc
pg_stat_ssi_failuresSTATCUnknownCluster-wide counter for PostgreSQL SSI serialization failures.
stat_recordSTATCUnknownExtension for record stats/reports from databases stats server like: connections, size, cache, table and index use, bloat, querys, etc
streaminglagSTATSQLUnknownStreaming Lag Utils
user_infoADMINSQLUnknownProvides user-related information including owned objects and granted roles.
pgosqlLANGCAGPL-3.0PL/SQL Compatibility
pgc_fdwFDWCUnknownForeign data wrapper for remote PostgreSQL servers with a FoundationDB-backed cache.
pglogFDWCPostgreSQLPostgreSQL log via SQL
postgres_fdw_plusFDWCPostgreSQLpostgres_fdw fork with global transaction support
ppg_fdwFDWCUnknownParallel foreign-data wrapper for remote PostgreSQL servers.
pgtsqlLANGCUnknownTransact SQL compatibility
pljvmLANGCBSD 3-Clauseexecute remote functions inside jvm
plpython3tLANGSQLUnknownPL/Python3t trusted procedural language
fzyFTSCMITFZY algorithm for PostgreSQL
pg_mystemFTSC++MITYandex Mystem support for PostgreSQL
simple_parserFTSCPostgreSQLsimple parser for full-text search
pg_textparserFTSCMITText search parser
unidecodeFTSCGPL-2.0ASCII transliterations of Unicode text
plrubyLANGCApache-2.0PL/Ruby untrusted procedural language
plsixLANGCPostgreSQLPL/six procedural language
plswiplLANGCMITPL/SWI-Prolog procedural language
agsFEATCUnknownAdvanced Generalized Search access method, a GiST-based advanced index.
geqo_extensionSTATCUnknownGenetic Query Optimizer isolated from PostgreSQL
gevelSTATCGPL-2.0PostgreSQL extension; upstream metadata did not provide a specific description.
index_analyzerSTATSQLBSD 2-ClausePostgreSQL extension; upstream metadata did not provide a specific description.
pargresFEATCPostgreSQLPrototype parallel query execution module for shared-nothing PostgreSQL clusters
pg_array_multi_indexFUNCCPostgreSQLsimultaneous multiple-indexing of PostgreSQL arrays
pg_get_queryidSTATCPostgreSQLget last queryid generated/used by pg_stat_statements for a given backend pid
pg_queryidSTATCPostgreSQLExternal query fingerprinting module
query_recorderSTATCUnknownAllows recording of SQL queries to a separate file.
saioSTATCPostgreSQLPostgreSQL join optimisation with Simulated Annealing
hamming_distanceRAGCMITfind hamming distance sparsing hexdigested hash value over two char groups
hclustFUNCCUnknownHierarchical clustering function for PostgreSQL.
numpgsqlFUNCC++MITArray and numerical computing library for PostgreSQL
pg_shared_plansSTATCPostgreSQLProof-of-concept shared-memory plan cache for PostgreSQL.
pg_stat_sql_plansSTATCPostgreSQLTrack execution statistics by normalized SQL query and plan ID.
query_histogramSTATCBSD 2-ClauseCollects query runtime histograms in shared memory.
sparse_vectorRAGCMITdata type for sparse vector
pgpymlRAGSQLPostgreSQLDeploy your python machine learning models in your database
pg_phashRAGCGPL-3.0support phash hamming distance calculation
postgresmlFEATCUnknownNaive Bayes text-classification helper for PostgreSQL; installs the ts_lexemes C function.
astrocatGISCUnknownPostgreSQL extension for indexing astronomical catalogues with spherical point and circle types, GiST indexing, radial queries, and k-nearest-neighbor ordering.
brin4postgisGISSQLGPL-3.0BRIN indexes for PostGIS
dumppointsGISCBSD 0-ClauseImproved ST_DumpPoints
pg_querylogSTATCUnknownShow queries running on PostgreSQL backends
pg_quotaADMINCPostgreSQLDisk space quota extension for PostgreSQL
pg_session_statsSTATCGPL-3.0Track PostgreSQL resource usage at session level
pg_sessionsSTATCGPL-3.0Active session history for PostgreSQL queries, including PID, timestamps, query metrics, and optional Linux process statistics.
optpathsFEATCBSD 3-ClausePlanner hook extension for adding paths and removing self joins
ctidscanSTATCUnknownexample implementation for custom-scan-provider interface
repeaterSTATCPostgreSQLRepeater / raw query plan execution extension
explanationSTATSQLBSD 3-ClauseEXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree.
pg_healpixGISCGPL-2.0HEALPIX functions for PostgreSQL
pg_landmetricsGISSQLGPL-3.0A PostgreSQL extension for calculating landscape metrics.
pg_tilelessGISCGPL-2.0Tools for packaging twkb in sqlite for tileless
pg_tmsGISSQLMITfunctions to tile rasters in TMS format
pg_twkbGISCGPL-2.0TWKB tools etc
triangle_arrayGISCUnknownTriangle Array prototype to store TINs
vasavgeomGISCGPL-2.0Vague geometry handler - VASA
geoip2lookupGISSQLBSD 2-ClauseLook up IP-address info in MaxMind GeoIP2 MMDB files
pg_trajectoryGISSQLUnknownPostgreSQL/PostGIS extension for spatiotemporal data
coordconvGISCGPL-2.0Convert equatorial and galactic coordinates
pg_geohash_extraGISCGPL-3.0Additional geohash functions for PostGIS
append_only_heapFEATCMITPostgreSQL table access method that avoids fragmentation of variable-length append-only data.
bztreeFEATC++Apache-2.0bztree index
calculate_markupFUNCCUnknownfunction for linear interpolation
calendarsTIMECBSD 3-Clausecalendar conversion routines
call_graphSTATCMITautomatically track function calls to create call graphs
cbtreeFEATCUnknowncounted btree access method
cdb_extension_fwUTILSQLUnknownexperimental framework for PostgreSQL extension boilerplate
check_orapgETLSQLUnknownvalidates Oracle-to-PostgreSQL/EDB migration objects and counts
chess_indexTYPECMITdata types for indexing chess positions
cms_topnSTATCUnknowntype for count-min sketch top-n
conninfoUTILCPostgreSQLconninfo string manipulation functions
constr_name_unifADMINSQLMITExtension for uniforming the names of different constraints in base tables
postgres_ciADMINSQLMITPostgres-CI PL/pgSQL backend
db2fceFUNCSQLPostgreSQLDB2 compatibility environment for PostgreSQL
dbms_sqlFUNCCBSD 0-ClauseFunctions and operators that emulate dbms_sql package''s API
ddlaADMINSQLUnknownExtension to logs DDL changes
debug_funcsADMINCUnknowndebugging functions
edb_block_commandsSECCUnknownRestricts superuser utility, DML, and SELECT commands with whitelist GUCs on EDB Advanced Server
efm_extensionADMINCPostgreSQLSQL interface for EDB Failover Manager cluster management
emptyUTILCUnknownDemo C extension with sample functions, a matrix type, an FDW, logical-decoding callbacks, and shared-memory hooks.
postgis_domainsGISSQLMITPostGIS domains for geometry and geography types
postgis_lettersGISSQLMITExtension to allow converting letters to PostGIS geometries
rasterdbGISCUnknownraster database
rtosmGISCGPL-2.0real-time simplification of spatial objects in Openstreetmap API Database
event_managerADMINCPostgreSQLLoosely coupled PostgreSQL event trigger and queue system with synchronous or asynchronous processing.
fireflyTYPESQLGPL-3.0firefly data types and function
formatFUNCCUnknownA string formatting function which takes named parameters
format_xFUNCCMITA polymorphic, variadic string formatting function which takes named parameters
gbuilderGISCUnknownAdditional geometry builders
geohash_extraGISCUnknownAdditional geohash functions
geohistorical_objectsGISSQLMITGeohistorical objects support
historical_geocodingGISSQLMITGeocoding and localisation helpers for historical data in PostgreSQL.
mapcodeGISC++PostgreSQLMapcodes in PostgreSQL
gbdchecksFUNCSQLGPL-3.0GBD tarafindan kullanilan fonkisyon ve viewlarin eklentiye donusturulmus hali
get_sumFUNCCUnknownsimple sum of two integers for postgres externsion using c
jsonb_schemaTYPECPostgreSQLjsonb with separately stored schema
jsonb_set_laxFUNCCPostgreSQLPostgreSQL extension; upstream metadata did not provide a specific description.
jsonfunFUNCCUnknownAdditional JSON functions for fun and profit.
ksjTYPECUnknowndata type for kanji representation integer
lispgLANGCUnknownlisp for postgresql
livewireSIMSQLUnknownpower delivery modeling
lsm_idxFEATCUnknownLsm index
mdbqsUTILCUnknownMongoDB-style query support for PostgreSQL
autopexADMINCUnknownEvent-trigger extension that invokes Pex to automatically download and build PostgreSQL extensions when CREATE EXTENSION is run.
bench_pg_unwindUTILRustApache-2.0Benchmark PostgreSQL/Rust exception unwinding overhead
binvecFUNCCUnknownC helper for summing integer bit values into arrays
sybase_fdwFDWCUnknownSybase foreign data wrapper for PostgreSQL
template_fdwFDWCBSD 2-ClausePostgreSQL data wrapper for template tables where DML and SELECT operations are disallowed
merge_ipsFUNCSQLPostgreSQLFunctions to merge IP addresses, ignoring gaps
meta_triggersADMINSQLBSD 2-ClauseInsert, update and delete triggers for the meta system catalog
mtreeFEATCUnknownmtree index
progressSTATCPostgreSQLQuery progress estimation for PostgreSQL.
pg2podgSIMSQLGPL-3.0PostgreSQL extension for two-player open deterministic games.
pg_aaFUNCCPostgreSQLASCII art extension for PostgreSQL
pg_abrisUTILSQLUnknownAbris metadata extension that creates a meta schema with metadata tables, views, and helper functions.
pg_aggFEATPythonUnknownExperimental aggregate-query support extension; its install script currently creates the untrusted PL/Python language.
pg_algorithmsFUNCCMITC extension that adds example algorithm functions, including bubble sort and quicksort for integer arrays.
pg_asyncETLCMITC extension that provides async LISTEN/NOTIFY queue support on PostgreSQL replicas in hot standby.
b64encTYPERustUnknownRust/C extension that defines a b64enc base type with URL-safe Base64 input and output functions.
pg_bofhSECCPostgreSQLRejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries.
pg_cache_treeETLSQLMITCaches recursive parent and child IDs in array columns using trigger and helper functions.
pg_calcpiFUNCSQLUnknownComputes digits of pi in PostgreSQL with a PL/pgSQL spigot algorithm.
pg_catalog_get_defsFUNCSQLBSD 3-ClauseAdds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata.
pg_cgroupADMINCPostgreSQLProvides SQL-callable functions to create, configure, and attach processes to Linux cgroups.
pg_crasherFUNCCUnknownProvides a function that intentionally crashes a PostgreSQL backend for client error-handling tests.
pg_dirty_handsADMINCUnknownProvides functions to freeze individual heap tuples, including an unlogged variant.
pg_dmsTYPECGPL-3.0Document management system with custom ID, family, and reference types plus action tracking and JSON registry helpers.
pg_elephantFUNCCUnknownToy example extension exposing a pg_elephant() function that returns ASCII elephant text.
pg_etagFUNCCBSD 3-ClauseFast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates.
jsonb_extendFUNCCMITMerge two or more jsonb values
jsonb_deleteFUNCCUnknownhstore-style delete function and operator for jsonb
jsonb_delete_arrayFUNCCUnknownDelete jsonb keys or string elements listed in a text array
jsonb_explorerFUNCCUnknownInspect jsonb trees and paths
jsonb_extraFUNCCUnknownExtra JSONB functions
dataclipsSECCUnknownA (very much) WIP PostgreSQL extension for fetching dataclips (https://dataclips.heroku.com) for further querying
pg_fallback_utf8_to_euc_jpFUNCCPostgreSQLprovides yet another encoding conversion from UTF-8 to EUC_JP
nvlfuncFUNCSQLUnknownOracle-compatible NVL function
otpSECSQLPostgreSQLImplementation of TOTP compatible with Google Authenticator
crangesTYPECUnknownClosed forms of PostgreSQL discrete built-in ranges
pg_fiuADMINCMITFault injection in PostgreSQL
pg_foobarUTILCUnknownfoo bar game
geekspeakADMINSQLGPL-2.0Database schema extension for the GeekSpeak podcast site.
geekspeak_calendarTIMESQLMITCalendar view integration for GeekSpeak podcast episodes.
implicit_schemaADMINCMITEvent-trigger extension that automatically creates a schema when a table or view is created in a missing schema.
pg_inet_addrFUNCCUnknownLists local IPv4/IPv6 interface addresses from PostgreSQL.
intpairTYPECApache-2.0Packed int64pair data type with comparison, hash, and index operator support.
json_queryFUNCSQLPostgreSQLGenerate PostgreSQL WHERE clause predicates from JSONB filter objects.
json_utilsTYPESQLPostgreSQLJSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+.
pg_mapFUNCCUnknownpg_map - Python-like map
pg_median_utilsFUNCCMITMedian filter and iterative median filter window functions for PostgreSQL
micromanageFEATCUnknownexample extension to inject plans
pg_popyramids_datamartsOLAPSQLGPL-3.0Create a data-mart schema for population-pyramid analytics in PostgreSQL.
pg_random_stringFUNCCUnknownGenerate random strings in PostgreSQL.
pg_reversiFUNCCUnknownReversi game implemented as a PostgreSQL extension.
jsonb_opxTYPECUnknownhstore-style functions and operators for jsonb
lextestUTILCUnknownTiny module for PostgreSQL lexer benchmarking
pg_linegazerSTATCMITTransparent code coverage for PL/pgSQL
pg_lock_poolUTILSQLPostgreSQLWait on a PostgreSQL advisory lock pool
gcdFUNCCUnknownC function extension that returns the greatest common divisor for an integer array.
jansson-jsonTYPECMITJSON data type, operators, and functions backed by the Jansson JSON library.
jsonpathFUNCCUnknownWrapper of JavaScript JSONPath implementation for PostgreSQL
modeshape_bsonFUNCCApache-2.0PostgreSQL extension to convert ModeShape BSON to and from JSON
pg_histSTATCGPL-2.0N-D histograms in PostgreSQL
pg_idmADMINSQLGPL-3.0Lightweight PostgreSQL extension for DML-like role management
pg_sipFUNCCISCSIP processing functions for PostgreSQL
pg_slugifyFUNCSQLUnknownSQL slugify function using unaccent
pg_string_extensionFUNCCUnknownString helper functions for PostgreSQL
pghllFEATCMITProvides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters.
pglogical_output_nzhooksETLCUnknownpglogical output plugin row-filter hook example for PostgreSQL logical replication
newsfeedsFUNCSQLGPL-2.0PostgreSQL extension for gathering news
pg_niceUTILCMITmoep
pg_outriderADMINCUnknownDynamically launches a background worker that extends a relation when free space drops below a configured watermark.
pg_plsql_graphsFUNCCUnknownCollects PL/pgSQL execution graph data and can export DOT, GraphML, and GML files.
pgintegritySECCUnknownTrigger-based row integrity watermark checker for PostgreSQL tables
pgmockUTILSQLMITSQL/PLpgSQL extension for mocking function and table dependencies in PostgreSQL unit tests
pg_taFUNCCBSD 2-ClauseTA-Lib technical-analysis functions exposed as PostgreSQL functions
pgorafuncSIMCAGPL-3.0Oracle compatibility functions and packages for PostgreSQL
pgpartsOLAPSQLBSD 3-ClauseSQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers
pslFUNCCPostgreSQLCanonicalize hostnames using the Public Suffix List
pgrgraphicFUNCSQLUnknownPostgreSQL PL/R graphing extension that generates image files from database data.
pgrollupOLAPCUnknowncreate rollup tables for fast aggregate queries
vihashFUNCCPostgreSQLversion-independent hash functions
wikiUTILSQLPostgreSQLSQL wiki
pgxsdETLCUnknownPostgreSQL extension; upstream metadata did not provide a specific description.
pgzintFUNCCMITZint Barcode Library for PostgreSQL
scriptsUTILSQLUnknownPhaseZero aftermarket schema, table, index, and constraint setup scripts packaged as a PostgreSQL extension.
pjpgUTILSQLMITGeneral-purpose utilities
pg_udpETLCUnknownUDP tool
pg_variant_functionsFUNCCPostgreSQLVariant summary and allele-frequency functions over TINYINT[] genotype arrays
pg_vartypeTYPECUnknownMultiple scalar types in a single column
pgautFEATSQLPostgreSQLAuto Update Timestamp for PostgreSQL
pgcatETLCApache-2.0Enhanced logical replication extension for per-table subscriptions, table mapping, and replica-identity tracking.
pgcodec7FUNCCUnknownC extension that encodes and decodes bytea values using compact 7-bit or 6-bit text grouping.
eigenTYPEC++MITNew array types and linear-algebra functions based on the Eigen numerical template library.
pgeyesADMINSQLMITPL/pgSQL administrative helper extension with a pgeyes() environment check and foreign_db metadata table.
myhelperUTILSQLUnknownCollection of PostgreSQL helper functions
plmrubyLANGC++UnknownPL/MRuby procedural language
plotpgFUNCCPostgreSQLfunctions to plot result sets with gnuplot
omnidb_plpgsql_debuggerLANGCMITPostgreSQL extension for enabling PL/pgSQL debugger in OmniDB
plsh_mtbADMINSQLPostgreSQLmulti-tenant backup based on PL/SH and Korn Shell
forbid_truncateSECCPostgreSQLPreload hook extension that rejects TRUNCATE commands.
migrationADMINSQLBSD 0-ClauseDatabase Migrations: Configure and Run
zlibFUNCCUnknownzlib decompress function for PostgreSQL.
pg_thudUTILSQLPostgreSQLFramework extending pgtap with scaffolding and test-data helpers for database unit tests.
gdpr_anatomizerSECPythonUnknownPrototype GDPR/anatomy anonymization extension implemented with PL/Python and PL/pgSQL helpers.
pscanUTILCUnknownTest tool for PostgreSQL parallel heap scan methods
putpostlogicETLCUnknownLogical decoding output plugin that streams JSON changes to Kafka or Nanomsg
randomstringFUNCCUnknownRandom text and bytea generator functions
redis_linkFDWCBSD 2-ClausePostgreSQL foreign data wrapper for Redis.
replace_empty_stringFUNCCBSD 2-ClauseTrigger function that replaces empty strings with NULL values.
rpgFUNCSQLUnknownR-inspired PL/pgSQL data manipulation functions.
rpg_base36LANGRustMITbase36_encode in rust
scrubADMINCPostgreSQLPerforms background data consistency checks for PostgreSQL heaps, indexes, TOAST data, and checksums.
session_variablesADMINSQLPostgreSQLFunctions to manipulate (get/set) session variables
shbfTYPECUnknowntype for shifting-bloom-filter
srfFUNCCUnknownset returning function test
tcn_jsonTYPECUnknownTriggered change notifications
pgsql_rruleFUNCSQLPostgreSQLRRULE expansion in SQL
pgstrtranslateFUNCCUnknownstring translation interface
pgsynckUTILCPostgreSQLRun SQL text through the PostgreSQL parser and return syntax error information
pgtt_rslUTILCPostgreSQLOracle or DB2 style Global Temporary Tables based on unlogged table, Row Security Level and views
unnest_ordinalityFUNCCPostgreSQLunnest function with ordinality
utinyintTYPECPostgreSQL1 byte integer data type
vacuum_utilsADMINSQLPostgreSQLto get information and execute statement about VACUUM and ANALYZE on tables
x5fixADMINCUnknownGreenplum persistent filespace node repair helper function.
yetiFUNCCUnknownhelper functions for YETI project
cmathFUNCCGPL-3.0C11 math functions exposed to PostgreSQL with C-backed implementations.
pltoolboxFUNCCBSD 2-ClauseFunctions for use from PostgreSQL stored procedures
pmppUTILSQLPostgreSQLPoor Man's Parallel Processing for PostgreSQL
postbisTYPECPostgreSQLPostgreSQL BioInformationSystem sequence types and functions
tm_postgres_basicsFUNCSQLMITbasic functions
translate_isbnFUNCCUnknowntranslate ISBN codes between ISBN13 and ISBN10 formats
trunkfingerprintSTATSQLPostgreSQLCalculates a fingerprint of the database structure, and of the data if requested
uniphantUTILSQLMITPostgreSQL extension; upstream metadata did not provide a specific description.
pg_timelordTIMECPostgreSQLProof-of-concept PostgreSQL extension for time-travel querying using commit timestamps.
pg_timeoutADMINCPostgreSQLPostgreSQL background-worker extension for terminating idle database sessions.
clerk_fdwFDWRustPostgreSQLForeign data wrapper for querying the Clerk user-management API from PostgreSQL.
lantern_extrasRAGRustAGPL-3.0Convenience functions for working with vector embeddings
pg_branchADMINRustMITPostgreSQL extension for quickly creating copies of databases and clusters.
pgfdbOLAPRustAGPL-3.0Experimental pgrx extension that stores PostgreSQL table and index data in FoundationDB for distributed, fault-tolerant, horizontally scalable operation.
pg_sqidsETLRustMITPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
pgprologLANGRustBSD 3-ClausePostgreSQL procedural language handler for Prolog, embedding Scryer Prolog.
upid_pgETLRustMITPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
pg_primalETLRustMITPrimal database extension used by the Primal Nostr cache server.
eva_pgSECRustCommercialEVA ICS pgrx extension for the EVA industrial IoT platform.
prometheus_fdwFDWRustPostgreSQLPostgres foreign data wrapper for querying Prometheus metrics.
pg_ferroidTYPERustMITPostgreSQL ULID type and generation functions backed by ferroid
goldenmatch_pgUTILRustMITGoldenMatch entity-resolution functions for deduplication, matching, scoring, and golden-record workflows.
pg_pgbouncerADMINRustMITRuns and controls PgBouncer from PostgreSQL through a shared-preload pgrx extension.
jsonschemaADMINRustMITJSON Schema (draft 2020-12, draft 2019-09, draft-7, draft-6, draft-4) Validation
pgnatsETLRustMITNATS messaging integration with publish, subscribe, JetStream, key-value, and object store SQL APIs
lanceFDWRustApache-2.0PostgreSQL FDW extension for reading and querying Lance format tables
pgpuOLAPRustAGPL-3.0GPU acceleration for PostgreSQL vector index builds using NVIDIA CUDA/cuVS and VectorChord.
pg_kalamFDWRustApache-2.0KalamDB PostgreSQL extension and FDW callback layer for SQL access to KalamDB.
vectorsRAGRustApache-2.0Vector database plugin for PostgreSQL, written in Rust, specifically designed for LLM
plrustLANGRustPostgreSQLA Trusted Rust procedural language for PostgreSQL
pg_ibc_0_1FEATRustUnknownpg_ibc_0_1: Created by pgrx
pgslothETLRustUnknownPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
pgzanETLRustUnknownPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
orb_fdwFDWRustPostgreSQLA foreign data wrapper for Orb
pg_stat_sysinfoSTATRustMITCreated by the PostgresML team
mumakFTSRustApache-2.0Cardano CBOR parser
pg_chainsyncETLRustMITAccess blockchain blocks, events, and tasks directly inside PostgreSQL using background workers.
cas_codesTYPERustGPL-3.0CAS Registry Number data type and validation support for PostgreSQL.
elementsTYPERustGPL-3.0Chemical elements and isotope metadata exposed as PostgreSQL enum types through pgrx.
iso_codesTYPERustGPL-3.0ISO country code enum/data types for PostgreSQL, generated with pgrx.
media_typesTYPERustGPL-3.0PostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
molecular_formulasETLRustGPL-3.0PostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
pgrx_validationETLRustGPL-3.0PostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
pgjwt_rsSECRustMITJWT verification for RS256 and Ed25519 tokens inside PostgreSQL
quriaRAGRustApache-2.0pgrx extension for BM25 full-text search and HNSW vector search
pg_subxact_countersSTATCPostgreSQLGlobal counters for PostgreSQL subtransaction activity
pg_bigmrFTSRustPostgreSQLtext similarity measurement and index searching based on bigrams
pg_debug_scanSTATRustApache-2.0Debug PostgreSQL table scans with custom MVCC snapshot definitions.
postgreChainETLRustMITpgrx extension for querying Solana blockchain data from PostgreSQL
pgmer2OLAPRustMITPostgreSQL connector for the MeritRank graph ranking service
pg_no_seqscanSTATRustMITPrevents or reports sequential scans in development and CI by inspecting query plans.
pgteraETLRustMITRender HTML templates in PostgreSQL using Tera
oidc_validatorSECRustUnknownPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
postileGISRustMITPostgreSQL extension with map tile generation and compression helper functions.
pgfakerFUNCRustMITGenerates fake company, person, internet, and phone data in PostgreSQL for tests, performance testing, and demos.
fmodel_rust_postgresFUNCRustApache-2.0Run f{model} event-sourced domain models inside PostgreSQL as a pgrx extension.
accumulo_access_pgSECRustMITPostgreSQL extension for parsing and evaluating Accumulo Access Expressions.
pg_ethopicFUNCRustMITFormat Ethiopic dates and numbers in PostgreSQL.
pg_extensionFEATRustUnknownIn-database model slicing and inference helper functions for structured data analytics.
rppdFUNCRustGPL-3.0RPPD PostgreSQL Trigger Extension
pg_multitenantSECRustMITMulti-tenant shared-schema helpers using PostgreSQL row-level security
kilobaseETLRustUnknownPostgreSQL extension; upstream metadata did not provide a specific description.
symbiotic_pythonETLRustApache-2.0PostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
pg_idnaUTILRustMITWHATWG URL IDNA helpers for PostgreSQL
pgextmgrADMINRustMITpgrx extension manager and hook framework for registering, ordering, enabling, and disabling PostgreSQL extension plugins.
pgx_show_hooksADMINRustMITCreated by pgx
pgx_trace_hooksSTATRustMITCreated by pgx
pg_bedtools_rsUTILRustMITA PostgreSQL plugin for bedtools, implemented in Rust.
postgres_icalTYPERustUnknownpgrx extension for parsing RFC 5545 iCalendar data and URLs from PostgreSQL
pg_chainutilsUTILRustMITBlockchain utility types and functions for PostgreSQL, built with pgrx.
pg_tamperlogSECSQLMITTamper-evident append-only audit logging with hash chaining
pg_tamperlog_rustSECRustMITRust pgrx helper extension for pg_tamperlog fast SHA-256 hash-chain calculations.
supamonitorSTATRustUnknownPostgreSQL extension; upstream metadata did not provide a specific description.
pg_knowledge_graphRAGRustMITKnowledge graph extension for PostgreSQL with graph algorithms and pgvector integration.
wrapper_deltalakeFDWRustApache-2.0Postgres Foreign Data Wrapper for Delta Lake written in Rust.
pg_strFUNCRustMITCreated by pgx
flameRAGRustAGPL-3.0PGRX proof-of-concept extension that generates text embeddings with fastembed/MiniLM.
pg_tpchOLAPRustMITTPC-H table creation, data loading, and query metadata for PostgreSQL
pgauthzSECRustApache-2.0Authz - Zanzibar-style authorization as a PostgreSQL extension
hammingSIMRustUnknownHamming-distance operators and an experimental IVF index access method for bytea binary hashes.
kq_cxFEATRustUnknownketteQ, Inc.
kq_fxFEATRustApache-2.0ketteQ, Inc.
cologne_pgFUNCRustMITCologne phonetics function for PostgreSQL built with pgrx.
pg_bech32FUNCRustUnknownAdds Bech32, Bech32m, and no-checksum Bech32 encoding/decoding support to PostgreSQL.
pg_lakehouseOLAPRustAGPL-3.0An analytical query engine for PostgreSQL
db721_fdwFDWRustUnknownRust/pgrx foreign data wrapper for db721 files, developed for CMU 15-721 project data.
bfnUTILRustUnknownRust/pgrx utility extension with UUID, date, string, JSON/address, and validation helper functions.
redis_backed_storageFEATRustUnknownExperimental PostgreSQL table access method backed by Redis storage.
pg_logfmtETLRustMITParse logfmt strings into JSONB and key sets
pg_bm25FTSRustAGPL-3.0Full text search for PostgreSQL using BM25
pg_data_retentionADMINRustMITPostgreSQL background-worker extension that applies table data retention policies.
pg_open_meteoFUNCRustUnknownRust/pgrx PostgreSQL extension for open-meteo.com; current generated SQL exposes small helper functions.
pgx_uuidv7TYPERustMITA PostgreSQL extension to generate and cast v7 UUIDs
malwaredb_pgETLRustApache-2.0PostgreSQL extension for MalwareDB similarity functions: SSDeep, LZJD, and TLSH
pg_ecdsa_verifySECRustMITECDSA signature verification functions for PostgreSQL.
pg_spladeETLRustUnknownPostgreSQL extension; upstream metadata did not provide a specific description.
pgzstd_rsETLRustMITPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
hypostatsSTATRustMITDump and load pg_statistic rows as JSON for statistics experiments.
postgrethETLRustUnknownPostgreSQL extension enabling Ethereum ABI datatypes and log decoding in SQL.
postgres_redisETLRustMITpgrx background worker extension for syncing PostgreSQL table values to Redis
utilsFUNCCMITExt for PG
postgridsETLRustMITPostgreSQL extension for British and Irish national grid reference conversions.
pgfirestoreFEATRustUnknownImplements Firestore-style document values, collection queries, and query operators inside PostgreSQL.
replace_stringETLRustUnknownRust/pgrx function for regex-based string replacement.
optimFUNCRustUnknownPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
ulidTYPERustMITulid type and methods
conda_pgsql_rust_extTYPERustMITConda version data type and helpers for PostgreSQL, implemented with pgrx and rattler_conda_types.
condaversionTYPEC++MITConda package version number data type implemented as a C++ PostgreSQL extension.
pg_condaTYPERustMITPostgreSQL extension adding conda ecosystem version types, aggregates, and functions.
tree_similarity_extensionSIMRustBSD 0-ClauseCreated by lukas.moravec.st2@vsb.cz
pg_ivfflatRAGRustUnknownExperimental pgrx extension providing a Vector type and an in-memory IVFFlat index access method.
pg_temporalTIMERustUnknownPostgreSQL extension adding Temporal ZonedDateTime support.
prometheusfdwFDWRustUnknownPostgres extension to fetch data from Prometheus through a foreign data wrapper.
pg_jalali_calendarTIMERustUnknownJalali/Persian calendar date conversion and helper functions for PostgreSQL.
pgcuid2FUNCRustMITGenerate CUID2 text identifiers inside PostgreSQL using the cuid2 Rust crate.
pg_sysloadSTATRustUnknownExpose Linux system load averages from PostgreSQL
pg_viewctlUTILRustUnknownView dependency management and safe schema evolution utilities
morpheme_funcsETLRustUnknownPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
pg_zen_engineFUNCRustApache-2.0Evaluate JSON Decision Model graphs on PostgreSQL JSONB inputs
pg_tviewsFEATRustMITTransactional materialized views with automatic incremental refresh for PostgreSQL
pg_row_hashesFUNCRustUnknownCalculate row-data fingerprints and checksums in PostgreSQL.
rtilesGISRustApache-2.0PostgreSQL extension written in Rust for serving vector tiles in MVT format for self-hosted interactive maps.
all_in_one_libUTILRustApache-2.0Rust/pgrx utility extension with encryption helpers and a sample FDW wrapper.
pgrx_jsonbTYPERustMITPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
pghexGISRustUnknownAdds a hexagonal-grid coordinate type with tile arithmetic, neighbor, range, line-drawing, and distance functions.
pg_snowflake_idFUNCRustMITSnowflake-style 64-bit ID generator for PostgreSQL implemented with pgrx
pg_graphql_serverFEATRustUnknownThis extension lets you run a GraphQL server directly in postgres
bgworker_segfaultADMINRustUnknownMinimal Rust/pgrx background-worker crash reproducer for max_worker_processes exhaustion.
pgrandFUNCRustUnknownRandom table data generator for PostgreSQL, built with pgrx.
bloom_fulonFEATRustUnknownExperimental pgrx index access method for PostgreSQL, created for learning purposes.
ebs_fdwFDWRustUnknownRust/pgrx foreign data wrapper for listing AWS EBS volumes through PostgreSQL.
pgniceADMINRustMPL-2.0Manage PostgreSQL backend process priorities and resource limits.
varlena_alignmentUTILRustUnknownpgrx test extension documenting varlena alignment behavior in pgrx set_varsize helpers.
pg_snowidFUNCRustMITGenerate Snowflake-like IDs with speed and thread-safety in PostgreSQL
pglasETLRustLGPL-2.1Reads LAS 2.0 well logging files from PostgreSQL functions
pgmer1OLAPRustMITMeritRank HTTP connector exposing graph ranking service calls in SQL
ped25519SECRustMITpgrx-ed25519: Created by pgrx
visualizing_aggregatesFUNCRustUnknownPostgreSQL extension for visualizing aggregates with pgrx functions that generate graph output.
pg_elephantduckOLAPRustMITColumnar PostgreSQL table access method powered by DuckDB and Parquet storage.
pg_ffmpegFUNCRustMITFFmpeg media processing functions for PostgreSQL
pksuidFUNCRustUnknownpostgresql plugin for generating prefixed ksuids
sql_sagaTIMECMITSql Saga - Valid Time Temporal Tables - API for working with valid time with support for foreign keys.
sql_saga_nativeTIMERustMITsql_saga native Rust functions for temporal_merge planning
date_string_converterTIMERustUnknownpgrx extension skeleton for date-string conversion; current source exposes hello_date_string_converter().
pg_s2GISRustMITS2 CellID type and geospatial indexing functions for PostgreSQL
hessra_authzSECRustApache-2.0Biscuit-token authorization helpers plus key and service-chain management inside PostgreSQL.
phone_numberETLRustUnknownPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
sixqlETLRustISCPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description.
pg_dagdbETLRustGPL-3.0PostgreSQL SQL client extension for the DagDB graph engine daemon.
a5pgGISRustApache-2.0Equal-area A5 spatial index functions for PostgreSQL.
accountSECSQLUnknownAdd Teams and permissions to Supabase.
ai_toolkitFUNCC++UnknownAI-powered query generation and explanation tools for PostgreSQL.
aiven_extrasSECCApache-2.0Aiven PostgreSQL extras for non-superuser access to selected database features.
alloydb_scannRAGCCommercialAlloyDB ScaNN extension for approximate nearest-neighbor vector indexes.
apg_plan_mgmtSTATCCommercialAmazon Aurora PostgreSQL Query Plan Management extension for managed plan baselines.
apgccSTATCCommercialNo-longer-supported internal RDS/Aurora PostgreSQL extension listed for older Aurora PostgreSQL 9.6 releases.
apgunitADMINCCommercialNo-longer-supported internal RDS/Aurora PostgreSQL extension listed for older Aurora PostgreSQL 9.6 releases.
aurora_stat_utilsSTATCCommercialAurora PostgreSQL statistics utility functions for wait-event reporting.
auth0SECSQLGPL-3.0Auth0 Management API client for PostgreSQL.
avocadoRAGRustMITAvocadoDB PostgreSQL extension for deterministic context compilation for AI agents.
aws_commonsFUNCSQLCommercialCommon helper objects used by Amazon RDS/Aurora PostgreSQL AWS extensions.
aws_lambdaFUNCCCommercialAmazon RDS for PostgreSQL extension for invoking AWS Lambda functions from SQL.
aws_mlRAGCCommercialAmazon Aurora PostgreSQL extension for invoking Amazon Comprehend, SageMaker AI, and Bedrock services from SQL.
azure_aiRAGCCommercialAzure Database for PostgreSQL extension for in-database calls to Azure AI, Azure OpenAI, Cognitive Services, and Azure Machine Learning.
azure_storageETLCCommercialAzure Database for PostgreSQL extension for importing from and exporting to Azure Storage blobs from SQL.
badappleUTILCUnknownPlay "Bad Apple!!" in the psql client.
basejump_coreFEATSQLMITBasejump adds accounts, teams, permissions and billing to Supabase.
bktreeFTSCUnknownSP-GiST BK-tree index extension for 64-bit perceptual hashes and Hamming-distance searches.
brainfuckLANGSQLApache-2.0Run Brainfuck programs inside PostgreSQL using a PLV8 trusted language extension.
buffercache_toolsFUNCCUnknownInspect and manipulate PostgreSQL buffer cache entries for relations, forks, databases, and tablespaces.
cat_hook_delete_claimsSECSQLUnknownSupabase Auth custom access token hook for deleting token claims
chessFUNCCUnknownSAN and FEN chess notation data types and functions for PostgreSQL
clickhouse_fdwFDWC++Apache-2.0ClickHouse foreign data wrapper for PostgreSQL
cos_fdwFDWCCommercialForeign data wrapper for accessing Tencent Cloud COS object storage from PostgreSQL
countriesTYPESQLUnknownCreates a countries table containing countries of the world
csv_tamFEATCUnknownCSV table access method for PostgreSQL that stores table tuples in CSV-formatted relation files.
custom_propertiesADMINSQLUnknownSupabase RLS helper tables and functions for managing user properties and custom claims.
custom_rolesADMINSQLUnknownRole-specific Supabase RLS tables and functions for managing user roles.
dbdevADMINSQLApache-2.0In-database client for installing packages from the database.dev registry.
ddl_versioningADMINSQLGPL-3.0DDL object versioning with event triggers for tables, indexes, functions, and views.
dynamodb_fdwFDWCPostgreSQLForeign data wrapper for querying and modifying Amazon DynamoDB tables from PostgreSQL.
eidos_oauthSECRustCommercialOAuth 2.0 JWT validator for PostgreSQL 18 using the OAuth validator API.
email_guardSECSQLUnknownSupabase Auth signup guard that blocks disposable email domains and normalizes Gmail addresses.
embeddingRAGCApache-2.0HNSW vector similarity search extension for PostgreSQL real[] embeddings.
embedding_searchRAGSQLUnknownLangChain/Supabase helper package for storing and searching document embeddings with pgvector.
encdbSECCCommercialAlibaba Cloud RDS extension that provides Always Confidential Database features for PostgreSQL.
encdb_btreeSECCCommercialAlibaba Cloud RDS extension that accelerates ciphertext index queries for Always Confidential Databases.
eqlSECSQLMITEncrypt Query Language provides PostgreSQL types, functions, operators, and index support for searchable encrypted data.
external_search_fdwFDWCCommercialAlloyDB extension that provides a read-only foreign data wrapper for querying Elasticsearch data from PostgreSQL.
flow_controlADMINCCommercialAmazon RDS for PostgreSQL extension that throttles writes in Multi-AZ DB clusters to reduce replica lag.
fsm_coreFEATRustMITFinite state machine framework for modeling stateful workflows inside PostgreSQL.
ganos_address_standardizerGISCCommercialA placename standardization extension based on the PAGC standard.
ganos_address_standardizer_data_usGISDataCommercialA placename standardization (United States) data extension based on the PAGC standard.
ganos_geometryGISCCommercialProvides computing and analysis features for spatial geometry types.
ganos_geometry_pyramidGISCCommercialUsed for fast display of 2D spatial geometry big data.
ganos_geometry_sfcgalGISCCommercialProvides extension features for the spatial geometry SFCGAL plugin.
ganos_geometry_topologyGISCCommercialGanos geometry topology spatial types and functions extension for PostgreSQL.
ganos_geomgridGISCCommercialProvides grid partitioning, encoding, indexing, and analysis capabilities for H3, GeoSOT, and other grid systems.
ganos_networkingGISCCommercialProvides computing and analysis features for spatial geometry network types.
ganos_pointcloudGISCCommercialProvides storage, computing, and analysis features for point clouds.
ganos_pointcloud_geometryGISCCommercialProvides storage, computing, and analysis features for point clouds.
ganos_rasterGISCCommercialProvides storage, computing, and analysis features for spatial raster data.
ganos_spatialrefGISDataCommercialProvides computing and analysis features for spatial references.
ganos_tiger_geocoderGISCCommercialGanos tiger geocoder and reverse geocoder with support for USCB TIGER data.
ganos_trajectoryGISCCommercialGanosBase moving object (MOD) trajectory data computing and analysis features.
generic_planSTATSQLPostgreSQLGenerate a generic plan for a parameterized SQL statement.
gitgresRAGCMITStore Git objects and refs in PostgreSQL tables with SQL functions and a native git_oid type.
google_columnar_engineOLAPCCommercialAlloyDB columnar engine extension for accelerating HTAP and OLAP analytical workloads.
google_db_advisorADMINCCommercialAlloyDB index advisor extension for workload analysis and index recommendations.
google_ml_integrationRAGCCommercialGoogle Cloud machine learning integration extension for registering model endpoints, generating embeddings, and invoking predictions from SQL.
google_plan_managementADMINCCommercialAlloyDB query plan management extension for tracking, approving, and stabilizing query plans.
graph_accelFEATRustApache-2.0In-memory graph traversal acceleration extension for Apache AGE.
gsheetsETLCMITRead and write Google Sheets from PostgreSQL.
htcFUNCCMPL-2.0Horvitz-Thompson continuous-population estimator functions for PostgreSQL.
hybrid_searchRAGSQLUnknownHybrid pgvector and full-text search helper functions for LangChain and Supabase.
hyperspaceTYPECUnknownFour-dimensional point, box, and circle data types with operators and SP-GiST indexing.
index_adviserFEATCCommercialAlibaba Cloud RDS extension that provides index recommendations.
jalali_utilsTIMECUnknownConvert Gregorian dates and timestamps to Jalali calendar values
json_schema_validateTYPECPostgreSQLValidate JSON and JSONB data against JSON Schema in PostgreSQL
jsonb_deep_sumTYPECMITRecursively sum numeric fields in JSONB objects
jsonb_plpythonuLANGCUnknownTransform between JSONB and PL/PythonU values
jusquciFTSCGPL-3.0jusquhui -- text search parser for contemporary french
keyhippoSECSQLMITRLS-compatible API keys for PostgreSQL
londisteETLSQLISCLondiste replication support code
mogipixGISRustUnknownPostgreSQL extension exposing HEALPix and MOC Rust functions to SQL.
mv_statsSTATSQLUnknownTracks creation, alteration, refresh, and reset statistics for materialized views.
natord_pgFUNCRustMITNatural-order comparison operators and btree operator class for PostgreSQL text values.
neonSTATCApache-2.0Neon-specific statistics and Local File Cache metrics for Neon Postgres computes.
neon_utilsSTATCCommercialMonitor Neon Autoscaling compute allocation with num_cpus().
neurondbRAGCCommercialAI database extension for vector search, ML inference, hybrid search, and RAG in PostgreSQL.
nextgres_idcpADMINCCommercialNEXTGRES in-database connection pool extension for PostgreSQL.
nfiestaFUNCSQLMPL-2.0PostgreSQL extension implementing nFIESTA forest inventory estimation functionality.
nfiesta_sdesignFUNCSQLMPL-2.0PostgreSQL extension for manipulating sampling design data.
nonomsUTILSQLUnknownNo English description available.
obs_fdwFDWCCommercialHuawei Cloud OBS foreign data wrapper extension listed for RDS PostgreSQL.
ollamaRAGSQLMITOllama client for PostgreSQL
online_advisorFEATCPostgreSQLOnline index advisor for PostgreSQL workload-based index, statistics, and prepared statement recommendations.
orochiOLAPCUnknownModern HTAP PostgreSQL extension for sharding, time-series, columnar analytics, tiered storage, and vector workloads.
oss_fdwFDWCCommercialAlibaba Cloud OSS foreign data wrapper for reading and writing OSS objects from PostgreSQL-compatible managed services.
parquet_s3_fdwFDWCPostgreSQLForeign data wrapper for accessing Parquet files on local filesystems and Amazon S3 from PostgreSQL.
paseRAGCUnknownPostgreSQL ultra-high dimensional approximate nearest neighbor search extension.
pg_ad_mappingSECCCommercialMaps Active Directory security groups to database roles on Aurora PostgreSQL.
pg_addressTYPESQLUnknownExtension creates composite type to store address
pg_admADMINSQLGPL-3.0A PostgreSQL extension providing some administrative tools.
pg_bleveFTSCAGPL-3.0PostgreSQL extension for Bleve search integration
pg_cld2LANGCMITcld2 language detection function for Postgres
pg_columnmaskSECCCommercialDynamic data masking extension for Amazon Aurora PostgreSQL
pg_concurrency_controlSECCCommercialConcurrency control plug-in for Alibaba Cloud ApsaraDB RDS PostgreSQL
pg_consulUTILC++UnknownPostgreSQL API for consul
pg_diffixSECCMITOpen Diffix PostgreSQL extension
pg_diskannRAGCCommercialProvider-documented PostgreSQL extension: pg_diskann
pg_dphypTYPECMITDynamic programming join enumeration algorithm based on hypergraphs for PostgreSQL.
pg_ducklakeOLAPC++MITMinimal pg_duckdb + DuckLake bridge extension
pg_duckpipeETLRustMITCDC synchronization from heap tables to DuckLake columnar tables
pg_emdSIMRustUnknownFast approximate Earth Mover's Distance using dynamic tree embeddings
pg_enquoSECRustMITPostgreSQL extension for encrypted query operations
pg_ethiopian_calendarTIMECPostgreSQLConvert between Gregorian and Ethiopian calendar dates
pg_flashbackADMINRustUnknownpg_flashback: Created by pgrx
pg_followerETLCUnknownCapture changes and follow
pg_force_unlogged_create_tableADMINCUnknownforce CREATE TABLE to create UNLOGGED tables
pg_fusionFEATRustBSD 2-ClauseNo English description available.
pg_gitUTILSQLPostgreSQLPostgreSQL-native Git implementation.
pg_headerkitFUNCSQLISCPostgreSQL SQL functions for reading PostgREST request headers inside database code
pg_hspellFTSCMPL-2.0Full text search dictionary template for Hebrew text using libhspell
pg_icalTYPECMITRRULE recurrence functions for PostgreSQL backed by libical
pg_isolateADMINCMITAssign PostgreSQL backends to Linux cgroups for resource isolation
pg_json_diffETLC++MITJSONB diff, JSON Patch, and merge-patch functions for PostgreSQL
pg_ledgerFEATRustCommercialDouble-entry accounting engine for PostgreSQL
pg_lexoTYPERustMITLexicographic ordering type and helper functions for PostgreSQL.
pg_llmRAGC++UnknownPostgreSQL extension for LLM integration with model management, chat, text-to-SQL, and vector-backed knowledge features.
pg_llm_helperRAGCPostgreSQLCapture PostgreSQL errors for LLM-assisted troubleshooting.
pg_nanoidTYPERustUnknownPostgreSQL extension adding a NanoID type and NanoID generation functions.
pg_neon_sudoSECCUnknownTrusted sudo helper functions for starting and stopping PostgreSQL Anonymizer dynamic masking.
pg_onceUTILSQLMITRun-once / idempotency-key manager with TTL and response caching
pg_onnxRAGC++MITONNX Runtime integrated with PostgreSQL. Perform ML inference with data in your database.
pg_openccFUNCCApache-2.0OpenCC extension for PostgreSQL
pg_opendalETLRustApache-2.0Access storage backends through Apache OpenDAL from PostgreSQL functions.
pg_ortoolsFUNCRustCommercialConstraint optimization extension using the HiGHS MIP/LP solver from PostgreSQL, with optional async execution.
pg_osgrGISSQLUnknownOrdnance Survey grid reference handling for biological recording
pg_pageindexFTSCMITPageIndex: hierarchical document structure and tree search (Go bridge)
pg_probTYPERustCommercialProbabilistic data types for PostgreSQL - Monte Carlo simulation in SQL
pg_protect_columnsSECSQLUnknownA set of postgres functions that allow you to protect columns that should not be updated.
pg_py_plan_forwardingLANGCBSD 3-Clauseextension forward PostgreSQL plan to Python for modification and return it back
pg_recyclebinADMINRustMITPostgreSQL Flashback Extension
pg_registryFEATRustCommercialSchema registry for PostgreSQL extensions with JSON Schema support
pg_rippleFEATRustApache-2.0High-performance RDF triple store with SPARQL 1.1, SHACL, Datalog, HTAP, federation, and Datalog-native PageRank (v0.99.1)
pg_roastADMINCPostgreSQLAudits your database and harshly judges what it finds
pg_sageADMINCAGPL-3.0pg_sage - Agentic Postgres DBA
pg_session_traceSTATCMITSession tracing extension for SQL statements, bind variables, execution plans, and timing metrics.
pg_sexpTYPECApache-2.0S-expression data type for PostgreSQL, similar to jsonb but for Lisp-like s-expressions.
pg_sorted_heapOLAPCPostgreSQLSorted heap table AM with zone map scan pruning for PostgreSQL
pg_stat_errorSTATCCommercialTencentDB supported extension
pg_stat_logSTATCCommercialProvider-documented PostgreSQL extension: pg_stat_log
pg_stat_plansSTATCPostgreSQLLow-overhead tracking of aggregate plan statistics and example EXPLAIN texts in PostgreSQL.
pg_statvizTIMESQLPostgreSQLstats visualization and time series analysis
pg_streamingETLRustCommercialDeclarative stream processing engine inside PostgreSQL
pg_substraitOLAPRustPostgreSQLExecute Substrait query plans in PostgreSQL
pg_synthesize_walADMINCPostgreSQLGenerate PostgreSQL WAL records of various sizes
pg_testgenFUNCCUnknownGenerate random test data for PostgreSQL
pg_timersTIMECPostgreSQLSchedule SQL execution at exact times or after intervals in PostgreSQL
pg_transportETLCCommercialAmazon RDS extension for transportable PostgreSQL database workflows.
pg_typescriptLANGRustMITpg_typescript: TypeScript/JavaScript procedural language for PostgreSQL
pg_walrusADMINRustPostgreSQLAutomatic max_wal_size tuning based on checkpoint activity
pgafisSIMCGPL-2.0AFIS Support for PostgreSQL
pgchy_similaritySIMPythonMITChemical structure similarity functions for PostgreSQL using Chython and PL/Python.
pgclawTYPERustMITpgrx extension that adds a claw data type and background worker for binding LLM/OpenClaw agents to PostgreSQL rows.
pgdamADMINCCommercialAWS Aurora PostgreSQL provider extension listed as pgdam version 1.7 for Aurora PostgreSQL 16 and 17.
pgdisablelogerrorADMINCPostgreSQLC extension that suppresses selected SQLSTATE error codes from the PostgreSQL server log.
pgdlRAGC++UnknownPostgreSQL extension for deep learning model inference and vector storage inside the database.
pgduck_rsOLAPRustUnknownpgrx prototype extension that uses DuckDB to read Parquet files and return rows as JSONB in PostgreSQL.
pgedge_vectorizerRAGCPostgreSQLAsynchronous text chunking and embedding generation for PostgreSQL using background workers and pgvector.
pgexporter_extSTATCBSD 3-ClauseExpose additional operating-system and host metrics for pgexporter.
pgfr_analyzeSTATSQLUnknownReporting, anomaly detection, incident forensics, and capacity-planning functions for pgfr_record.
pgfr_controlADMINSQLUnknownVacuum diagnostics, autovacuum scale-factor recommendations, and table bloat analysis for pgfr_record.
pgfr_recordSTATSQLUnknownServer-side flight recorder for PostgreSQL performance monitoring and incident forensics.
pgfsUTILRustMITPostgreSQL extension for copying files on the server filesystem through SQL.
pginstallADMINCPostgreSQLPostgreSQL extension installer that hooks CREATE EXTENSION to fetch and install extension archives.
pgkvFEATSQLMITRedis-like key-value store for PostgreSQL using JSONB-backed PL/pgSQL functions.
pgmoljiFUNCRustUnknownpgrx extension that rewrites strings to random emoji strings.
pgmonitorSTATCApache-2.0PostgreSQL metrics extension for external collectors, with optional background worker maintenance.
pgotelSTATC++Apache-2.0PostgreSQL extension exposing OpenTelemetry functionality for other extensions.
pgq_nodeADMINSQLISCCascaded queue infrastructure
pgr_dmmsyGISCUnknownDMMSY deterministic directed single-source shortest path algorithm for pgRouting
pgtamFEATCUnknownTable access method extension example for PostgreSQL
plcoffeeLANGC++PostgreSQLCoffeeScript procedural language extension shipped with plv8
plidFUNCRustMITplid: Created by pgrx
pllsLANGC++PostgreSQLPL/LiveScript procedural language powered by V8, formerly provided by plv8.
postfgaSECCUnknownFine-Grained Authorization for PostgreSQL
postgres_web3TYPECUnknownA collection of optimized data types for web3 applications
postllmRAGRustMITpostllm: call OpenAI-compatible LLMs from PostgreSQL
postpicFEATCUnknownPostPic is an extension for the open source PostgreSQL dbms that enables image processing inside the database.
postrFUNCRustUnknownRuby-backed PostgreSQL functions built with pgrx
provenFUNCCUnknownFormally verified safety functions (math, validation, encoding) via libproven
quackRAGCApache-2.0DuckDB Embedded in Postgres
rds_activity_streamETLCCommercialAmazon Aurora PostgreSQL database activity stream extension
rds_aiRAGCCommercialAlibaba Cloud RDS PostgreSQL AI extension
rds_cclSECCCommercialAlibaba Cloud RDS PostgreSQL concurrent control/limit extension
rds_duckdbOLAPCCommercialAlibaba Cloud RDS PostgreSQL DuckDB integration extension
rds_embeddingRAGCCommercialProvider-documented PostgreSQL extension: rds_embedding
rds_encdbSECCCommercialNo English description available.
rds_hwdrs_ddlADMINCCommercialHuawei Cloud RDS supported PostgreSQL extension
rds_hwdrs_privsFUNCSQLCommercialHuawei Cloud RDS PostgreSQL privileges helper extension.
rds_online_ddlSECCCommercialOnline column type modification for schema evolution without business interruption
rds_online_migrateSECCCommercialAlibaba Cloud RDS PostgreSQL online migration extension.
rds_pg_sql_cclADMINCCommercialHuawei Cloud RDS PostgreSQL SQL concurrency control extension.
rds_server_handlerADMINCCommercialTencentDB for PostgreSQL server handler extension.
rds_tde_utilsSECSQLCommercialAlibaba Cloud RDS PostgreSQL transparent data encryption utility extension.
rds_toolsADMINCCommercialAWS RDS for PostgreSQL administrative tools extension.
rls_helpersFUNCSQLUnknownConvenience functions to help test and simulate RLS policies within the database.
rostgisGISRustMITA PostGIS-compatible PostgreSQL extension written in Rust.
rpcTYPECUnknownRPC client for PostgreSQL; send and receive JSON documents inside the database.
rule_engine_postgre_extensionsFUNCRustMITHigh-performance PostgreSQL rule engine with RETE algorithm (2-24x faster), time-travel debugging, 24 built-in functions, NATS JetStream, webhooks, and flexible execution modes (RETE/Forward Chaining)
ruvectorRAGRustMITSIMD-optimized vector similarity search extension with solver, math, TDA, and AI capabilities.
s3_ioETLRustUnknowns3_io: Created by pgrx
scheduleTIMECMITCron-formatted schedule type for PostgreSQL
scylla_fdwFDWCPostgreSQLForeign data wrapper for ScyllaDB
sgp4FUNCCMITSGP4 C implementation for PostgreSQL
short_idsFUNCSQLPostgreSQLExtension to generate short, textual, unique id strings
skitch-extension-verifyUTILSQLMITPostgreSQL verification utilities
softvisio_adminADMINSQLCommercialAdmin extension
starrocks_fdwFDWCCommercialTencentDB supported extension
statsmgrSTATCUnknownStatistics management for PostgreSQL
steampipe_postgres_awsFDWSQLUnknownThis README provides instructions on how to set up the Steampipe Postgres aws Foreign Data Wrapper (FDW) extension.
stopgapLANGRustMITRun TypeScript/JavaScript inside PostgreSQL with database-native deployment, activation, rollback, and path-based invocation workflows.
stringtheoryFUNCCPostgreSQLtools for comparing strings
stripeFDWPythonApache-2.0The official PostgreSQL extension for the Stripe API.
supa_auditTIMESQLApache-2.0The supa_audit PostgreSQL extension is a generic solution for tracking changes to tables' data over time.
supa_queueTIMESQLApache-2.0Simple Queue system for Postgres using pg cron & pg net
supabase_auth_apikeySECSQLUnknownSupabase Auth API key authentication helpers with role and permission checks.
synchdbETLJavaApache-2.0PostgreSQL extension for direct heterogeneous database replication into PostgreSQL.
tencentdb_aiRAGCCommercialTencentDB proprietary extension for calling large model APIs from PostgreSQL.
tencentdb_failover_slotETLCCommercialTencentDB proprietary extension for logical replication slot failover.
tencentdb_pwdcheckSECCCommercialTencentDB proprietary strong password authentication extension.
tencentdb_serverlessADMINCCommercialTencentDB proprietary extension for database-level CPU resource isolation/serverless mode.
tencentdb_sql_throttlingADMINCCommercialTencentDB proprietary extension for SQL throttling rules and concurrency control.
tencentdb_statSTATCCommercialTencentDB supported PostgreSQL extension
tencentdb_superuserADMINCCommercialTencentDB PostgreSQL privileged administration helper extension.
tencentdb_system_statSTATCCommercialTencentDB supported extension
tencentdb_wal_statSTATCCommercialProvider-documented PostgreSQL extension: tencentdb_wal_stat
texcallerUTILCMITNo English description available.
thai_parserFTSCGPL-2.0a Thai parser for full text search
tceSECRustPostgreSQLTransparent Column Encryption for PostgreSQL
timeitTIMECPostgreSQLmeasure runtime of built-in functions
timetravelTIMECCommercialProvider-documented PostgreSQL extension: timetravel
townTIMESQLMITmangae time-series data in postgres
tsearch2FTSCUnknownLegacy PostgreSQL full-text search extension listed by AWS RDS.
tsp_semantic_headlineRAGSQLGPL-3.0Phrase highlighting and improved semantics for ts_headline
uuid47TYPECMITuuid47 base type and helpers (v7 storage, v4 facade I/O)
valkey_fdwFDWCPostgreSQLForeign data wrapper for querying a Valkey server
varbitxTYPECCommercialAlibaba Cloud RDS bitmap function extension for additional varbit operations
vmagentfdwFDWRustApache-2.0vmagentfdw: Created by pgrx + alesharik
wasmLANGRustMITA Postgres extension to run WebAssembly binaries.
xtypesTYPECApache-2.0Convenience types for PostgreSQL
norasearchFTSCMITNoraSearch is a high-performance search engine for PostgreSQL.
pg_column_tetrisADMINSQLMITEnforce optimal column alignment to minimize row padding
pg_extension_baseUTILCApache-2.0Extension development kit by Snowflake
pg_extension_updaterTIMECApache-2.0Automatic extension updater
pg_lakeOLAPCApache-2.0Data lake extension by Snowflake
pg_lake_benchmarkOLAPCApache-2.0Benchmark for PgLake and Iceberg tables
pg_lake_copyETLCApache-2.0Copy to/from data lake files
pg_lake_engineOLAPCApache-2.0Query engine for data lake queries
pg_lake_icebergOLAPCApache-2.0Iceberg implementation in Postgres
pg_lake_spatialGISCApache-2.0Geospatial file format support
pg_lake_tableOLAPCApache-2.0Data lake tables and Iceberg tables
pg_semantic_cacheRAGCPostgreSQLSemantic query result caching using vector embeddings
pg_sentence_transformerRAGPythonBSD 2-ClauseComputes embeddings using huggingface model without the need for external LLM setup
pg_stash_adviceFEATCPostgreSQLstore and automatically apply plan advice
pg_turretFEATRustMITpg_turret: Created by pgrx
pg_worker_poolADMINCUnknownA background worker pool for executing SQL queries
plhaskellLANGCGPL-3.0PL/Haskell procedural language
saturated_intTYPECMITan integer type with saturation arithmetic
pgedge_safesessionSECCPostgreSQLEnforce read-only sessions for specified PostgreSQL roles.
pg_pii_vaultSECRustMITPostgreSQL extension for GDPR-compliant column-level encryption using HashiCorp Vault Transit Engine.
redis_fdw_rsFDWRustApache-2.0This extension allows PostgreSQL to directly query and manipulate Redis data as if it were regular PostgreSQL tables.
pg_httpsUTILCMITHTTP/HTTPS client functions for PostgreSQL using libcurl
pg_turboquantRAGCMITPostgreSQL ANN index access method for pgvector using TurboQuant.
pglensETLCApache-2.0WAL-oriented projection/read-model extension built with PGXS; current implementation is manual recompute, with async/WAL pieces deferred.
pg_fasttransferETLCMITPostgresql Extension for FastTransfer
pg_conn2FDWCUnknownManage separate PostgreSQL database connections from SQL code
pg_sheet_fdwFDWCMITforeign data wrapper for access to SheetReader
oai_fdwFDWCMITOAI-PMH foreign data wrapper for PostgreSQL
multicdr_fdwFDWCPostgreSQLForeign data wrapper for reading call-detail-record file streams as external SQL tables.
pg_normalize_emailFUNCCPostgreSQLNormalize email addresses in PostgreSQL
kham_pgFTSRustMITThai word-segmentation FTS parser - tsvector, soundex, RTGS romanization, NER
basejump-supabase_test_helpersFUNCSQLMITA collection of functions designed to make testing Supabase projects easier.
crunchy_poolerSECSQLCommercialCrunchy Bridge PgBouncer authentication helper extension.
pgpodmanADMINCCommercialCrunchy Bridge provider extension for launching and managing container apps from PostgreSQL.
pgfgaSECRustMITExperimental ReBAC/Zanzibar-style fine-grained authorization functions for PostgreSQL.
pg_askLANGCMITPostgres Extension which uses AI to create SQL from Natural language.
pgautographLANGRustUnknownA PostgreSQL extension written in Rust using pgrx for automatically creating Property Graph queries from foreign key constraints.
pg_smolidTYPERustMITA Postgres pgrx extension adding smolid type and helper functions.
json_validator_extTYPERustUnknownValidate JSONB values against JSON Schema using Rust and pgrx
pg_debyte_extFUNCRustApache-2.0Example PostgreSQL extension for decoding bytea payloads to JSON using pg_debyte Rust crates.
pgbitmapTYPECUnknownBitmap-type extension for PostgreSQL
kor_searchFTSCMITA PostgreSQL extension for Korean-English text search.
pg_icu_parserFTSCMPL-2.0Full text search parser using ICU boundary analysis
pg_gembedRAGCApache-2.0Generate embeddings inside PostgreSQL
tab_tierOLAPSQLApache-2.0Extension for date-based, job-driven table partition management.
test_factoryUTILSQLBSD 2-ClauseFramework for managing test data
pg_sweepSTATRustMITCollect PostgreSQL database and table statistics as JSON
normFUNCSQLGPL-3.0No-ORM helper extension that generates simple CRUD functions.
pg-gvmFUNCCUnknownFunctions for GVMd
uuidv7-sqlTYPESQLUnknownthis is a dbdev package for https://github.com/dverite/postgres-uuidv7-sql Pure SQL functions to use UUIDs v7 in PostgreSQL.