Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| tdigest | 1.4.6 | Provides tdigest aggregate function. | FUNC | Apache-2.0 | C | 14–18 | 98 |
| datasketches | 1.7.0 | Approximate analytics sketches and aggregates for PostgreSQL | FUNC | Apache-2.0 | C++ | 14–18 | 96 |
| pg_libphonenumber | 0.1.0 | Adds a packed phone-number type and parsing functions backed by Google libphonenumber. | TYPE | Apache-2.0 | C++ | — | 96 |
| plan_filter | 0.0.1 | filter statements by their execution plans. | FEAT | PostgreSQL | C | 14–18 | 96 |
| snowflake | 2.5.0 | Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL | FUNC | PostgreSQL | C | 15–18 | 95 |
| timestamp9 | 1.4.0 | timestamp nanosecond resolution | TYPE | MIT | C | 14–18 | 95 |
| pldbgapi | 1.10 | server-side support for debugging PL/pgSQL functions | LANG | Artistic-2.0 | C | 14–18 | 94 |
| pgmonitor | 2.2.0 | Collector-friendly metric views and background refresh worker | STAT | Apache-2.0 | C | 14–18 | 93 |
| emaj | 5.0.0 | Enables fine-grained write logging and time travel on subsets of the database. | TIME | GPL-3.0 | SQL | 14–18 | 92 |
| acl | 1.0.4 | ACL Data type | TYPE | BSD-2-Clause | C | 14–18 | 90 |
| q3c | 2.0.5 | q3c sky indexing plugin | GIS | GPL-2.0 | C | 14–18 | 90 |
| gitgres | 0.1 | Store Git objects and refs in PostgreSQL tables with SQL functions and a native git_oid type. | FEAT | MIT | C | — | 88 |
| gzip | 1.1.0 | gzip and gunzip functions. | UTIL | MIT | C | 14–18 | 88 |
| supautils | 3.2.1 | Extension that secures a cluster on a cloud environment | SEC | Apache-2.0 | C | 14–18 | 88 |
| pg_catcheck | 1.6.0 | Diagnosing system catalog corruption | ADMIN | BSD-3-Clause | C | 14–18 | 87 |
| credcheck | 5.0 | credcheck - postgresql plain text credential checker | SEC | MIT | C | 14–18 | 86 |
| pgh3 | 0.3.0 | Expose Uber H3 hierarchical geospatial indexing functions for PostGIS geometries | GIS | Apache-2.0 | C | 10–13 | 85 |
| steampipe_postgres_fdw | 1.0 | Zero-ETL foreign data wrapper that maps PostgreSQL foreign tables to cloud-service and API calls. | FDW | Apache-2.0 | Go | — | 85 |
| gg_tables_tracking | 1.0 | Greengage relation-size change tracking for monitoring and maintenance. | STAT | Apache-2.0 | C | — | 84 |
| gg_wait_sampling | 1.1 | Greengage wait-event sampling with history and query attribution. | STAT | Apache-2.0 | C | — | 84 |
| pgfr_analyze | 2.29.2 | Reporting and analysis functions for pgfr_record | STAT | Apache-2.0 | SQL | 15–18 | 81 |
| pgfr_record | 2.29.2 | Server-side PostgreSQL performance flight recorder | STAT | Apache-2.0 | SQL | 15–18 | 81 |
| 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_enquo | 0.0 | PostgreSQL extension for encrypted query operations | SEC | MIT | Rust | 12–17 | 79 |
| set_user | 4.2.0 | similar to SET ROLE but with added logging | SEC | PostgreSQL | C | 14–18 | 78 |
| pg_savior | 0.1.0 | Postgres extension to save OOPS mistakes | ADMIN | Apache-2.0 | C | 14–18 | 76 |
| typesafe | 0.0.1 | SQL client for TypeSafe AI classification and scoring | RAG | MIT | C | 16–17 | 76 |
| bg_mon | — | Background worker for monitoring PostgreSQL | STAT | MIT | C | 10–18 | 75 |
| pg_turso | 1.0 | Postgres output plugin for replicating data to Turso. | ETL | MIT | Zig | — | 75 |
| powa | 5.3.0 | PostgreSQL Workload Analyser-core | STAT | PostgreSQL | PLpgSQL | 14–18 | 75 |
| uids | 0.0.1 | PostgreSQL extension to generate various types of universally unique IDs | FUNC | — | Rust | 11–16 | 74 |
| provsql | 1.12.0 | Semiring provenance and probability management for PostgreSQL | FEAT | MIT | C++ | 14–18 | 73 |
| twitter_fdw | 1.1.0 | Legacy foreign data wrapper for the retired unauthenticated Twitter Search API. | FDW | PostgreSQL | C | — | 73 |
| pg_curl | 2.4.6 | Run curl actions for data transfer in URL syntax | UTIL | MIT | C | 14–18 | 71 |
| pgfsm | 0.0.1 | Finite State Machine enforcement with triggers and util functions. | FEAT | CC0-1.0 | SQL | 17 | 71 |
| upid_pg | 0.0.0 | Prefixed, sortable 128-bit identifier type and generator | TYPE | MIT | Rust | 18 | 71 |
| s3_fdw | 0.1.0 | Foreign data wrapper for reading Amazon S3 files through PostgreSQL COPY format. | FDW | PostgreSQL | C | — | 70 |
| pg_duckpipe | 1.0.0 | CDC synchronization from heap tables to DuckLake columnar tables | ETL | MIT | Rust | 17–18 | 69 |
| pg_session_jwt | 0.5.0 | Manage authentication sessions using JWTs | SEC | Apache-2.0 | Rust | 14–18 | 69 |
| pg_store_plans | 1.10 | track plan statistics of all SQL statements executed | STAT | BSD-3-Clause | C | 14–18 | 69 |
| hunspell_cs_cz | 1.0 | Czech Hunspell Dictionary | FTS | PostgreSQL | Data | 14–18 | 68 |
| hunspell_de_de | 1.0 | German Hunspell Dictionary | FTS | PostgreSQL | Data | 14–18 | 68 |
| hunspell_en_us | 1.0 | en_US Hunspell Dictionary | FTS | PostgreSQL | Data | 14–18 | 68 |
| hunspell_fr | 1.0 | French Hunspell Dictionary | FTS | PostgreSQL | Data | 14–18 | 68 |
| hunspell_ne_np | 1.0 | Nepali Hunspell Dictionary | FTS | PostgreSQL | Data | 14–18 | 68 |
| hunspell_nl_nl | 1.0 | Dutch Hunspell Dictionary | FTS | PostgreSQL | Data | 14–18 | 68 |
| hunspell_nn_no | 1.0 | Norwegian (norsk) Hunspell Dictionary | FTS | PostgreSQL | Data | 14–18 | 68 |
| hunspell_pt_pt | 1.0 | Portuguese Hunspell Dictionary | FTS | PostgreSQL | Data | 14–18 | 68 |