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:
| 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 | btree_gist dblink | 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 |
qdgc_postgis | qdgc postgis | Add PostGIS geometry and geography bindings plus area-to-cell fills for QDGC. |
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 | Single-plan multimodal agent memory for PostgreSQL |
pgcontext_pgvector | pgcontext vector | Optional pgvector compatibility bridge for pgcontext HNSW indexes. |
pg_search | vector | Full text search for PostgreSQL using BM25 |
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 probability 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 | Additional validation, profiling, and diagnostics for PL/pgSQL functions |
pgsqlmock | plpgsql pgtap | Mocking and faking helpers for PostgreSQL unit tests |
jsonb_plruby | plruby | Transform between jsonb and native Ruby data for PL/Ruby |
hstore_plruby | hstore plruby | Transform between hstore and Ruby Hashes for PL/Ruby |
ltree_plruby | ltree plruby | Transform between ltree and Ruby Arrays for PL/Ruby |
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 Markdown README from PostgreSQL COMMENT objects |
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_column_tetris | plpgsql | Enforce optimal column alignment to minimize row padding |
cat_tools | plpgsql | Tools for interfacing with the PostgreSQL catalog |
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_statviz | plpgsql | Capture PostgreSQL statistics snapshots for time-series analysis and visualization |
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 76 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 |
qdgc | qdgc_postgis | Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL. |
vector | ai 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 vectorscale | vector data type and ivfflat and hnsw access methods |
pgcontext | pgcontext_pgvector | Vector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables. |
fuzzystrmatch | postgis_tiger_geocoder | determine similarities and distance between strings |
citus | cigration documentdb_distributed | Distributed PostgreSQL as an extension |
pg_duckdb | pg_mooncake | DuckDB Embedded in Postgres |
pg_partman | partman_to_cstore 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 |
plruby | hstore_plruby jsonb_plruby ltree_plruby | Embed MRI Ruby as an untrusted PostgreSQL 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 | bedquilt 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 zombodb | 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 | flux 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_dblink | 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 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 types | generate universally unique identifiers (UUIDs) |
btree_gist | emaj omni_auth periods pg_lake_table pgautofailover powa | support for indexing common datatypes in GiST |
cat_tools | extension_drop object_reference | Tools for interfacing with the PostgreSQL catalog |
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 |
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)