Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
1442 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| call_graph | 1.4 | Track PostgreSQL function calls automatically and aggregate them into call graphs and optional table-usage statistics. | STAT | MIT | C | — | 12 |
| dict_voikko | 1.0 | Finnish full-text-search dictionary using Voikko morphological analysis. | FTS | PostgreSQL | C | — | 12 |
| file_fixed_length_fdw | 1.0 | Foreign data wrapper for files with fixed-length fields. | FDW | — | C | — | 12 |
| hello_fdw | 1.0 | foreign-data wrapper for hello world | FDW | — | C | — | 12 |
| json_schema_validate | 0.1.0 | Validate JSON and JSONB data against JSON Schema in PostgreSQL | FEAT | PostgreSQL | C | 14–18 | 12 |
| pair | 0.1.2 | A key/value pair data type for PostgreSQL | TYPE | PostgreSQL | C | 10–18 | 12 |
| pg_circuit | 0.1.0 | Runtime observation, warnings and blocking for dangerous SQL statements | ADMIN | Apache-2.0 | C | 16–18 | 12 |
| pg_grab_statement | 1.0 | Record detailed SQL statements from successfully committed transactions. | STAT | GPL-2.0 | C | 10–18 | 12 |
| pg_log_statements | 0.0.2 | Enables log_statement=all selectively for chosen PostgreSQL backend processes or newly started backends matching connection filters. | STAT | PostgreSQL | C | 10–16 | 12 |
| pg_log_userqueries | 1.0.0 | Module to log user queries | STAT | PostgreSQL | C | — | 12 |
| pg_natural_sort_order | 1.0.1 | Natural sort ordering support through a C normalization function usable with indexes. | FUNC | MIT | C | 10–18 | 12 |
| pg_oltp_bench | 1.0 | Helper function and pgbench scripts for a sysbench-style OLTP benchmark. | FEAT | — | C | — | 12 |
| pgcmp | 3.1 | Support extension for pg_comparator, providing checksum and cast functions for PostgreSQL data comparison. | ETL | BSD-3-Clause | C | — | 12 |
| pgtsql | 3.0 | provide Transact-SQL compatibility for PostgreSQL | LANG | — | C | 11 | 12 |
| ppg_fdw | 1.0 | ppg_fdw: distributed parallel query engine for sharded remote PostgreSQL servers | OLAP | — | C | — | 12 |
| tsexact | 1.0 | Full-text-search helpers for exact phrase matching on PostgreSQL 9.5 and earlier. | FTS | PostgreSQL | C | 10–18 | 12 |
| vgram | 1.0 | Variable-length grams | FTS | PostgreSQL | C | 13–18 | 12 |
| weighted_mean | 1.0.1 | Weighted average aggregate function for PostgreSQL numeric values. | FUNC | PostgreSQL | C | 10–18 | 12 |
| colors | 0.0.1 | C functions for perceptual color-distance calculations in the CIE L*a*b* color space | FUNC | PostgreSQL | C | 10–18 | 11 |
| inetrange | 1.0.2 | Range type for PostgreSQL inet values with range operators and GiST indexing support. | TYPE | MIT | C | — | 11 |
| logical_ddl | 0.1.0 | Replicate supported DDL changes over PostgreSQL logical replication | ETL | MIT | C | 14–18 | 11 |
| numeral | 1.3 | numeral datatypes extension | TYPE | GPL-2.0 | C | 14–18 | 11 |
| omni_git | 0.1.0 | A PostgreSQL extension that stores git repositories in database tables and serves the git smart HTTP protocol, turning Postgres into a git remote. | SIM | MIT | C | — | 11 |
| pg_fact_loader | 2.0.1 | build fact tables with Postgres | ETL | MIT | C | 14–18 | 11 |
| pg_subtrans_infos | 1.0 | Inspect PostgreSQL subtransaction status, parent XIDs, nesting level, and commit timestamps. | ADMIN | PostgreSQL | C | 10–13 | 11 |
| pgcov | 1.0 | Tracks test coverage in PL/PgSQL functions and requires shared_preload_libraries. | LANG | MIT | C | 10–12 | 11 |
| pgsynck | 1.0 | Parse SQL text without execution and return per-statement syntax diagnostics | UTIL | PostgreSQL | C | — | 11 |
| plmruby | 0.0.1 | Run scalar, set-returning, inline, and trigger functions in the embedded mruby runtime | LANG | — | C | — | 11 |
| plpgsql_wrap | 1.0 | Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source. | SIM | PostgreSQL | C | 14–18 | 11 |
| schema_triggers | 0.1 | Archived C hook extension adding relation, column, and trigger schema-change events to PostgreSQL event triggers. | FEAT | BSD-2-Clause | C | 10–18 | 11 |
| slowjit | 1.0.0 | A simple demo to illustrate how to implement a JIT provider for PostgreSQL. | LANG | — | C | — | 11 |
| xxhash | 0.0.1 | xxhash functions for PostgreSQL | UTIL | BSD-2-Clause | C | 14–18 | 11 |
| autopex | 0 | Event-trigger extension that invokes Pex to automatically download and build PostgreSQL extensions when CREATE EXTENSION is run. | ADMIN | — | C | 10–18 | 10 |
| jsonbd | 0.1 | Compression method for JSONB type | UTIL | — | C | — | 10 |
| log_functions | 1.0.0 | Module to log functions | STAT | PostgreSQL | C | — | 10 |
| memstat | 1.0 | Memory context statistics for local and instance backends | STAT | — | C | — | 10 |
| mv_rewrite | 0.6.2 | Query rewriting extension that transparently rewrites queries to use lower-cost materialized views. | FEAT | — | C | — | 10 |
| pg_fasttransfer | 1.0 | Postgresql Extension for FastTransfer | ETL | MIT | C | 15–18 | 10 |
| pg_phash | 1.0 | Calculate Hamming distance between decimal-encoded perceptual image hashes | RAG | GPL-3.0 | C | — | 10 |
| pg_remote_exec | 1.0 | Executes shell commands from SQL and optionally returns their standard output. | ADMIN | PostgreSQL | C | 12–16 | 10 |
| pg_stat_sql_plans | 0.2 | Track execution statistics by normalized SQL query and plan ID. | STAT | PostgreSQL | C | 14–18 | 10 |
| pg_subxact_counters | 1.0 | Global counters for PostgreSQL subtransaction activity | STAT | PostgreSQL | C | 13–16 | 10 |
| pg_testgen | 1.0 | Generate random integers, strings, and test-data rows for PostgreSQL development | FUNC | — | C | — | 10 |
| pg_thrift | 1.0 | Encode, decode, and query Apache Thrift binary and compact protocol values in PostgreSQL. | TYPE | — | C | 10–11 | 10 |
| pg_timeout | 1.0 | PostgreSQL background-worker extension for terminating idle database sessions. | ADMIN | PostgreSQL | C | 10–16 | 10 |
| saio | 0.0.1 | Experimental load-only planner hook that searches PostgreSQL join orders with simulated annealing as an alternative to GEQO | FEAT | PostgreSQL | C | — | 10 |
| shared_ispell | 1.0.0 | Shared-memory ispell dictionary template for reducing per-session initialization and memory. | FTS | BSD-2-Clause | C | 10–18 | 10 |
| accel_ext | 1.0 | Fine-grained accelerator offload runtime that overlaps GPU, HSM, or inference work with other PostgreSQL requests. | FEAT | MIT | C | — | 9 |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | GIS | GPL-2.0 | C | 14–18 | 9 |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | GIS | GPL-2.0 | C | 14–18 | 9 |