Explore 2392 PostgreSQL extensions from PGEXT, maintained by Pigsty.
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_kalam | 0.5.5-rc.1 | KalamDB PostgreSQL extension and FDW callback layer for SQL access to KalamDB. | FDW | Apache-2.0 | Rust | 13–18 | 50 |
| pg_tm_aux | 1.1.1 | Transfer manager auxiliary functions | ETL | — | C | — | 50 |
| prometheus_fdw | 0.2.1 | A Rust/pgrx foreign data wrapper that queries Prometheus metrics through PostgreSQL foreign tables. | FDW | PostgreSQL | Rust | 14–17 | 50 |
| temporal | 0.7.1 | C extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support. | TIME | PostgreSQL | C | — | 50 |
| doom | 0.0.1 | DOOM in the terminal with curses | FEAT | — | C++ | — | 49 |
| git_fdw | 1.1.0 | PostgreSQL Git Foreign Data Wrapper | FDW | MIT | C | 10–18 | 49 |
| plsci | 1.0 | PostgreSQL procedural language handler for Clojure via SCI | LANG | EPL-1.0 | Rust | — | 49 |
| coldfront | 1.0 | Transparent hot and cold tiering between PostgreSQL partitions and writable Apache Iceberg tables | OLAP | PostgreSQL | C | 16–18 | 48 |
| lolor | 1.2.2 | Logical-replication-friendly replacement for PostgreSQL large objects | ETL | PostgreSQL | C | 15–18 | 48 |
| ch_fdw | 1.0 | Foreign data wrapper for federated access from PostgreSQL to ClickHouse. | FDW | MIT | C | 13 | 47 |
| pg-audit-json | 1.0.2 | Trigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs. | SEC | PostgreSQL | SQL | 10–18 | 47 |
| pgh_consistency | 6.6 | Pfafstetter consistency checks for PgHydro | GIS | GPL-2.0 | SQL | 14–18 | 47 |
| pgh_hgm | 2.2.6 | Hydrogeomorphological analysis extension for PgHydro | GIS | GPL-2.0 | SQL | 14–18 | 47 |
| pgh_output | 6.6 | Output and reporting objects for PgHydro | GIS | GPL-2.0 | SQL | 14–18 | 47 |
| pgh_output_en_au | 6.6 | Australian English output pack for PgHydro | GIS | GPL-2.0 | SQL | 14–18 | 47 |
| pgh_output_pt_br | 6.6 | Brazilian Portuguese output pack for PgHydro | GIS | GPL-2.0 | SQL | 14–18 | 47 |
| pgh_raster | 6.6 | Raster hydrology extension for PgHydro | GIS | GPL-2.0 | SQL | 14–18 | 47 |
| pghydro | 6.6 | Drainage network analysis core for PostgreSQL and PostGIS | GIS | GPL-2.0 | SQL | 14–18 | 47 |
| emailaddr | 0 | Email address type for PostgreSQL | TYPE | — | C | 14–18 | 46 |
| pg_rewrite | 2.2 | Tool allows read write to the table during the rewriting | ADMIN | BSD-3-Clause | C | 14–18 | 46 |
| pg_when | 0.1.10 | Natural language time parsing for PostgreSQL | TIME | MIT | Rust | 13–18 | 46 |
| pre_prepare | 0.9 | Pre Prepare your Statement server side | ADMIN | PostgreSQL | C | 14–18 | 46 |
| pg_tokenizer | 0.1.1 | Tokenizers for full-text search | FTS | Apache-2.0 | Rust | 14–18 | 45 |
| scan | 1.0 | Visual Studio Code - Development Container - PostgreSQL | FEAT | Apache-2.0 | C | — | 45 |
| pg_ferroid | 2.0.0 | PostgreSQL ULID type and generation functions backed by ferroid | TYPE | MIT | Rust | 13–18 | 44 |
| pgclone | 4.4.2 | Clone PostgreSQL databases, schemas, tables, and functions across environments | ETL | PostgreSQL | C | 14–18 | 44 |
| postgraph | 0.1.0 | All in One Graph Extension for Postgres | FEAT | AGPL-3.0 | C | — | 44 |
| firebird_fdw | 1.4.2 | Foreign data wrapper for Firebird | FDW | PostgreSQL | C | 14–18 | 43 |
| pg_dbms_job | 2.0 | Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL | SIM | PostgreSQL | C | 14–18 | 43 |
| zstd | 1.1.2 | Zstandard compression algorithm implementation in PostgreSQL | UTIL | ISC | C | 14–18 | 43 |
| pgpu | 2.1.0 | GPU acceleration for PostgreSQL vector index builds using NVIDIA CUDA/cuVS and VectorChord. | RAG | AGPL-3.0 | Rust | 14–18 | 42 |
| external_file | 1.2 | Access external server-side files through PostgreSQL functions | UTIL | PostgreSQL | SQL | 14–18 | 41 |
| monetdb_fdw | 0.0 | MonetDB foreign data wrapper | FDW | PostgreSQL | C | — | 41 |
| pg_cjk_parser | 0.1.0 | CJK bigram parser derived from PostgreSQL full-text search | FTS | PostgreSQL | C | 14–18 | 41 |
| pg_scws | 1.0 | a parser for full-text search of Chinese | FTS | BSD-3-Clause | C | — | 41 |
| thai_parser | 1.0.0 | Thai-language parser and text search configuration for PostgreSQL full-text search. | FTS | — | C | 10–18 | 41 |
| jalali_utils | 0.0.1 | Convert Gregorian dates and timestamps to Jalali calendar values. | TIME | — | C | 12–18 | 40 |
| pg_roast | 1.0 | Opinionated PostgreSQL database auditor | SEC | PostgreSQL | C | 14–18 | 40 |
| yezzey | 1.8.11 | Offload Greenplum and Cloudberry append-only tables to S3 | OLAP | PostgreSQL | C++ | — | 40 |
| bigtable | 0.1.0 | Rust PostgreSQL FDW for Google Bigtable | FDW | MIT | Rust | 10–18 | 39 |
| eaggr | 2.0 | The OpenEAGGR software library is an implementation of a Discrete Global Grid System (DGGS) which models the Earth's surface as a network of equal area cells. | GIS | LGPL-3.0 | C++ | — | 39 |
| kt_fdw | 0.0.1 | Foreign data wrapper for reading and writing Kyoto Tycoon key-value stores. | FDW | MIT | C | — | 39 |
| mysqlcompat | 0.0.7 | MySQL compatibility functions, aggregates, operators, and casts for PostgreSQL porting. | SIM | — | SQL | — | 39 |
| permuteseq | 1.2.2 | Pseudo-randomly permute sequences with a format-preserving encryption on elements | FUNC | PostgreSQL | C | 14–18 | 39 |
| pg_cheat_funcs | 1.0 | Provides cheat (but useful) functions | ADMIN | PostgreSQL | C | 14–18 | 39 |
| quantile | 1.1.8 | Quantile aggregation function | FUNC | BSD-2-Clause | C | 14–18 | 39 |
| aggs_for_vecs | 1.4.1 | Aggregate functions for array inputs | FUNC | MIT | C | 14–18 | 38 |
| xataid_extension | 0.0.0 | Generate Xata-style rec_ identifiers with a 20-character lowercase alphanumeric suffix. | FUNC | MPL-2.0 | Rust | — | 38 |
| clerk_fdw | 0.3.3 | Foreign data wrapper for querying the Clerk user-management API from PostgreSQL. | FDW | PostgreSQL | Rust | 14–17 | 37 |
| dynamodb_fdw | 1.1 | Foreign data wrapper for querying and modifying Amazon DynamoDB tables from PostgreSQL. | FDW | PostgreSQL | C | 13–17 | 37 |