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.

pg_deltax · Fast time-series extension for PostgreSQL · 0.2.1 · Time series · Apache-2.0 · Rust · Not packagedrecall · Tracks table changes in per-table _log tables for timestamp-based history queries. · 0.9.6 · Time series · PostgreSQL · SQL · Not packagedtemporal · C extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support. · 0.7.1 · Time series · PostgreSQL · C · Not packagedjalali_utils · Convert Gregorian dates and timestamps to Jalali calendar values. · 0.0.1 · Time series · Unknown · C · Not packagedtown · Minimal PL/pgSQL helper that creates JSONB-and-array time-series tables with GIN and GiST indexes. · 0.1.0 · Time series · MIT · SQL · Not packagedpgchronos · SQL functions and operators for union, intersection, and difference over daterange and tstzrange arrays. · 1.0.2 · Time series · BSD-3-Clause · SQL · Not packagedtime_for_keys · C and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers. · 0.0.1 · Time series · MIT · C · Not packagedkilobase · Preloaded pgrx background worker for scheduling and refreshing PostgreSQL materialized views. · 17.4.1 · Time series · Unknown · Rust · Not packagedpostgres_ical · parse RFC 5545 iCalendar text and URLs inside PostgreSQL · 0.1.0 · Time series · Unknown · Rust · Not packagedschedulerx · Prototype background-worker scheduler for periodic, one-shot, and NOTIFY-triggered SQL jobs. · 1.0 · Time series · BSD-3-Clause · C · Not packagedworkalendar · PostgreSQL extension for Workalendar · 1.0.0 · Time series · Unknown · SQL · Not packagedpg_ethiopian_calendar · Convert between Gregorian and Ethiopian calendar dates · 1.1 · Time series · PostgreSQL · C · Not packagedistoria · Table history management with non-linear undo/redo · 1.1 · Time series · GPL-3.0 · SQL · Not packagedpgts · time encode for PostgreSQL · 0.1.0 · Time series · MIT · C · Not packagedworker_spark · A background worker for PostgreSQL 9.3 which executed a procedure at regular intervals. · 0.0.1 · Time series · PostgreSQL · C · Not packagedcalendars · calendar conversion routines · 1.0 · Time series · BSD-3-Clause · C · Not packagedflux · Logs table data changes and reconstructs rows as they existed in the past. · 0.3 · Time series · Unknown · SQL · Not packagedpg_background_queue · Topic-aware background SQL task queue with concurrency limits and retries. · 1.0 · Time series · GPL-3.0 · C · Not packagedpg_change_point_detection · A Postgres extension to detect change points in time series data · 1.0 · Time series · Unknown · C · Not packagedbitemp_retrieval · Retrieval, coalescing, and join helpers for bitemporal tables created by pg_bitemporal. · 0.0.1 · Time series · Unknown · C · Not packagedkq_cx · Preloaded in-memory calendar cache and date-arithmetic functions for ketteQ PostgreSQL schemas. · 1.0.1 · Time series · Unknown · Rust · Not packagedpg_flashback · Table-level point-in-time restore and time-travel queries for PostgreSQL using trigger or WAL capture. · 0.1.0 · Time series · MIT · Rust · Not packagedpg_timelord · Proof-of-concept time-travel queries using commit timestamps and a custom MVCC snapshot. · 0.0.1 · Time series · PostgreSQL · C · Not packagedpgtime · Temporal tables extension for PostgreSQL. Automatically tracks Transaction Time (system time) on any table using range types and a high-performance C-based AFTER ROW trigger. · 0.1 · Time series · MIT · C · Not packagedschedule · Cron-formatted schedule type and UTC timestamp-matching functions for PostgreSQL. · 1.0 · Time series · MIT · C · Not packagedtimeflux · TimeFlux+: Advanced Time-Series Storage Engine · 1.0 · Time series · MulanPSL-2.0 · C++ · Not packagedalohadb_timeseries · Auto-partition management for time-series tables using a background worker · 1.0 · Time series · MIT · C · Not packagedauto_job · A PostgreSQL extension for background job scheduling · 1.0.0 · Time series · Unknown · C · Not packagedchronoturtle · Git-like branches and append-only row history for tables · 0.1.0 · Time series · PostgreSQL · PLpgSQL · Not packageddate_string_converter · pgrx extension skeleton for date-string conversion; current source exposes hello_date_string_converter(). · 0.0.0 · Time series · Unknown · Rust · Not packageddbms_job · EPAS Oracle-compatible DBMS_JOB package backed by EDB Job Scheduler. · Time series · Proprietary · SQL · Not packageddbms_scheduler · EPAS Oracle-compatible DBMS_SCHEDULER programs, schedules, and jobs. · Time series · Proprietary · SQL · Not packagededb_job_scheduler · EPAS background-worker runtime for scheduled database jobs. · Time series · Proprietary · Unknown · Not packagededtf_postgres · EDTF validation, normalization, date bounds, and temporal relations. · 1.2.3 · Time series · MIT OR Apache-2.0 · Rust · Not packagedfind_bucket_ts · Artifacts of BaCon. For VLDB26 reviewers only. · 1.0 · Time series · Unknown · Python · Not packagedgeekspeak_calendar · Calendar and iCalendar integration for GeekSpeak podcast recording schedules and episodes. · 1.0.0 · Time series · MIT · SQL · Not packagedmmddyyyy · Educational date type with B-tree, wildcard patterns, and GiST nearest-neighbor search · 0.1.0 · Time series · Unknown · C · Not packagedpgAutomator · Database logic for the pgAutomator job scheduling system. · 0.0.1 · Time series · MIT · SQL · Not packagedpg_cron_helper · Extension to help functionality of pg_cron · 0.3 · Time series · GPL-3.0 · SQL · Not packagedpg_ical · RRULE recurrence functions for PostgreSQL backed by libical · 0.2.0 · Time series · MIT · C · Not packagedpg_jalali_calendar · Jalali/Persian calendar date conversion and helper functions for PostgreSQL. · 0.1.0 · Time series · Unknown · Rust · Not packagedpg_timers · Schedule SQL execution at exact times or after intervals in PostgreSQL · 0.0.0 · Time series · PostgreSQL · C · Not packagedscheduler · Extension that enables flexible scheduling and execution of SQL and shell jobs directly within your database · 1.0 · Time series · MIT · C · Not packagedscheduling · pgpm demo for the Postgres Conference 2026 · 0.1.0 · Time series · MIT · C · Not packagedsimple_timeseries · time-series extension · 1.0 · Time series · MIT · C · Not packagedsql_saga · C and PL/pgSQL extension for valid-time temporal tables, temporal foreign keys, history-preserving views, and bulk temporal merge operations. · 1.0 · Time series · MIT · C · Not packagedsql_saga_native · Rust/pgrx companion library that accelerates sql_saga temporal_merge planning and executor introspection. · 0.1.0 · Time series · MIT · Rust · Not packagedtemporal_rtree · Experimental temporal R-tree access method implemented as a PostgreSQL extension. · 1.0 · Time series · Unknown · C · Not packagedtimeql · Native temporal history tracking and point-in-time queries using PostgreSQL range types and GiST indexes. · 1.0 · Time series · MIT · C · Not packagedtimetravel · TencentDB for PostgreSQL provider extension named timetravel, available as version 1.0 on PostgreSQL 10 and 11. · 1.0 · Time series · Unknown · C · Not packaged

50 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pg_deltax 0.2.1 Fast time-series extension for PostgreSQL TIME Apache-2.0 Rust 284
recall 0.9.6 Tracks table changes in per-table _log tables for timestamp-based history queries. TIME PostgreSQL SQL 10–18 55
temporal 0.7.1 C extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support. TIME PostgreSQL C 50
jalali_utils 0.0.1 Convert Gregorian dates and timestamps to Jalali calendar values. TIME C 12–18 40
town 0.1.0 Minimal PL/pgSQL helper that creates JSONB-and-array time-series tables with GIN and GiST indexes. TIME MIT SQL 31
pgchronos 1.0.2 SQL functions and operators for union, intersection, and difference over daterange and tstzrange arrays. TIME BSD-3-Clause SQL 10–18 25
time_for_keys 0.0.1 C and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers. TIME MIT C 23
kilobase 17.4.1 Preloaded pgrx background worker for scheduling and refreshing PostgreSQL materialized views. TIME Rust 17–18 21
postgres_ical 0.1.0 parse RFC 5545 iCalendar text and URLs inside PostgreSQL TIME Rust 12–17 13
schedulerx 1.0 Prototype background-worker scheduler for periodic, one-shot, and NOTIFY-triggered SQL jobs. TIME BSD-3-Clause C 7
workalendar 1.0.0 PostgreSQL extension for Workalendar TIME SQL 6
pg_ethiopian_calendar 1.1 Convert between Gregorian and Ethiopian calendar dates TIME PostgreSQL C 11–18 5
istoria 1.1 Table history management with non-linear undo/redo TIME GPL-3.0 SQL 4
pgts 0.1.0 time encode for PostgreSQL TIME MIT C 3
worker_spark 0.0.1 A background worker for PostgreSQL 9.3 which executed a procedure at regular intervals. TIME PostgreSQL C 3
calendars 1.0 calendar conversion routines TIME BSD-3-Clause C 2
flux 0.3 Logs table data changes and reconstructs rows as they existed in the past. TIME SQL 2
pg_background_queue 1.0 Topic-aware background SQL task queue with concurrency limits and retries. TIME GPL-3.0 C 13–18 2
pg_change_point_detection 1.0 A Postgres extension to detect change points in time series data TIME C 2
bitemp_retrieval 0.0.1 Retrieval, coalescing, and join helpers for bitemporal tables created by pg_bitemporal. TIME C 1
kq_cx 1.0.1 Preloaded in-memory calendar cache and date-arithmetic functions for ketteQ PostgreSQL schemas. TIME Rust 15–18 1
pg_flashback 0.1.0 Table-level point-in-time restore and time-travel queries for PostgreSQL using trigger or WAL capture. TIME MIT Rust 13–18 1
pg_timelord 0.0.1 Proof-of-concept time-travel queries using commit timestamps and a custom MVCC snapshot. TIME PostgreSQL C 1
pgtime 0.1 Temporal tables extension for PostgreSQL. Automatically tracks Transaction Time (system time) on any table using range types and a high-performance C-based AFTER ROW trigger. TIME MIT C 1
schedule 1.0 Cron-formatted schedule type and UTC timestamp-matching functions for PostgreSQL. TIME MIT C 1
timeflux 1.0 TimeFlux+: Advanced Time-Series Storage Engine TIME MulanPSL-2.0 C++ 1
alohadb_timeseries 1.0 Auto-partition management for time-series tables using a background worker TIME MIT C
auto_job 1.0.0 A PostgreSQL extension for background job scheduling TIME C
chronoturtle 0.1.0 Git-like branches and append-only row history for tables TIME PostgreSQL PLpgSQL 16
date_string_converter 0.0.0 pgrx extension skeleton for date-string conversion; current source exposes hello_date_string_converter(). TIME Rust 11–16
dbms_job EPAS Oracle-compatible DBMS_JOB package backed by EDB Job Scheduler. TIME Proprietary SQL
dbms_scheduler EPAS Oracle-compatible DBMS_SCHEDULER programs, schedules, and jobs. TIME Proprietary SQL
edb_job_scheduler EPAS background-worker runtime for scheduled database jobs. TIME Proprietary
edtf_postgres 1.2.3 EDTF validation, normalization, date bounds, and temporal relations. TIME MIT OR Apache-2.0 Rust 14–18
find_bucket_ts 1.0 Artifacts of BaCon. For VLDB26 reviewers only. TIME Python
geekspeak_calendar 1.0.0 Calendar and iCalendar integration for GeekSpeak podcast recording schedules and episodes. TIME MIT SQL
mmddyyyy 0.1.0 Educational date type with B-tree, wildcard patterns, and GiST nearest-neighbor search TIME C 17
pgAutomator 0.0.1 Database logic for the pgAutomator job scheduling system. TIME MIT SQL
pg_cron_helper 0.3 Extension to help functionality of pg_cron TIME GPL-3.0 SQL
pg_ical 0.2.0 RRULE recurrence functions for PostgreSQL backed by libical TIME MIT C 11–12
pg_jalali_calendar 0.1.0 Jalali/Persian calendar date conversion and helper functions for PostgreSQL. TIME Rust 18
pg_timers 0.0.0 Schedule SQL execution at exact times or after intervals in PostgreSQL TIME PostgreSQL C 15–18
scheduler 1.0 Extension that enables flexible scheduling and execution of SQL and shell jobs directly within your database TIME MIT C
scheduling 0.1.0 pgpm demo for the Postgres Conference 2026 TIME MIT C
simple_timeseries 1.0 time-series extension TIME MIT C
sql_saga 1.0 C and PL/pgSQL extension for valid-time temporal tables, temporal foreign keys, history-preserving views, and bulk temporal merge operations. TIME MIT C 18
sql_saga_native 0.1.0 Rust/pgrx companion library that accelerates sql_saga temporal_merge planning and executor introspection. TIME MIT Rust 18
temporal_rtree 1.0 Experimental temporal R-tree access method implemented as a PostgreSQL extension. TIME C
timeql 1.0 Native temporal history tracking and point-in-time queries using PostgreSQL range types and GiST indexes. TIME MIT C
timetravel 1.0 TencentDB for PostgreSQL provider extension named timetravel, available as version 1.0 on PostgreSQL 10 and 11. TIME C 10–11