Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| supabase_vault | 0.3.1 | Supabase Vault Extension | SEC | Apache-2.0 | C | 14–18 | 234 |
| steampipe_postgres_aws | 0.125.0 | Steampipe AWS native PostgreSQL FDW for querying live AWS APIs as foreign tables. | FDW | Apache-2.0 | Go | 14–15 | 230 |
| pg_incremental | 1.5.0 | Incremental Processing by Crunchy Data | FEAT | PostgreSQL | C | 16–18 | 228 |
| pgfdb | 0.0.2 | Experimental pgrx extension that stores PostgreSQL table and index data in FoundationDB for distributed, fault-tolerant, horizontally scalable operation. | OLAP | AGPL-3.0 | Rust | 13–17 | 227 |
| 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 |
| pgclaw | 0.1.0 | Store LLM or OpenClaw agents as PostgreSQL values and process watched rows with a background worker | RAG | MIT | Rust | 14–17 | 210 |
| 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 |
| pg_jobmon | 1.4.1 | Extension for logging and monitoring functions in PostgreSQL | SEC | PostgreSQL | SQL | 14–18 | 203 |
| 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 |
| jev | 0.2.0 | Natural-language row filtering, ranking and classification through TypeSafe | RAG | PostgreSQL | Python | 14–17 | 195 |
| 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 |
| 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 |
| aws_s3 | 0.0.1 | aws_s3 postgres extension to import/export data from/to s3 | FDW | Apache-2.0 | SQL | 14–18 | 178 |
| 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 |
| pglinter | 2.0.0 | PostgreSQL Linting and Analysis Extension | ADMIN | PostgreSQL | Rust | 14–18 | 170 |
| 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 |
| 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 |
| 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 |
| pg_query_state | 1.2 | Tool for query progress monitoring in PostgreSQL | STAT | PostgreSQL | C | 10–18 | 160 |
| tagext | 1.0 | Tag Programming Example Extension | FUNC | MIT | Shell | — | 160 |
| ddlx | 0.31 | DDL eXtractor functions | ADMIN | PostgreSQL | SQL | 14–18 | 156 |
| gfs | 0.0.1 | GFS copy-on-read storage: a Table Access Method whose missing rows are fetched from the source on read and written through locally | ETL | MIT | Rust | — | 156 |
| safeupdate | 1.5 | Require criteria for UPDATE and DELETE | ADMIN | ISC | C | 14–18 | 153 |
| pg_bigm | 1.2 | create 2-gram (bigram) index for faster full text search. | FTS | PostgreSQL | C | 14–18 | 152 |
| quack | 0.0.1 | DuckDB Embedded in Postgres | OLAP | Apache-2.0 | C | 14–15 | 151 |
| nr_model | 1.0.0 | AI-powered Autonomous Data System | RAG | — | C | — | 148 |
| plhaskell | 5.0 | provide trusted and untrusted Haskell procedural languages for PostgreSQL | LANG | GPL-3.0 | C | — | 147 |