Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
66 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| rdkit | 202503.6 | Cheminformatics functionality for PostgreSQL. | FEAT | BSD-3-Clause | C++ | 14–18 | 3.6k |
| pg_ivm | 1.15 | incremental view maintenance on PostgreSQL | FEAT | PostgreSQL | C | 14–18 | 1.5k |
| rum | 1.3.15 | RUM index access method | FEAT | PostgreSQL | C | 14–18 | 840 |
| mobilitydb | 1.3.0 | MobilityDB geospatial trajectory data management & analysis platform | GIS | PostgreSQL | C | 14–18 | 624 |
| mobilitydb_datagen | 1.3.0 | MobilityDB random data generator functions | GIS | PostgreSQL | SQL | 14–18 | 624 |
| pg_uuidv7 | 1.7.0 | Create UUIDv7 values in postgres | FUNC | MPL-2.0 | C | 14–18 | 430 |
| pg_similarity | 1.0 | support similarity queries | RAG | BSD-3-Clause | C | 14–18 | 402 |
| uint | 1.20250815 | unsigned integer types | TYPE | PostgreSQL | C | 14–18 | 342 |
| pg_profile | 4.16 | PostgreSQL load profile repository and report builder | STAT | BSD-2-Clause | C | 14–18 | 312 |
| sequential_uuids | 1.0.3 | generator of sequential UUIDs | FUNC | MIT | C | 14–18 | 310 |
| pg_rational | 0.0.3 | bigint fractions | TYPE | MIT | C | 14–18 | 257 |
| pljs | 1.0.5 | PL/JS trusted procedural language | LANG | PostgreSQL | C | 14–18 | 224 |
| pg_jobmon | 1.4.1 | Extension for logging and monitoring functions in PostgreSQL | SEC | PostgreSQL | SQL | 14–18 | 203 |
| plproxy | 2.12.0 | Database partitioning implemented as procedural language | OLAP | ISC | C | 14–18 | 198 |
| pgsentinel | 1.4.2 | active session history | STAT | PostgreSQL | C | 14–18 | 190 |
| pgfaceting | 0.2.0 | fast faceting queries using an inverted index | TYPE | BSD-3-Clause | SQL | 14–18 | 181 |
| pg_wait_sampling | 1.1.11 | sampling based statistics of wait events | STAT | PostgreSQL | C | 14–18 | 180 |
| system_stats | 4.1 | EnterpriseDB system statistics for PostgreSQL | STAT | PostgreSQL | C | 14–18 | 179 |
| pg_rrule | 0.3.0 | RRULE field type for PostgreSQL | TYPE | MIT | C | 14–18 | 175 |
| pg_dirtyread | 2.8 | Read dead but unvacuumed rows from table | ADMIN | BSD-3-Clause | C | 14–18 | 165 |
| hstore_pllua | 2.0.12 | Hstore transform for Lua | LANG | MIT | C | 14–18 | 161 |
| hstore_plluau | 2.0.12 | Hstore transform for untrusted Lua | LANG | MIT | C | 14–18 | 161 |
| pllua | 2.0.12 | Lua as a procedural language | LANG | MIT | C | 14–18 | 161 |
| plluau | 2.0.12 | Lua as an untrusted procedural language | LANG | MIT | C | 14–18 | 161 |
| ddlx | 0.31 | DDL eXtractor functions | ADMIN | PostgreSQL | SQL | 14–18 | 156 |
| pg_bigm | 1.2 | create 2-gram (bigram) index for faster full text search. | FTS | PostgreSQL | C | 14–18 | 152 |
| hdfs_fdw | 2.0.5 | foreign-data wrapper for remote hdfs servers | FDW | PostgreSQL | C | 14–18 | 141 |
| timestamp9 | 1.4.0 | timestamp nanosecond resolution | TYPE | MIT | C | 14–18 | 95 |
| gzip | 1.1.0 | gzip and gunzip functions. | UTIL | MIT | C | 14–18 | 88 |
| count_distinct | 3.0.2 | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate | FUNC | BSD-2-Clause | C | 14–18 | 80 |
| jdbc_fdw | 1.2 | foreign-data wrapper for remote servers available over JDBC | FDW | PostgreSQL | C | 14–18 | 79 |
| mimeo | 1.5.1 | Extension for specialized, per-table replication between PostgreSQL instances | ETL | PostgreSQL | SQL | 14–18 | 79 |
| pg_store_plans | 1.10 | track plan statistics of all SQL statements executed | STAT | BSD-3-Clause | C | 14–18 | 69 |
| table_version | 1.11.1 | PostgreSQL table versioning extension | TIME | BSD-3-Clause | SQL | 14–18 | 68 |
| pg_statement_rollback | 1.6 | Server side rollback at statement level for PostgreSQL like Oracle or DB2 | SIM | ISC | C | 14–18 | 56 |
| geoip | 0.3.0 | IP-based geolocation query | GIS | BSD-2-Clause | SQL | 14–18 | 52 |
| pg_rewrite | 2.2 | Tool allows read write to the table during the rewriting | ADMIN | BSD-3-Clause | C | 14–18 | 46 |
| pre_prepare | 0.9 | Pre Prepare your Statement server side | ADMIN | PostgreSQL | C | 14–18 | 46 |
| pg_dbms_job | 2.0 | Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL | SIM | PostgreSQL | C | 14–18 | 43 |
| logerrors | 2.1.5 | Function for collecting statistics about messages in logfile | SEC | BSD-3-Clause | C | 14–18 | 37 |
| pgbouncer_fdw | 1.4.0 | Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions | FDW | PostgreSQL | SQL | 14–18 | 36 |
| first_last_agg | 0.1.4 | first() and last() aggregate functions | FUNC | PostgreSQL | C | 14–18 | 34 |
| login_hook | 1.7 | login_hook - hook to execute login_hook.login() at login time | SEC | GPL-3.0 | C | 14–18 | 33 |
| pg_csv | 1.0.2 | Flexible CSV processing for Postgres | FUNC | MIT | C | 14–18 | 30 |
| pgpcre | 0.20190509 | Perl Compatible Regular Expression functions | UTIL | PostgreSQL | C | 14–18 | 30 |
| pg_auth_mon | 3.0 | monitor connection attempts per user | SEC | MIT | C | 14–18 | 28 |
| pg_snakeoil | 1.4 | The PostgreSQL Antivirus | SEC | PostgreSQL | C | 14–18 | 25 |
| pg_sphere | 1.5.2 | spherical objects with useful functions, operators and index support | TYPE | BSD-3-Clause | C | 14–18 | 25 |
| faker | 0.5.3 | Wrapper for the Faker Python library | LANG | PostgreSQL | Python | 14–18 | 24 |
| pg_readonly | 1.0.6 | cluster database read only | ADMIN | PostgreSQL | C | 14–18 | 19 |