Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
1798 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| cedarling_pg | 0.1.0 | PostgreSQL integration for Cedarling authorization decisions, including JWT-aware checks and RLS-oriented helpers. | SEC | Apache-2.0 | Rust | — | 646 |
| pg_pathman | 1.5 | Partitioning tool for PostgreSQL | OLAP | PostgreSQL | C | 11–15 | 587 |
| embedding | 0.3.6 | HNSW vector similarity search extension for PostgreSQL real[] embeddings. | RAG | Apache-2.0 | C | 12–16 | 579 |
| zson | 1.1 | Dictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators. | TYPE | MIT | C | — | 568 |
| pg_analytics | 0.3.7 | Postgres for analytics, powered by DuckDB | OLAP | PostgreSQL | Rust | 14–17 | 540 |
| oraplsql | 1.0 | Oracle-compatible procedural SQL language for OpenTenBase. | SIM | — | C | — | 520 |
| postgres-json-schema | 0.1.1 | Pure PL/pgSQL functions for validating PostgreSQL jsonb documents against JSON Schema draft 4, including use in CHECK constraints. | FEAT | PostgreSQL | SQL | — | 508 |
| aqo | 1.6 | Adaptive query optimization extension using execution statistics to improve cardinality estimation. | FEAT | AGPL-3.0 | C | 10–18 | 499 |
| madlib | 2.1.0 | An open-source in-database analytics library | RAG | Apache-2.0 | C++ | — | 475 |
| pg_gpt | 0.0.0 | Experimental extension that brings OpenAI API to your PostgreSQL to run queries in human language. | RAG | Apache-2.0 | Rust | — | 458 |
| dbdev | 0.0.5 | In-database client for installing packages from the database.dev registry. | ADMIN | Apache-2.0 | SQL | — | 441 |
| hybrid_search | 1.1.0 | Hybrid pgvector and full-text search helper functions for LangChain and Supabase. | RAG | Apache-2.0 | SQL | — | 441 |
| wasm | 0.1.0 | A Postgres extension to run WebAssembly binaries. | LANG | MIT | Rust | 10 | 430 |
| db_assist | 0.0.0 | Minimal pgrx training extension exposing a hello_db_assist function. | FUNC | — | Rust | — | 387 |
| parquet_fdw | 0.2 | Read-only foreign data wrapper for Apache Parquet files | FDW | PostgreSQL | C++ | 10–16 | 387 |
| pg_branch | 0.0.1 | PostgreSQL extension for quickly creating copies of databases and clusters. | FEAT | MIT | Rust | 11–16 | 359 |
| pg_rusage | 1.0 | Gathering of template plugins for PostgreSQL: background workers, logical replication things, etc. | STAT | — | C | — | 349 |
| pgmpc | 0.1.0 | mpd client for PostgreSQL | UTIL | PostgreSQL | C | — | 349 |
| 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_paxos | 0.2 | Paxos distributed consensus functions and table replication for PostgreSQL | ETL | PostgreSQL | C | — | 309 |
| pg_biscuit | 1.0 | A fast bitmap-based index for PostgreSQL | FTS | MIT | C | — | 300 |
| pgcapture | 0.1 | A scalable Netflix DBLog implementation for PostgreSQL | ETL | Apache-2.0 | Go | — | 285 |
| pg_deltax | 0.2.1 | Fast time-series extension for PostgreSQL | TIME | Apache-2.0 | Rust | — | 284 |
| clickhouse_fdw | 1.4 | ClickHouse foreign data wrapper for PostgreSQL | FDW | Apache-2.0 | C++ | 11–17 | 275 |
| pg_netstat | 0.1.0 | pg netstat: network traffic monitor | STAT | — | Rust | — | 259 |
| parquet_s3_fdw | 0.3 | Foreign data wrapper for accessing Parquet files on local filesystems and Amazon S3 from PostgreSQL. | FDW | PostgreSQL | C++ | 13–17 | 241 |
| pg_blkchain | 0.0.1 | C extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. | FUNC | MIT | C | — | 237 |
| 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 |
| 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 |
| 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 |
| clickhousedb_fdw | 1 | ClickHouse foreign data wrapper with SELECT/INSERT support plus aggregate and join pushdown. | FDW | PostgreSQL | C | 11–13 | 207 |
| imcs | 1.1 | In-Memory Columnar Store extension for PostgreSQL. | OLAP | Apache-2.0 | C | — | 202 |
| 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 |
| 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 |
| 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 |
| holycorn | 1.0 | Ruby foreign data wrapper provider | FDW | LGPL-3.0 | C | 10–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 |
| 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 |
| 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 |
| 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 |
| opm_core | 2.6 | Central module of the OPM suite | STAT | PostgreSQL | C | — | 146 |
| postal | 1.0 | PostgreSQL bindings for libpostal that normalize free-form addresses and parse them into labeled components. | GIS | MIT | C | 10–18 | 146 |
| postpic | 0.9.1 | A PostgreSQL image type with SQL image-processing and metadata functions, backed by GraphicsMagick, plus import/export utilities. | TYPE | LGPL-3.0 | C | — | 137 |