Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
155 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| uuid47 | 1.0 | UUIDv7 storage with keyed UUIDv4-looking façade I/O | TYPE | MIT | C | 17 | 749 |
| automerge | 0.0.1 | CRDT support in Postgres (experimental) | TYPE | PostgreSQL | C | — | 649 |
| zson | 1.1 | Dictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators. | TYPE | MIT | C | — | 568 |
| 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 |
| pg_libphonenumber | 0.1.0 | Adds a packed phone-number type and parsing functions backed by Google libphonenumber. | TYPE | Apache-2.0 | C++ | — | 96 |
| upid_pg | 0.0.0 | Prefixed, sortable 128-bit identifier type and generator | TYPE | MIT | Rust | 18 | 71 |
| pg_ferroid | 2.0.0 | PostgreSQL ULID type and generation functions backed by ferroid | TYPE | MIT | Rust | 13–18 | 44 |
| fixeddecimal | 1.1.0 | Fixed-precision decimal type optimized for performance and storage. | TYPE | PostgreSQL | C | 10–18 | 36 |
| istore | 0.1.12 | Integer-to-integer key/value store for analytic workloads. | TYPE | MIT | C | 10–16 | 35 |
| postgres_web3 | 1.0 | Optimized PostgreSQL types and operators for 128/256-bit signed and unsigned integers plus 160/256-bit hexadecimal web3 values. | TYPE | MIT | C | 15 | 33 |
| tinyint | 0.1.1 | One-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes. | TYPE | PostgreSQL | C | 10 | 28 |
| bignum | 0.8.0 | Unlimited precision integers for PostgreSQL | TYPE | PostgreSQL | C | 10–18 | 23 |
| pgbitmap | 0.9.5 | Bitmap-type extension for PostgreSQL | TYPE | BSD-2-Clause | C | 10–18 | 23 |
| timestampandtz | 1.0.0 | C data type that stores a timestamp together with its source time-zone identity, with casts, operators, indexing, and date/time functions. | TYPE | MIT | C | 10–18 | 21 |
| ccnumber | 1.0 | data type representing encrypted CC numbers | TYPE | — | C | — | 18 |
| pg_toolkit_brazil | 0.1 | Brazilian CPF and CNPJ types, validation, formatting, casts, and operators. | TYPE | BSD-3-Clause | C | — | 16 |
| wltree | 2.0 | data type for hierarchical tree-like structures with wide character support | TYPE | MIT | C | 10–17 | 16 |
| varint | 0.1.0 | A signed and unsigned 64 bit integer encoding scheme that saves disk space | TYPE | PostgreSQL | C | — | 15 |
| libversion | 2.0.0 | Version string comparison functions and versiontext type using libversion | TYPE | MIT | C | 10–16 | 14 |
| crockford | 0.8.34 | Crockford Base32 encoded unsigned integer data types | TYPE | PostgreSQL | C | 11 | 13 |
| pair | 0.1.2 | A key/value pair data type for PostgreSQL | TYPE | PostgreSQL | C | 10–18 | 12 |
| iban | 1.1 | IBAN data type and validation functions for PostgreSQL | TYPE | GPL-3.0 | C++ | 14 | 11 |
| inetrange | 1.0.2 | Range type for PostgreSQL inet values with range operators and GiST indexing support. | TYPE | MIT | C | — | 11 |
| cas_codes | 0.1.0 | CAS Registry Number data type and validation support for PostgreSQL. | TYPE | GPL-3.0 | Rust | 13–17 | 10 |
| elements | 0.1.0 | Chemical elements and isotope metadata exposed as PostgreSQL enum types through pgrx. | TYPE | GPL-3.0 | Rust | 13–17 | 10 |
| iso_codes | 0.1.0 | ISO country code enum/data types for PostgreSQL, generated with pgrx. | TYPE | GPL-3.0 | Rust | 13–17 | 10 |
| media_types | 0.1.0 | Strongly typed MIME media-type data type for PostgreSQL | TYPE | GPL-3.0 | Rust | 13–17 | 10 |
| molecular_formulas | 0.1.0 | Molecular-formula parser and strongly typed PostgreSQL data type | TYPE | GPL-3.0 | Rust | 13–17 | 10 |
| pg_thrift | 1.0 | Encode, decode, and query Apache Thrift binary and compact protocol values in PostgreSQL. | TYPE | — | C | 10–11 | 10 |
| pgsql_rrule | 0.0.4 | Pure SQL PostgreSQL data types and functions for parsing and expanding RFC 5545 recurrence rules. | TYPE | PostgreSQL | SQL | 10–18 | 10 |
| datalink | 0.5.0 | SQL/MED DATALINK data type and functions for controlled access to files outside PostgreSQL | TYPE | PostgreSQL | C | 10–18 | 9 |
| plid | 0.0.0 | A 128-bit, lexicographically sortable PostgreSQL PLID type with short prefixes, millisecond timestamps, randomness, and optional monotonic generation. | TYPE | MIT | Rust | 13–18 | 8 |
| telephone | 0.0.1 | PostgreSQL data type for normalized telephone numbers with dialing-plan validation. | TYPE | PostgreSQL | C | 10–18 | 8 |
| cbor | 0.1.0 | Concise Binary Object Representation data type for PostgreSQL. | TYPE | PostgreSQL | C | 10–18 | 7 |
| intpair | 0.2 | Packed int64pair data type with comparison, hash, and index operator support. | TYPE | Apache-2.0 | C | — | 7 |
| jansson-json | 0.0.2 | JSON data type, operators, and functions backed by the Jansson JSON library. | TYPE | MIT | C | 10–18 | 7 |
| pg-json | 0.0.1 | A json data type and related functions | TYPE | MIT | C | — | 7 |
| pgbrtypes | 1.0 | Brazilian CPF and CNPJ data types with validation, formatting, casts, and indexing support | TYPE | — | C | 10–18 | 7 |
| uints | 0.9 | C extension providing unsigned 16-bit and 32-bit integer types with casts, operators, and numeric support functions. | TYPE | PostgreSQL | C | — | 7 |
| ajbool | 0.0.3 | Three-valued boolean type with a pseudo-NULL unknown state for primary keys. | TYPE | PostgreSQL | C | 10–16 | 6 |
| 0.1 | Email address data type with validation, equality operators, and user/domain helper functions. | TYPE | PostgreSQL | C | 10–18 | 6 | |
| g_cube | 1.0 | GPU version of contrib/cube | TYPE | — | C | — | 6 |
| pg_datatype_password | 0.0.1 | SQL-only password data type and operators using pgcrypto Blowfish hashes, with trigger-based encryption before storage. | TYPE | MIT | SQL | 10–18 | 6 |
| pg_semver | 0.0.1 | Version(SEMVER) data type for postgresql | TYPE | MIT | C | — | 6 |
| postcode | 1.3.0 | Store UK postcodes in a compact 32-bit type with validation, formatting, partial matching, and B-tree indexing | TYPE | BSD-2-Clause | C | — | 6 |
| jsonb_schema | 1.0 | jsonb with separately stored schema | TYPE | PostgreSQL | C | — | 5 |
| variant | 1.0.1 | Variant data type that can store values from other PostgreSQL types. | TYPE | BSD-2-Clause | C | — | 5 |
| device_type | 0.0.2 | Fixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes. | TYPE | PostgreSQL | C | 10–18 | 4 |
| kmea | 1.0 | K-Mer Extension for Analysis | TYPE | MIT | C | — | 4 |
| lpathtree | 1.0 | Hierarchical path types using slash-separated labels | TYPE | — | C | — | 4 |