Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| ogai | 1.0 | OGAI - AI vectorization and search framework for openGauss | RAG | MulanPSL-2.0 | C++ | — | 784 |
| plpgsql_check | 2.10.10 | Additional validation, profiling, and diagnostics for PL/pgSQL functions | LANG | MIT | C | 14–18 | 778 |
| uuid47 | 1.0 | UUIDv7 storage with keyed UUIDv4-looking façade I/O | TYPE | MIT | C | 17 | 749 |
| pgroonga | 4.0.4 | Use Groonga as index, fast full text search platform for all languages! | FTS | PostgreSQL | C | 14–18 | 748 |
| pgroonga_database | 4.0.4 | PGroonga database management module | FTS | PostgreSQL | C | 14–18 | 748 |
| spock | 5.0.10 | Multi-master logical replication extension for PostgreSQL | ETL | PostgreSQL | C | 15–18 | 744 |
| jsquery | 1.2 | data type for jsonb inspection | FEAT | PostgreSQL | C | 14–18 | 710 |
| pg_squeeze | 1.9.4 | A tool to remove unused space from a relation. | ADMIN | BSD-2-Clause | C | 14–18 | 691 |
| pg_parquet | 0.5.1 | copy data between Postgres and Parquet | OLAP | PostgreSQL | Rust | 14–18 | 685 |
| supabase_custom_claims | 1.0 | How to implement custom claims with Supabase | SEC | — | JavaScript | — | 678 |
| supa_audit | 0.3.1 | Trigger-based table audit history with stable UUID record identities and JSONB row versions. | SEC | Apache-2.0 | SQL | 12–16 | 672 |
| acdat | 0.1.1 | Compiled Aho-Corasick double-array machines for exact multi-pattern matching and replacement in PostgreSQL. | FTS | Apache-2.0 | C | 14–18 | 664 |
| automerge | 0.0.1 | CRDT support in Postgres (experimental) | TYPE | PostgreSQL | C | — | 649 |
| 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 |
| mobilitydb | 1.3.0 | MobilityDB geospatial trajectory data management & analysis platform | GIS | PostgreSQL | C | 14–18 | 624 |
| mobilitydb_datagen | 1.3.0 | MobilityDB random data generator functions | GIS | PostgreSQL | SQL | 14–18 | 624 |
| 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_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 |
| oracle_fdw | 2.9.0 | foreign data wrapper for Oracle access | FDW | PostgreSQL | C | 14–18 | 551 |
| orafce | 4.16.10 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | SIM | 0BSD | C | 14–18 | 541 |
| pg_analytics | 0.3.7 | Postgres for analytics, powered by DuckDB | OLAP | PostgreSQL | Rust | 14–17 | 540 |
| redis_fdw | 1.0 | Foreign data wrapper for querying a Redis server | FDW | PostgreSQL | C | 14–18 | 535 |
| 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 |
| pgx_ulid | 0.2.3 | ulid type and methods | FUNC | MIT | Rust | 14–18 | 501 |
| aqo | 1.6 | Adaptive query optimization extension using execution statistics to improve cardinality estimation. | FEAT | AGPL-3.0 | C | 10–18 | 499 |
| pg_bulkload | 3.1.23 | pg_bulkload is a high speed data loading utility for PostgreSQL | ETL | BSD-3-Clause | C | 14–18 | 496 |
| timescaledb_toolkit | 1.23.0 | Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities | TIME | Timescale | Rust | 15–18 | 487 |
| madlib | 2.1.0 | An open-source in-database analytics library | RAG | Apache-2.0 | C++ | — | 475 |
| plprql | 18.0.2 | Use PRQL in PostgreSQL - Pipelined Relational Query Language | LANG | Apache-2.0 | Rust | 14–18 | 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 |
| pgjwt | 0.2.0 | JSON Web Token API for Postgresql | UTIL | MIT | SQL | 14–18 | 443 |
| 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 |
| tds_fdw | 2.0.5 | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) | FDW | PostgreSQL | C | 14–18 | 432 |
| pg_uuidv7 | 1.7.0 | Create UUIDv7 values in postgres | FUNC | MPL-2.0 | C | 14–18 | 430 |
| wasm | 0.1.0 | A Postgres extension to run WebAssembly binaries. | LANG | MIT | Rust | 10 | 430 |
| 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 |
| pgq | 3.5.1 | Generic queue for PostgreSQL | FEAT | ISC | C | 14–18 | 425 |
| pg_idkit | 0.4.0 | multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) | FUNC | Apache-2.0 | Rust | 14–18 | 423 |
| timeseries | 0.2.1 | Convenience API for time series stack | TIME | PostgreSQL | SQL | 14–18 | 423 |
| aux_mysql | 1.5 | MySQL Supplementary Extension | SIM | GPL-3.0 | C | 14 | 420 |
| pg_jieba | 1.1.0 | Chinese full-text search parser based on cppjieba | FTS | BSD-3-Clause | C++ | 14–18 | 420 |
| pgmemento | 0.7.4 | Transaction-based audit trail with schema versioning | SEC | LGPL-3.0 | SQL | 14–18 | 411 |
| pg_tle | 1.5.2 | Trusted Language Extensions for PostgreSQL | LANG | Apache-2.0 | C | 14–18 | 410 |