Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
95 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| vector | 0.8.6 | vector data type and ivfflat and hnsw access methods | RAG | PostgreSQL | C | 14–18 | 23k |
| pg_cron | 1.6.8 | Job scheduler for PostgreSQL | TIME | PostgreSQL | C | 14–18 | 3.9k |
| pg_partman | 5.5.0 | Extension to manage partitioned tables by time or ID | OLAP | PostgreSQL | C | 14–18 | 2.8k |
| pg_repack | 1.5.3 | Reorganize tables in PostgreSQL databases with minimal locks | ADMIN | PostgreSQL | C | 14–18 | 2.3k |
| repmgr | 5.5.0 | Replication manager for PostgreSQL | ETL | GPL-3.0 | C | 14–18 | 1.7k |
| hypopg | 1.4.3 | Hypothetical indexes for PostgreSQL | FEAT | PostgreSQL | C | 14–18 | 1.7k |
| pgaudit | 18.0 | provides auditing functionality | SEC | PostgreSQL | C | 14–18 | 1.7k |
| http | 1.7.2 | HTTP client for PostgreSQL, allows web page retrieval inside the database. | UTIL | MIT | C | 14–18 | 1.6k |
| wal2json | 2.6 | Changing data capture in JSON format | ETL | BSD-3-Clause | C | 14–18 | 1.5k |
| pgrouting | 4.0.2 | pgRouting Extension | GIS | GPL-2.0 | C++ | 14–18 | 1.4k |
| pg_strom | 6.1 | PG-Strom - big-data processing acceleration using GPU and NVME | OLAP | PostgreSQL | C | 15–18 | 1.4k |
| pgautofailover | 2.2 | pg_auto_failover | ADMIN | PostgreSQL | C | 14–18 | 1.4k |
| pglogical | 2.4.8 | PostgreSQL Logical Replication | ETL | PostgreSQL | C | 14–18 | 1.2k |
| pglogical_origin | 2.4.7 | Dummy extension for compatibility when upgrading from Postgres 9.4 | ETL | PostgreSQL | C | 14–18 | 1.2k |
| hll | 2.21 | type for storing hyperloglog data | FEAT | Apache-2.0 | C++ | 14–18 | 1.2k |
| pgtap | 1.3.4 | Unit testing for PostgreSQL | LANG | PostgreSQL | C | 14–18 | 1.2k |
| pg_hint_plan | 1.8.0 | Give PostgreSQL ability to manually force some decisions in execution plans. | FEAT | BSD-3-Clause | C | 14–18 | 913 |
| jsquery | 1.2 | data type for jsonb inspection | FEAT | PostgreSQL | C | 14–18 | 710 |
| pg_squeeze | 1.9.4 | A tool to remove unused space from a relation. | ADMIN | BSD-2-Clause | C | 14–18 | 691 |
| pgsodium | 3.1.11 | Postgres extension for libsodium functions | SEC | BSD-3-Clause | C | 14–18 | 611 |
| mysql_fdw | 2.9.3 | Foreign data wrapper for querying a MySQL server | FDW | BSD-3-Clause | C | 14–18 | 599 |
| oracle_fdw | 2.9.0 | foreign data wrapper for Oracle access | FDW | PostgreSQL | C | 14–18 | 551 |
| orafce | 4.16.10 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | SIM | 0BSD | C | 14–18 | 541 |
| tds_fdw | 2.0.5 | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) | FDW | PostgreSQL | C | 14–18 | 432 |
| pointcloud | 1.2.5 | data type for lidar point clouds | GIS | BSD-3-Clause | C | 14–18 | 426 |
| pointcloud_postgis | 1.2.5 | integration for pointcloud LIDAR data and PostGIS geometry data | GIS | BSD-3-Clause | C | 14–18 | 426 |
| pgq | 3.5.1 | Generic queue for PostgreSQL | FEAT | ISC | C | 14–18 | 425 |
| h3 | 4.5.0 | H3 bindings for PostgreSQL | GIS | Apache-2.0 | C | 14–18 | 381 |
| h3_postgis | 4.5.0 | H3 PostGIS integration | GIS | Apache-2.0 | C | 14–18 | 381 |
| mongo_fdw | 5.5.3 | foreign data wrapper for MongoDB access | FDW | LGPL-3.0 | C | 14–18 | 343 |
| pg_qualstats | 2.1.4 | An extension collecting statistics about quals | STAT | BSD-3-Clause | C | 14–18 | 340 |
| roaringbitmap | 1.2.0 | support for Roaring Bitmaps | TYPE | Apache-2.0 | C | 14–18 | 287 |
| unit | 7.10 | SI units extension | TYPE | GPL-2.0 | C | 14–18 | 280 |
| pg_stat_kcache | 2.3.2 | Kernel statistics gathering | STAT | BSD-3-Clause | C | 14–18 | 277 |
| pljava | 1.6.10 | PL/Java procedural language | LANG | BSD-3-Clause | Java | 14–18 | 271 |
| ogr_fdw | 1.1.9 | foreign-data wrapper for GIS data access | GIS | MIT | C | 14–18 | 264 |
| sqlite_fdw | 2.5.0 | SQLite Foreign Data Wrapper | FDW | PostgreSQL | C | 14–18 | 262 |
| decoderbufs | 3.6.0 | Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format | ETL | MIT | C | 14–18 | 260 |
| pg_background | 2.0.2 | Run SQL queries in the background | TIME | GPL-3.0 | C | 14–18 | 254 |
| topn | 2.7.1 | type for top-n JSONB | FUNC | AGPL-3.0 | C | 14–18 | 249 |
| pg_show_plans | 2.1.8 | show query plans of all currently running SQL statements | STAT | PostgreSQL | C | 14–18 | 208 |
| plsh | 1.20220917 | PL/sh procedural language | LANG | MIT | C | 14–18 | 178 |
| pgmemcache | 2.3.0 | memcached interface | SIM | MIT | C | 14–18 | 175 |
| semver | 0.41.0 | Semantic version data type | TYPE | PostgreSQL | C | 14–18 | 168 |
| pg_permissions | 1.4.1 | view object permissions and compare them with the desired state | ADMIN | BSD-2-Clause | SQL | 14–18 | 167 |
| ip4r | 2.4.3 | IPv4/v6 and IPv4/v6 range index type for PostgreSQL | TYPE | PostgreSQL | C | 14–18 | 166 |
| safeupdate | 1.5 | Require criteria for UPDATE and DELETE | ADMIN | ISC | C | 14–18 | 153 |
| plr | 8.4.8.6 | load R interpreter and execute R script from within a database | LANG | GPL-2.0 | C | 14–18 | 128 |
| multicorn | 3.2 | Fetch foreign data in Python in your PostgreSQL server. | FDW | PostgreSQL | C | 14–18 | 116 |
| pgfincore | 1.4.0 | examine and manage the os buffer cache | ADMIN | BSD-3-Clause | C | 14–18 | 111 |