Skip to content

By License

PostgreSQL extensions organized by open source license

PostgreSQL extension categorized by license.

Summary

License Count Reference Description
PostgreSQL 250 License Text Very liberal license based on the BSD license, allowing almost unlimited freedom.
Apache-2.0 109 License Text Permissive license with patent protection and attribution requirements.
MIT 96 License Text A permissive license that allows commercial use, modification, and private use.
BSD-3-Clause 34 License Text Unknown license
GPL-2.0 21 License Text Strong copyleft license requiring derivative works to be open source.
BSD-2-Clause 16 License Text Unknown license
GPL-3.0 13 License Text Strong copyleft license with additional patent and hardware restrictions.
AGPL-3.0 11 License Text Network copyleft license extending GPL to cover network-distributed software.
ISC 8 License Text A permissive license similar to MIT, allowing commercial use and modification.
Unknown 5 License Text Unknown license
LGPL-3.0 4 License Text Weak copyleft license with additional patent and hardware provisions.
Timescale 2 License Text Proprietary license with restrictions on commercial use and distribution.
Artistic-2.0 2 License Text Unknown license
MPL-2.0 1 License Text Weak copyleft license allowing proprietary combinations with file-level copyleft.
LGPL-2.1 1 License Text Weak copyleft license allowing proprietary applications to link dynamically.
Artistic-1.0 1 License Text Unknown license
0BSD 1 License Text Unknown license
Elastic-2.0 1 License Text Unknown license

PostgreSQL

PostgreSQL 250 Extensions
License Text Very liberal license based on the BSD license, allowing almost unlimited freedom.
ID Extension Description
1020 timeseries / pg_timeseries Convenience API for time series stack
1030 periods Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
1070 pg_cron Job scheduler for PostgreSQL
1090 pg_later Run queries now and get results later
1100 pg_dispatch Asynchronous SQL dispatcher built on pg_cron
1130 pg_stl Time series analysis functions for PostgreSQL
1650 mobilitydb MobilityDB geospatial trajectory data management & analysis platform
1651 mobilitydb_datagen / mobilitydb MobilityDB random data generator functions
1690 earthdistance calculate great-circle distances on the surface of the Earth
1800 vector / pgvector vector data type and ivfflat and hnsw access methods
1820 vectorscale / pgvectorscale Advanced indexing for vector data with DiskANN
1830 vectorize / pg_vectorize The simplest way to do vector search on Postgres
2110 pgroonga Use Groonga as index, fast full text search platform for all languages!
2111 pgroonga_database / pgroonga PGroonga database management module
2120 pg_bigm create 2-gram (bigram) index for faster full text search.
2130 zhparser a parser for full-text search of Chinese
2180 pg_textsearch Full-text search with BM25 ranking
2220 pg_fts Full-text search with BM25 and BM25F ranking
2230 pg_cjk_parser CJK bigram parser derived from PostgreSQL full-text search
2270 hunspell_cs_cz / hunspell Czech Hunspell Dictionary
2271 hunspell_de_de / hunspell German Hunspell Dictionary
2272 hunspell_en_us / hunspell en_US Hunspell Dictionary
2273 hunspell_fr / hunspell French Hunspell Dictionary
2274 hunspell_ne_np / hunspell Nepali Hunspell Dictionary
2275 hunspell_nl_nl / hunspell Dutch Hunspell Dictionary
2276 hunspell_nn_no / hunspell Norwegian (norsk) Hunspell Dictionary
2277 hunspell_pt_pt / hunspell Portuguese Hunspell Dictionary
2278 hunspell_ru_ru / hunspell Russian Hunspell Dictionary
2279 hunspell_ru_ru_aot / hunspell Russian Hunspell Dictionary (from AOT.ru group)
2380 fuzzystrmatch determine similarities and distance between strings
2390 pg_trgm text similarity measurement and index searching based on trigrams
2480 pg_parquet copy data between Postgres and Parquet
2510 pg_partman Extension to manage partitioned tables by time or ID
2530 pg_strom PG-Strom - big-data processing acceleration using GPU and NVME
2550 pg_sorted_heap Sorted heap table AM with zone map scan pruning and built-in vector search
2590 tablefunc functions that manipulate whole tables, including crosstab
2660 pgmq A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
2670 pgmb A simple PostgreSQL Message Broker system
2710 rum RUM index access method
2730 pg_ttl_index Automatic data expiration with TTL indexes
2770 jsquery data type for jsonb inspection
2790 hypopg Hypothetical indexes for PostgreSQL
2800 index_advisor Query index advisor
2810 plan_filter / pg_plan_filter filter statements by their execution plans.
2820 pg_variables Session-scoped variables with scalar, array, and record types
2830 imgsmlr Image similarity with haar
2840 pg_ivm incremental view maintenance on PostgreSQL
2850 pg_incremental Incremental Processing by Crunchy Data
2870 pg_durable Durable SQL functions for PostgreSQL
2880 pg_disorder Perturb unordered SELECT row order to expose order-dependent tests
2910 orioledb OrioleDB, the next generation transactional engine
2990 bloom bloom access method - signature file based index
3010 plv8 PL/JavaScript (v8) trusted procedural language
3011 pljs PL/JS trusted procedural language
3110 plxslt XSLT procedural language for PostgreSQL
3120 pg_mockable Create mockable wrappers for PostgreSQL functions in tests
3130 pgsqlmock Mocking and faking helpers for PostgreSQL unit tests
3200 pgtap Unit testing for PostgreSQL
3210 faker Wrapper for the Faker Python library
3240 pltcl PL/Tcl procedural language
3250 pltclu / pltcl PL/TclU untrusted procedural language
3260 plperl PL/Perl procedural language
3261 bool_plperl / plperl transform between bool and plperl
3262 hstore_plperl / plperl transform between hstore and plperl
3263 jsonb_plperl / plperl transform between jsonb and plperl
3270 plperlu PL/PerlU untrusted procedural language
3271 bool_plperlu / plperlu transform between bool and plperlu
3272 jsonb_plperlu / plperlu transform between jsonb and plperlu
3273 hstore_plperlu / plperlu transform between hstore and plperlu
3280 plpgsql PL/pgSQL procedural language
3290 plpython3u PL/Python3U untrusted procedural language
3291 jsonb_plpython3u / plpython3u transform between jsonb and plpython3u
3292 ltree_plpython3u / plpython3u transform between ltree and plpython3u
3293 hstore_plpython3u / plpython3u transform between hstore and plpython3u
3500 prefix / pg_prefix Prefix Range module for PostgreSQL
3510 semver / pg_semver Semantic version data type
3520 pg_text_semver Semantic version domain and comparison operators for PostgreSQL
3660 country / pg_country Country data type, ISO 3166-1
3670 pg_xenophile More than the bare necessities for PostgreSQL i18n and l10n.
3671 l10n_table_dependent_extension / pg_xenophile PostgreSQL l10n toolbox
3730 uint / pguint unsigned integer types
3740 uint128 / pg_uint128 Native uint128 type
3750 hashtypes sha1, md5 and other data types for PostgreSQL
3760 postbis Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and bioinformatics functions.
3770 ip4r IPv4/v6 and IPv4/v6 range index type for PostgreSQL
3790 uri / pg_uri URI Data type for PostgreSQL
3820 debversion Debian version number data type
3860 pg_bikram_sambat Bikram Sambat date type and AD/BS conversion functions
3920 chkpass data type for auto-encrypted passwords
3930 isn data types for international product numbering standards
3940 seg data type for representing line segments or floating-point intervals
3950 cube data type for multidimensional cubes
3960 ltree data type for hierarchical tree-like structures
3970 hstore data type for storing sets of (key, value) pairs
3980 citext data type for case-insensitive character strings
3990 xml2 XPath querying and XSLT
4100 pg_retry Retry SQL statements on transient errors with exponential backoff
4110 pg_fsql Recursive SQL template engine with JSONB-driven execution
4130 pgproto Native Protobuf parsing, mutation, indexing, and JSON conversion support
4140 pglock Lightweight distributed lock service inside PostgreSQL
4180 pg_html5_email_address PostgreSQL email validation that is consistent with the HTML5 spec
4190 url_encode url_encode, url_decode functions
4200 pgsql_tweaks Some functions and views for daily usage
4210 pg_relation_sql Generate inlinable SQL functions for navigating PostgreSQL foreign-key relations
4220 pg_extra_time Some date time functions and operators that,
4230 pgpcre Perl Compatible Regular Expression functions
4235 re2 ClickHouse-compatible regex functions using RE2
4240 icu_ext Access ICU functions
4270 envvar / pg_envvar Fetch the value of an environment variable
4285 external_file Access external server-side files through PostgreSQL functions
4300 pg_readme Generate a Markdown README from PostgreSQL COMMENT objects
4301 pg_readme_test_extension / pg_readme Fixture extension used to test pg_readme document generation
4320 data_historization PLPGSQL Script to historize data in partitionned table
4400 hashlib / pg_hashlib Stable hash functions for Postgres
4440 shacrypt Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
4450 cryptint Encryption functions for int and bigint values
4530 pg_uuid_v8 UUID v8 generator with embedded timestamps for PostgreSQL
4540 permuteseq Pseudo-randomly permute sequences with a format-preserving encryption on elements
4590 snowflake Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL
4640 omnisketch data structure for on-line agg of data into approximate sketch
4650 ddsketch Provides ddsketch aggregate function
4680 weighted_statistics / pg_weighted_statistics High-performance weighted statistics functions for sparse data
4710 first_last_agg first() and last() aggregate functions
4720 extra_window_functions Extra Window Functions for PostgreSQL
4755 argm argmax, argmin, and anyold aggregate functions
4790 random / pg_random random data generator
4840 financial / pg_financial Financial aggregate functions
4845 pg_accumulator Accumulation registers for balance and turnover tracking in PostgreSQL
4860 parray_gin GIN index operator class and partial-match operators for text arrays
4880 refint functions for implementing referential integrity (obsolete)
4881 autoinc functions for autoincrementing fields
4882 insert_username functions for tracking who changed a table
4883 moddatetime functions for tracking last modification time
4890 tsm_system_time TABLESAMPLE method which accepts time in milliseconds as a limit
4900 dict_xsyn text search dictionary template for extended synonym processing
4910 tsm_system_rows TABLESAMPLE method which accepts number of rows as a limit
4920 tcn Triggered change notifications
4930 uuid-ossp generate universally unique identifiers (UUIDs)
4940 btree_gist support for indexing common datatypes in GiST
4950 btree_gin support for indexing common datatypes in GIN
4960 intarray functions, operators, and index support for 1-D arrays of integers
4970 intagg integer aggregator and enumerator (obsolete)
4980 dict_int text search dictionary template for integers
4990 unaccent text search dictionary that removes accents
5010 pg_repack Reorganize tables in PostgreSQL databases with minimal locks
5030 pg_query_rewrite Rewrite SQL statements with a PostgreSQL ProcessUtility hook
5080 ddlx / pg_ddlx DDL eXtractor functions
5090 pglinter PostgreSQL Linting and Analysis Extension
5100 prioritize / pg_prioritize get and set the priority of PostgreSQL backends
5120 pg_readonly cluster database read only
5150 pgautofailover pg_auto_failover
5170 pre_prepare / preprepare Pre Prepare your Statement server side
5180 pg_upless Detect Useless UPDATE
5190 pgcozy Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
5200 pg_orphaned Deal with orphaned files
5220 pg_cheat_funcs Provides cheat (but useful) functions
5260 pgdisablelogerror Disable selected SQLSTATE error codes from PostgreSQL server logging.
5270 online_advisor Suggest missing indexes and extended statistics online
5850 pg_drop_events logs transaction ids of drop table, drop column, drop materialized view statements
5860 table_log record table modification logs and PITR for table/row
5870 pgelog Extended logging via pseudo-autonomous transactions
5880 pgagent A PostgreSQL job scheduler
5890 pg_prewarm prewarm relation data
5900 pgpool_adm / pgpool Administrative functions for pgPool
5910 pgpool_recovery / pgpool recovery functions for pgpool-II for V4.3
5920 pgpool_regclass / pgpool replacement for regclass
5930 lo Large Object maintenance
5940 basic_archive an example of an archive module
5950 basebackup_to_shell adds a custom basebackup target called shell
5960 old_snapshot utilities in support of old_snapshot_threshold
5970 adminpack administrative functions for PostgreSQL
5980 amcheck functions for verifying relation integrity
5990 pg_surgery extension to perform surgery on a damaged relation
6030 pg_stat_backtrace Capture or log C-level stack backtraces of PostgreSQL processes
6040 pg_stat_log Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.
6050 pg_stat_plans Track per-plan call counts, execution times, and example EXPLAIN texts.
6080 pg_statviz Capture PostgreSQL statistics snapshots for time-series analysis and visualization
6210 pg_show_plans show query plans of all currently running SQL statements
6260 pg_track_settings Track settings changes
6280 pg_wait_sampling sampling based statistics of wait events
6410 pgsentinel active session history
6420 system_stats EnterpriseDB system statistics for PostgreSQL
6510 bgw_replstatus Small PostgreSQL background worker to report whether a node is a replication master or standby
6530 toastinfo show details on toasted datums
6850 pg_relusage Log all the queries that reference a particular column
6870 powa PostgreSQL Workload Analyser-core
6880 pg_overexplain Allow EXPLAIN to dump even more details
6890 pg_logicalinspect Logical decoding components inspection
6900 pageinspect inspect the contents of database pages at a low level
6910 pgrowlocks show row-level locking information
6920 sslinfo information about SSL certificates
6930 pg_buffercache examine the shared buffer cache
6940 pg_walinspect functions to inspect contents of PostgreSQL Write-Ahead Log
6950 pg_freespacemap examine the free space map (FSM)
6960 pg_visibility examine the visibility map (VM) and page-level visibility info
6970 pgstattuple show tuple-level statistics
6980 auto_explain Provides a means for logging execution plans of slow statements automatically
6990 pg_stat_statements track planning and execution statistics of all SQL statements executed
7030 column_encrypt Transparent column-level encryption with encrypted_text and encrypted_bytea types
7040 passwordpolicy Dynamically configurable PostgreSQL password complexity checks.
7070 anon / pg_anon PostgreSQL Anonymizer (anon) extension
7100 pgaudit provides auditing functionality
7110 pgauditlogtofile pgAudit addon to redirect audit log to an independent file
7120 pg_roast Opinionated PostgreSQL database auditor
7160 pg_jobmon Extension for logging and monitoring functions in PostgreSQL
7320 pgcryptokey cryptographic key management
7370 set_user similar to SET ROLE but with added logging
7380 pg_snakeoil The PostgreSQL Antivirus
7390 pgextwlist PostgreSQL Extension Whitelisting
7410 sslutils A Postgres extension for managing SSL certificates through SQL
7440 pg_policy Agentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls
7510 pg_vault_tde Transparent Data Encryption for PostgreSQL through custom table and index access methods
7960 sepgsql label-based mandatory access control (MAC) based on SELinux security policy.
7970 auth_delay pause briefly before reporting authentication failure
7980 pgcrypto cryptographic functions
7990 passwordcheck checks user passwords and reject weak password
8510 multicorn Fetch foreign data in Python in your PostgreSQL server.
8520 odbc_fdw Foreign data wrapper for accessing remote databases using ODBC
8530 jdbc_fdw foreign-data wrapper for remote servers available over JDBC
8540 pgspider_ext foreign-data wrapper for remote PGSpider servers
8610 oracle_fdw foreign data wrapper for Oracle access
8620 tds_fdw Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
8630 db2_fdw foreign data wrapper for DB2 access
8640 sqlite_fdw SQLite Foreign Data Wrapper
8650 pgbouncer_fdw Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
8670 informix_fdw Foreign data wrapper for Informix access
8710 redis_fdw Foreign data wrapper for querying a Redis server
8730 kafka_fdw kafka Foreign Data Wrapper for CSV formatted messages
8740 hdfs_fdw foreign-data wrapper for remote hdfs servers
8750 firebird_fdw Foreign data wrapper for Firebird
8970 dblink connect to other PostgreSQL databases from within a database
8980 file_fdw foreign-data wrapper for flat file access
8990 postgres_fdw foreign-data wrapper for remote PostgreSQL servers
9200 db2fce DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.
9210 plpgsql_wrap Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.
9240 pg_dbms_metadata Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
9250 pg_dbms_lock Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
9260 pg_dbms_job Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
9290 pg_utl_smtp Oracle UTL_SMTP compatibility extension for PostgreSQL
9500 pglogical PostgreSQL Logical Replication
9501 pglogical_origin / pglogical Dummy extension for compatibility when upgrading from Postgres 9.4
9510 pglogical_ticker Have an accurate view on pglogical replication delay
9540 pg_failover_slots PG Failover Slots extension
9570 spock Multi-master logical replication extension for PostgreSQL
9580 lolor Logical-replication-friendly replacement for PostgreSQL large objects
9590 pgclone Clone PostgreSQL databases, schemas, tables, and functions across environments
9660 decoder_raw Output plugin for logical replication in Raw SQL format
9700 mimeo Extension for specialized, per-table replication between PostgreSQL instances
9970 test_decoding SQL-based test/example module for WAL logical decoding
9980 pgoutput Logical Replication output plugin

Apache-2.0

Apache-2.0 109 Extensions
License Text Permissive license with patent protection and attribution requirements.
ID Extension Description
1530 h3 / pg_h3 H3 bindings for PostgreSQL
1531 h3_postgis / pg_h3 H3 PostGIS integration
1700 qdgc Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL.
1710 qdgc_postgis / qdgc Add PostGIS geometry and geography bindings plus area-to-cell fills for QDGC.
1870 pg_tiktoken tiktoken tokenizer for use with OpenAI models in postgres
1880 pg_tiktoken_c Fast tiktoken BPE tokenizer for PostgreSQL implemented in C
1950 pgmnemo Single-plan multimodal agent memory for PostgreSQL
1960 pgcontext Vector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables.
1970 pgcontext_pgvector / pgcontext Optional pgvector compatibility bridge for pgcontext HNSW indexes.
1980 pg_turbovec TurboQuant-compressed vector type and ANN index access method for PostgreSQL.
2140 pg_bestmatch Generate BM25 sparse vector inside PostgreSQL
2160 pg_tokenizer Tokenizers for full-text search
2210 psql_bm25s PostgreSQL extension for BM25-family lexical retrieval
2460 pg_clickhouse Interfaces to query ClickHouse databases from PostgreSQL
2540 pg_orca ORCA query optimizer as a PostgreSQL extension
2560 pg_lake Data lake extension by Snowflake
2561 pg_extension_base / pg_lake Extension development kit by Snowflake
2562 pg_extension_updater / pg_lake Automatic extension updater
2563 pg_map / pg_lake Map type for PostgreSQL, bundled as a required pg_lake component.
2564 pg_lake_engine / pg_lake Query engine for data lake queries
2565 pg_lake_iceberg / pg_lake Iceberg implementation in Postgres
2566 pg_lake_table / pg_lake Data lake tables and Iceberg tables
2567 pg_lake_copy / pg_lake Copy to/from data lake files
2600 age AGE graph database extension
2620 onesparse / one_sparse Sparse linear algebra and graph extension for PostgreSQL 18
2630 graph / pggraph Graph database capabilities for PostgreSQL
2680 ulak Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery
2690 fsm_core Finite state machine toolkit for PostgreSQL
2700 hll type for storing hyperloglog data
2720 pg_ai_query AI-powered SQL query generation for PostgreSQL
2740 pg_graphql Add in-database GraphQL support
2750 pg_jsonschema PostgreSQL extension providing JSON Schema validation
2860 pg_trickle Streaming tables and differential view maintenance for PostgreSQL 18
2940 omni / omnigres Advanced adapter for Postgres extensions
2941 omni_auth / omnigres Basic session management
2942 omni_aws / omnigres Amazon Web Services APIs (S3)
2943 omni_cloudevents / omnigres CloudEvents support
2944 omni_containers / omnigres Docker container management
2945 omni_credentials / omnigres Application credential management
2946 omni_csv CSV toolkit
2947 omni_datasets Dataset provisioning
2948 omni_email / omnigres E-mail framework
2949 omni_http / omnigres Basic HTTP types
2950 omni_httpc / omnigres HTTP client
2951 omni_httpd / omnigres HTTP server
2952 omni_id / omnigres Identity types
2953 omni_json / omnigres JSON toolkit
2954 omni_kube / omnigres Kubernetes (k8s) integration
2955 omni_ledger / omnigres Financial ledger
2956 omni_manifest / omnigres Package installation manifests
2957 omni_mimetypes / omnigres MIME types
2958 omni_os / omnigres Operating system integration
2959 omni_polyfill / omnigres Postgres API polyfills
2960 omni_python / omnigres First-class Python support
2961 omni_regex / omnigres PCRE-compatible regular expressions
2962 omni_rest / omnigres REST API toolkit (with PostgREST support)
2963 omni_schema / omnigres Advanced schema management tooling
2964 omni_seq / omnigres Distributed integer sequences
2965 omni_service / omnigres Service management
2966 omni_session / omnigres Session management
2967 omni_shmem Shared Memory Management
2968 omni_sql / omnigres Programmatic SQL manipulation
2969 omni_sqlite / omnigres Embedded SQLite
2970 omni_test / omnigres Testing framework
2971 omni_txn / omnigres Transaction management
2972 omni_types / omnigres Advanced types
2973 omni_var / omnigres Scoped variables
2974 omni_vfs / omnigres Virtual File System
2975 omni_vfs_types_v1 / omnigres Virtual File System types (v1)
2976 omni_web / omnigres Common web stack primitives
2977 omni_worker / omnigres Generalized worker pool
2978 omni_xml / omnigres XML toolkit
2979 omni_yaml / omnigres YAML toolkit
2980 pg_mentat Datomic-compatible data model and Datalog query engine inside PostgreSQL
3000 pg_tle Trusted Language Extensions for PostgreSQL
3040 plprql Use PRQL in PostgreSQL - Pipelined Relational Query Language
3630 roaringbitmap / pg_roaringbitmap support for Roaring Bitmaps
3690 collection / pgcollection Memory optimized data type to be used inside of plpglsql func
4080 pg_net Async HTTP Requests
4470 sparql / pgsparql Query SPARQL datasource with SQL
4500 pg_idkit multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
4690 datasketches Approximate analytics sketches and aggregates for PostgreSQL
4700 tdigest Provides tdigest aggregate function.
5070 pg_cooldown remove buffered pages for specific relations
5810 pg_savior Postgres extension to save OOPS mistakes
6020 pg_stat_ch Export PostgreSQL query telemetry to ClickHouse
6060 pgfr_record / pg_flight_recorder Server-side PostgreSQL performance flight recorder
6061 pgfr_analyze / pg_flight_recorder Reporting and analysis functions for pgfr_record
6070 pgmonitor Collector-friendly metric views and background refresh worker
6440 pgnodemx Capture node OS metrics via SQL queries
7010 supautils Extension that secures a cluster on a cloud environment
7050 supabase_vault / pg_vault Supabase Vault Extension
7060 pg_session_jwt Manage authentication sessions using JWTs
7170 pg_oidc_validator OAuth and OIDC token validator for PostgreSQL 18
8500 wrappers Foreign data wrappers developed by Supabase
8800 aws_s3 aws_s3 postgres extension to import/export data from/to s3
8810 log_fdw foreign-data wrapper for Postgres log file access
9140 ivorysql_ora / ivorysql Oracle Compatible extension on Postgres Database
9150 ora_btree_gin / ivorysql Support for indexing oracle datatypes in GIN
9160 ora_btree_gist / ivorysql Support for oracle indexing common datatypes in GiST
9170 pg_get_functiondef / ivorysql Get function’s definition
9180 plisql / ivorysql PL/iSQL procedural language
9190 gb18030_2022 / ivorysql Support GB18030-2022 and UTF-8 conversion
9300 babelfishpg_common / babelfish SQL Server Transact SQL Datatype Support
9310 babelfishpg_tsql / babelfish SQL Server Transact SQL compatibility
9320 babelfishpg_tds / babelfish SQL Server TDS protocol extension
9330 babelfishpg_money / babelfish SQL Server Money Data Type
9560 pgactive Active-Active Replication Extension for PostgreSQL
9640 wal2mongo PostgreSQL logical decoding output plugin for MongoDB

MIT

MIT 96 Extensions
License Text A permissive license that allows commercial use, modification, and private use.
ID Extension Description
1080 pg_task execute any sql command at any specific time at background
1120 pg_when Natural language time parsing for PostgreSQL
1140 cron_utils Parse cron expressions and compute previous or next trigger times
1550 ogr_fdw foreign-data wrapper for GIS data access
1570 pg_polyline Fast Google Encoded Polyline encoding & decoding for postgres
1580 pg_eviltransform Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
1590 pg_geohash Handle geohash based functionality for spatial coordinates
1680 tzf / pg_tzf Fast lookup timezone name by GPS coordinates
1845 pg_rrf Reciprocal rank fusion functions for hybrid search
1940 pgml Run AL/ML workloads with SQL interface
2170 biscuit / pg_biscuit IAM-LIKE pattern matching with bitmap indexing
2190 pg_pinyin Pinyin romanization and search helpers for PostgreSQL
2430 pg_duckdb DuckDB Embedded in Postgres
2440 pg_mooncake Columnstore Table in Postgres
2470 duckdb_fdw DuckDB Foreign Data Wrapper
2490 pg_ducklake DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet
2610 pg_liquid Liquid-inspired Datalog graph query extension for PostgreSQL
2640 pgrdf RDF, SPARQL, SHACL, and OWL reasoning for PostgreSQL
2760 jsonschema JSON Schema validation functions for PostgreSQL
2890 pg_local_cache Transaction-aware shared-memory cache for ordinary PostgreSQL primary-key reads
2900 provsql Semiring provenance and probability management for PostgreSQL
2920 pg_cardano A suite of Cardano-related tools
3020 pllua Lua as a procedural language
3021 hstore_pllua / pllua Hstore transform for Lua
3030 plluau / pllua Lua as an untrusted procedural language
3031 hstore_plluau / pllua Hstore transform for untrusted Lua
3060 plpgsql_check Additional validation, profiling, and diagnostics for PL/pgSQL functions
3080 plsh PL/sh procedural language
3140 plx Transpile multiple procedural dialects to PL/pgSQL
3160 plruby Embed MRI Ruby as an untrusted PostgreSQL procedural language
3161 jsonb_plruby / plruby Transform between jsonb and native Ruby data for PL/Ruby
3162 hstore_plruby / plruby Transform between hstore and Ruby Hashes for PL/Ruby
3163 ltree_plruby / plruby Transform between ltree and Ruby Arrays for PL/Ruby
3590 pglite_fusion Embed an SQLite database in your PostgreSQL table
3680 currency / pg_currency Custom PostgreSQL currency type in 1Byte
3720 pg_rational bigint fractions
3850 pg_duration data type for representing durations
3880 pg_rrule RRULE field type for PostgreSQL
3890 pgcalendar Recurring calendar, schedule, and exception management for PostgreSQL
3900 timestamp9 timestamp nanosecond resolution
3910 pgbson BSON data type and accessor functions for PostgreSQL
4010 gzip / pg_gzip gzip and gunzip functions.
4020 bzip / pg_bzip Bzip compression and decompression
4070 http / pg_http HTTP client for PostgreSQL, allows web page retrieval inside the database.
4090 pg_curl Run curl actions for data transfer in URL syntax
4120 pg_protobuf Protobuf support for PostgreSQL
4150 pgjq Use jq in Postgres
4160 pgjwt JSON Web Token API for Postgresql
4170 pg_smtp_client PostgreSQL extension to send email using SMTP
4280 floatfile Simple file storage for arrays of floats
4290 pg_render Render HTML in SQL
4350 pg_describe Report a query’s parameters and result columns without executing it
4510 pgx_ulid ulid type and methods
4550 pg_hashids Short unique id generator for PostgreSQL, using hashids
4560 pg_slug_gen Generate cryptographically secure timestamp-based slugs
4570 sequential_uuids generator of sequential UUIDs
4580 typeid / pg_typeid Allows to use TypeIDs in Postgres natively
4695 fbsql Closure-preserving formula-based statistical modeling in SQL
4730 floatvec Math for vectors (arrays) of numbers
4740 aggs_for_vecs Aggregate functions for array inputs
4750 aggs_for_arrays Various functions for computing statistics on arrays of numbers
4760 pg_csv Flexible CSV processing for Postgres
4770 arraymath / pg_arraymath Array math and operators that work element by element on the contents of arrays
4800 base36 / pg_base36 Integer Base36 types
4810 base62 / pg_base62 Base62 extension for PostgreSQL
4830 pg_base58 Base58 Encoder/Decoder Extension for PostgreSQL
4850 convert / pg_convert conversion functions for spatial, routing and other specialized uses
5130 pgdd Introspect pg data dictionary via standard SQL
5250 pg_pathcheck Validate planner Path trees for freed or corrupt memory
5280 pg_column_tetris Enforce optimal column alignment to minimize row padding
5290 cat_tools Tools for interfacing with the PostgreSQL catalog
5830 pg_strict Prevent dangerous UPDATE and DELETE without WHERE clause
6010 pg_tracing Distributed Tracing for PostgreSQL
6270 pg_track_optimizer Track planning decisions in comparison with execution reality
6520 pgmeminfo show memory usage
6860 pagevis Visualise database pages in ascii code
7080 pgsmcrypto PostgreSQL SM Algorithm Extension
7090 pg_enigma Encrypted postgres data type
7150 pg_auth_mon monitor connection attempts per user
7310 credcheck credcheck - postgresql plain text credential checker
7330 pg_pwhash Advanced password hashing methods for PostgreSQL
7500 pg_tde Percona pg_tde access method
8660 etcd_fdw Foreign data wrapper for etcd
8680 nominatim_fdw Nominatim Foreign Data Wrapper for PostgreSQL
8720 redis / pg_redis_pubsub Send redis pub/sub messages to Redis from PostgreSQL Directly
8760 rdf_fdw Foreign data wrapper for RDF triplestores over SPARQL endpoints
9000 documentdb API surface for DocumentDB for PostgreSQL
9010 documentdb_core / documentdb Core API surface for DocumentDB on PostgreSQL
9020 documentdb_distributed / documentdb Multi-Node API surface for DocumentDB
9030 documentdb_extended_rum / documentdb DocumentDB Extended RUM index access method
9090 pg_projection MongoDB-like read projections for JSONB in PostgreSQL
9410 pgmemcache memcached interface
9520 pgl_ddl_deploy automated ddl deployment using pglogical
9530 logical_ddl Replicate supported DDL changes over PostgreSQL logical replication
9650 decoderbufs Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
9820 pg_fact_loader build fact tables with Postgres

BSD-3-Clause

BSD-3-Clause 34 Extensions
License Text Unknown license
ID Extension Description
1060 table_version PostgreSQL table versioning extension
1520 pointcloud data type for lidar point clouds
1521 pointcloud_postgis / pointcloud integration for pointcloud LIDAR data and PostGIS geometry data
1840 pg_similarity support similarity queries
2240 pg_jieba Chinese full-text search parser based on cppjieba
2780 pg_hint_plan Give PostgreSQL ability to manually force some decisions in execution plans.
2930 rdkit Cheminformatics functionality for PostgreSQL.
3090 pljava PL/Java procedural language
3150 pgwasm Run sandboxed WebAssembly components as strongly typed PostgreSQL SQL functions.
3640 pgfaceting fast faceting queries using an inverted index
3650 pg_sphere / pgsphere spherical objects with useful functions, operators and index support
4250 pgqr QR Code generator from PostgreSQL
5020 pg_rewrite Tool allows read write to the table during the rewriting
5050 pg_dirtyread Read dead but unvacuumed rows from table
5060 pgfincore examine and manage the os buffer cache
5160 pg_catcheck Diagnosing system catalog corruption
5210 pg_crash Send random signals to random processes
5230 fio / pg_fio PostgreSQL File I/O Functions
6220 pg_stat_kcache Kernel statistics gathering
6230 pg_stat_monitor The 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.
6240 pg_qualstats An extension collecting statistics about quals
6250 pg_store_plans track plan statistics of all SQL statements executed
6400 pg_datasentinel Observability and activity monitoring extension for PostgreSQL
6450 pg_proctab / pgnodemx PostgreSQL extension to access the OS process table
6500 pg_sqlog Provide SQL interface to logs
7020 pgsodium Postgres extension for libsodium functions
7130 pg_auditor Audit data changes and provide flashback ability
7140 logerrors Function for collecting statistics about messages in logfile
7400 pg_command_fw DDL and utility command firewall for PostgreSQL
7430 block_copy_command Block COPY commands via a configurable ProcessUtility hook
8600 mysql_fdw Foreign data wrapper for querying a MySQL server
9550 db_migrator Tools to migrate other databases to PostgreSQL
9630 wal2json Changing data capture in JSON format
9830 pg_bulkload pg_bulkload is a high speed data loading utility for PostgreSQL

GPL-2.0

GPL-2.0 21 Extensions
License Text Strong copyleft license requiring derivative works to be open source.
ID Extension Description
1500 postgis PostGIS geometry and geography spatial types and functions
1501 postgis_topology / postgis PostGIS topology spatial types and functions
1502 postgis_raster / postgis PostGIS raster types and functions
1503 postgis_sfcgal / postgis PostGIS SFCGAL functions
1504 postgis_tiger_geocoder / postgis PostGIS tiger geocoder and reverse geocoder
1505 address_standardizer / postgis Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
1506 address_standardizer_data_us / postgis Address Standardizer US dataset example
1510 pgrouting pgRouting Extension
1540 q3c q3c sky indexing plugin
1600 pghydro Drainage network analysis core for PostgreSQL and PostGIS
1601 pgh_raster / pghydro Raster hydrology extension for PgHydro
1602 pgh_hgm / pghydro Hydrogeomorphological analysis extension for PgHydro
1603 pgh_output / pghydro Output and reporting objects for PgHydro
1604 pgh_output_en_au / pghydro Australian English output pack for PgHydro
1605 pgh_output_pt_br / pghydro Brazilian Portuguese output pack for PgHydro
1606 pgh_consistency / pghydro Pfafstetter consistency checks for PgHydro
2500 pg_fkpart Table partitioning by foreign key utility
3100 plr load R interpreter and execute R script from within a database
3550 unit / pgunit SI units extension
3710 numeral numeral datatypes extension
4310 ddl_historization Historize the ddl changes inside PostgreSQL database

BSD-2-Clause

BSD-2-Clause 16 Extensions
License Text Unknown license
ID Extension Description
1040 temporal_tables temporal tables
1560 geoip IP-based geolocation query
3230 pg_regresql Trust pg_class statistics for planning instead of physical relation size
3610 md5hash type for storing 128-bit binary data inline
3810 acl / pg_acl ACL Data type
4275 byteamagic / pg_byteamagic Detect MIME types and file formats from PostgreSQL bytea values
4430 xxhash / pg_xxhash xxhash functions for PostgreSQL
4460 pguecc / pg_ecdsa uECC bindings for Postgres
4610 quantile Quantile aggregation function
4620 lower_quantile Lower quantile aggregate function
4630 count_distinct An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
5040 pg_squeeze A tool to remove unused space from a relation.
5110 pg_checksums Activate/deactivate/verify checksums in offline Postgres clusters
5140 pg_permissions view object permissions and compare them with the desired state
6000 pg_profile PostgreSQL load profile repository and report builder
6430 meta / pg_meta Normalized, friendlier system catalog for PostgreSQL

GPL-3.0

GPL-3.0 13 Extensions
License Text Strong copyleft license with additional patent and hardware restrictions.
ID Extension Description
1050 emaj Enables fine-grained write logging and time travel on subsets of the database.
1110 pg_background Run SQL queries in the background
3570 pgpdf PDF type with meta admin & Full-Text Search
3620 asn1oid asn1oid extension
4330 schedoc / pg_schedoc Cross documentation between Django and DBT projects
4660 vasco discover hidden correlations in your data with MIC
4670 xicor / pgxicor XI Correlation Coefficient in Postgres
4780 pg_math GSL statistical functions for postgresql
5240 qos / pg_qos QoS resource governor extension for PostgreSQL sessions and queries
7360 login_hook login_hook - hook to execute login_hook.login() at login time
9120 session_variable Registration and manipulation of session variables and constants
9420 aux_mysql / openhalo MySQL Supplementary Extension
9710 repmgr Replication manager for PostgreSQL

AGPL-3.0

AGPL-3.0 11 Extensions
License Text Network copyleft license extending GPL to cover network-distributed software.
ID Extension Description
1810 vchord Vector database plugin for Postgres, written in Rust
1930 pg4ml Machine learning framework for PostgreSQL
2100 pg_search Full text search for PostgreSQL using BM25
2150 vchord_bm25 A postgresql extension for bm25 ranking algorithm
2400 citus Distributed PostgreSQL as an extension
2401 citus_columnar / citus Citus columnar storage engine
2410 columnar / hydra Hydra Columnar extension
2450 storage_engine colcompress and rowcompress Table Access Methods with vectorized execution
4340 pg_isok Query-based data integrity management and soft alerting for PostgreSQL
4600 topn type for top-n JSONB
7420 noset / pg_noset Module for blocking SET variables for non-super users.

ISC

ISC 8 Extensions
License Text A permissive license similar to MIT, allowing commercial use and modification.
ID Extension Description
2520 plproxy Database partitioning implemented as procedural language
2650 pgq Generic queue for PostgreSQL
4030 zstd / pg_zstd Zstandard compression algorithm implementation in PostgreSQL
5820 safeupdate Require criteria for UPDATE and DELETE
7450 pg_kpart Reject full partition scans that omit the partition key
9110 pgtt Extension to add Global Temporary Tables feature to PostgreSQL
9130 pg_statement_rollback Server side rollback at statement level for PostgreSQL like Oracle or DB2
9270 pg_dbms_errlog Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.

Unknown

Unknown 5 Extensions
License Text Unknown license
ID Extension Description
1850 smlar Effective similarity search
1860 pg_summarize Text Summarization using LLMs. Built using pgrx
3800 emailaddr / pg_emailaddr Email address type for PostgreSQL
6540 explain_ui / pg_explain_ui easily jump into a visual plan UI for any SQL query
7180 oidc_validator / pg_oidc_validator_rust PostgreSQL 18 OIDC bearer-token validator plugin written in Rust

LGPL-3.0

LGPL-3.0 4 Extensions
License Text Weak copyleft license with additional patent and hardware provisions.
ID Extension Description
2200 pg_kazsearch Kazakh full-text search extension for PostgreSQL
3700 pgmp Multiple Precision Arithmetic extension
7190 pgmemento Transaction-based audit trail with schema versioning
8700 mongo_fdw foreign data wrapper for MongoDB access

Timescale

Timescale 2 Extensions
License Text Proprietary license with restrictions on commercial use and distribution.
ID Extension Description
1000 timescaledb Enables scalable inserts and complex queries for time-series data
1010 timescaledb_toolkit Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities

Artistic-2.0

Artistic-2.0 2 Extensions
License Text Unknown license
ID Extension Description
3050 pldbgapi / pldebugger server-side support for debugging PL/pgSQL functions
3220 dbt2 OSDL-DBT-2 test kit

MPL-2.0

MPL-2.0 1 Extensions
License Text Weak copyleft license allowing proprietary combinations with file-level copyleft.
ID Extension Description
4520 pg_uuidv7 Create UUIDv7 values in postgres

LGPL-2.1

LGPL-2.1 1 Extensions
License Text Weak copyleft license allowing proprietary applications to link dynamically.
ID Extension Description
7000 passwordcheck_cracklib Strengthen PostgreSQL user password checks with cracklib

Artistic-1.0

Artistic-1.0 1 Extensions
License Text Unknown license
ID Extension Description
3070 plprofiler server-side support for profiling PL/pgSQL functions

0BSD

0BSD 1 Extensions
License Text Unknown license
ID Extension Description
9100 orafce Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS

Elastic-2.0

Elastic-2.0 1 Extensions
License Text Unknown license
ID Extension Description
9620 pgmqtt CDC-to-MQTT broker for PostgreSQL