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.

pgmq · A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. · 1.13.0 · Features · PostgreSQL · SQL · Packagedindex_advisor · Query index advisor · 0.2.0 · Features · PostgreSQL · SQL · Packagedbundle · data version control system · 0.4.0 · Features · GPL-3.0 · SQL · Not packageddocumentation · Aquameta internal documentation system · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedendpoint · endpoint extension · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedevent · pub/sub data change event tracking system · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedide · Aquameta IDE · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedsemantics · Aquameta Semantics Extension · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedwidget · Aquameta widget framework · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedbasejump_core · Basejump adds accounts, teams, permissions and billing to Supabase. · 2.0.1 · Features · MIT · SQL · Not packagedpostgres-json-schema · Pure PL/pgSQL functions for validating PostgreSQL jsonb documents against JSON Schema draft 4, including use in CHECK constraints. · 0.1.1 · Features · PostgreSQL · SQL · Not packagedbasejump-supabase_test_helpers · A collection of functions designed to make testing Supabase projects easier. · 0.0.6 · Features · MIT · SQL · Not packagedpgfsm · Finite State Machine enforcement with triggers and util functions. · 0.0.1 · Features · CC0-1.0 · SQL · Not packagedpg_message_queue · Listen/Notify-based PostgreSQL message queue extension · 0.2.1 · Features · PostgreSQL · SQL · Not packagedpg_doc_store · Provides a JSONB document-store API with full-text search. · 0.2.1 · Features · PostgreSQL · SQL · Not packagedsupa_queue · Simple PostgreSQL job queue that dispatches asynchronous HTTP requests with pg_net, schedules processing and retries with pg_cron, and stores endpoint credentials in Supabase Vault. · 1.0.4 · Features · Apache-2.0 · SQL · Not packagedpostgres_ci · Implements the database backend for the defunct Postgres-CI service, including users, projects, builds, hooks, sessions, and notifications. · 0.3 · Features · MIT · SQL · Not packagedmeta_triggers · Insert, update and delete triggers for the meta system catalog · 0.5.0 · Features · BSD-2-Clause · SQL · Not packagedjson_model · JSON Model PL/pgSQL Runtime - JSON value validation · 2.0 · Features · Public Domain · SQL · Not packagedpgmock · SQL/PLpgSQL extension for mocking function and table dependencies in PostgreSQL unit tests · 0.2 · Features · MIT · SQL · Not packagednorm · No-ORM helper extension that generates simple CRUD functions. · 0.0.1 · Features · GPL-3.0 · SQL · Not packagedfetchq · Postgres extension that enables FetchQ capabilities · 4.0.2 · Features · MIT · SQL · Not packagedkonfigraf · Git based application configuration · 0.0.2 · Features · MIT · SQL · Not packagedpgwebhook · A very powerful extension to use webhooks and interact with Supabase Edge Functions · 0.1.2 · Features · Apache-2.0 · SQL · Not packagedindex_analyzer · PL/pgSQL functions for evaluating existing and prospective indexes and checking foreign-key indexing. · 0.1.0 · Features · BSD-2-Clause · SQL · Not packagedmbus · simple message bus for pg · 1.1 · Features · Unknown · SQL · Not packagedpg_os · PostgreSQL extension providing operating system-level functionality directly through SQL, enabling process management, file system operations, IPC, and system monitoring within the database environment. · 1.0 · Features · MIT · SQL · Not packagedpgmb · A simple PostgreSQL Message Broker system · 1.0.0 · Features · PostgreSQL · SQL · Packagedpgque · Pure SQL PostgreSQL job queue that orders jobs by priority and claims them with advisory locks. · 0.1.0 · Features · Unknown · SQL · Not packagedqgres · Simple queue system · 0.1.2 · Features · PostgreSQL · SQL · Not packagedsession_variables · SQL functions for storing and retrieving session-scoped values through custom PostgreSQL settings. · 0.0.4 · Features · PostgreSQL · SQL · Not packagedmy_extension · A Basic PostgreSQL Extension · 1.1.0 · Features · PostgreSQL · SQL · Not packagedpg_fossa · Archived SQL extension supporting FOSSA hasGraph data structures and queries. · 1.7 · Features · Unknown · SQL · Not packagedpg_thud · Framework extending pgtap with scaffolding and test-data helpers for database unit tests. · 0.1.0 · Features · PostgreSQL · SQL · Not packagedwiki · In-database wiki data model and SQL/PLPerl API with optional MediaWiki integration. · 0.1 · Features · PostgreSQL · SQL · Not packagedfsm_core · Finite state machine toolkit for PostgreSQL · 1.1.0 · Features · Apache-2.0 · SQL · Packagedgeekspeak · Database schema extension for the GeekSpeak podcast website. · 1.0.0 · Features · GPL-2.0 · SQL · Not packagednewsfeeds · PostgreSQL extension for gathering news · 1.0.0 · Features · GPL-2.0 · SQL · Not packagedpg2podg · PostgreSQL extension for two-player open deterministic games. · 0.1.3 · Features · GPL-3.0 · SQL · Not packagedpg_cache_tree · Caches recursive parent and child IDs in array columns using trigger and helper functions. · 1.0.0 · Features · MIT · SQL · Not packagedpg_git · Implements Git-like repositories, commits, branches, merges and remote operations using PostgreSQL-native data and functions. · 0.4.0 · Features · PostgreSQL · SQL · Not packagedpg_semantius · Database-first application backend with RBAC, RLS, data dictionary, and message queue. · 0.4.0 · Features · MIT · SQL · Not packagedpgwtc · Dataset and counterpoint-analysis tools for Bach's Well-Tempered Clavier fugues. · 0.1 · Features · Unknown · SQL · Not packagedtest_factory · Framework for registering, creating, caching, and reusing named PostgreSQL test data sets. · 0.5.0 · Features · BSD-2-Clause · SQL · Not packagedtest_factory_pgtap · A framework for managing test data · 0.1.0 · Features · BSD-2-Clause · SQL · Not packagedaccount · Add team, billing, and permission support to Supabase. · 0.1.2 · Features · Unknown · SQL · Not packagedasghonim@pgho_inbox · Inbound contact and inbox framework with validation, rate limiting, spam scoring, workflow state, and notification events. · 0.0.3 · Features · Unknown · SQL · Not packagedcdb_extension_fw · experimental framework for PostgreSQL extension boilerplate · current · Features · Unknown · SQL · Not packagedcountries · Pure-SQL package that creates and seeds a public.countries reference table. · 0.0.4 · Features · Unknown · SQL · Not packagedfhirbase · Incomplete PostgreSQL extension scaffold for a FHIR database. · 1.0 · Features · EPL-1.0 · SQL · Not packagedgaryaustin-test_tle · test custom-properties. · 0.0.2 · Features · Unknown · SQL · Not packagedjsonpath · Run JSONPath queries through a bundled JavaScript implementation in PLV8 · 0.1 · Features · MIT · SQL · Not packagedmedications · medications extension · 0.1.0 · Features · MIT · SQL · Not packagednonoms · Normalised nomenclatural system for managing biological names and taxonomic understandings in PostgreSQL. · 1.2.0 · Features · Unknown · SQL · Not packagedobject_reference · Provides immutable references to Postgres objects. · 0.1.0 · Features · BSD-3-Clause · SQL · Not packagedolirice-read_once · Send messages that can only be read once · 0.3.2 · Features · Unknown · SQL · Not packagedpatients · patients extension · 0.1.0 · Features · MIT · SQL · Not packagedpg_abris · Abris metadata extension that creates a meta schema with metadata tables, views, and helper functions. · 0.0.1 · Features · Unknown · SQL · Not packagedpg_fairmlq · PL/pgSQL only implementation of a fair multi-level queue for multi-tenant applications · 0.1.0 · Features · MIT · SQL · Not packagedpg_fedi · Pure-SQL ActivityPub federation primitives for PostgreSQL and pg_tle environments. · 0.2.0 · Features · Apache-2.0 · SQL · Not packagedpg_once · Run‑once / idempotency‑key manager with TTL and response caching · 0.1.0 · Features · MIT · SQL · Not packagedpg_relay · Durable event processor for PostgreSQL · 1.0 · Features · Unknown · SQL · Not packagedpg_sakila_db · PostgreSQL extension for deploying a port of the Sakila example database. · 0.0.1 · Features · GPL-3.0 · SQL · Not packagedpg_siose_bench · A PostgreSQL extension for benchmarking different SIOSE database configurations (pure relational, with indexes, json, jsonb, xml, etc)) · 0.0.1 · Features · GPL-3.0 · SQL · Not packagedpg_spi · Failing test case for SPI rollback · 0.0.1 · Features · Unknown · SQL · Not packagedpgtap_fixture · A PostgreSQL extension that allows more complex fixtures to be created for pgTAP tests. · 0.0.1 · Features · MIT · SQL · Not packagedscripts · PhaseZero aftermarket application schema packaged as a PostgreSQL extension. · 1.4 · Features · Unknown · SQL · Not packagedtg_sanity · Trigger function for enforcing data quality. · 0.1.0 · Features · MIT · SQL · Not packagedtg_sanity_tap · pgtap testing function for tg sanity triggers · 0.1.0 · Features · MIT · SQL · Not packaged

69 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pgmq 1.13.0 A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. FEAT PostgreSQL SQL 14–18 5.1k
index_advisor 0.2.0 Query index advisor FEAT PostgreSQL SQL 14–18 1.7k
bundle 0.4.0 data version control system FEAT GPL-3.0 SQL 1.1k
documentation 0.5.0 Aquameta internal documentation system FEAT GPL-3.0 SQL 1.1k
endpoint 0.5.0 endpoint extension FEAT GPL-3.0 SQL 1.1k
event 0.5.0 pub/sub data change event tracking system FEAT GPL-3.0 SQL 1.1k
ide 0.5.0 Aquameta IDE FEAT GPL-3.0 SQL 1.1k
semantics 0.5.0 Aquameta Semantics Extension FEAT GPL-3.0 SQL 1.1k
widget 0.5.0 Aquameta widget framework FEAT GPL-3.0 SQL 1.1k
basejump_core 2.0.1 Basejump adds accounts, teams, permissions and billing to Supabase. FEAT MIT SQL 941
postgres-json-schema 0.1.1 Pure PL/pgSQL functions for validating PostgreSQL jsonb documents against JSON Schema draft 4, including use in CHECK constraints. FEAT PostgreSQL SQL 508
basejump-supabase_test_helpers 0.0.6 A collection of functions designed to make testing Supabase projects easier. FEAT MIT SQL 131
pgfsm 0.0.1 Finite State Machine enforcement with triggers and util functions. FEAT CC0-1.0 SQL 17 71
pg_message_queue 0.2.1 Listen/Notify-based PostgreSQL message queue extension FEAT PostgreSQL SQL 10–18 21
pg_doc_store 0.2.1 Provides a JSONB document-store API with full-text search. FEAT PostgreSQL SQL 10–18 15
supa_queue 1.0.4 Simple PostgreSQL job queue that dispatches asynchronous HTTP requests with pg_net, schedules processing and retries with pg_cron, and stores endpoint credentials in Supabase Vault. FEAT Apache-2.0 SQL 10–18 15
postgres_ci 0.3 Implements the database backend for the defunct Postgres-CI service, including users, projects, builds, hooks, sessions, and notifications. FEAT MIT SQL 10
meta_triggers 0.5.0 Insert, update and delete triggers for the meta system catalog FEAT BSD-2-Clause SQL 9
json_model 2.0 JSON Model PL/pgSQL Runtime - JSON value validation FEAT Public Domain SQL 8
pgmock 0.2 SQL/PLpgSQL extension for mocking function and table dependencies in PostgreSQL unit tests FEAT MIT SQL 10 8
norm 0.0.1 No-ORM helper extension that generates simple CRUD functions. FEAT GPL-3.0 SQL 7
fetchq 4.0.2 Postgres extension that enables FetchQ capabilities FEAT MIT SQL 6
konfigraf 0.0.2 Git based application configuration FEAT MIT SQL 6
pgwebhook 0.1.2 A very powerful extension to use webhooks and interact with Supabase Edge Functions FEAT Apache-2.0 SQL 5
index_analyzer 0.1.0 PL/pgSQL functions for evaluating existing and prospective indexes and checking foreign-key indexing. FEAT BSD-2-Clause SQL 4
mbus 1.1 simple message bus for pg FEAT SQL 4
pg_os 1.0 PostgreSQL extension providing operating system-level functionality directly through SQL, enabling process management, file system operations, IPC, and system monitoring within the database environment. FEAT MIT SQL 3
pgmb 1.0.0 A simple PostgreSQL Message Broker system FEAT PostgreSQL SQL 14–18 3
pgque 0.1.0 Pure SQL PostgreSQL job queue that orders jobs by priority and claims them with advisory locks. FEAT SQL 3
qgres 0.1.2 Simple queue system FEAT PostgreSQL SQL 3
session_variables 0.0.4 SQL functions for storing and retrieving session-scoped values through custom PostgreSQL settings. FEAT PostgreSQL SQL 10–18 3
my_extension 1.1.0 A Basic PostgreSQL Extension FEAT PostgreSQL SQL 2
pg_fossa 1.7 Archived SQL extension supporting FOSSA hasGraph data structures and queries. FEAT SQL 2
pg_thud 0.1.0 Framework extending pgtap with scaffolding and test-data helpers for database unit tests. FEAT PostgreSQL SQL 10–18 2
wiki 0.1 In-database wiki data model and SQL/PLPerl API with optional MediaWiki integration. FEAT PostgreSQL SQL 10–12 2
fsm_core 1.1.0 Finite state machine toolkit for PostgreSQL FEAT Apache-2.0 SQL 15–18 1
geekspeak 1.0.0 Database schema extension for the GeekSpeak podcast website. FEAT GPL-2.0 SQL 10 1
newsfeeds 1.0.0 PostgreSQL extension for gathering news FEAT GPL-2.0 SQL 10–18 1
pg2podg 0.1.3 PostgreSQL extension for two-player open deterministic games. FEAT GPL-3.0 SQL 10–18 1
pg_cache_tree 1.0.0 Caches recursive parent and child IDs in array columns using trigger and helper functions. FEAT MIT SQL 10–18 1
pg_git 0.4.0 Implements Git-like repositories, commits, branches, merges and remote operations using PostgreSQL-native data and functions. FEAT PostgreSQL SQL 12–18 1
pg_semantius 0.4.0 Database-first application backend with RBAC, RLS, data dictionary, and message queue. FEAT MIT SQL 18 1
pgwtc 0.1 Dataset and counterpoint-analysis tools for Bach's Well-Tempered Clavier fugues. FEAT SQL 1
test_factory 0.5.0 Framework for registering, creating, caching, and reusing named PostgreSQL test data sets. FEAT BSD-2-Clause SQL 1
test_factory_pgtap 0.1.0 A framework for managing test data FEAT BSD-2-Clause SQL 1
account 0.1.2 Add team, billing, and permission support to Supabase. FEAT SQL
asghonim@pgho_inbox 0.0.3 Inbound contact and inbox framework with validation, rate limiting, spam scoring, workflow state, and notification events. FEAT SQL
cdb_extension_fw current experimental framework for PostgreSQL extension boilerplate FEAT SQL
countries 0.0.4 Pure-SQL package that creates and seeds a public.countries reference table. FEAT SQL
fhirbase 1.0 Incomplete PostgreSQL extension scaffold for a FHIR database. FEAT EPL-1.0 SQL