Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
91 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 |
| wal2json | 2.6 | Changing data capture in JSON format | ETL | BSD-3-Clause | C | 14–18 | 1.5k |
| 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 |
| 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 |
| pg_stat_monitor | 2.4.0 | 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. | STAT | BSD-3-Clause | C | 14–18 | 588 |
| pg_bulkload | 3.1.23 | pg_bulkload is a high speed data loading utility for PostgreSQL | ETL | BSD-3-Clause | C | 14–18 | 496 |
| 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 |
| pg_jieba | 1.1.0 | Chinese full-text search parser based on cppjieba | FTS | BSD-3-Clause | C++ | 14–18 | 420 |
| pg_similarity | 1.0 | support similarity queries | RAG | BSD-3-Clause | C | 14–18 | 402 |
| pg_qualstats | 2.1.4 | An extension collecting statistics about quals | STAT | BSD-3-Clause | C | 14–18 | 340 |
| 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 |
| amqp | 0.4.2 | Publish messages to AMQP brokers from PostgreSQL | ETL | BSD-3-Clause | C | 10–18 | 214 |
| pg_gist_hamming | 1.0 | support for indexing common datatypes in GiST | RAG | BSD-3-Clause | C | — | 185 |
| vptree | 1.0 | VP-tree implementation | RAG | BSD-3-Clause | C | — | 185 |
| pgfaceting | 0.2.0 | fast faceting queries using an inverted index | TYPE | BSD-3-Clause | SQL | 14–18 | 181 |
| pg_dirtyread | 2.8 | Read dead but unvacuumed rows from table | ADMIN | BSD-3-Clause | C | 14–18 | 165 |
| pgprolog | 0.0.0 | PostgreSQL procedural language handler for Prolog, embedding Scryer Prolog. | LANG | BSD-3-Clause | Rust | 11–16 | 134 |
| cartodb | 0.37.1 | Archived PostgreSQL extension for turning a database into a CartoDB user database. | GIS | BSD-3-Clause | Python | 11–18 | 112 |
| pgfincore | 1.4.0 | examine and manage the os buffer cache | ADMIN | BSD-3-Clause | C | 14–18 | 111 |
| pg_catcheck | 1.6.0 | Diagnosing system catalog corruption | ADMIN | BSD-3-Clause | C | 14–18 | 87 |
| 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 |
| crankshaft | 0.9.0 | Archived CARTO spatial-analysis functions for clustering, segmentation, and spatial statistics. | GIS | BSD-3-Clause | Python | — | 54 |
| dump_fdw | 1.0 | Foreign data wrapper for querying rows directly from PostgreSQL custom-format dump files | FDW | BSD-3-Clause | C | — | 54 |
| pg_check | 0.1.0 | Provides basic integrity checks for data files. | ADMIN | BSD-3-Clause | C | 10–18 | 52 |
| pg_rewrite | 2.2 | Tool allows read write to the table during the rewriting | ADMIN | BSD-3-Clause | C | 14–18 | 46 |
| pg_scws | 1.0 | a parser for full-text search of Chinese | FTS | BSD-3-Clause | C | — | 41 |
| logerrors | 2.1.5 | Function for collecting statistics about messages in logfile | SEC | BSD-3-Clause | C | 14–18 | 37 |
| pg_crash | 1.0 | Send random signals to random processes | ADMIN | BSD-3-Clause | C | 14–18 | 34 |
| fio | 1.0 | PostgreSQL File I/O Functions | ADMIN | BSD-3-Clause | C | 14–18 | 33 |
| pg_dbms_stats | 14.0 | Statistics management extension for stabilizing PostgreSQL execution plans using fixed statistics. | ADMIN | BSD-3-Clause | C | 14 | 30 |
| pg_proctab | 2.0.1 | PostgreSQL extension to access the OS process table | STAT | BSD-3-Clause | C | 14–18 | 29 |
| db_migrator | 1.0.0 | Tools to migrate other databases to PostgreSQL | ETL | BSD-3-Clause | SQL | 14–18 | 28 |
| lostgis | 1.0.2 | LostGIS spatial helper functions and types | GIS | BSD-3-Clause | SQL | 10–18 | 26 |
| pg_sphere | 1.5.2 | spherical objects with useful functions, operators and index support | TYPE | BSD-3-Clause | C | 14–18 | 25 |
| pgchronos | 1.0.2 | SQL functions and operators for union, intersection, and difference over daterange and tstzrange arrays. | TIME | BSD-3-Clause | SQL | 10–18 | 25 |
| dblink_plus | 1.0.11 | Run SQL against external PostgreSQL, Oracle, MySQL, and SQLite databases from PostgreSQL. | FDW | BSD-3-Clause | C | — | 21 |
| pg_normalize_query | 1.0 | Normalize constants in SQL statements using PostgreSQL parser logic | FUNC | BSD-3-Clause | C | 10–13 | 19 |
| pgsocket | 1.0 | send bytes from PostgreSQL to a TCP/IP socket | UTIL | BSD-3-Clause | C | 10 | 19 |
| adaptive_counter | 1.3.3 | Aggregation functions and data type for distinct estimation based on adaptive sampling. | FUNC | BSD-3-Clause | C | 10–18 | 18 |
| bitmap_counter | 1.3.5 | Aggregation functions and data type for distinct estimation based on s-bitmap. | FUNC | BSD-3-Clause | C | 10–18 | 18 |
| superloglog_counter | 1.2.3 | C data type, functions, and aggregates for approximate distinct counting with the SuperLogLog algorithm. | FUNC | BSD-3-Clause | C | 10–18 | 18 |
| pg_datasentinel | 1.0 | Observability and activity monitoring extension for PostgreSQL | STAT | BSD-3-Clause | C | 15–18 | 17 |
| pgqr | 1.0 | QR Code generator from PostgreSQL | UTIL | BSD-3-Clause | C | 14–18 | 17 |
| pg_migrate | 0.1.1 | Migrates a PostgreSQL table avoiding long locks | ETL | BSD-3-Clause | C | — | 16 |
| pg_toolkit_brazil | 0.1 | Brazilian CPF and CNPJ types, validation, formatting, casts, and operators. | TYPE | BSD-3-Clause | C | — | 16 |
| statsd | 0.2.0 | C client functions for sending counters, gauges, and timings to StatsD over UDP. | STAT | BSD-3-Clause | C | 10–18 | 14 |