Explore 2400 PostgreSQL extensions from PGEXT, maintained by Pigsty.
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_chainutils | 0.2.4 | Blockchain utility types and functions for PostgreSQL, built with pgrx. | TYPE | MIT | Rust | 17 | 3 |
| pg_color | 1.1 | Color data type for PostgreSQL | TYPE | Apache-2.0 | C | 10 | 3 |
| pg_control_priority | 1.0 | Controls scheduling priorities (nice values) of PostgreSQL server processes. | ADMIN | PostgreSQL | C | 10–18 | 3 |
| pg_dbo_timestamp | 1.0.1 | PostgreSQL extension for storing time and author of database structure modification. | SEC | — | SQL | 10–18 | 3 |
| pg_duration | 1.0.2 | data type for representing durations | TYPE | MIT | C | 17–18 | 3 |
| pg_erlang_term | 0.0.1 | PostgreSQL type for encoding, storing, and decoding Erlang External Term Format values. | TYPE | PostgreSQL | C | — | 3 |
| pg_extension | 0.1.0 | In-database model slicing and inference helper functions for structured data analytics. | RAG | — | Rust | 11–15 | 3 |
| pg_fuck_block | 1.0 | C extension for reading all tuples from a relation block | ADMIN | — | C | — | 3 |
| pg_gnuplot | 1.0 | PostgreSQL extension to plot graphs using GNUPlot | UTIL | — | C | — | 3 |
| pg_gsl | 0.0.2 | Wraps selected GNU Scientific Library routines, including real FFT transforms and helper functions, for PostgreSQL. | FUNC | GPL-3.0 | C | — | 3 |
| pg_icu_parser | 1.0 | Full text search parser using ICU boundary analysis | FTS | MPL-2.0 | C | 10–16 | 3 |
| pg_idna | 0.1.1-docs | WHATWG URL IDNA helpers for PostgreSQL | UTIL | MIT | Rust | 12–17 | 3 |
| pg_infer | 1.0.0 | Expose transformer model knowledge as SQL relations and a custom index access method | RAG | Apache-2.0 | Rust | 18 | 3 |
| pg_libnumbertext | 0.1.0 | Converts numbers to words in multiple languages through libnumbertext. | FUNC | BSD-3-Clause | C++ | — | 3 |
| pg_linearAlgebra | 1.0 | A linear algebra extension | FUNC | — | Rust | — | 3 |
| pg_llm_helper | 1.0 | Captures PostgreSQL errors in shared memory and exposes history plus an optional pgai-backed LLM troubleshooting function. | STAT | PostgreSQL | C | 17 | 3 |
| pg_memorycontext | 1.0 | Examines PostgreSQL memory context information. | STAT | PostgreSQL | C | 10–18 | 3 |
| pg_multitenant | 1.0 | Multi-tenant shared-schema helpers using PostgreSQL row-level security | SEC | MIT | Rust | 16 | 3 |
| pg_normalize_email | 1.0.9 | Normalize email addresses in PostgreSQL | FUNC | PostgreSQL | SQL | 12–18 | 3 |
| pg_os | 1.0 | PostgreSQL extension providing operating system-level functionality directly through SQL, enabling process management, file system operations, IPC, and system monitoring within the database environment. | FEAT | MIT | SQL | — | 3 |
| pg_plsql_graphs | 1.0 | Capture PL/pgSQL control-flow and dependence graphs for DOT export | LANG | — | C | — | 3 |
| pg_purr | 0.2.0 | A PostgreSQL extension (via PL/Python) that brings quantum computing capabilities. | FUNC | MIT | Python | — | 3 |
| pg_relation_sql | 0.2.2 | Generate inlinable SQL functions for navigating PostgreSQL foreign-key relations | UTIL | PostgreSQL | PLpgSQL | 11–18 | 3 |
| pg_retry | 1.0.0 | Retry SQL statements on transient errors with exponential backoff | UTIL | PostgreSQL | C | 17–18 | 3 |
| pg_rrf | 0.0.3 | Reciprocal rank fusion functions for hybrid search | RAG | MIT | Rust | 14–18 | 3 |
| pg_show_vm | 1.0 | pg show vm displays the visibility map data for a specified relation, including its corresponding indexes and partitions. | ADMIN | — | C | — | 3 |
| pg_stat_backtrace | 1.0.0 | Capture or log C-level stack backtraces of PostgreSQL processes | STAT | PostgreSQL | C | 14–18 | 3 |
| pg_tiktoken_c | 1.1 | Fast tiktoken BPE tokenizer for PostgreSQL implemented in C | RAG | Apache-2.0 | C | 14–18 | 3 |
| pg_uuid_v8 | 1.1.0 | UUID v8 generator with embedded timestamps for PostgreSQL | FUNC | PostgreSQL | C | 14–18 | 3 |
| pgbdd | 0.0.1 | Provides bdd and dictionary data types. | TYPE | GPL-3.0 | C | — | 3 |
| pgcompress | 1.0 | Provides deflate, inflate, gzip, and Brotli compression functions for bytea, text, json, and jsonb. | UTIL | GPL-3.0 | C | — | 3 |
| pglock | 1.0.0 | Lightweight distributed lock service inside PostgreSQL | UTIL | PostgreSQL | SQL | 14–18 | 3 |
| pglogical_ticker | 1.4.1 | Have an accurate view on pglogical replication delay | ETL | PostgreSQL | C | 14–18 | 3 |
| pgmb | 1.0.0 | A simple PostgreSQL Message Broker system | FEAT | PostgreSQL | SQL | 14–18 | 3 |
| pgque | 0.1.0 | Pure SQL PostgreSQL job queue that orders jobs by priority and claims them with advisory locks. | FEAT | — | SQL | — | 3 |
| pgreadfile | 1.0 | Read and overwrite server-local files as bytea through C functions | UTIL | — | C | 11 | 3 |
| pgts | 0.1.0 | time encode for PostgreSQL | TIME | MIT | C | — | 3 |
| pgx_json_schema | 1.0 | JSON Schema validation for Postgres | FEAT | — | Rust | — | 3 |
| pgyaml | 1.0 | transform between yaml and jsonb | UTIL | — | C | — | 3 |
| postgrest_auth | 0.1 | Placeholder PostgREST authentication extension with no implemented database objects | SEC | MIT | SQL | — | 3 |
| qgres | 0.1.2 | Simple queue system | FEAT | PostgreSQL | SQL | — | 3 |
| repeat | 0.0.1 | A testing repo comparing an SRF that is dually implemented as ValuePerCall and Materialize | FEAT | — | C | — | 3 |
| rostgis | 0.1.0 | Experimental PostGIS-compatible spatial extension written in Rust. | GIS | MIT | Rust | 13–17 | 3 |
| salesforce_id | 1.0 | Compact 12-byte PostgreSQL type with casts, comparison operators, and B-tree/hash operator classes for Salesforce IDs. | TYPE | PostgreSQL | C | — | 3 |
| scrub | 1.0 | Background worker that scans heaps, B-tree indexes, TOAST data, page structure, and checksums for corruption. | ADMIN | PostgreSQL | C | — | 3 |
| session_variables | 0.0.4 | SQL functions for storing and retrieving session-scoped values through custom PostgreSQL settings. | FEAT | PostgreSQL | SQL | 10–18 | 3 |
| short_ids | 0.1.0 | PL/pgSQL generator for short random text IDs with collision checks and transaction advisory locks. | FUNC | PostgreSQL | SQL | 10–18 | 3 |
| simple_parser | 1.0 | C full-text-search parser that splits input only at ASCII space characters, preserving punctuation such as underscores inside tokens. | FTS | PostgreSQL | C | — | 3 |
| stannum | 0.1.0 | Experimental TINQL text search with BM25 and persistent indexes | FTS | AGPL-3.0-only | Rust | 17–18 | 3 |
| student | 1.0 | Let's learn how to add types in PostgreSQL 👨🏻💻 | TYPE | — | C | — | 3 |