By License
PostgreSQL extensions organized by open source license
MIT
ISC
PostgreSQL
BSD 0-Clause
BSD 2-Clause
BSD 3-Clause
Artistic
Apache-2.0
MPL-2.0
GPL-2.0
GPL-3.0
LGPL-2.1
LGPL-3.0
AGPL-3.0
Timescale
Summary
| License | Count | Reference | Description |
|---|---|---|---|
PostgreSQL | 198 | License Text | Very liberal license based on the BSD license, allowing almost unlimited freedom. |
Apache-2.0 | 68 | License Text | Permissive license with patent protection and attribution requirements. |
MIT | 59 | License Text | A permissive license that allows commercial use, modification, and private use. |
BSD 3-Clause | 30 | License Text | Permissive license with attribution and endorsement restriction clauses. |
BSD 2-Clause | 14 | License Text | Permissive license requiring attribution but allowing commercial use. |
GPL-2.0 | 14 | License Text | Strong copyleft license requiring derivative works to be open source. |
GPL-3.0 | 12 | License Text | Strong copyleft license with additional patent and hardware restrictions. |
AGPL-3.0 | 10 | License Text | Network copyleft license extending GPL to cover network-distributed software. |
ISC | 5 | License Text | A permissive license similar to MIT, allowing commercial use and modification. |
Artistic | 3 | License Text | Copyleft license allowing modification with certain distribution requirements. |
Timescale | 2 | License Text | Proprietary license with restrictions on commercial use and distribution. |
BSD 0-Clause | 2 | License Text | Public domain equivalent license with no restrictions on use. |
LGPL-3.0 | 2 | License Text | Weak copyleft license with additional patent and hardware provisions. |
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. |
PostgreSQL
PostgreSQL
198 Extensions
PostgreSQL License Text : Very liberal license based on the BSD license, allowing almost unlimited freedom.
| ID | Extension | Package | Description |
|---|---|---|---|
| 5970 | adminpack | adminpack | administrative functions for PostgreSQL |
| 5980 | amcheck | amcheck | functions for verifying relation integrity |
| 7050 | anon | pg_anon | PostgreSQL Anonymizer (anon) extension |
| 7970 | auth_delay | auth_delay | pause briefly before reporting authentication failure |
| 6980 | auto_explain | auto_explain | Provides a means for logging execution plans of slow statements automatically |
| 4881 | autoinc | autoinc | functions for autoincrementing fields |
| 5950 | basebackup_to_shell | basebackup_to_shell | adds a custom basebackup target called shell |
| 5940 | basic_archive | basic_archive | an example of an archive module |
| 6340 | bgw_replstatus | bgw_replstatus | Small PostgreSQL background worker to report whether a node is a replication master or standby |
| 2990 | bloom | bloom | bloom access method - signature file based index |
| 3261 | bool_plperl | plperl | transform between bool and plperl |
| 3271 | bool_plperlu | plperlu | transform between bool and plperlu |
| 4950 | btree_gin | btree_gin | support for indexing common datatypes in GIN |
| 4940 | btree_gist | btree_gist | support for indexing common datatypes in GiST |
| 3920 | chkpass | chkpass | data type for auto-encrypted passwords |
| 3980 | citext | citext | data type for case-insensitive character strings |
| 3600 | country | pg_country | Country data type, ISO 3166-1 |
| 4450 | cryptint | cryptint | Encryption functions for int and bigint values |
| 3950 | cube | cube | data type for multidimensional cubes |
| 4320 | data_historization | data_historization | PLPGSQL Script to historize data in partitionned table |
| 8630 | db2_fdw | db2_fdw | foreign data wrapper for DB2 access |
| 8970 | dblink | dblink | connect to other PostgreSQL databases from within a database |
| 5060 | ddlx | pg_ddlx | DDL eXtractor functions |
| 4650 | ddsketch | ddsketch | Provides ddsketch aggregate function |
| 3870 | debversion | debversion | Debian version number data type |
| 9660 | decoder_raw | decoder_raw | Output plugin for logical replication in Raw SQL format |
| 4980 | dict_int | dict_int | text search dictionary template for integers |
| 4900 | dict_xsyn | dict_xsyn | text search dictionary template for extended synonym processing |
| 1690 | earthdistance | earthdistance | calculate great-circle distances on the surface of the Earth |
| 3850 | emailaddr | pgemailaddr | Email address type for PostgreSQL |
| 4270 | envvar | envvar | Fetch the value of an environment variable |
| 6370 | explain_ui | pg_explain_ui | easily jump into a visual plan UI for any SQL query |
| 4720 | extra_window_functions | extra_window_functions | Extra Window Functions for PostgreSQL |
| 3210 | faker | faker | Wrapper for the Faker Python library |
| 8980 | file_fdw | file_fdw | foreign-data wrapper for flat file access |
| 4840 | financial | pg_financial | Financial aggregate functions |
| 8750 | firebird_fdw | firebird_fdw | Foreign data wrapper for Firebird |
| 4710 | first_last_agg | first_last_agg | first() and last() aggregate functions |
| 2180 | fuzzystrmatch | fuzzystrmatch | determine similarities and distance between strings |
| 4400 | hashlib | pg_hashlib | Stable hash functions for Postgres |
| 3750 | hashtypes | hashtypes | sha1, md5 and other data types for PostgreSQL |
| 3970 | hstore | hstore | data type for storing sets of (key, value) pairs |
| 3262 | hstore_plperl | plperl | transform between hstore and plperl |
| 3273 | hstore_plperlu | plperlu | transform between hstore and plperlu |
| 3293 | hstore_plpython3u | plpython3u | transform between hstore and plpython3u |
| 2170 | hunspell_cs_cz | hunspell_cs_cz | Czech Hunspell Dictionary |
| 2171 | hunspell_de_de | hunspell_de_de | German Hunspell Dictionary |
| 2172 | hunspell_en_us | hunspell_en_us | en_US Hunspell Dictionary |
| 2173 | hunspell_fr | hunspell_fr | French Hunspell Dictionary |
| 2174 | hunspell_ne_np | hunspell_ne_np | Nepali Hunspell Dictionary |
| 2175 | hunspell_nl_nl | hunspell_nl_nl | Dutch Hunspell Dictionary |
| 2176 | hunspell_nn_no | hunspell_nn_no | Norwegian (norsk) Hunspell Dictionary |
| 2177 | hunspell_pt_pt | hunspell_pt_pt | Portuguese Hunspell Dictionary |
| 2178 | hunspell_ru_ru | hunspell_ru_ru | Russian Hunspell Dictionary |
| 2179 | hunspell_ru_ru_aot | hunspell_ru_ru_aot | Russian Hunspell Dictionary (from AOT.ru group) |
| 2830 | hypopg | hypopg | Hypothetical indexes for PostgreSQL |
| 4240 | icu_ext | icu_ext | Access ICU functions |
| 2860 | imgsmlr | imgsmlr | Image similarity with haar |
| 2840 | index_advisor | index_advisor | Query index advisor |
| 4882 | insert_username | insert_username | functions for tracking who changed a table |
| 4970 | intagg | intagg | integer aggregator and enumerator (obsolete) |
| 4960 | intarray | intarray | functions, operators, and index support for 1-D arrays of integers |
| 3820 | ip4r | ip4r | IPv4/v6 and IPv4/v6 range index type for PostgreSQL |
| 3930 | isn | isn | data types for international product numbering standards |
| 8530 | jdbc_fdw | jdbc_fdw | foreign-data wrapper for remote servers available over JDBC |
| 3263 | jsonb_plperl | plperl | transform between jsonb and plperl |
| 3272 | jsonb_plperlu | plperlu | transform between jsonb and plperlu |
| 3291 | jsonb_plpython3u | plpython3u | transform between jsonb and plpython3u |
| 2810 | jsquery | jsquery | data type for jsonb inspection |
| 8730 | kafka_fdw | kafka_fdw | kafka Foreign Data Wrapper for CSV formatted messages |
| 3611 | l10n_table_dependent_extension | pg_xenophile | PostgreSQL l10n toolbox |
| 5930 | lo | lo | Large Object maintenance |
| 3960 | ltree | ltree | data type for hierarchical tree-like structures |
| 3292 | ltree_plpython3u | plpython3u | transform between ltree and plpython3u |
| 9700 | mimeo | mimeo | Extension for specialized, per-table replication between PostgreSQL instances |
| 4883 | moddatetime | moddatetime | functions for tracking last modification time |
| 8510 | multicorn | multicorn | Fetch foreign data in Python in your PostgreSQL server. |
| 8520 | odbc_fdw | odbc_fdw | Foreign data wrapper for accessing remote databases using ODBC |
| 5960 | old_snapshot | old_snapshot | utilities in support of old_snapshot_threshold |
| 4640 | omnisketch | omnisketch | data structure for on-line agg of data into approximate sketch |
| 8610 | oracle_fdw | oracle_fdw | foreign data wrapper for Oracle access |
| 6900 | pageinspect | pageinspect | inspect the contents of database pages at a low level |
| 7990 | passwordcheck | passwordcheck | checks user passwords and reject weak password |
| 1030 | periods | periods | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING |
| 4550 | permuteseq | permuteseq | Pseudo-randomly permute sequences with a format-preserving encryption on elements |
| 2420 | pg_analytics | pg_analytics | Postgres for analytics, powered by DuckDB |
| 2120 | pg_bigm | pg_bigm | create 2-gram (bigram) index for faster full text search. |
| 6930 | pg_buffercache | pg_buffercache | examine the shared buffer cache |
| 5200 | pg_cheat_funcs | pg_cheat_funcs | Provides cheat (but useful) functions |
| 1070 | pg_cron | pg_cron | Job scheduler for PostgreSQL |
| 9260 | pg_dbms_job | pg_dbms_job | Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL |
| 9250 | pg_dbms_lock | pg_dbms_lock | Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL |
| 9240 | pg_dbms_metadata | pg_dbms_metadata | Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL |
| 5830 | pg_drop_events | pg_drop_events | logs transaction ids of drop table, drop column, drop materialized view statements |
| 4220 | pg_extra_time | pg_extra_time | Some date time functions and operators that, |
| 9530 | pg_failover_slots | pg_failover_slots | PG Failover Slots extension |
| 6950 | pg_freespacemap | pg_freespacemap | examine the free space map (FSM) |
| 4180 | pg_html5_email_address | pg_html5_email_address | PostgreSQL email validation that is consistent with the HTML5 spec |
| 2880 | pg_incremental | pg_incremental | Incremental Processing by Crunchy Data |
| 2870 | pg_ivm | pg_ivm | incremental view maintenance on PostgreSQL |
| 7130 | pg_jobmon | pg_jobmon | Extension for logging and monitoring functions in PostgreSQL |
| 1090 | pg_later | pg_later | Run queries now and get results later |
| 6890 | pg_logicalinspect | pg_logicalinspect | Logical decoding components inspection |
| 5180 | pg_orphaned | pg_orphaned | Deal with orphaned files |
| 6880 | pg_overexplain | pg_overexplain | Allow EXPLAIN to dump even more details |
| 2460 | pg_parquet | pg_parquet | copy data between Postgres and Parquet |
| 2510 | pg_partman | pg_partman | Extension to manage partitioned tables by time or ID |
| 5890 | pg_prewarm | pg_prewarm | prewarm relation data |
| 4300 | pg_readme | pg_readme | Generate a README.md document for a database extension or schema |
| 4301 | pg_readme_test_extension | pg_readme | Test generating a README.md document for extension or schema |
| 5090 | pg_readonly | pg_readonly | cluster database read only |
| 6380 | pg_relusage | pg_relusage | Log all the queries that reference a particular column |
| 6210 | pg_show_plans | pg_show_plans | show query plans of all currently running SQL statements |
| 7170 | pg_snakeoil | pg_snakeoil | The PostgreSQL Antivirus |
| 6990 | pg_stat_statements | pg_stat_statements | track planning and execution statistics of all SQL statements executed |
| 2530 | pg_strom | pg_strom | PG-Strom - big-data processing acceleration using GPU and NVME |
| 1860 | pg_summarize | pg_summarize | Text Summarization using LLMs. Built using pgrx |
| 5990 | pg_surgery | pg_surgery | extension to perform surgery on a damaged relation |
| 6260 | pg_track_settings | pg_track_settings | Track settings changes |
| 2190 | pg_trgm | pg_trgm | text similarity measurement and index searching based on trigrams |
| 5150 | pg_upless | pg_upless | Detect Useless UPDATE |
| 6960 | pg_visibility | pg_visibility | examine the visibility map (VM) and page-level visibility info |
| 6270 | pg_wait_sampling | pg_wait_sampling | sampling based statistics of wait events |
| 6940 | pg_walinspect | pg_walinspect | functions to inspect contents of PostgreSQL Write-Ahead Log |
| 3610 | pg_xenophile | pg_xenophile | More than the bare necessities for PostgreSQL i18n and l10n. |
| 5880 | pgagent | pgagent | A PostgreSQL job scheduler |
| 7080 | pgaudit | pgaudit | provides auditing functionality |
| 7090 | pgauditlogtofile | pgauditlogtofile | pgAudit addon to redirect audit log to an independent file |
| 5120 | pgautofailover | pgautofailover | pg_auto_failover |
| 8650 | pgbouncer_fdw | pgbouncer_fdw | Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions |
| 5170 | pgcozy | pgcozy | Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. |
| 7980 | pgcrypto | pgcrypto | cryptographic functions |
| 7120 | pgcryptokey | pgcryptokey | cryptographic key management |
| 7180 | pgextwlist | pgextwlist | PostgreSQL Extension Whitelisting |
| 9500 | pglogical | pglogical | PostgreSQL Logical Replication |
| 9501 | pglogical_origin | pglogical | Dummy extension for compatibility when upgrading from Postgres 9.4 |
| 9510 | pglogical_ticker | pglogical_ticker | Have an accurate view on pglogical replication delay |
| 2900 | pgmq | pgmq | A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. |
| 9980 | pgoutput | pgoutput | Logical Replication output plugin |
| 4230 | pgpcre | pgpcre | Perl Compatible Regular Expression functions |
| 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 |
| 2110 | pgroonga | pgroonga | Use Groonga as index, fast full text search platform for all languages! |
| 2111 | pgroonga_database | pgroonga | PGroonga database management module |
| 6910 | pgrowlocks | pgrowlocks | show row-level locking information |
| 6280 | pgsentinel | pgsentinel | active session history |
| 8540 | pgspider_ext | pgspider_ext | foreign-data wrapper for remote PGSpider servers |
| 4200 | pgsql_tweaks | pgsql_tweaks | Some functions and views for daily usage |
| 6970 | pgstattuple | pgstattuple | show tuple-level statistics |
| 3200 | pgtap | pgtap | Unit testing for PostgreSQL |
| 2850 | plan_filter | pg_plan_filter | filter statements by their execution plans. |
| 3260 | plperl | plperl | PL/Perl procedural language |
| 3270 | plperlu | plperlu | PL/PerlU untrusted procedural language |
| 3280 | plpgsql | plpgsql | PL/pgSQL procedural language |
| 3290 | plpython3u | plpython3u | PL/Python3U untrusted procedural language |
| 3240 | pltcl | pltcl | PL/Tcl procedural language |
| 3250 | pltclu | pltcl | PL/TclU untrusted procedural language |
| 3010 | plv8 | plv8 | PL/JavaScript (v8) trusted procedural language |
| 8990 | postgres_fdw | postgres_fdw | foreign-data wrapper for remote PostgreSQL servers |
| 6810 | powa | powa | PostgreSQL Workload Analyser-core |
| 5140 | pre_prepare | preprepare | Pre Prepare your Statement server side |
| 3500 | prefix | pg_prefix | Prefix Range module for PostgreSQL |
| 5070 | prioritize | pg_prioritize | get and set the priority of PostgreSQL backends |
| 4780 | random | pg_random | random data generator |
| 8710 | redis_fdw | redis_fdw | Foreign data wrapper for querying a Redis server |
| 4880 | refint | refint | functions for implementing referential integrity (obsolete) |
| 2780 | rum | rum | RUM index access method |
| 3940 | seg | seg | data type for representing line segments or floating-point intervals |
| 3510 | semver | pg_semver | Semantic version data type |
| 7960 | sepgsql | sepgsql | label-based mandatory access control (MAC) based on SELinux security policy. |
| 7160 | set_user | set_user | similar to SET ROLE but with added logging |
| 4440 | shacrypt | shacrypt | Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes |
| 1850 | smlar | smlar | Effective similarity search |
| 8640 | sqlite_fdw | sqlite_fdw | SQLite Foreign Data Wrapper |
| 6920 | sslinfo | sslinfo | information about SSL certificates |
| 7200 | sslutils | sslutils | A Postgres extension for managing SSL certificates through SQL |
| 6290 | system_stats | system_stats | EnterpriseDB system statistics for PostgreSQL |
| 5840 | table_log | table_log | record table modification logs and PITR for table/row |
| 2590 | tablefunc | tablefunc | functions that manipulate whole tables, including crosstab |
| 4920 | tcn | tcn | Triggered change notifications |
| 8620 | tds_fdw | tds_fdw | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) |
| 9970 | test_decoding | test_decoding | SQL-based test/example module for WAL logical decoding |
| 1020 | timeseries | pg_timeseries | Convenience API for time series stack |
| 6360 | toastinfo | toastinfo | show details on toasted datums |
| 4910 | tsm_system_rows | tsm_system_rows | TABLESAMPLE method which accepts number of rows as a limit |
| 4890 | tsm_system_time | tsm_system_time | TABLESAMPLE method which accepts time in milliseconds as a limit |
| 3730 | uint | pguint | unsigned integer types |
| 3740 | uint128 | pg_uint128 | Native uint128 type |
| 4990 | unaccent | unaccent | text search dictionary that removes accents |
| 3840 | uri | pg_uri | URI Data type for PostgreSQL |
| 4190 | url_encode | url_encode | url_encode, url_decode functions |
| 4930 | uuid-ossp | uuid-ossp | generate universally unique identifiers (UUIDs) |
| 1800 | vector | pgvector | vector data type and ivfflat and hnsw access methods |
| 1830 | vectorize | pg_vectorize | The simplest way to do vector search on Postgres |
| 1820 | vectorscale | pgvectorscale | Advanced indexing for vector data with DiskANN |
| 3990 | xml2 | xml2 | XPath querying and XSLT |
| 2130 | zhparser | zhparser | a parser for full-text search of Chinese |
Apache-2.0
Apache-2.0
68 Extensions
Apache-2.0 License Text : Permissive license with patent protection and attribution requirements.
| ID | Extension | Package | Description |
|---|---|---|---|
| 2760 | age | age | AGE graph database extension |
| 8800 | aws_s3 | aws_s3 | aws_s3 postgres extension to import/export data from/to s3 |
| 9300 | babelfishpg_common | babelfishpg_common | SQL Server Transact SQL Datatype Support |
| 9330 | babelfishpg_money | babelfishpg_money | SQL Server Money Data Type |
| 9320 | babelfishpg_tds | babelfishpg_tds | SQL Server TDS protocol extension |
| 9310 | babelfishpg_tsql | babelfishpg_tsql | SQL Server Transact SQL compatibility |
| 3630 | collection | pg_collection | Memory optimized data type to be used inside of plpglsql func |
| 1530 | h3 | pg_h3 | H3 bindings for PostgreSQL |
| 1531 | h3_postgis | pg_h3 | H3 PostGIS integration |
| 2770 | hll | hll | type for storing hyperloglog data |
| 8810 | log_fdw | log_fdw | foreign-data wrapper for Postgres log file access |
| 2951 | omni | omnigres | Advanced adapter for Postgres extensions |
| 2952 | omni_auth | omnigres | Basic session management |
| 2953 | omni_aws | omnigres | Amazon Web Services APIs (S3) |
| 2954 | omni_cloudevents | omnigres | CloudEvents support |
| 2955 | omni_containers | omnigres | Docker container management |
| 2956 | omni_credentials | omnigres | Application credential management |
| 2958 | omni_email | omnigres | E-mail framework |
| 2959 | omni_http | omnigres | Basic HTTP types |
| 2960 | omni_httpc | omnigres | HTTP client |
| 2961 | omni_httpd | omnigres | HTTP server |
| 2962 | omni_id | omnigres | Identity types |
| 2963 | omni_json | omnigres | JSON toolkit |
| 2964 | omni_kube | omnigres | Kubernetes (k8s) integration |
| 2965 | omni_ledger | omnigres | Financial ledger |
| 2966 | omni_manifest | omnigres | Package installation manifests |
| 2967 | omni_mimetypes | omnigres | MIME types |
| 2968 | omni_os | omnigres | Operating system integration |
| 2969 | omni_polyfill | omnigres | Postgres API polyfills |
| 2970 | omni_python | omnigres | First-class Python support |
| 2971 | omni_regex | omnigres | PCRE-compatible regular expressions |
| 2972 | omni_rest | omnigres | REST API toolkit (with PostgREST support) |
| 2973 | omni_schema | omnigres | Advanced schema management tooling |
| 2974 | omni_seq | omnigres | Distributed integer sequences |
| 2975 | omni_service | omnigres | Service management |
| 2976 | omni_session | omnigres | Session management |
| 2977 | omni_sql | omnigres | Programmatic SQL manipulation |
| 2979 | omni_sqlite | omnigres | Embedded SQLite |
| 2980 | omni_test | omnigres | Testing framework |
| 2981 | omni_txn | omnigres | Transaction management |
| 2982 | omni_types | omnigres | Advanced types |
| 2983 | omni_var | omnigres | Scoped variables |
| 2984 | omni_vfs | omnigres | Virtual File System |
| 2985 | omni_vfs_types_v1 | omnigres | Virtual File System types (v1) |
| 2986 | omni_web | omnigres | Common web stack primitives |
| 2987 | omni_worker | omnigres | Generalized worker pool |
| 2988 | omni_xml | omnigres | XML toolkit |
| 2989 | omni_yaml | omnigres | YAML toolkit |
| 2140 | pg_bestmatch | pg_bestmatch | Generate BM25 sparse vector inside PostgreSQL |
| 5050 | pg_cooldown | pg_cooldown | remove buffered pages for specific relations |
| 2790 | pg_graphql | pg_graphql | Add in-database GraphQL support |
| 4500 | pg_idkit | pg_idkit | multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) |
| 2800 | pg_jsonschema | pg_jsonschema | PostgreSQL extension providing JSON Schema validation |
| 4080 | pg_net | pg_net | Async HTTP Requests |
| 5810 | pg_savior | pg_savior | Postgres extension to save OOPS mistakes |
| 7040 | pg_session_jwt | pg_session_jwt | Manage authentication sessions using JWTs |
| 1870 | pg_tiktoken | pg_tiktoken | tiktoken tokenizer for use with OpenAI models in postgres |
| 3000 | pg_tle | pg_tle | Trusted Language Extensions for PostgreSQL |
| 2160 | pg_tokenizer | pg_tokenizer | Tokenizers for full-text search |
| 6310 | pgnodemx | pgnodemx | Capture node OS metrics via SQL queries |
| 3040 | plprql | plprql | Use PRQL in PostgreSQL - Pipelined Relational Query Language |
| 3570 | roaringbitmap | roaringbitmap | support for Roaring Bitmaps |
| 4470 | sparql | pgsparql | Query SPARQL datasource with SQL |
| 7030 | supabase_vault | pg_vault | Supabase Vault Extension |
| 7010 | supautils | supautils | Extension that secures a cluster on a cloud environment |
| 4700 | tdigest | tdigest | Provides tdigest aggregate function. |
| 9640 | wal2mongo | wal2mongo | PostgreSQL logical decoding output plugin for MongoDB |
| 8500 | wrappers | wrappers | Foreign data wrappers developed by Supabase |
MIT
MIT
59 Extensions
MIT License Text : A permissive license that allows commercial use, modification, and private use.
| ID | Extension | Package | Description |
|---|---|---|---|
| 4750 | aggs_for_arrays | aggs_for_arrays | Various functions for computing statistics on arrays of numbers |
| 4740 | aggs_for_vecs | aggs_for_vecs | Aggregate functions for array inputs |
| 4760 | 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 |
| 4020 | bzip | pg_bzip | Bzip compression and decompression |
| 4850 | convert | pg_convert | conversion functions for spatial, routing and other specialized uses |
| 7110 | credcheck | credcheck | credcheck - postgresql plain text credential checker |
| 3620 | currency | pg_currency | Custom PostgreSQL currency type in 1Byte |
| 9650 | decoderbufs | decoderbufs | Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format |
| 9000 | documentdb | documentdb | API surface for DocumentDB for PostgreSQL |
| 9010 | documentdb_core | documentdb | Core API surface for DocumentDB for PostgreSQL |
| 9020 | documentdb_distributed | documentdb | Multi-Node API surface for DocumentDB |
| 2450 | duckdb_fdw | duckdb_fdw | DuckDB Foreign Data Wrapper |
| 4280 | floatfile | floatfile | Simple file storage for arrays of floats |
| 4730 | floatvec | floatvec | Math for vectors (arrays) of numbers |
| 4010 | gzip | pg_gzip | gzip and gunzip functions. |
| 3021 | hstore_pllua | pllua | Hstore transform for Lua |
| 3031 | hstore_plluau | pllua | Hstore transform for untrusted Lua |
| 4070 | http | pg_http | HTTP client for PostgreSQL, allows web page retrieval inside the database. |
| 1550 | ogr_fdw | ogr_fdw | foreign-data wrapper for GIS data access |
| 6800 | pagevis | pagevis | Visualise database pages in ascii code |
| 7100 | pg_auth_mon | pg_auth_mon | monitor connection attempts per user |
| 4830 | pg_base58 | pg_base58 | Base58 Encoder/Decoder Extension for PostgreSQL |
| 2930 | pg_cardano | pg_cardano | A suite of Cardano-related tools |
| 4090 | pg_curl | pg_curl | Run curl actions for data transfer in URL syntax |
| 2430 | pg_duckdb | pg_duckdb | DuckDB Embedded in Postgres |
| 3830 | pg_duration | pg_duration | data type for representing durations |
| 9820 | pg_fact_loader | pg_fact_loader | build fact tables with Postgres |
| 1590 | pg_geohash | pg_geohash | Handle geohash based functionality for spatial coordinates |
| 4560 | pg_hashids | pg_hashids | Short unique id generator for PostgreSQL, using hashids |
| 2440 | pg_mooncake | pg_mooncake | Columnstore Table in Postgres |
| 1570 | pg_polyline | pg_polyline | Fast Google Encoded Polyline encoding & decoding for postgres |
| 4260 | pg_protobuf | pg_protobuf | Protobuf support for PostgreSQL |
| 3720 | pg_rational | pg_rational | bigint fractions |
| 4290 | pg_render | pg_render | Render HTML in SQL |
| 3880 | pg_rrule | pg_rrule | RRULE field type for PostgreSQL |
| 4170 | pg_smtp_client | pg_smtp_client | PostgreSQL extension to send email using SMTP |
| 1080 | pg_task | pg_task | execute any sql command at any specific time at background |
| 7060 | pg_tde | pg_tde | pg_tde access method |
| 6010 | pg_tracing | pg_tracing | Distributed Tracing for PostgreSQL |
| 5100 | pgdd | pgdd | Introspect pg data dictionary via standard SQL |
| 4150 | pgjq | pgjq | Use jq in Postgres |
| 4160 | pgjwt | pgjwt | JSON Web Token API for Postgresql |
| 9520 | pgl_ddl_deploy | pgl_ddl_deploy | automated ddl deployment using pglogical |
| 3540 | pglite_fusion | pglite_fusion | Embed an SQLite database in your PostgreSQL table |
| 9410 | pgmemcache | pgmemcache | memcached interface |
| 6350 | pgmeminfo | pgmeminfo | show memory usage |
| 1890 | pgml | pgml | Run AL/ML workloads with SQL interface |
| 7070 | pgsmcrypto | pgsmcrypto | PostgreSQL SM Algorithm Extension |
| 4510 | pgx_ulid | pgx_ulid | ulid type and methods |
| 3020 | pllua | pllua | Lua as a procedural language |
| 3030 | plluau | pllua | Lua as an untrusted procedural language |
| 3060 | plpgsql_check | plpgsql_check | extended check for plpgsql functions |
| 3080 | plsh | plsh | PL/sh procedural language |
| 8720 | redis | pg_redis_pubsub | Send redis pub/sub messages to Redis from PostgreSQL Directly |
| 4570 | sequential_uuids | sequential_uuids | generator of sequential UUIDs |
| 3890 | timestamp9 | timestamp9 | timestamp nanosecond resolution |
| 1680 | tzf | pg_tzf | Fast lookup timezone name by GPS coordinates |
BSD 3-Clause
BSD 3-Clause
30 Extensions
BSD 3-Clause License Text : Permissive license with attribution and endorsement restriction clauses.
| ID | Extension | Package | Description |
|---|---|---|---|
| 9540 | db_migrator | db_migrator | Tools to migrate other databases to PostgreSQL |
| 5230 | fio | pg_fio | PostgreSQL File I/O Functions |
| 8740 | hdfs_fdw | hdfs_fdw | foreign-data wrapper for remote hdfs servers |
| 7140 | logerrors | logerrors | Function for collecting statistics about messages in logfile |
| 8600 | mysql_fdw | mysql_fdw | Foreign data wrapper for querying a MySQL server |
| 7190 | pg_auditor | pg_auditor | Audit data changes and provide flashback ability |
| 9830 | pg_bulkload | pg_bulkload | pg_bulkload is a high speed data loading utility for PostgreSQL |
| 5130 | pg_catcheck | pg_catcheck | Diagnosing system catalog corruption |
| 5190 | pg_crash | pg_crash | Send random signals to random processes |
| 5030 | pg_dirtyread | pg_dirtyread | Read dead but unvacuumed rows from table |
| 2820 | pg_hint_plan | pg_hint_plan | Give PostgreSQL ability to manually force some decisions in execution plans. |
| 6320 | pg_proctab | pgnodemx | PostgreSQL extension to access the OS process table |
| 6240 | pg_qualstats | pg_qualstats | An extension collecting statistics about quals |
| 5010 | pg_repack | pg_repack | Reorganize tables in PostgreSQL databases with minimal locks |
| 1840 | pg_similarity | pg_similarity | support similarity queries |
| 3590 | pg_sphere | pgsphere | spherical objects with useful functions, operators and index support |
| 6330 | pg_sqlog | pg_sqlog | Provide SQL interface to logs |
| 6220 | pg_stat_kcache | pg_stat_kcache | Kernel statistics gathering |
| 6230 | pg_stat_monitor | 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. |
| 6250 | pg_store_plans | pg_store_plans | track plan statistics of all SQL statements executed |
| 3580 | pgfaceting | pgfaceting | fast faceting queries using an inverted index |
| 5040 | pgfincore | pgfincore | examine and manage the os buffer cache |
| 4250 | pgqr | pgqr | QR Code generator from PostgreSQL |
| 7020 | pgsodium | pgsodium | Postgres extension for libsodium functions |
| 3090 | pljava | pljava | PL/Java procedural language |
| 1520 | pointcloud | pointcloud | data type for lidar point clouds |
| 1521 | pointcloud_postgis | pointcloud | integration for pointcloud LIDAR data and PostGIS geometry data |
| 2940 | rdkit | rdkit | Cheminformatics functionality for PostgreSQL. |
| 1060 | table_version | table_version | PostgreSQL table versioning extension |
| 9630 | wal2json | wal2json | Changing data capture in JSON format |
BSD 2-Clause
BSD 2-Clause
14 Extensions
BSD 2-Clause License Text : Permissive license requiring attribution but allowing commercial use.
| ID | Extension | Package | Description |
|---|---|---|---|
| 3860 | acl | pg_acl | ACL Data type |
| 4630 | count_distinct | count_distinct | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate |
| 1560 | geoip | geoip | IP-based geolocation query |
| 4620 | lower_quantile | lower_quantile | Lower quantile aggregate function |
| 3550 | md5hash | md5hash | type for storing 128-bit binary data inline |
| 6300 | meta | pg_meta | Normalized, friendlier system catalog for PostgreSQL |
| 5080 | pg_checksums | pg_checksums | Activate/deactivate/verify checksums in offline Postgres clusters |
| 5110 | pg_permissions | pg_permissions | view object permissions and compare them with the desired state |
| 6000 | pg_profile | pg_profile | PostgreSQL load profile repository and report builder |
| 5020 | pg_squeeze | pg_squeeze | A tool to remove unused space from a relation. |
| 4460 | pguecc | pg_ecdsa | uECC bindings for Postgres |
| 4610 | quantile | quantile | Quantile aggregation function |
| 1040 | temporal_tables | temporal_tables | temporal tables |
| 4430 | xxhash | pg_xxhash | xxhash functions for PostgreSQL |
GPL-2.0
GPL-2.0
14 Extensions
GPL-2.0 License Text : Strong copyleft license requiring derivative works to be open source.
| ID | Extension | Package | Description |
|---|---|---|---|
| 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 |
| 4310 | ddl_historization | ddl_historization | Historize the ddl changes inside PostgreSQL database |
| 3710 | numeral | numeral | numeral datatypes extension |
| 2500 | pg_fkpart | pg_fkpart | Table partitioning by foreign key utility |
| 1510 | pgrouting | pgrouting | pgRouting Extension |
| 3100 | plr | plr | load R interpreter and execute R script from within a database |
| 1500 | postgis | postgis | PostGIS geometry and geography 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 |
| 1501 | postgis_topology | postgis | PostGIS topology spatial types and functions |
| 1540 | q3c | q3c | q3c sky indexing plugin |
| 3520 | unit | pgunit | SI units extension |
GPL-3.0
GPL-3.0
12 Extensions
GPL-3.0 License Text : Strong copyleft license with additional patent and hardware restrictions.
| ID | Extension | Package | Description |
|---|---|---|---|
| 3560 | asn1oid | asn1oid | asn1oid extension |
| 1050 | emaj | emaj | Enables fine-grained write logging and time travel on subsets of the database. |
| 7150 | login_hook | login_hook | login_hook - hook to execute login_hook.login() at login time |
| 1650 | mobilitydb | mobilitydb | MobilityDB geospatial trajectory data management & analysis platform |
| 1100 | pg_background | pg_background | Run SQL queries in the background |
| 4770 | pg_math | pg_math | GSL statistical functions for postgresql |
| 3530 | pgpdf | pgpdf | PDF type with meta admin & Full-Text Search |
| 9710 | repmgr | repmgr | Replication manager for PostgreSQL |
| 4330 | schedoc | pg_schedoc | Cross documentation between Django and DBT projects |
| 9120 | session_variable | session_variable | Registration and manipulation of session variables and constants |
| 4660 | vasco | vasco | discover hidden correlations in your data with MIC |
| 4670 | xicor | pgxicor | XI Correlation Coefficient in Postgres |
AGPL-3.0
AGPL-3.0
10 Extensions
AGPL-3.0 License Text : Network copyleft license extending GPL to cover network-distributed software.
| ID | Extension | Package | Description |
|---|---|---|---|
| 2400 | citus | citus | Distributed PostgreSQL as an extension |
| 2401 | citus_columnar | citus | Citus columnar storage engine |
| 2410 | columnar | hydra | Hydra Columnar extension |
| 7210 | noset | pg_noset | Module for blocking SET variables for non-super users. |
| 1880 | pg4ml | pg4ml | Machine learning framework for PostgreSQL |
| 2100 | pg_search | pg_search | Full text search for PostgreSQL using BM25 |
| 9400 | spat | spat | Redis-like In-Memory DB Embedded in Postgres |
| 4600 | topn | topn | type for top-n JSONB |
| 1810 | vchord | vchord | Vector database plugin for Postgres, written in Rust |
| 2150 | vchord_bm25 | vchord_bm25 | A postgresql extension for bm25 ranking algorithm |
ISC
ISC
5 Extensions
ISC License Text : A permissive license similar to MIT, allowing commercial use and modification.
| ID | Extension | Package | Description |
|---|---|---|---|
| 9130 | pg_statement_rollback | pg_statement_rollback | Server side rollback at statement level for PostgreSQL like Oracle or DB2 |
| 2910 | pgq | pgq | Generic queue for PostgreSQL |
| 9110 | pgtt | pgtt | Extension to add Global Temporary Tables feature to PostgreSQL |
| 5820 | safeupdate | safeupdate | Require criteria for UPDATE and DELETE |
| 4030 | zstd | pg_zstd | Zstandard compression algorithm implementation in PostgreSQL |
Artistic
Artistic
3 Extensions
Artistic License Text : Copyleft license allowing modification with certain distribution requirements.
| ID | Extension | Package | Description |
|---|---|---|---|
| 3220 | dbt2 | dbt2 | OSDL-DBT-2 test kit |
| 3050 | pldbgapi | pldebugger | server-side support for debugging PL/pgSQL functions |
| 3070 | plprofiler | plprofiler | server-side support for profiling PL/pgSQL functions |
Timescale
Timescale
2 Extensions
Timescale License Text : Proprietary license with restrictions on commercial use and distribution.
| ID | Extension | Package | Description |
|---|---|---|---|
| 1000 | timescaledb | timescaledb | Enables scalable inserts and complex queries for time-series data |
| 1010 | timescaledb_toolkit | timescaledb_toolkit | Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities |
BSD 0-Clause
BSD 0-Clause
2 Extensions
BSD 0-Clause License Text : Public domain equivalent license with no restrictions on use.
| ID | Extension | Package | Description |
|---|---|---|---|
| 9100 | orafce | orafce | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS |
| 2520 | plproxy | plproxy | Database partitioning implemented as procedural language |
LGPL-3.0
LGPL-3.0
2 Extensions
LGPL-3.0 License Text : Weak copyleft license with additional patent and hardware provisions.
| ID | Extension | Package | Description |
|---|---|---|---|
| 8700 | mongo_fdw | mongo_fdw | foreign data wrapper for MongoDB access |
| 3700 | pgmp | pgmp | Multiple Precision Arithmetic extension |
MPL-2.0
MPL-2.0
1 Extensions
MPL-2.0 License Text : Weak copyleft license allowing proprietary combinations with file-level copyleft.
LGPL-2.1
LGPL-2.1
1 Extensions
LGPL-2.1 License Text : Weak copyleft license allowing proprietary applications to link dynamically.
| ID | Extension | Package | Description |
|---|---|---|---|
| 7000 | passwordcheck_cracklib | passwordcheck | Strengthen PostgreSQL user password checks with cracklib |