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
garyaustin-test_tle 0.0.2 test custom-properties. FEAT SQL
jsonpath 0.1 Run JSONPath queries through a bundled JavaScript implementation in PLV8 FEAT MIT SQL
medications 0.1.0 medications extension FEAT MIT SQL
nonoms 1.2.0 Normalised nomenclatural system for managing biological names and taxonomic understandings in PostgreSQL. FEAT SQL
object_reference 0.1.0 Provides immutable references to Postgres objects. FEAT BSD-3-Clause SQL
olirice-read_once 0.3.2 Send messages that can only be read once FEAT SQL
patients 0.1.0 patients extension FEAT MIT SQL
pg_abris 0.0.1 Abris metadata extension that creates a meta schema with metadata tables, views, and helper functions. FEAT SQL
pg_fairmlq 0.1.0 PL/pgSQL only implementation of a fair multi-level queue for multi-tenant applications FEAT MIT SQL
pg_fedi 0.2.0 Pure-SQL ActivityPub federation primitives for PostgreSQL and pg_tle environments. FEAT Apache-2.0 SQL
pg_once 0.1.0 Run‑once / idempotency‑key manager with TTL and response caching FEAT MIT SQL
pg_relay 1.0 Durable event processor for PostgreSQL FEAT SQL
pg_sakila_db 0.0.1 PostgreSQL extension for deploying a port of the Sakila example database. FEAT GPL-3.0 SQL
pg_siose_bench 0.0.1 A PostgreSQL extension for benchmarking different SIOSE database configurations (pure relational, with indexes, json, jsonb, xml, etc)) FEAT GPL-3.0 SQL
pg_spi 0.0.1 Failing test case for SPI rollback FEAT SQL
pgtap_fixture 0.0.1 A PostgreSQL extension that allows more complex fixtures to be created for pgTAP tests. FEAT MIT SQL
scripts 1.4 PhaseZero aftermarket application schema packaged as a PostgreSQL extension. FEAT SQL
tg_sanity 0.1.0 Trigger function for enforcing data quality. FEAT MIT SQL
tg_sanity_tap 0.1.0 pgtap testing function for tg sanity triggers FEAT MIT SQL