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