Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
1442 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| babelfishpg_unit | 1.0.0 | C test runner for invoking all or selected Babelfish unit tests from SQL. | FEAT | Apache-2.0 | C | — | 338 |
| pg_hashids | 1.3 | Short unique id generator for PostgreSQL, using hashids | FUNC | MIT | C | 14–18 | 324 |
| uri | 1.20251029 | URI Data type for PostgreSQL | TYPE | PostgreSQL | C | 14–18 | 324 |
| periods | 1.2.3 | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING | TIME | PostgreSQL | C | 14–18 | 320 |
| 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_paxos | 0.2 | Paxos distributed consensus functions and table replication for PostgreSQL | ETL | PostgreSQL | C | — | 309 |
| biscuit | 3.1.0 | IAM-LIKE pattern matching with bitmap indexing | FTS | MIT | C | 16–18 | 300 |
| pg_biscuit | 1.0 | A fast bitmap-based index for PostgreSQL | FTS | MIT | C | — | 300 |
| 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 |
| imgsmlr | 1.0 | Image similarity with haar | FEAT | PostgreSQL | C | 14–18 | 264 |
| 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_rational | 0.0.3 | bigint fractions | TYPE | MIT | C | 14–18 | 257 |
| 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_blkchain | 0.0.1 | C extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. | FUNC | MIT | C | — | 237 |
| supabase_vault | 0.3.1 | Supabase Vault Extension | SEC | Apache-2.0 | C | 14–18 | 234 |
| pg_incremental | 1.5.0 | Incremental Processing by Crunchy Data | FEAT | PostgreSQL | C | 16–18 | 228 |
| pgpdf | 0.1.0 | PDF type with meta admin & Full-Text Search | TYPE | GPL-3.0 | C | 14–18 | 226 |
| pg_tde | 2.2.1 | Percona pg_tde access method | SEC | MIT | C | 18 | 224 |
| pljs | 1.0.5 | PL/JS trusted procedural language | LANG | PostgreSQL | C | 14–18 | 224 |
| pg_prometheus | 0.2.2 | Prometheus metric sample type and helpers for PostgreSQL. | STAT | Apache-2.0 | C | — | 217 |
| amqp | 0.4.2 | Publish messages to AMQP brokers from PostgreSQL | ETL | BSD-3-Clause | C | 10–18 | 214 |
| pg_show_plans | 2.1.8 | show query plans of all currently running SQL statements | STAT | PostgreSQL | C | 14–18 | 208 |
| clickhousedb_fdw | 1 | ClickHouse foreign data wrapper with SELECT/INSERT support plus aggregate and join pushdown. | FDW | PostgreSQL | C | 11–13 | 207 |
| pgjq | 0.1.0 | Use jq in Postgres | UTIL | MIT | C | 14–18 | 205 |
| imcs | 1.1 | In-Memory Columnar Store extension for PostgreSQL. | OLAP | Apache-2.0 | C | — | 202 |
| 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 |
| 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 |
| 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 |
| plsh | 1.20220917 | PL/sh procedural language | LANG | MIT | C | 14–18 | 178 |
| sql_firewall | 0.8 | Cluster-wide query allowlist firewall with learning, enforcing, permissive, and disabled modes keyed by user and parse-tree fingerprint. | SEC | PostgreSQL | C | — | 176 |
| pg_rrule | 0.3.0 | RRULE field type for PostgreSQL | TYPE | MIT | C | 14–18 | 175 |
| pgmemcache | 2.3.0 | memcached interface | SIM | MIT | C | 14–18 | 175 |
| is_jsonb_valid | 0.1.4 | Native PostgreSQL extension for validating jsonb values against JSON Schema draft 4 and draft 7. | FEAT | MIT | C | 10–18 | 173 |
| semver | 0.41.0 | Semantic version data type | TYPE | PostgreSQL | C | 14–18 | 168 |
| ip4r | 2.4.3 | IPv4/v6 and IPv4/v6 range index type for PostgreSQL | TYPE | PostgreSQL | C | 14–18 | 166 |
| holycorn | 1.0 | Ruby foreign data wrapper provider | FDW | LGPL-3.0 | C | 10–18 | 165 |
| pg_dirtyread | 2.8 | Read dead but unvacuumed rows from table | ADMIN | BSD-3-Clause | C | 14–18 | 165 |
| pldotnet | 0.9 | add C# and F# procedural languages to PostgreSQL through .NET | LANG | PostgreSQL | C | 10–16 | 164 |
| vops | 1.1 | Vectorized tile types, aggregates, projections, and FDW for PostgreSQL OLAP | OLAP | PostgreSQL | C | — | 163 |
| 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 |