Dependencies

PostgreSQL extensions with dependency relationships

122 extensions depend on other extensions, 72 extensions are depended upon by others.

Upstream Dependencies

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

Extension	Requires	Description
`timeseries`	`pg_cron` `pg_partman`	Convenience API for time series stack
`periods`	`btree_gist`	Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
`emaj`	`dblink` `btree_gist`	Enables fine-grained write logging and time travel on subsets of the database.
`table_version`	`plpgsql`	PostgreSQL table versioning extension
`pg_later`	`pgmq`	Run queries now and get results later
`pg_dispatch`	`pgcrypto` `pg_cron`	Asynchronous SQL dispatcher built on pg_cron
`postgis_topology`	`postgis`	PostGIS topology spatial types and functions
`postgis_raster`	`postgis`	PostGIS raster types and functions
`postgis_sfcgal`	`postgis`	PostGIS SFCGAL functions
`postgis_tiger_geocoder`	`postgis` `fuzzystrmatch`	PostGIS tiger geocoder and reverse geocoder
`pgrouting`	`plpgsql` `postgis`	pgRouting Extension
`pointcloud_postgis`	`postgis` `pointcloud`	integration for pointcloud LIDAR data and PostGIS geometry data
`h3_postgis`	`h3` `postgis` `postgis_raster`	H3 PostGIS integration
`geoip`	`ip4r`	IP-based geolocation query
`pg_eviltransform`	`postgis`	Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
`pghydro`	`plpgsql` `postgis`	Drainage network analysis core for PostgreSQL and PostGIS
`pgh_raster`	`plpgsql` `postgis` `postgis_raster` `pghydro`	Raster hydrology extension for PgHydro
`pgh_hgm`	`plpgsql` `postgis` `postgis_raster` `pghydro` `pgh_raster`	Hydrogeomorphological analysis extension for PgHydro
`pgh_output`	`plpgsql` `postgis` `pghydro`	Output and reporting objects for PgHydro
`pgh_output_en_au`	`plpgsql` `postgis` `pghydro`	Australian English output pack for PgHydro
`pgh_output_pt_br`	`plpgsql` `postgis` `pghydro`	Brazilian Portuguese output pack for PgHydro
`pgh_consistency`	`plpgsql` `postgis` `pghydro`	Pfafstetter consistency checks for PgHydro
`mobilitydb`	`postgis`	MobilityDB geospatial trajectory data management & analysis platform
`mobilitydb_datagen`	`mobilitydb`	MobilityDB random data generator functions
`earthdistance`	`cube`	calculate great-circle distances on the surface of the Earth
`vchord`	`vector`	Vector database plugin for Postgres, written in Rust
`vectorscale`	`vector`	Advanced indexing for vector data with DiskANN
`vectorize`	`pg_cron` `pgmq` `vector`	The simplest way to do vector search on Postgres
`pg4ml`	`plpgsql` `tablefunc` `cube` `plpython3u`	Machine learning framework for PostgreSQL
`pgmnemo`	`vector`	Provenance-gated vector memory for LLM agents in PostgreSQL
`biscuit`	`plpgsql`	IAM-LIKE pattern matching with bitmap indexing
`pg_mooncake`	`pg_duckdb`	Columnstore Table in Postgres
`pg_partman`	`plpgsql`	Extension to manage partitioned tables by time or ID
`pg_lake`	`pg_lake_copy` `pg_lake_table`	Data lake extension by Snowflake
`pg_extension_updater`	`pg_extension_base`	Automatic extension updater
`pg_lake_engine`	`pg_extension_base` `pg_map`	Query engine for data lake queries
`pg_lake_iceberg`	`pg_lake_engine` `plpgsql`	Iceberg implementation in Postgres
`pg_lake_table`	`btree_gist` `pg_lake_engine` `pg_lake_iceberg`	Data lake tables and Iceberg tables
`pg_lake_copy`	`pg_lake_engine` `pg_lake_iceberg` `pg_lake_table`	Copy to/from data lake files
`pgmb`	`pg_cron` `http`	A simple PostgreSQL Message Broker system
`fsm_core`	`ltree` `pgmq` `pg_jsonschema`	Finite state machine toolkit for PostgreSQL
`index_advisor`	`hypopg`	Query index advisor
`provsql`	`uuid-ossp`	Semiring provenance and uncertainty management for PostgreSQL
`omni_auth`	`omni_types` `omni_id` `pgcrypto` `btree_gist` `omni_polyfill`	Basic session management
`omni_aws`	`omni_httpc` `pgcrypto` `omni_xml` `omni_web`	Amazon Web Services APIs (S3)
`omni_cloudevents`	`omni_web`	CloudEvents support
`omni_containers`	`omni_httpc` `omni_web`	Docker container management
`omni_credentials`	`pgcrypto` `omni_os`	Application credential management
`omni_email`	`omni_id` `omni_cloudevents` `omni_polyfill`	E-mail framework
`omni_httpc`	`omni_http` `omni_types`	HTTP client
`omni_httpd`	`omni_types` `omni_http`	HTTP server
`omni_kube`	`omni_httpc` `omni_web` `omni_var` `omni_yaml`	Kubernetes (k8s) integration
`omni_ledger`	`omni_id` `omni_polyfill`	Financial ledger
`omni_python`	`plpython3u`	First-class Python support
`omni_rest`	`omni_httpd` `omni_sql` `omni_web` `omni_var` `pgcrypto`	REST API toolkit (with PostgREST support)
`omni_schema`	`omni_sql` `omni_vfs` `omni_polyfill` `omni_yaml` `dblink` `postgres_fdw` `omni_types` `omni_cloudevents`	Advanced schema management tooling
`omni_session`	`omni_var` `omni_id` `omni_web` `omni_httpd` `omni_polyfill`	Session management
`omni_test`	`dblink` `omni_cloudevents`	Testing framework
`omni_vfs`	`omni_vfs_types_v1` `dblink`	Virtual File System
`hstore_pllua`	`hstore` `pllua`	Hstore transform for Lua
`hstore_plluau`	`hstore` `plluau`	Hstore transform for untrusted Lua
`plpgsql_check`	`plpgsql`	extended check for plpgsql functions
`pgsqlmock`	`plpgsql` `pgtap`	Mocking and faking helpers for PostgreSQL unit tests
`pgtap`	`plpgsql`	Unit testing for PostgreSQL
`faker`	`plpython3u`	Wrapper for the Faker Python library
`bool_plperl`	`plperl`	transform between bool and plperl
`hstore_plperl`	`hstore` `plperl`	transform between hstore and plperl
`jsonb_plperl`	`plperl`	transform between jsonb and plperl
`bool_plperlu`	`plperlu`	transform between bool and plperlu
`jsonb_plperlu`	`plperlu`	transform between jsonb and plperlu
`hstore_plperlu`	`hstore` `plperlu`	transform between hstore and plperlu
`jsonb_plpython3u`	`plpython3u`	transform between jsonb and plpython3u
`ltree_plpython3u`	`ltree` `plpython3u`	transform between ltree and plpython3u
`hstore_plpython3u`	`hstore` `plpython3u`	transform between hstore and plpython3u
`unit`	`plpgsql`	SI units extension
`pgfaceting`	`roaringbitmap`	fast faceting queries using an inverted index
`pg_xenophile`	`hstore`	More than the bare necessities for PostgreSQL i18n and l10n.
`l10n_table_dependent_extension`	`pg_xenophile`	PostgreSQL l10n toolbox
`currency`	`plpgsql`	Custom PostgreSQL currency type in 1Byte
`pg_fsql`	`plpgsql`	Recursive SQL template engine with JSONB-driven execution
`pglock`	`pg_cron`	Lightweight distributed lock service inside PostgreSQL
`pgjwt`	`pgcrypto`	JSON Web Token API for Postgresql
`pg_readme`	`hstore`	Generate a README.md document for a database extension or schema
`pg_readme_test_extension`	`hstore`	Test generating a README.md document for extension or schema
`ddl_historization`	`plpgsql`	Historize the ddl changes inside PostgreSQL database
`data_historization`	`plpgsql`	PLPGSQL Script to historize data in partitionned table
`schedoc`	`ddl_historization`	Cross documentation between Django and DBT projects
`sparql`	`plperl` `plperlu`	Query SPARQL datasource with SQL
`fbsql`	`plr`	Closure-preserving formula-based statistical modeling in SQL
`pg_accumulator`	`plpgsql`	Accumulation registers for balance and turnover tracking in PostgreSQL
`pgautofailover`	`btree_gist`	pg_auto_failover
`pg_upless`	`plpgsql`	Detect Useless UPDATE
`pgcozy`	`pg_buffercache` `pg_prewarm`	Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
`pg_drop_events`	`plpgsql`	logs transaction ids of drop table, drop column, drop materialized view statements
`pgelog`	`dblink` `pg_variables`	Extended logging via pseudo-autonomous transactions
`pg_profile`	`dblink` `plpgsql`	PostgreSQL load profile repository and report builder
`pgfr_record`	`pg_cron`	Server-side PostgreSQL performance flight recorder
`pgfr_analyze`	`pgfr_record`	Reporting and analysis functions for pgfr_record
`pg_stat_kcache`	`pg_stat_statements`	Kernel statistics gathering
`pg_sqlog`	`file_fdw`	Provide SQL interface to logs
`powa`	`plpgsql` `pg_stat_statements` `btree_gist`	PostgreSQL Workload Analyser-core
`column_encrypt`	`pgcrypto`	Transparent column-level encryption with encrypted_text and encrypted_bytea types
`supabase_vault`	`pgsodium`	Supabase Vault Extension
`pg_auditor`	`hstore`	Audit data changes and provide flashback ability
`pg_jobmon`	`dblink`	Extension for logging and monitoring functions in PostgreSQL
`pgcryptokey`	`pgcrypto`	cryptographic key management
`pgbouncer_fdw`	`dblink`	Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
`documentdb`	`documentdb_core` `pg_cron` `postgis` `tsm_system_rows` `vector`	API surface for DocumentDB for PostgreSQL
`documentdb_distributed`	`citus` `documentdb_core` `documentdb`	Multi-Node API surface for DocumentDB
`documentdb_extended_rum`	`documentdb`	DocumentDB Extended RUM index access method
`ora_btree_gin`	`ivorysql_ora`	Support for indexing oracle datatypes in GIN
`ora_btree_gist`	`ivorysql_ora`	Support for oracle indexing common datatypes in GiST
`db2fce`	`plpgsql`	DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.
`plpgsql_wrap`	`plpgsql`	Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.
`pg_dbms_lock`	`pg_background`	Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
`pg_dbms_errlog`	`pg_statement_rollback`	Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
`pg_utl_smtp`	`plperlu`	Oracle UTL_SMTP compatibility extension for PostgreSQL
`babelfishpg_tsql`	`babelfishpg_common` `uuid-ossp`	SQL Server Transact SQL compatibility
`babelfishpg_tds`	`babelfishpg_tsql`	SQL Server TDS protocol extension
`pglogical_ticker`	`pglogical`	Have an accurate view on pglogical replication delay
`pgl_ddl_deploy`	`pglogical`	automated ddl deployment using pglogical
`mimeo`	`dblink`	Extension for specialized, per-table replication between PostgreSQL instances

Downstream Dependencies

The following 72 extensions are depended upon by other extensions:

Extension	Required By	Description
`pg_cron`	`documentdb` `pg_dispatch` `pglock` `pgmb` `timeseries` `vectorize`	Job scheduler for PostgreSQL
`postgis`	`documentdb` `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_topology`	PostGIS geometry and geography spatial types and functions
`postgis_raster`	`h3_postgis` `pgh_hgm` `pgh_raster`	PostGIS raster types and functions
`pointcloud`	`pointcloud_postgis`	data type for lidar point clouds
`h3`	`h3_postgis`	H3 bindings for PostgreSQL
`pghydro`	`pgh_consistency` `pgh_hgm` `pgh_output` `pgh_output_en_au` `pgh_output_pt_br` `pgh_raster`	Drainage network analysis core for PostgreSQL and PostGIS
`pgh_raster`	`pgh_hgm`	Raster hydrology extension for PgHydro
`mobilitydb`	`mobilitydb_datagen`	MobilityDB geospatial trajectory data management & analysis platform
`vector`	`documentdb` `pgmnemo` `vchord` `vectorize` `vectorscale`	vector data type and ivfflat and hnsw access methods
`fuzzystrmatch`	`postgis_tiger_geocoder`	determine similarities and distance between strings
`citus`	`documentdb_distributed`	Distributed PostgreSQL as an extension
`pg_duckdb`	`pg_mooncake`	DuckDB Embedded in Postgres
`pg_partman`	`timeseries`	Extension to manage partitioned tables by time or ID
`pg_extension_base`	`pg_extension_updater` `pg_lake_engine`	Extension development kit by Snowflake
`pg_map`	`pg_lake_engine`	Map type for PostgreSQL, bundled as a required pg_lake component.
`pg_lake_engine`	`pg_lake_copy` `pg_lake_iceberg` `pg_lake_table`	Query engine for data lake queries
`pg_lake_iceberg`	`pg_lake_copy` `pg_lake_table`	Iceberg implementation in Postgres
`pg_lake_table`	`pg_lake` `pg_lake_copy`	Data lake tables and Iceberg tables
`pg_lake_copy`	`pg_lake`	Copy to/from data lake files
`tablefunc`	`pg4ml`	functions that manipulate whole tables, including crosstab
`pgmq`	`fsm_core` `pg_later` `vectorize`	A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
`pg_jsonschema`	`fsm_core`	PostgreSQL extension providing JSON Schema validation
`hypopg`	`index_advisor`	Hypothetical indexes for PostgreSQL
`pg_variables`	`pgelog`	Session-scoped variables with scalar, array, and record types
`omni_cloudevents`	`omni_email` `omni_schema` `omni_test`	CloudEvents support
`omni_http`	`omni_httpc` `omni_httpd`	Basic HTTP types
`omni_httpc`	`omni_aws` `omni_containers` `omni_kube`	HTTP client
`omni_httpd`	`omni_rest` `omni_session`	HTTP server
`omni_id`	`omni_auth` `omni_email` `omni_ledger` `omni_session`	Identity types
`omni_os`	`omni_credentials`	Operating system integration
`omni_polyfill`	`omni_auth` `omni_email` `omni_ledger` `omni_schema` `omni_session`	Postgres API polyfills
`omni_sql`	`omni_rest` `omni_schema`	Programmatic SQL manipulation
`omni_types`	`omni_auth` `omni_httpc` `omni_httpd` `omni_schema`	Advanced types
`omni_var`	`omni_kube` `omni_rest` `omni_session`	Scoped variables
`omni_vfs`	`omni_schema`	Virtual File System
`omni_vfs_types_v1`	`omni_vfs`	Virtual File System types (v1)
`omni_web`	`omni_aws` `omni_cloudevents` `omni_containers` `omni_kube` `omni_rest` `omni_session`	Common web stack primitives
`omni_xml`	`omni_aws`	XML toolkit
`omni_yaml`	`omni_kube` `omni_schema`	YAML toolkit
`pllua`	`hstore_pllua`	Lua as a procedural language
`plluau`	`hstore_plluau`	Lua as an untrusted procedural language
`plperl`	`bool_plperl` `hstore_plperl` `jsonb_plperl` `sparql`	PL/Perl procedural language
`plperlu`	`bool_plperlu` `hstore_plperlu` `jsonb_plperlu` `pg_utl_smtp` `sparql`	PL/PerlU untrusted procedural language
`plpgsql`	`biscuit` `currency` `data_historization` `db2fce` `ddl_historization` `pg4ml` `pg_accumulator` `pg_drop_events` `pg_fsql` `pg_lake_iceberg` `pg_partman` `pg_profile` `pg_upless` `pgh_consistency` `pgh_hgm` `pgh_output` `pgh_output_en_au` `pgh_output_pt_br` `pgh_raster` `pghydro` `pgrouting` `pgtap` `plpgsql_check` `plpgsql_wrap` `powa` `table_version` `unit`	PL/pgSQL procedural language
`plpython3u`	`hstore_plpython3u` `jsonb_plpython3u` `ltree_plpython3u` `omni_python` `pg4ml`	PL/Python3U untrusted procedural language
`roaringbitmap`	`pgfaceting`	support for Roaring Bitmaps
`pg_xenophile`	`l10n_table_dependent_extension`	More than the bare necessities for PostgreSQL i18n and l10n.
`ip4r`	`geoip`	IPv4/v6 and IPv4/v6 range index type for PostgreSQL
`cube`	`earthdistance` `pg4ml`	data type for multidimensional cubes
`ltree`	`fsm_core` `ltree_plpython3u`	data type for hierarchical tree-like structures
`hstore`	`hstore_pllua` `hstore_plluau` `hstore_plperl` `hstore_plperlu` `hstore_plpython3u` `pg_auditor` `pg_readme` `pg_readme_test_extension` `pg_xenophile`	data type for storing sets of (key, value) pairs
`http`	`pgmb`	HTTP client for PostgreSQL, allows web page retrieval inside the database.
`ddl_historization`	`schedoc`	Historize the ddl changes inside PostgreSQL database
`tsm_system_rows`	`documentdb`	TABLESAMPLE method which accepts number of rows as a limit
`uuid-ossp`	`babelfishpg_tsql` `provsql`	generate universally unique identifiers (UUIDs)
`btree_gist`	`emaj` `omni_auth` `periods` `pg_lake_table` `pgautofailover` `powa`	support for indexing common datatypes in GiST
`pg_prewarm`	`pgcozy`	prewarm relation data
`pgfr_record`	`pgfr_analyze`	Server-side PostgreSQL performance flight recorder
`pg_buffercache`	`pgcozy`	examine the shared buffer cache
`pg_stat_statements`	`pg_stat_kcache` `powa`	track planning and execution statistics of all SQL statements executed
`pgsodium`	`supabase_vault`	Postgres extension for libsodium functions
`pgcrypto`	`column_encrypt` `omni_auth` `omni_aws` `omni_credentials` `omni_rest` `pg_dispatch` `pgcryptokey` `pgjwt`	cryptographic functions
`dblink`	`emaj` `mimeo` `omni_schema` `omni_test` `omni_vfs` `pg_jobmon` `pg_profile` `pgbouncer_fdw` `pgelog`	connect to other PostgreSQL databases from within a database
`file_fdw`	`pg_sqlog`	foreign-data wrapper for flat file access
`postgres_fdw`	`omni_schema`	foreign-data wrapper for remote PostgreSQL servers
`documentdb`	`documentdb_distributed` `documentdb_extended_rum`	API surface for DocumentDB for PostgreSQL
`documentdb_core`	`documentdb` `documentdb_distributed`	Core API surface for DocumentDB on PostgreSQL
`pg_statement_rollback`	`pg_dbms_errlog`	Server side rollback at statement level for PostgreSQL like Oracle or DB2
`ivorysql_ora`	`ora_btree_gin` `ora_btree_gist`	Oracle Compatible extension on Postgres Database
`babelfishpg_common`	`babelfishpg_tsql`	SQL Server Transact SQL Datatype Support
`babelfishpg_tsql`	`babelfishpg_tds`	SQL Server Transact SQL compatibility
`pglogical`	`pgl_ddl_deploy` `pglogical_ticker`	PostgreSQL Logical Replication

Feedback

Was this page helpful?

Thanks for the feedback! Please let us know how we can improve.

Sorry to hear that. Please let us know how we can improve.

Last Modified 2026-07-23: update extension list to 555 (d81fc56)