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 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 · 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 · 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 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 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 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 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 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 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 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 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 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 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 · 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 · Packaged

73 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
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
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
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
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
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
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
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
plswipl 0.1 Execute PostgreSQL functions and inline blocks in an embedded SWI-Prolog runtime LANG MIT C 8
hstore_plpython2u 1.0 transform between hstore and plpython2u LANG C 7
pg_jinx 2.3 JNI bridge for PostgreSQL stored procedures, triggers, and foreign data wrappers written in Java. LANG C 7
pg_linegazer 1.0 Transparent code coverage for PL/pgSQL LANG MIT C 7
pgosql 9.4 C procedural-language handler providing PL/SQL-style compatibility and Oracle-like sys catalog views. LANG AGPL-3.0 C 7
pllju 0.1 LuaJIT FFI PostgreSQL language extension LANG MIT C 6
pljvm 1.0.0 A PostgreSQL procedural language that sends function calls over RPC to code running in an external JVM process. LANG BSD-3-Clause C 4
pg_plsql_graphs 1.0 Capture PL/pgSQL control-flow and dependence graphs for DOT export LANG C 3
lispg 1.0 Lisp-like expression type and evaluator for PostgreSQL LANG C 2
numpy_plpython2u 1.0 transform between numpy and plpython2u LANG MIT C 2
numpy_plpython3u 1.0 transform between numpy and plpython3u LANG MIT C 2
numpy_plpythonu 1.0 transform between numpy and plpythonu LANG MIT C 2
pljulia 0.8 Embeds Julia as an untrusted PostgreSQL procedural language with SPI access, DO blocks, triggers, arrays, and composite-type conversion. LANG PostgreSQL C 14–18 2