Skip to content

Dependencies

PostgreSQL extensions with dependency relationships

130 extensions depend on other extensions, 76 extensions are depended upon by others.

Upstream Dependencies

The following 130 extensions require other extensions to be installed first:

ExtensionRequiresDescription
timeseriespg_cron pg_partmanConvenience API for time series stack
periodsbtree_gistProvide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
emajbtree_gist dblinkEnables fine-grained write logging and time travel on subsets of the database.
table_versionplpgsqlPostgreSQL table versioning extension
pg_laterpgmqRun queries now and get results later
pg_dispatchpgcrypto pg_cronAsynchronous SQL dispatcher built on pg_cron
postgis_topologypostgisPostGIS topology spatial types and functions
postgis_rasterpostgisPostGIS raster types and functions
postgis_sfcgalpostgisPostGIS SFCGAL functions
postgis_tiger_geocoderpostgis fuzzystrmatchPostGIS tiger geocoder and reverse geocoder
pgroutingplpgsql postgispgRouting Extension
pointcloud_postgispostgis pointcloudintegration for pointcloud LIDAR data and PostGIS geometry data
h3_postgish3 postgis postgis_rasterH3 PostGIS integration
geoipip4rIP-based geolocation query
pg_eviltransformpostgisCoordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
pghydroplpgsql postgisDrainage network analysis core for PostgreSQL and PostGIS
pgh_rasterplpgsql postgis postgis_raster pghydroRaster hydrology extension for PgHydro
pgh_hgmplpgsql postgis postgis_raster pghydro pgh_rasterHydrogeomorphological analysis extension for PgHydro
pgh_outputplpgsql postgis pghydroOutput and reporting objects for PgHydro
pgh_output_en_auplpgsql postgis pghydroAustralian English output pack for PgHydro
pgh_output_pt_brplpgsql postgis pghydroBrazilian Portuguese output pack for PgHydro
pgh_consistencyplpgsql postgis pghydroPfafstetter consistency checks for PgHydro
mobilitydbpostgisMobilityDB geospatial trajectory data management & analysis platform
mobilitydb_datagenmobilitydbMobilityDB random data generator functions
earthdistancecubecalculate great-circle distances on the surface of the Earth
qdgc_postgisqdgc postgisAdd PostGIS geometry and geography bindings plus area-to-cell fills for QDGC.
vchordvectorVector database plugin for Postgres, written in Rust
vectorscalevectorAdvanced indexing for vector data with DiskANN
vectorizepg_cron pgmq vectorThe simplest way to do vector search on Postgres
pg4mlplpgsql tablefunc cube plpython3uMachine learning framework for PostgreSQL
pgmnemovectorSingle-plan multimodal agent memory for PostgreSQL
pgcontext_pgvectorpgcontext vectorOptional pgvector compatibility bridge for pgcontext HNSW indexes.
pg_searchvectorFull text search for PostgreSQL using BM25
biscuitplpgsqlIAM-LIKE pattern matching with bitmap indexing
pg_mooncakepg_duckdbColumnstore Table in Postgres
pg_partmanplpgsqlExtension to manage partitioned tables by time or ID
pg_lakepg_lake_copy pg_lake_tableData lake extension by Snowflake
pg_extension_updaterpg_extension_baseAutomatic extension updater
pg_lake_enginepg_extension_base pg_mapQuery engine for data lake queries
pg_lake_icebergpg_lake_engine plpgsqlIceberg implementation in Postgres
pg_lake_tablebtree_gist pg_lake_engine pg_lake_icebergData lake tables and Iceberg tables
pg_lake_copypg_lake_engine pg_lake_iceberg pg_lake_tableCopy to/from data lake files
pgmbpg_cron httpA simple PostgreSQL Message Broker system
fsm_coreltree pgmq pg_jsonschemaFinite state machine toolkit for PostgreSQL
index_advisorhypopgQuery index advisor
provsqluuid-osspSemiring provenance and probability management for PostgreSQL
omni_authomni_types omni_id pgcrypto btree_gist omni_polyfillBasic session management
omni_awsomni_httpc pgcrypto omni_xml omni_webAmazon Web Services APIs (S3)
omni_cloudeventsomni_webCloudEvents support
omni_containersomni_httpc omni_webDocker container management
omni_credentialspgcrypto omni_osApplication credential management
omni_emailomni_id omni_cloudevents omni_polyfillE-mail framework
omni_httpcomni_http omni_typesHTTP client
omni_httpdomni_types omni_httpHTTP server
omni_kubeomni_httpc omni_web omni_var omni_yamlKubernetes (k8s) integration
omni_ledgeromni_id omni_polyfillFinancial ledger
omni_pythonplpython3uFirst-class Python support
omni_restomni_httpd omni_sql omni_web omni_var pgcryptoREST API toolkit (with PostgREST support)
omni_schemaomni_sql omni_vfs omni_polyfill omni_yaml dblink postgres_fdw omni_types omni_cloudeventsAdvanced schema management tooling
omni_sessionomni_var omni_id omni_web omni_httpd omni_polyfillSession management
omni_testdblink omni_cloudeventsTesting framework
omni_vfsomni_vfs_types_v1 dblinkVirtual File System
hstore_plluahstore plluaHstore transform for Lua
hstore_plluauhstore plluauHstore transform for untrusted Lua
plpgsql_checkplpgsqlAdditional validation, profiling, and diagnostics for PL/pgSQL functions
pgsqlmockplpgsql pgtapMocking and faking helpers for PostgreSQL unit tests
jsonb_plrubyplrubyTransform between jsonb and native Ruby data for PL/Ruby
hstore_plrubyhstore plrubyTransform between hstore and Ruby Hashes for PL/Ruby
ltree_plrubyltree plrubyTransform between ltree and Ruby Arrays for PL/Ruby
pgtapplpgsqlUnit testing for PostgreSQL
fakerplpython3uWrapper for the Faker Python library
bool_plperlplperltransform between bool and plperl
hstore_plperlhstore plperltransform between hstore and plperl
jsonb_plperlplperltransform between jsonb and plperl
bool_plperluplperlutransform between bool and plperlu
jsonb_plperluplperlutransform between jsonb and plperlu
hstore_plperluhstore plperlutransform between hstore and plperlu
jsonb_plpython3uplpython3utransform between jsonb and plpython3u
ltree_plpython3ultree plpython3utransform between ltree and plpython3u
hstore_plpython3uhstore plpython3utransform between hstore and plpython3u
unitplpgsqlSI units extension
pgfacetingroaringbitmapfast faceting queries using an inverted index
pg_xenophilehstoreMore than the bare necessities for PostgreSQL i18n and l10n.
l10n_table_dependent_extensionpg_xenophilePostgreSQL l10n toolbox
currencyplpgsqlCustom PostgreSQL currency type in 1Byte
pg_fsqlplpgsqlRecursive SQL template engine with JSONB-driven execution
pglockpg_cronLightweight distributed lock service inside PostgreSQL
pgjwtpgcryptoJSON Web Token API for Postgresql
pg_readmehstoreGenerate a Markdown README from PostgreSQL COMMENT objects
ddl_historizationplpgsqlHistorize the ddl changes inside PostgreSQL database
data_historizationplpgsqlPLPGSQL Script to historize data in partitionned table
schedocddl_historizationCross documentation between Django and DBT projects
sparqlplperl plperluQuery SPARQL datasource with SQL
fbsqlplrClosure-preserving formula-based statistical modeling in SQL
pg_accumulatorplpgsqlAccumulation registers for balance and turnover tracking in PostgreSQL
pgautofailoverbtree_gistpg_auto_failover
pg_uplessplpgsqlDetect Useless UPDATE
pgcozypg_buffercache pg_prewarmPre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
pg_column_tetrisplpgsqlEnforce optimal column alignment to minimize row padding
cat_toolsplpgsqlTools for interfacing with the PostgreSQL catalog
pg_drop_eventsplpgsqllogs transaction ids of drop table, drop column, drop materialized view statements
pgelogdblink pg_variablesExtended logging via pseudo-autonomous transactions
pg_profiledblink plpgsqlPostgreSQL load profile repository and report builder
pgfr_recordpg_cronServer-side PostgreSQL performance flight recorder
pgfr_analyzepgfr_recordReporting and analysis functions for pgfr_record
pg_statvizplpgsqlCapture PostgreSQL statistics snapshots for time-series analysis and visualization
pg_stat_kcachepg_stat_statementsKernel statistics gathering
pg_sqlogfile_fdwProvide SQL interface to logs
powaplpgsql pg_stat_statements btree_gistPostgreSQL Workload Analyser-core
column_encryptpgcryptoTransparent column-level encryption with encrypted_text and encrypted_bytea types
supabase_vaultpgsodiumSupabase Vault Extension
pg_auditorhstoreAudit data changes and provide flashback ability
pg_jobmondblinkExtension for logging and monitoring functions in PostgreSQL
pgcryptokeypgcryptocryptographic key management
pgbouncer_fdwdblinkExtension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
documentdbdocumentdb_core pg_cron postgis tsm_system_rows vectorAPI surface for DocumentDB for PostgreSQL
documentdb_distributedcitus documentdb_core documentdbMulti-Node API surface for DocumentDB
documentdb_extended_rumdocumentdbDocumentDB Extended RUM index access method
ora_btree_ginivorysql_oraSupport for indexing oracle datatypes in GIN
ora_btree_gistivorysql_oraSupport for oracle indexing common datatypes in GiST
db2fceplpgsqlDB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.
plpgsql_wrapplpgsqlOracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.
pg_dbms_lockpg_backgroundExtension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
pg_dbms_errlogpg_statement_rollbackEmulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
pg_utl_smtpplperluOracle UTL_SMTP compatibility extension for PostgreSQL
babelfishpg_tsqlbabelfishpg_common uuid-osspSQL Server Transact SQL compatibility
babelfishpg_tdsbabelfishpg_tsqlSQL Server TDS protocol extension
pglogical_tickerpglogicalHave an accurate view on pglogical replication delay
pgl_ddl_deploypglogicalautomated ddl deployment using pglogical
mimeodblinkExtension for specialized, per-table replication between PostgreSQL instances

Downstream Dependencies

The following 76 extensions are depended upon by other extensions:

ExtensionRequired ByDescription
pg_crondocumentdb pg_dispatch pglock pgmb timeseries vectorizeJob scheduler for PostgreSQL
postgisdocumentdb h3_postgis mobilitydb pg_eviltransform pgh_consistency pgh_hgm pgh_output pgh_output_en_au pgh_output_pt_br pgh_raster pghydro pgrouting pointcloud_postgis postgis_raster postgis_sfcgal postgis_tiger_geocoder postgis_topologyPostGIS geometry and geography spatial types and functions
postgis_rasterh3_postgis pgh_hgm pgh_rasterPostGIS raster types and functions
pointcloudpointcloud_postgisdata type for lidar point clouds
h3h3_postgisH3 bindings for PostgreSQL
pghydropgh_consistency pgh_hgm pgh_output pgh_output_en_au pgh_output_pt_br pgh_rasterDrainage network analysis core for PostgreSQL and PostGIS
pgh_rasterpgh_hgmRaster hydrology extension for PgHydro
mobilitydbmobilitydb_datagenMobilityDB geospatial trajectory data management & analysis platform
qdgcqdgc_postgisEncode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL.
vectorai alloydb_scann avocado documentdb embedding_search hybrid_search maludb_core pg_cuvs pg_diskann pg_gembed pg_knowledge_graph pg_llm pg_llm_helper pg_search pg_semantic_cache pg_sentence_transformer pg_splade pg_turboquant pgcontext_pgvector pgedge_vectorizer pgmnemo pgpu pgturbohybrid pgvecutils rag rag_bge_small_en_v15 rag_jina_reranker_v1_tiny_en rds_ai rds_embedding vchord vectorize vectorscalevector data type and ivfflat and hnsw access methods
pgcontextpgcontext_pgvectorVector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables.
fuzzystrmatchpostgis_tiger_geocoderdetermine similarities and distance between strings
cituscigration documentdb_distributedDistributed PostgreSQL as an extension
pg_duckdbpg_mooncakeDuckDB Embedded in Postgres
pg_partmanpartman_to_cstore timeseriesExtension to manage partitioned tables by time or ID
pg_extension_basepg_extension_updater pg_lake_engineExtension development kit by Snowflake
pg_mappg_lake_engineMap type for PostgreSQL, bundled as a required pg_lake component.
pg_lake_enginepg_lake_copy pg_lake_iceberg pg_lake_tableQuery engine for data lake queries
pg_lake_icebergpg_lake_copy pg_lake_tableIceberg implementation in Postgres
pg_lake_tablepg_lake pg_lake_copyData lake tables and Iceberg tables
pg_lake_copypg_lakeCopy to/from data lake files
tablefuncpg4mlfunctions that manipulate whole tables, including crosstab
pgmqfsm_core pg_later vectorizeA lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pg_jsonschemafsm_corePostgreSQL extension providing JSON Schema validation
hypopgindex_advisorHypothetical indexes for PostgreSQL
pg_variablespgelogSession-scoped variables with scalar, array, and record types
omni_cloudeventsomni_email omni_schema omni_testCloudEvents support
omni_httpomni_httpc omni_httpdBasic HTTP types
omni_httpcomni_aws omni_containers omni_kubeHTTP client
omni_httpdomni_rest omni_sessionHTTP server
omni_idomni_auth omni_email omni_ledger omni_sessionIdentity types
omni_osomni_credentialsOperating system integration
omni_polyfillomni_auth omni_email omni_ledger omni_schema omni_sessionPostgres API polyfills
omni_sqlomni_rest omni_schemaProgrammatic SQL manipulation
omni_typesomni_auth omni_httpc omni_httpd omni_schemaAdvanced types
omni_varomni_kube omni_rest omni_sessionScoped variables
omni_vfsomni_schemaVirtual File System
omni_vfs_types_v1omni_vfsVirtual File System types (v1)
omni_webomni_aws omni_cloudevents omni_containers omni_kube omni_rest omni_sessionCommon web stack primitives
omni_xmlomni_awsXML toolkit
omni_yamlomni_kube omni_schemaYAML toolkit
plluahstore_plluaLua as a procedural language
plluauhstore_plluauLua as an untrusted procedural language
plrubyhstore_plruby jsonb_plruby ltree_plrubyEmbed MRI Ruby as an untrusted PostgreSQL procedural language
plperlbool_plperl hstore_plperl jsonb_plperl sparqlPL/Perl procedural language
plperlubool_plperlu hstore_plperlu jsonb_plperlu pg_utl_smtp sparqlPL/PerlU untrusted procedural language
plpgsqlbedquilt biscuit cat_tools check_orapg currency data_historization db2fce dbpatch dbstat ddl_historization drop_role_helper dsef event_manager explanation firefly geekspeak generic_plan gogudb grants_manager hello-world hybrid_search index_analyzer istoria italian_codes job_queue json_query json_utils jsonb_schema jx_io keyhippo kilobase kissfft lab-orders launchql-base32 launchql-ext-types launchql-extension-utils launchql-extension-verify launchql-inflection launchql-jwt-claims launchql-stamps launchql-totp livewire medications merge_ips meta_triggers migration monitoring_role mv_rewrite mv_stats myhelper mypg_sharding mysqlcompat newsfeeds nfiesta_gisdata nfiesta_sdesign nfiesta_target_data nonoms norm npm ollama omnidb_plpgsql_debugger partman_to_cstore pase pathman_sharding patients pg-audit-json pg2podg pg4ml pgAutomator pg_abris pg_accumulator pg_audit pg_audit_tools pg_biscuit pg_bleve pg_bm25 pg_cache_tree pg_calcpi pg_catalog_get_defs pg_column_tetris pg_credereum pg_datatype_password pg_dbo_timestamp pg_dbwa pg_dms pg_drop_events pg_dropbuffers pg_dropcache pg_eyes pg_fairmlq pg_fsql pg_gen_uid pg_git pg_graphql_server pg_gsl pg_idm pg_idx_advisor pg_lake_iceberg pg_landmetrics pg_ledger pg_linegazer pg_llm_helper pg_lock_pool pg_message_queue pg_monitoring pg_normalize_email pg_once pg_os pg_osgr pg_pageprep pg_part pg_particulous pg_partman pg_pathman pg_paxos pg_popyramids_datamarts pg_profile pg_prometheus pg_prttn_tools pg_reversi pg_sakila_db pg_semantic_cache pg_sendmail pg_sentence_transformer pg_sessions pg_shardman pg_statviz pg_tileless pg_tms pg_turboquant pg_twkb pg_upless pg_zlog pgaut pgcat pgeyes pgfsm pgh_consistency pgh_hgm pgh_output pgh_output_en_au pgh_output_pt_br pgh_raster pghydro pgmemento pgmock pgnats pgparts pgpm-base32 pgpm-defaults pgpm-faker pgpm-inflection pgpm-jwt-claims pgpm-measurements pgpm-types pgpm-verify pgrao pgrollup pgrouting pgsqlmock pgtap pgtap_fixture pgtelemetry pgvroom plparrot plpgsql_check plpgsql_wrap plrust postgres_ci postpic powa prescriptions qgres quria range_partitioning recall recursively_delete rep_fdw rls_helpers roleman rpg rtiles scheduling session_variables short_ids skitch-extension-defaults skitch-extension-jobs skitch-extension-utils skitch-extension-verify sphinxlink sql_saga supa_queue supabase supabase_auth_apikey sys_syn_dblink tab_tier table_log_pl table_version tablelog telephone test_factory time_for_keys timestampandtz town types unit units us-states uuidv7-sql variant vectors vrprouting wasm webauthn xl_global_views zombodbPL/pgSQL procedural language
plpython3uhstore_plpython3u jsonb_plpython3u ltree_plpython3u omni_python pg4mlPL/Python3U untrusted procedural language
roaringbitmappgfacetingsupport for Roaring Bitmaps
pg_xenophilel10n_table_dependent_extensionMore than the bare necessities for PostgreSQL i18n and l10n.
ip4rgeoipIPv4/v6 and IPv4/v6 range index type for PostgreSQL
cubeearthdistance pg4mldata type for multidimensional cubes
ltreefsm_core ltree_plpython3udata type for hierarchical tree-like structures
hstoreflux format hstore_hash_ops hstore_ops hstore_pllua hstore_plluau hstore_plperl hstore_plperlu hstore_plpython2u hstore_plpython3u hstore_plpythonu hstore_plruby json_enhancements_with_hstore mbus meta_triggers numhstore pg_auditor pg_readme pg_rowalesce pg_utility_trigger_functions pg_xenophile sys_syn_dblinkdata type for storing sets of (key, value) pairs
httppgmbHTTP client for PostgreSQL, allows web page retrieval inside the database.
ddl_historizationschedocHistorize the ddl changes inside PostgreSQL database
tsm_system_rowsdocumentdbTABLESAMPLE method which accepts number of rows as a limit
uuid-osspbabelfishpg_tsql bundle datalink launchql-extension-verify launchql-inflection launchql-jwt-claims npm pg_abris pg_dms provsql ruid skitch-extension-jobs skitch-extension-verify supa_audit typesgenerate universally unique identifiers (UUIDs)
btree_gistemaj omni_auth periods pg_lake_table pgautofailover powasupport for indexing common datatypes in GiST
cat_toolsextension_drop object_referenceTools for interfacing with the PostgreSQL catalog
pg_prewarmpgcozyprewarm relation data
pgfr_recordpgfr_analyzeServer-side PostgreSQL performance flight recorder
pg_buffercachepgcozyexamine the shared buffer cache
pg_stat_statementspg_stat_kcache powatrack planning and execution statistics of all SQL statements executed
pgsodiumsupabase_vaultPostgres extension for libsodium functions
pgcryptocolumn_encrypt omni_auth omni_aws omni_credentials omni_rest pg_dispatch pgcryptokey pgjwtcryptographic functions
dblinkemaj mimeo omni_schema omni_test omni_vfs pg_jobmon pg_profile pgbouncer_fdw pgelogconnect to other PostgreSQL databases from within a database
file_fdwpg_sqlogforeign-data wrapper for flat file access
postgres_fdwomni_schemaforeign-data wrapper for remote PostgreSQL servers
documentdbdocumentdb_distributed documentdb_extended_rumAPI surface for DocumentDB for PostgreSQL
documentdb_coredocumentdb documentdb_distributedCore API surface for DocumentDB on PostgreSQL
pg_statement_rollbackpg_dbms_errlogServer side rollback at statement level for PostgreSQL like Oracle or DB2
ivorysql_oraora_btree_gin ora_btree_gistOracle Compatible extension on Postgres Database
babelfishpg_commonbabelfishpg_tsqlSQL Server Transact SQL Datatype Support
babelfishpg_tsqlbabelfishpg_tdsSQL Server Transact SQL compatibility
pglogicalpgl_ddl_deploy pglogical_tickerPostgreSQL Logical Replication

Was this page helpful?