PGEXT - the PostgreSQL Extension Catalog

Harness the synergistic superpower of the PostgreSQL extensions ecosystem with three things:

  • PIG CLI : The PostgreSQL Extension Package Manager for Linux - pig
  • Catalog : Find the extension you need, with unparalleled 420+ extensions included
  • Repository : Get pre-made RPM/DEB packages for 10 mainstream Linux OS
Package Manager
The missing package manager for PostgreSQL & Extensions Ecosystem
Extension Catalog
The complete list of 420+ available PostgreSQL extensions
Software Repository
The APT / DNF repo that deliver PostgreSQL extensions in native Linux format

Just use PostgreSQL for everything! Also check our blog post: PostgreSQL is eating the Database World

ecosystem

Catalog

TIME
GIS
RAG
FTS
OLAP
FEAT
LANG
TYPE

UTIL
FUNC
ADMIN
STAT
SEC
FDW
SIM
ETL

TIME
TimescaleDB, Versioning & Temporal Table, Crontab, Async & Background Job Scheduler, …
GIS
GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc…
RAG
Vector Database with IVFFLAT, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc…
FTS
ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…
OLAP
DuckDB Integration with FDW & PG Lakehouse, Access Parquet from File/S3, Sharding with Citus/Partman/PlProxy, …
FEAT
OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,…
LANG
Develop, Test, Package, and Deliver Stored Procedures written in various PL/Languages: Java, Js, Lua, R, Sh, PRQL, …
TYPE
Dedicate New Data Types Like: prefix, sember, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more…
UTIL
Utilities such as send http request, perform gzip/zstd compress, send mails, Regex, ICU, encoding, docs, Encryption,…
FUNC
Function such as id generator, aggregations, sketches, vector functions, mathematical functions and digest functions…
ADMIN
Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…
STAT
Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc…
SEC
Auditing Logs, Enforce Passwords, Keep Secrets, TDE, SM Algorithm, Login Hooks, Log Error, Extension White List, …
FDW
Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,…
SIM
Protocol Simulation & heterogeneous DBMS Compatibility: Oracle, MSSQL, DB2, MySQL, Memcached, and Babelfish!
ETL
Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,…

MIT
ISC
PostgreSQL
BSD 0-Clause
BSD 2-Clause
BSD 3-Clause
Artistic
Apache-2.0
MPL-2.0

GPL-2.0
GPL-3.0
LGPL-2.1
LGPL-3.0
AGPL-3.0
Timescale
C
C++
Rust
Java
Python
SQL
Data

Projects

Related projects on GitHub: github.com/pgsty

GitHub RepoDescription
github.com/pgsty/pigstyPostgreSQL Database Distribution
github.com/pgsty/pigPostgreSQL Package Manager
github.com/pgsty/extThis documentation site, Extension Catalog
github.com/pgsty/rpmRPM Building Specs
github.com/pgsty/debDEB Building Specs
github.com/pgsty/infra-pkgInfra Package Building Specs
Last updated on