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.

jsonb_plpython2u · Historical transform between jsonb and the untrusted PL/Python 2 language. · 1.0 · Procedural languages · Unknown · C · Not packagedplpython2u · Historical untrusted PL/Python 2 procedural language. · 1.0 · Procedural languages · Unknown · C · Not packagedplpythonu · Historical untrusted PL/Python procedural language. · 1.0 · Procedural languages · Unknown · C · Not packagedomnidb_plugin · PostgreSQL plugin for enabling PL/pgSQL debugger in OmniDB · 0.0.1 · Procedural languages · MIT · C · Not packagedplcoffee · CoffeeScript procedural language for PostgreSQL, compiled and executed by the PL/v8 runtime · 3.1.10 · Procedural languages · PostgreSQL · C++ · Not packagedplls · LiveScript procedural language for PostgreSQL, compiled and executed by the PL/v8 runtime · 3.1.10 · Procedural languages · PostgreSQL · C++ · Not packagedplv8 · PL/JavaScript (v8) trusted procedural language · 3.2.4 · Procedural languages · PostgreSQL · C++ · Packagedplrust · Compiles Rust functions to native code as a PostgreSQL procedural language, with optional postgrestd-backed trusted sandboxing. · 1.1 · Procedural languages · PostgreSQL · Rust · Not packagedpgtap · Unit testing for PostgreSQL · 1.3.4 · Procedural languages · PostgreSQL · C · Packagedplpgsql_check · Additional validation, profiling, and diagnostics for PL/pgSQL functions · 2.10.10 · Procedural languages · MIT · C · Packagedplprql · Use PRQL in PostgreSQL - Pipelined Relational Query Language · 18.0.2 · Procedural languages · Apache-2.0 · Rust · Packagedwasm · A Postgres extension to run WebAssembly binaries. · 0.1.0 · Procedural languages · MIT · Rust · Not packagedpg_tle · Trusted Language Extensions for PostgreSQL · 1.5.2 · Procedural languages · Apache-2.0 · C · Packagedpg_regresql · Trust pg_class statistics for planning instead of physical relation size · 2.0.0 · Procedural languages · BSD-2-Clause · C · Packagedpljava · PL/Java procedural language · 1.6.10 · Procedural languages · BSD-3-Clause · Java · Packagedpljs · PL/JS trusted procedural language · 1.0.5 · Procedural languages · PostgreSQL · C · Packagedplsh · PL/sh procedural language · 1.20220917 · Procedural languages · MIT · C · Packagedpldotnet · add C# and F# procedural languages to PostgreSQL through .NET · 0.9 · Procedural languages · PostgreSQL · C · Not packagedhstore_pllua · Hstore transform for Lua · 2.0.12 · Procedural languages · MIT · C · Packagedhstore_plluau · Hstore transform for untrusted Lua · 2.0.12 · Procedural languages · MIT · C · Packagedpllua · Lua as a procedural language · 2.0.12 · Procedural languages · MIT · C · Packagedplluau · Lua as an untrusted procedural language · 2.0.12 · Procedural languages · MIT · C · Packagedplhaskell · provide trusted and untrusted Haskell procedural languages for PostgreSQL · 5.0 · Procedural languages · GPL-3.0 · C · Not packagedpgprolog · PostgreSQL procedural language handler for Prolog, embedding Scryer Prolog. · 0.0.0 · Procedural languages · BSD-3-Clause · Rust · Not packagedplr · load R interpreter and execute R script from within a database · 8.4.8.6 · Procedural languages · GPL-2.0 · C · Packagedplprofiler · server-side support for profiling PL/pgSQL functions · 4.2.5 · Procedural languages · Artistic-1.0 · C · Packagedpldbgapi · server-side support for debugging PL/pgSQL functions · 1.10 · Procedural languages · Artistic-2.0 · C · Packagedbytea_plphp · Binary-safe transform between bytea and PHP strings for PL/php · 1.0 · Procedural languages · PostgreSQL · C · Not packagedhstore_plphp · Transform between hstore and PHP associative arrays for PL/php · 1.0 · Procedural languages · PostgreSQL · C · Not packagedjsonb_plphp · Transform between jsonb and native PHP values for PL/php · 1.0 · Procedural languages · PostgreSQL · C · Not packagedplphp · Embed PHP 8 as an untrusted PostgreSQL procedural language · 2.6 · Procedural languages · PostgreSQL · C · Not packagedplsci · PostgreSQL procedural language handler for Clojure via SCI · 1.0 · Procedural languages · EPL-1.0 · Rust · Not packagedhstore_plruby · Transform between hstore and Ruby Hashes for PL/Ruby · 1.0 · Procedural languages · MIT · C · Packagedjsonb_plruby · Transform between jsonb and native Ruby data for PL/Ruby · 1.0 · Procedural languages · MIT · C · Packagedltree_plruby · Transform between ltree and Ruby Arrays for PL/Ruby · 1.0 · Procedural languages · MIT · C · Packagedplruby · Embed MRI Ruby as an untrusted PostgreSQL procedural language · 2.5 · Procedural languages · MIT · C · Packagedplx · Transpile multiple procedural dialects to PL/pgSQL · 2.0.0 · Procedural languages · MIT · C · Packagedplparrot · Parrot Virtual Machine and Rakudo Perl 6 as PostgreSQL procedural languages · 0.4.0 · Procedural languages · Artistic-2.0 · C · Not packagedfaker · Wrapper for the Faker Python library · 0.5.3 · Procedural languages · PostgreSQL · Python · Packagedplxslt · XSLT procedural language for PostgreSQL · 0.20140221 · Procedural languages · PostgreSQL · C · Packagedpgtsql · provide Transact-SQL compatibility for PostgreSQL · 3.0 · Procedural languages · Unknown · C · Not packagedpgcov · Tracks test coverage in PL/PgSQL functions and requires shared_preload_libraries. · 1.0 · Procedural languages · MIT · C · Not packagedplmruby · Run scalar, set-returning, inline, and trigger functions in the embedded mruby runtime · 0.0.1 · Procedural languages · Unknown · C · Not packagedslowjit · A simple demo to illustrate how to implement a JIT provider for PostgreSQL. · 1.0.0 · Procedural languages · Unknown · C · Not packagedlambda · Lambda function for Postgres · 1.0.5 · Procedural languages · BSD-2-Clause · SQL · Not packagedpg_typescript · pg_typescript: TypeScript/JavaScript procedural language for PostgreSQL · 0.1.0 · Procedural languages · MIT · Rust · Not packageddbt2 · OSDL-DBT-2 test kit · 0.61.7 · Procedural languages · Artistic-2.0 · C · Packagederlang_cnode · Erlang C-node bridge for connecting PostgreSQL sessions to Erlang or Elixir nodes. · 1.0 · Procedural languages · Unknown · C · Not packagedomnidb_plpgsql_debugger · PostgreSQL extension for enabling PL/pgSQL debugger in OmniDB · 1.0.0 · Procedural languages · MIT · C · Not packagedpg_mockable · Create mockable wrappers for PostgreSQL functions in tests · 1.1.0 · Procedural languages · PostgreSQL · SQL · Packagedplswipl · Execute PostgreSQL functions and inline blocks in an embedded SWI-Prolog runtime · 0.1 · Procedural languages · MIT · C · Not packagedhstore_plpython2u · transform between hstore and plpython2u · 1.0 · Procedural languages · Unknown · C · Not packagedpg_jinx · JNI bridge for PostgreSQL stored procedures, triggers, and foreign data wrappers written in Java. · 2.3 · Procedural languages · Unknown · C · Not packagedpg_linegazer · Transparent code coverage for PL/pgSQL · 1.0 · Procedural languages · MIT · C · Not packagedpgosql · C procedural-language handler providing PL/SQL-style compatibility and Oracle-like sys catalog views. · 9.4 · Procedural languages · AGPL-3.0 · C · Not packagedpllju · LuaJIT FFI PostgreSQL language extension · 0.1 · Procedural languages · MIT · C · Not packagedbrainfuck · Run Brainfuck programs inside PostgreSQL using a PLV8 trusted language extension. · 4.2.0 · Procedural languages · Apache-2.0 · SQL · Not packagedpljvm · A PostgreSQL procedural language that sends function calls over RPC to code running in an external JVM process. · 1.0.0 · Procedural languages · BSD-3-Clause · C · Not packagedpg_plsql_graphs · Capture PL/pgSQL control-flow and dependence graphs for DOT export · 1.0 · Procedural languages · Unknown · C · Not packagedlispg · Lisp-like expression type and evaluator for PostgreSQL · 1.0 · Procedural languages · Unknown · C · Not packagednumpy_plpython2u · transform between numpy and plpython2u · 1.0 · Procedural languages · MIT · C · Not packagednumpy_plpython3u · transform between numpy and plpython3u · 1.0 · Procedural languages · MIT · C · Not packagednumpy_plpythonu · transform between numpy and plpythonu · 1.0 · Procedural languages · MIT · C · Not packagedpgsqlmock · Mocking and faking helpers for PostgreSQL unit tests · 1.0.1 · Procedural languages · PostgreSQL · SQL · Packagedpljulia · Embeds Julia as an untrusted PostgreSQL procedural language with SPI access, DO blocks, triggers, arrays, and composite-type conversion. · 0.8 · Procedural languages · PostgreSQL · C · Not packagedplpy_venv · Select and manage Python virtual environments for PL/Python functions. · 1.0 · Procedural languages · Unknown · SQL · Not packagedpostr · Embeds Ruby as an untrusted PostgreSQL procedural language supporting functions, DO blocks, triggers, and set-returning functions. · 0.1.0 · Procedural languages · MIT · Rust · Not packagedhstore_plpythonu · transform between hstore and plpythonu · 1.0 · Procedural languages · Unknown · C · Not packagedjsonb_plpythonu · Transform between JSONB and PL/PythonU values · 1.0 · Procedural languages · Unknown · C · Not packagedpgwasm · Run sandboxed WebAssembly components as strongly typed PostgreSQL SQL functions. · 0.1.0 · Procedural languages · BSD-3-Clause · Rust · Packagedpllisp · PL/Lisp toy extension · 0.1.0 · Procedural languages · BSD-3-Clause · C · Not packagedplocamlu · PL/OCaml Procedural Language Handler for PostgreSQL · 1.0 · Procedural languages · Unknown · C · Not packagedplsix · provide a Perl 6/Raku procedural language handler for PostgreSQL · 2 · Procedural languages · PostgreSQL · C · Not packagedbool_plperl · transform between bool and plperl · 1.0 · Procedural languages · PostgreSQL · C · Packagedbool_plperlu · transform between bool and plperlu · 1.0 · Procedural languages · PostgreSQL · C · Packagedhstore_plperl · transform between hstore and plperl · 1.0 · Procedural languages · PostgreSQL · C · Packagedhstore_plperlu · transform between hstore and plperlu · 1.0 · Procedural languages · PostgreSQL · C · Packagedhstore_plpython3u · transform between hstore and plpython3u · 1.0 · Procedural languages · PostgreSQL · C · Packagedjsonb_plperl · transform between jsonb and plperl · 1.0 · Procedural languages · PostgreSQL · C · Packagedjsonb_plperlu · transform between jsonb and plperlu · 1.0 · Procedural languages · PostgreSQL · C · Packagedjsonb_plpython3u · transform between jsonb and plpython3u · 1.0 · Procedural languages · PostgreSQL · C · Packagedltree_plpython2u · A fixed postgres xl so it can compile on newer versions of GCC and glibc · 1.0 · Procedural languages · Unknown · C · Not packagedltree_plpython3u · transform between ltree and plpython3u · 1.0 · Procedural languages · PostgreSQL · C · Packagedltree_plpythonu · transform between ltree and plpythonu · 1.0 · Procedural languages · Unknown · C · Not packagedpg_agg · Experimental aggregate-query support extension; its install script currently creates the untrusted PL/Python language. · 1.0 · Procedural languages · Unknown · Python · Not packagedpg_extism · An Extism sample showing how you can run Extism plugins from PostgreSQl using pgrx! · 0.0.0 · Procedural languages · Unknown · Rust · Not packagedplmuggin · PL/Muggin: an HTML templating language for PostgreSQL · 0.1 · Procedural languages · MIT · C · Not packagedplperl · PL/Perl procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedplperlu · PL/PerlU untrusted procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedplpgsql · PL/pgSQL procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedplpython3t · A SQL-only wrapper that registers PostgreSQL PL/Python 3 handlers as a trusted procedural language named plpython3t. · 1.0 · Procedural languages · Unknown · SQL · Not packagedplpython3u · PL/Python3U untrusted procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedpltcl · PL/Tcl procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedpltclu · PL/TclU untrusted procedural language · 1.0 · Procedural languages · PostgreSQL · C · Packagedspl_check · Static checks for EPAS SPL and PL/pgSQL routines. · Procedural languages · Proprietary · Unknown · Not packagedstopgap · pgrx deployment layer for versioned TypeScript/JavaScript function bundles backed by PLTS. · 0.1.3 · Procedural languages · MIT · Rust · Not packaged

96 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
jsonb_plpython2u 1.0 Historical transform between jsonb and the untrusted PL/Python 2 language. LANG C 22k
plpython2u 1.0 Historical untrusted PL/Python 2 procedural language. LANG C 22k
plpythonu 1.0 Historical untrusted PL/Python procedural language. LANG C 22k
omnidb_plugin 0.0.1 PostgreSQL plugin for enabling PL/pgSQL debugger in OmniDB LANG MIT C 3.3k
plcoffee 3.1.10 CoffeeScript procedural language for PostgreSQL, compiled and executed by the PL/v8 runtime LANG PostgreSQL C++ 10–16 2.1k
plls 3.1.10 LiveScript procedural language for PostgreSQL, compiled and executed by the PL/v8 runtime LANG PostgreSQL C++ 10–16 2.1k
plv8 3.2.4 PL/JavaScript (v8) trusted procedural language LANG PostgreSQL C++ 14–18 2.1k
plrust 1.1 Compiles Rust functions to native code as a PostgreSQL procedural language, with optional postgrestd-backed trusted sandboxing. LANG PostgreSQL Rust 13–16 1.4k
pgtap 1.3.4 Unit testing for PostgreSQL LANG PostgreSQL C 14–18 1.2k
plpgsql_check 2.10.10 Additional validation, profiling, and diagnostics for PL/pgSQL functions LANG MIT C 14–18 778
plprql 18.0.2 Use PRQL in PostgreSQL - Pipelined Relational Query Language LANG Apache-2.0 Rust 14–18 475
wasm 0.1.0 A Postgres extension to run WebAssembly binaries. LANG MIT Rust 10 430
pg_tle 1.5.2 Trusted Language Extensions for PostgreSQL LANG Apache-2.0 C 14–18 410
pg_regresql 2.0.0 Trust pg_class statistics for planning instead of physical relation size LANG BSD-2-Clause C 14–18 393
pljava 1.6.10 PL/Java procedural language LANG BSD-3-Clause Java 14–18 271
pljs 1.0.5 PL/JS trusted procedural language LANG PostgreSQL C 14–18 224
plsh 1.20220917 PL/sh procedural language LANG MIT C 14–18 178
pldotnet 0.9 add C# and F# procedural languages to PostgreSQL through .NET LANG PostgreSQL C 10–16 164
hstore_pllua 2.0.12 Hstore transform for Lua LANG MIT C 14–18 161
hstore_plluau 2.0.12 Hstore transform for untrusted Lua LANG MIT C 14–18 161
pllua 2.0.12 Lua as a procedural language LANG MIT C 14–18 161
plluau 2.0.12 Lua as an untrusted procedural language LANG MIT C 14–18 161
plhaskell 5.0 provide trusted and untrusted Haskell procedural languages for PostgreSQL LANG GPL-3.0 C 147
pgprolog 0.0.0 PostgreSQL procedural language handler for Prolog, embedding Scryer Prolog. LANG BSD-3-Clause Rust 11–16 134
plr 8.4.8.6 load R interpreter and execute R script from within a database LANG GPL-2.0 C 14–18 128
plprofiler 4.2.5 server-side support for profiling PL/pgSQL functions LANG Artistic-1.0 C 14–18 104
pldbgapi 1.10 server-side support for debugging PL/pgSQL functions LANG Artistic-2.0 C 14–18 94
bytea_plphp 1.0 Binary-safe transform between bytea and PHP strings for PL/php LANG PostgreSQL C 11–18 56
hstore_plphp 1.0 Transform between hstore and PHP associative arrays for PL/php LANG PostgreSQL C 11–18 56
jsonb_plphp 1.0 Transform between jsonb and native PHP values for PL/php LANG PostgreSQL C 11–18 56
plphp 2.6 Embed PHP 8 as an untrusted PostgreSQL procedural language LANG PostgreSQL C 11–18 56
plsci 1.0 PostgreSQL procedural language handler for Clojure via SCI LANG EPL-1.0 Rust 49
hstore_plruby 1.0 Transform between hstore and Ruby Hashes for PL/Ruby LANG MIT C 11–18 36
jsonb_plruby 1.0 Transform between jsonb and native Ruby data for PL/Ruby LANG MIT C 11–18 36
ltree_plruby 1.0 Transform between ltree and Ruby Arrays for PL/Ruby LANG MIT C 11–18 36
plruby 2.5 Embed MRI Ruby as an untrusted PostgreSQL procedural language LANG MIT C 11–18 36
plx 2.0.0 Transpile multiple procedural dialects to PL/pgSQL LANG MIT C 13–18 32
plparrot 0.4.0 Parrot Virtual Machine and Rakudo Perl 6 as PostgreSQL procedural languages LANG Artistic-2.0 C 27
faker 0.5.3 Wrapper for the Faker Python library LANG PostgreSQL Python 14–18 24
plxslt 0.20140221 XSLT procedural language for PostgreSQL LANG PostgreSQL C 14–18 20
pgtsql 3.0 provide Transact-SQL compatibility for PostgreSQL LANG C 11 12
pgcov 1.0 Tracks test coverage in PL/PgSQL functions and requires shared_preload_libraries. LANG MIT C 10–12 11
plmruby 0.0.1 Run scalar, set-returning, inline, and trigger functions in the embedded mruby runtime LANG C 11
slowjit 1.0.0 A simple demo to illustrate how to implement a JIT provider for PostgreSQL. LANG C 11
lambda 1.0.5 Lambda function for Postgres LANG BSD-2-Clause SQL 10
pg_typescript 0.1.0 pg_typescript: TypeScript/JavaScript procedural language for PostgreSQL LANG MIT Rust 14–18 9
dbt2 0.61.7 OSDL-DBT-2 test kit LANG Artistic-2.0 C 14–18 8
erlang_cnode 1.0 Erlang C-node bridge for connecting PostgreSQL sessions to Erlang or Elixir nodes. LANG C 8
omnidb_plpgsql_debugger 1.0.0 PostgreSQL extension for enabling PL/pgSQL debugger in OmniDB LANG MIT C 8
pg_mockable 1.1.0 Create mockable wrappers for PostgreSQL functions in tests LANG PostgreSQL SQL 14–18 8