select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

pgx_ulid · ulid type and methods · 0.2.3 · Functions and aggregates · MIT · Rust · Packagedpg_hashids · Short unique id generator for PostgreSQL, using hashids · 1.3 · Functions and aggregates · MIT · C · Packagedsequential_uuids · generator of sequential UUIDs · 1.0.3 · Functions and aggregates · MIT · C · Packagedpg_blkchain · C extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. · 0.0.1 · Functions and aggregates · MIT · C · Not packagedtagext · Tag Programming Example Extension · 1.0 · Functions and aggregates · MIT · Shell · Not packagedtuid · tuid datatype · 0.3.0 · Functions and aggregates · MIT · C · Not packagedpg_sqids · Encode numbers as short URL-safe Sqids and decode them in PostgreSQL · 0.1.0 · Functions and aggregates · MIT · Rust · Not packagedaggs_for_arrays · Various functions for computing statistics on arrays of numbers · 1.3.3 · Functions and aggregates · MIT · C · Packagedaggs_for_vecs · Aggregate functions for array inputs · 1.4.1 · Functions and aggregates · MIT · C · Packagedpg_xid · PostgreSQL extension exposing xid generation functions · 1.0 · Functions and aggregates · MIT · C · Not packagedpg_csv · Flexible CSV processing for Postgres · 1.0.2 · Functions and aggregates · MIT · C · Packagedtypeid · Allows to use TypeIDs in Postgres natively · 0.3.0 · Functions and aggregates · MIT · Rust · Packagedjsonb_deep_sum · Recursively sum numeric fields in JSONB objects · 0.0.2 · Functions and aggregates · MIT · C · Not packagedrange_agg · range_agg: merge adjacent or overlapping PostgreSQL range values · 1.2.1 · Functions and aggregates · MIT · C · Not packagedpg_slug_gen · Generate cryptographically secure timestamp-based slugs · 1.0.0 · Functions and aggregates · MIT · C · Packagedarraymath · Array math and operators that work element by element on the contents of arrays · 1.1 · Functions and aggregates · MIT · C · Packagedbase36 · Integer Base36 types · 1.0.0 · Functions and aggregates · MIT · C · Packagedfloatvec · Math for vectors (arrays) of numbers · 1.1.1 · Functions and aggregates · MIT · C · Packagedpg_natural_sort_order · Natural sort ordering support through a C normalization function usable with indexes. · 1.0.1 · Functions and aggregates · MIT · C · Not packagedpg_url · Implements URL handling methods as postgres extension · 0.1.0 · Functions and aggregates · MIT · Rust · Not packagedslugify · PostgreSQL Extension to generate various variant of Slugs from a string. · 0.0.1 · Functions and aggregates · MIT · Rust · Not packagedpg_bitcount · Bit-count scalar and aggregate functions for integers and bit strings. · 0.0.3 · Functions and aggregates · MIT · C · Not packagedpopcount · provide population-count functions for PostgreSQL bit(n) values · 1.0.0 · Functions and aggregates · MIT · C · Not packagedformat_x · Polymorphic variadic string formatting with named lookups into composite, JSONB, and HSTORE values. · 0.0.1 · Functions and aggregates · MIT · C · Not packagedlaunchql-inflection · inflection is a port of the functionality from Ruby on Rails' Active Support Inflection classes into PostgreSQL · 0.0.2 · Functions and aggregates · MIT · C · Not packagednatord_pg · Natural-order comparison operators and btree operator class for PostgreSQL text values. · 0.0.0 · Functions and aggregates · MIT · Rust · Not packagedpgfaker · Generates fake company, person, internet, and phone data in PostgreSQL for tests, performance testing, and demos. · 0.0.3 · Functions and aggregates · MIT · Rust · Not packagedcidr · Transform an IPv4 or IPv6 address range into the minimal set of CIDR blocks · 1.0 · Functions and aggregates · MIT · SQL · Not packagedformat · A string formatting function which takes named parameters · 0.0.1 · Functions and aggregates · MIT · C · Not packagedjsonb_extend · Merge two or more jsonb values · 1.0 · Functions and aggregates · MIT · C · Not packagedpg_ethopic · Format Ethiopic dates and numbers in PostgreSQL. · 0.0.1 · Functions and aggregates · MIT · Rust · Not packagedpg_uuid · generator of new UUID versions · 1.0.0 · Functions and aggregates · MIT · C · Not packagedbase62 · Base62 extension for PostgreSQL · 0.0.1 · Functions and aggregates · MIT · C · Packagedconvert · conversion functions for spatial, routing and other specialized uses · 0.1.0 · Functions and aggregates · MIT · Rust · Packagednextid · Generate Instagram-style sharded integer IDs. · 0.1 · Functions and aggregates · MIT · C · Not packagednumpgsql · Array and numerical computing library for PostgreSQL · 0.0.1 · Functions and aggregates · MIT · C++ · Not packagedpg_bedtools_rs · A PostgreSQL plugin for bedtools, implemented in Rust. · 0.1.0 · Functions and aggregates · MIT · Rust · Not packagedpg_purr · A PostgreSQL extension (via PL/Python) that brings quantum computing capabilities. · 0.2.0 · Functions and aggregates · MIT · Python · Not packagedpg_base58 · Base58 Encoder/Decoder Extension for PostgreSQL · 0.0.1 · Functions and aggregates · MIT · Rust · Packagedpg_median_utils · Median filter and iterative median filter window functions for PostgreSQL · 0.0.1 · Functions and aggregates · MIT · C · Not packagedpg_str · Add Laravel-inspired string manipulation functions to PostgreSQL using pgrx · 0.3.1 · Functions and aggregates · MIT · Rust · Not packagedpghll · Provides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters. · 1.0 · Functions and aggregates · MIT · C · Not packagedpgpm-faker · PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes. · 0.15.5 · Functions and aggregates · MIT · C · Not packagedpgpm-inflection · PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes. · 0.30.0 · Functions and aggregates · MIT · C · Not packagedgraph_component · Compute graph components · 1.0.0 · Functions and aggregates · MIT · C · Not packagedpg_algorithms · C extension that adds example algorithm functions, including bubble sort and quicksort for integer arrays. · 1.0 · Functions and aggregates · MIT · C · Not packagedpg_json_diff · JSONB diff, JSON Patch, and merge-patch functions for PostgreSQL · 1.0 · Functions and aggregates · MIT · C++ · Not packagedpg_snowid · Generate thread-safe, time-sorted Snowflake-like IDs in PostgreSQL · 3.1.0 · Functions and aggregates · MIT · Rust · Not packagedpg_statkit · Descriptive statistics and clinical effect-size functions over arrays. · 1.1.0 · Functions and aggregates · MIT · Rust · Not packagedpgx_uuidv7 · A PostgreSQL extension to generate and cast v7 UUIDs · 0.1.7 · Functions and aggregates · MIT · Rust · Not packagedtm_postgres_basics · PL/pgSQL helper functions for resolving relation OIDs and traversing table inheritance. · 1.0.0 · Functions and aggregates · MIT · SQL · Not packagedxata_id_extension · Generate Xata-style rec_ identifiers with a 20-character lowercase alphanumeric suffix. · 0.0.0 · Functions and aggregates · MIT · Rust · Not packagedalohadb_approx · Approximate query processing: HLL, Count-Min Sketch, Top-K · 1.1 · Functions and aggregates · MIT · C · Not packagedcheck_digits · Functions to check various identification numbers · 0.3.3 · Functions and aggregates · MIT · C · Not packagedexploring_aggregates · pgrx example defining a custom integer-sum aggregate with serialized state. · 0.0.0 · Functions and aggregates · MIT · Rust · Not packagedfbsql · Closure-preserving formula-based statistical modeling in SQL · 0.1.0 · Functions and aggregates · MIT · SQL · Packagedfft_approximate · FFT-based approximate aggregate range queries over time-series data. · 1.0 · Functions and aggregates · MIT · C · Not packagedlaunchql-stamps · 🛠. basic pg utils · 0.4.5 · Functions and aggregates · MIT · C · Not packagedpbloompg · portable bloom filter, create, serialize, query across Go, Rust, Postgres · 0.0.0 · Functions and aggregates · MIT · Rust · Not packagedpg_jsonpatch · PostgreSQL implementation of JSON Patch · 1.0.0 · Functions and aggregates · MIT · SQL · Not packagedpg_meritrank · The extension provides functionality for computing and ranking a merit in a Postgres database. · 0.0.1 · Functions and aggregates · MIT · Rust · Not packagedpg_num2int_direct_comp · Exact numeric/float-to-integer comparison operators that preserve index use. · 1.0.0 · Functions and aggregates · MIT · C · Not packagedpg_running_stats · Mergeable Running Statistics (Welford/Chan) Extension for PostgreSQL · 1.0 · Functions and aggregates · MIT · C · Not packagedpg_snowflake_id · Snowflake-style 64-bit ID generator for PostgreSQL implemented with pgrx · 0.0.1 · Functions and aggregates · MIT · Rust · Not packagedpgcuid2 · Generate CUID2 text identifiers inside PostgreSQL using the cuid2 Rust crate. · 0.1.0 · Functions and aggregates · MIT · Rust · Not packagedpgrx_jsonb · Proof-of-concept pgrx functions for iterating PostgreSQL JSONB internals and reconstructing JSON values · 0.0.0 · Functions and aggregates · MIT · Rust · Not packagedphilihp@pg_openskill · OpenSkill Plackett-Luce ratings as a database.dev TLE package. · 0.1.0 · Functions and aggregates · MIT · SQL · Not packagedpksuid · generate prefixed, sortable KSUID identifiers in PostgreSQL · 0.1.0 · Functions and aggregates · MIT · Rust · Not packagedrange_tools · Tools for use with range types · 0.1.2 · Functions and aggregates · MIT · SQL · Not packagedutils · Minimal C extension example providing integer addition and multiplication functions. · 0.0.1 · Functions and aggregates · MIT · C · Not packaged

70 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
tm_postgres_basics 1.0.0 PL/pgSQL helper functions for resolving relation OIDs and traversing table inheritance. FUNC MIT SQL 1
xata_id_extension 0.0.0 Generate Xata-style rec_ identifiers with a 20-character lowercase alphanumeric suffix. FUNC MIT Rust 1
alohadb_approx 1.1 Approximate query processing: HLL, Count-Min Sketch, Top-K FUNC MIT C
check_digits 0.3.3 Functions to check various identification numbers FUNC MIT C
exploring_aggregates 0.0.0 pgrx example defining a custom integer-sum aggregate with serialized state. FUNC MIT Rust
fbsql 0.1.0 Closure-preserving formula-based statistical modeling in SQL FUNC MIT SQL 16–18
fft_approximate 1.0 FFT-based approximate aggregate range queries over time-series data. FUNC MIT C
launchql-stamps 0.4.5 🛠. basic pg utils FUNC MIT C
pbloompg 0.0.0 portable bloom filter, create, serialize, query across Go, Rust, Postgres FUNC MIT Rust
pg_jsonpatch 1.0.0 PostgreSQL implementation of JSON Patch FUNC MIT SQL
pg_meritrank 0.0.1 The extension provides functionality for computing and ranking a merit in a Postgres database. FUNC MIT Rust
pg_num2int_direct_comp 1.0.0 Exact numeric/float-to-integer comparison operators that preserve index use. FUNC MIT C 12–16
pg_running_stats 1.0 Mergeable Running Statistics (Welford/Chan) Extension for PostgreSQL FUNC MIT C
pg_snowflake_id 0.0.1 Snowflake-style 64-bit ID generator for PostgreSQL implemented with pgrx FUNC MIT Rust 13–17
pgcuid2 0.1.0 Generate CUID2 text identifiers inside PostgreSQL using the cuid2 Rust crate. FUNC MIT Rust 11–16
pgrx_jsonb 0.0.0 Proof-of-concept pgrx functions for iterating PostgreSQL JSONB internals and reconstructing JSON values FUNC MIT Rust 11–16
philihp@pg_openskill 0.1.0 OpenSkill Plackett-Luce ratings as a database.dev TLE package. FUNC MIT SQL 16
pksuid 0.1.0 generate prefixed, sortable KSUID identifiers in PostgreSQL FUNC MIT Rust 11–16
range_tools 0.1.2 Tools for use with range types FUNC MIT SQL
utils 0.0.1 Minimal C extension example providing integer addition and multiplication functions. FUNC MIT C 18