1225+ PostgreSQL Extensions Ranked & Compared
Every Postgres server extension (pgvector, PostGIS, pg_cron, Citus, and 1,200+ more), ranked by GitHub stars and grouped by category.
AWS RDSEnables scalable inserts and complex queries for time-series data
Enables scalable inserts and complex queries for time-series data
vector data type and ivfflat and hnsw access methods
Distributed PostgreSQL as an extension
Full text search for PostgreSQL using BM25
Run AL/ML workloads with SQL interface
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
Pluggable PostgreSQL storage engine using undo logs, copy-on-write checkpoints, and 64-bit transaction IDs.
Pluggable PostgreSQL storage engine using undo logs, copy-on-write checkpoints, and 64-bit transaction IDs.
Job scheduler for PostgreSQL
Cheminformatics functionality for PostgreSQL.
API surface for DocumentDB for PostgreSQL
Add in-database GraphQL support
Advanced indexing for vector data with DiskANN
Extension to manage partitioned tables by time or ID
Extension to manage partitioned tables by time or ID
Runs continuous SQL queries that incrementally aggregate streaming time-series data and store only aggregate output in queryable tables.
Runs continuous SQL queries that incrementally aggregate streaming time-series data and store only aggregate output in queryable tables.
Reorganize tables in PostgreSQL databases with minimal locks
Reorganize tables in PostgreSQL databases with minimal locks
PL/JavaScript (v8) trusted procedural language
Columnstore Table in Postgres
Vector database plugin for Postgres, written in Rust
Provides columnar storage for analytics workloads via a foreign data wrapper, with ORC-inspired compression and skip indexes.
Provides columnar storage for analytics workloads via a foreign data wrapper, with ORC-inspired compression and skip indexes.
Hypothetical indexes for PostgreSQL
Replication manager for PostgreSQL
provides auditing functionality
HTTP client for PostgreSQL, allows web page retrieval inside the database.
HTTP client for PostgreSQL, allows web page retrieval inside the database.
Advanced adapter for Postgres extensions
Changing data capture in JSON format
incremental view maintenance on PostgreSQL
PG-Strom - big-data processing acceleration using GPU and NVME
PG-Strom - big-data processing acceleration using GPU and NVME
pg_auto_failover
PostgreSQL Logical Replication
type for storing hyperloglog data
PostgreSQL extension providing JSON Schema validation
PostgreSQL extension providing JSON Schema validation
Active-Active Replication Extension for PostgreSQL
Shards and replicates PostgreSQL tables across multiple nodes for horizontal scaling (superseded by Citus).
Shards and replicates PostgreSQL tables across multiple nodes for horizontal scaling (superseded by Citus).
Give PostgreSQL ability to manually force some decisions in execution plans.
Give PostgreSQL ability to manually force some decisions in execution plans.
Foreign data wrappers developed by Supabase
a parser for full-text search of Chinese
PostgreSQL Workload Analyser-core
Embed an SQLite database in your PostgreSQL table
The simplest way to do vector search on Postgres
extended check for plpgsql functions
Use Groonga as index, fast full text search platform for all languages!
Use Groonga as index, fast full text search platform for all languages!
data type for jsonb inspection
Foreign data wrapper that lets you implement custom FDWs in Python to fetch external data as Postgres tables.
Foreign data wrapper that lets you implement custom FDWs in Python to fetch external data as Postgres tables.
A tool to remove unused space from a relation.
copy data between Postgres and Parquet
Provides a trigger-based row-level audit log of table changes; intended as a demo and reference rather than production.
Provides a trigger-based row-level audit log of table changes; intended as a demo and reference rather than production.
MobilityDB geospatial trajectory data management & analysis platform
MobilityDB geospatial trajectory data management & analysis platform
Postgres extension for libsodium functions
Foreign data wrapper for querying a MySQL server
Foreign data wrapper for querying a MySQL server
The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
Provides optimized HASH and RANGE partitioning with custom plan nodes and faster partition pruning than native inheritance.
Provides optimized HASH and RANGE partitioning with custom plan nodes and faster partition pruning than native inheritance.
Provides transparent JSONB compression using a shared dictionary of frequently used strings learned from training data.
Provides transparent JSONB compression using a shared dictionary of frequently used strings learned from training data.
foreign data wrapper for Oracle access
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
Foreign data wrapper for querying a Redis server
Validates JSON columns against JSON Schema draft v4 specifications using a PL/pgSQL function suitable for CHECK constraints.
Validates JSON columns against JSON Schema draft v4 specifications using a PL/pgSQL function suitable for CHECK constraints.
Improves the query planner by learning cardinality estimates from prior query executions.
Improves the query planner by learning cardinality estimates from prior query executions.
pg_bulkload is a high speed data loading utility for PostgreSQL
pg_bulkload is a high speed data loading utility for PostgreSQL
Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities
Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities
Provides scalable in-database analytics with statistical, machine learning, and graph algorithms for PostgreSQL and Greenplum.
Provides scalable in-database analytics with statistical, machine learning, and graph algorithms for PostgreSQL and Greenplum.
Use PRQL in PostgreSQL - Pipelined Relational Query Language
Use PRQL in PostgreSQL - Pipelined Relational Query Language
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
data type for lidar point clouds
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
Convenience API for time series stack
Adds Chinese full-text search to PostgreSQL using the cppjieba word-segmentation library.
Adds Chinese full-text search to PostgreSQL using the cppjieba word-segmentation library.
Provides an audit trail with schema versioning using triggers, PL/pgSQL functions, and JSONB delta logging.
Provides an audit trail with schema versioning using triggers, PL/pgSQL functions, and JSONB delta logging.
Trusted Language Extensions for PostgreSQL
Provides sparse linear algebra and graph processing inside PostgreSQL using the SuiteSparse GraphBLAS library.
Provides sparse linear algebra and graph processing inside PostgreSQL using the SuiteSparse GraphBLAS library.
Read-only foreign data wrapper for querying Apache Parquet files as PostgreSQL tables.
Read-only foreign data wrapper for querying Apache Parquet files as PostgreSQL tables.
PostgreSQL bindings for H3, a hierarchical hexagonal geospatial indexing system
PostgreSQL bindings for H3, a hierarchical hexagonal geospatial indexing system
A postgresql extension for bm25 ranking algorithm
A postgresql extension for bm25 ranking algorithm
Run queries now and get results later
Output plugin for logical replication in Raw SQL format
Output plugin for logical replication in Raw SQL format
foreign data wrapper for MongoDB access
An extension collecting statistics about quals
An extension collecting statistics about quals
Implements a vectorized executor for PostgreSQL over the cstore_fdw columnar store to speed up analytic queries.
Implements a vectorized executor for PostgreSQL over the cstore_fdw columnar store to speed up analytic queries.
Short unique id generator for PostgreSQL, using hashids
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
PostgreSQL load profile repository and report builder
PostgreSQL load profile repository and report builder
Bitmap-based index access method for LIKE/ILIKE pattern matching with multi-column support and no recheck overhead.
Bitmap-based index access method for LIKE/ILIKE pattern matching with multi-column support and no recheck overhead.
Kernel statistics gathering
SQLite Foreign Data Wrapper
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
Run SQL queries in the background
Adds Bitcoin blockchain parsing functions to PostgreSQL, including script parsing, signature verification, and transaction inspection over bytea columns.
Adds Bitcoin blockchain parsing functions to PostgreSQL, including script parsing, signature verification, and transaction inspection over bytea columns.
Incremental Processing by Crunchy Data
PDF type with meta admin & Full-Text Search
Trusted JavaScript procedural language for PostgreSQL using the QuickJS engine.
Trusted JavaScript procedural language for PostgreSQL using the QuickJS engine.
Lets PostgreSQL statements publish messages directly to an AMQP broker like RabbitMQ.
Lets PostgreSQL statements publish messages directly to an AMQP broker like RabbitMQ.
show query plans of all currently running SQL statements
show query plans of all currently running SQL statements
Queries ClickHouse from PostgreSQL via a foreign data wrapper, with aggregate and join pushdown for analytics workloads.
Queries ClickHouse from PostgreSQL via a foreign data wrapper, with aggregate and join pushdown for analytics workloads.
Provides an in-memory columnar store for accelerating analytical queries.
Provides an in-memory columnar store for accelerating analytical queries.
Extension for logging and monitoring functions in PostgreSQL
Extension for logging and monitoring functions in PostgreSQL
Database partitioning implemented as procedural language
Database partitioning implemented as procedural language
active session history
EnterpriseDB system statistics for PostgreSQL
fast faceting queries using an inverted index
sampling based statistics of wait events
aws_s3 postgres extension to import/export data from/to s3
aws_s3 postgres extension to import/export data from/to s3
Learns a whitelist of allowed queries by userid and blocks or warns on unrecognized statements to protect against SQL injection.
Learns a whitelist of allowed queries by userid and blocks or warns on unrecognized statements to protect against SQL injection.
Validates jsonb values against JSON Schema Draft 4 and Draft 7 specifications.
Validates jsonb values against JSON Schema Draft 4 and Draft 7 specifications.
view object permissions and compare them with the desired state
view object permissions and compare them with the desired state
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
Read dead but unvacuumed rows from table
Implements foreign data wrappers in Ruby via an embedded mruby VM, with built-in support for Redis and other backends.
Implements foreign data wrappers in Ruby via an embedded mruby VM, with built-in support for Redis and other backends.
Adds C# and F# as loadable procedural languages for PostgreSQL functions, procedures, triggers, and set-returning functions.
Adds C# and F# as loadable procedural languages for PostgreSQL functions, procedures, triggers, and set-returning functions.
Speeds up OLAP queries in PostgreSQL using vectorized columnar tiles and chunk-based execution.
Speeds up OLAP queries in PostgreSQL using vectorized columnar tiles and chunk-based execution.
Inspects a running backend and returns EXPLAIN ANALYZE-style live execution statistics for the query it is currently processing.
Inspects a running backend and returns EXPLAIN ANALYZE-style live execution statistics for the query it is currently processing.
create 2-gram (bigram) index for faster full text search.
create 2-gram (bigram) index for faster full text search.
Require criteria for UPDATE and DELETE
Exposes libpostal address parsing and normalization functions for international street addresses inside PostgreSQL.
Exposes libpostal address parsing and normalization functions for international street addresses inside PostgreSQL.
foreign-data wrapper for remote hdfs servers
Adds NodeJS-like require(), console, and HTTP helpers to PLV8 functions in PostgreSQL and Supabase, with dynamic loading of web modules.
Adds NodeJS-like require(), console, and HTTP helpers to PLV8 functions in PostgreSQL and Supabase, with dynamic loading of web modules.
Foreign data wrapper that exposes RocksDB and other LSM-tree key-value stores as PostgreSQL tables.
Foreign data wrapper that exposes RocksDB and other LSM-tree key-value stores as PostgreSQL tables.
Provides functions to query, convert, and extract fields from Protocol Buffer columns stored in PostgreSQL.
Provides functions to query, convert, and extract fields from Protocol Buffer columns stored in PostgreSQL.
load R interpreter and execute R script from within a database
load R interpreter and execute R script from within a database
Foreign data wrapper that exposes remote web services (JSON, XML) as PostgreSQL tables.
Foreign data wrapper that exposes remote web services (JSON, XML) as PostgreSQL tables.
db_migrator plugin that migrates Oracle databases to PostgreSQL with optional near-zero-downtime replication.
db_migrator plugin that migrates Oracle databases to PostgreSQL with optional near-zero-downtime replication.
Tunes execution plans automatically through a feedback loop, refining hints via pg_hint_plan and pg_store_plans across repeated runs.
Tunes execution plans automatically through a feedback loop, refining hints via pg_hint_plan and pg_store_plans across repeated runs.
Fetch foreign data in Python in your PostgreSQL server.
Fetch foreign data in Python in your PostgreSQL server.
Adds a RoaringBitmap data type with functions, operators, and aggregates for compressed bitmap computation on Greenplum and PostgreSQL.
Adds a RoaringBitmap data type with functions, operators, and aggregates for compressed bitmap computation on Greenplum and PostgreSQL.
kafka Foreign Data Wrapper for CSV formatted messages
kafka Foreign Data Wrapper for CSV formatted messages
examine and manage the os buffer cache
Queries local or remote line-delimited JSON files as PostgreSQL foreign tables with read and write support.
Queries local or remote line-delimited JSON files as PostgreSQL foreign tables with read and write support.
PG Failover Slots extension
K-means function as a user-defined window function in PostgreSQL
K-means function as a user-defined window function in PostgreSQL
server-side support for profiling PL/pgSQL functions
server-side support for profiling PL/pgSQL functions
PostgreSQL Extension Whitelisting
Provides end-to-end RAG building blocks in Postgres including text extraction, chunking, local embeddings, reranking and remote LLM calls.
Provides end-to-end RAG building blocks in Postgres including text extraction, chunking, local embeddings, reranking and remote LLM calls.
Generate BM25 sparse vector inside PostgreSQL
Generate BM25 sparse vector inside PostgreSQL
Extension to add Global Temporary Tables feature to PostgreSQL
Extension to add Global Temporary Tables feature to PostgreSQL
automated ddl deployment using pglogical
filter statements by their execution plans.
Adds a packed phone number type backed by Google's libphonenumber.
Adds a packed phone number type backed by Google's libphonenumber.
Provides a writable foreign data wrapper for Redis, supporting SELECT, INSERT, UPDATE, DELETE on strings, sets, hashes, lists, zsets, and pubsub.
Provides a writable foreign data wrapper for Redis, supporting SELECT, INSERT, UPDATE, DELETE on strings, sets, hashes, lists, zsets, and pubsub.
Provides probabilistic data-sketch aggregates (HLL, CPC, Theta, KLL, quantiles, frequent items) backed by Apache DataSketches C++.
Provides probabilistic data-sketch aggregates (HLL, CPC, Theta, KLL, quantiles, frequent items) backed by Apache DataSketches C++.
server-side support for debugging PL/pgSQL functions
server-side support for debugging PL/pgSQL functions
Enables fine-grained write logging and time travel on subsets of the database.
Enables fine-grained write logging and time travel on subsets of the database.
Provides PL/R, a PostgreSQL procedural language for writing functions in the R statistical computing language.
Provides PL/R, a PostgreSQL procedural language for writing functions in the R statistical computing language.
Provides change data capture for PostgreSQL by translating the write-ahead log to JSON output.
Provides change data capture for PostgreSQL by translating the write-ahead log to JSON output.
Extension that secures a cluster on a cloud environment
Extension that secures a cluster on a cloud environment
Diagnosing system catalog corruption
credcheck - postgresql plain text credential checker
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
foreign-data wrapper for remote servers available over JDBC
foreign-data wrapper for remote servers available over JDBC
Extension for specialized, per-table replication between PostgreSQL instances
Extension for specialized, per-table replication between PostgreSQL instances
similar to SET ROLE but with added logging
Generates a range of unique identifiers including UUIDv6, UUIDv7, NanoID, KSUID, ULID, Timeflake, PushID, CUID2, and TypeID.
Generates a range of unique identifiers including UUIDv6, UUIDv7, NanoID, KSUID, ULID, Timeflake, PushID, CUID2, and TypeID.
Background worker that collects per-process and system stats and serves them via an embedded HTTP endpoint.
Background worker that collects per-process and system stats and serves them via an embedded HTTP endpoint.
Core extension for the PoWA Workload Analyzer that gathers PostgreSQL performance statistics for monitoring and tuning.
Core extension for the PoWA Workload Analyzer that gathers PostgreSQL performance statistics for monitoring and tuning.
Adds (m-)semiring provenance and uncertainty management, enabling probability, Shapley value, and semiring evaluation over query results.
Adds (m-)semiring provenance and uncertainty management, enabling probability, Shapley value, and semiring evaluation over query results.
Foreign data wrapper that fetches tweets from the Twitter API and exposes them as a queryable table.
Foreign data wrapper that fetches tweets from the Twitter API and exposes them as a queryable table.
Run curl actions for data transfer in URL syntax
Manage authentication sessions using JWTs
Demonstrates a simple finite state machine pattern using SQL tables and triggers to enforce valid state transitions.
Demonstrates a simple finite state machine pattern using SQL tables and triggers to enforce valid state transitions.
Provides a foreign data wrapper for reading Amazon S3 files using PostgreSQL's built-in COPY format.
Provides a foreign data wrapper for reading Amazon S3 files using PostgreSQL's built-in COPY format.
track plan statistics of all SQL statements executed
track plan statistics of all SQL statements executed
execute any sql command at any specific time at background
execute any sql command at any specific time at background
Czech Hunspell Dictionary
German Hunspell Dictionary
en_US Hunspell Dictionary
French Hunspell Dictionary
Nepali Hunspell Dictionary
Dutch Hunspell Dictionary
Norwegian (norsk) Hunspell Dictionary
Portuguese Hunspell Dictionary
Russian Hunspell Dictionary
Russian Hunspell Dictionary (from AOT.ru group)
Russian Hunspell Dictionary (from AOT.ru group)
PostgreSQL table versioning extension
PostgreSQL table versioning extension
Saves and restores query execution plans to lock planner decisions, similar to Oracle's Outline system.
Saves and restores query execution plans to lock planner decisions, similar to Oracle's Outline system.
Queries InfluxDB 1.8 and 2.7 time-series data as PostgreSQL foreign tables with pushdown of GROUP BY time intervals.
Queries InfluxDB 1.8 and 2.7 time-series data as PostgreSQL foreign tables with pushdown of GROUP BY time intervals.
Provides a cryptographically verifiable audit trail by applying blockchain-style Merkle proofs to relational data.
Provides a cryptographically verifiable audit trail by applying blockchain-style Merkle proofs to relational data.
Generates Universally Unique Lexicographically Sortable Identifiers (ULIDs) as text values.
Generates Universally Unique Lexicographically Sortable Identifiers (ULIDs) as text values.
Consumes Apache Kafka topics into PipelineDB streams via background workers and produces messages from queries.
Consumes Apache Kafka topics into PipelineDB streams via background workers and produces messages from queries.
Adds a ULID data type stored as a 128-bit integer along with creation, comparison, and formatting helpers.
Adds a ULID data type stored as a 128-bit integer along with creation, comparison, and formatting helpers.
Stable hash functions for Postgres
Adds full-text search dictionaries for North American street addresses, handling abbreviations and directional tokens.
Adds full-text search dictionaries for North American street addresses, handling abbreviations and directional tokens.
Extends pg_trgm with substring similarity functions and operators for fuzzy text search.
Extends pg_trgm with substring similarity functions and operators for fuzzy text search.
Server side rollback at statement level for PostgreSQL like Oracle or DB2
Server side rollback at statement level for PostgreSQL like Oracle or DB2
Simulates database failures by injecting waits, errors, fatals or panics for selected SQL operations to help test resilience.
Simulates database failures by injecting waits, errors, fatals or panics for selected SQL operations to help test resilience.
Encodes and decodes bytea or text values to and from emoji sequences with a built-in checksum.
Encodes and decodes bytea or text values to and from emoji sequences with a built-in checksum.
Introspect pg data dictionary via standard SQL
Exposes OpenSSL's X.509 certificate parser as SQL functions, powering crt.sh-style certificate transparency search.
Exposes OpenSSL's X.509 certificate parser as SQL functions, powering crt.sh-style certificate transparency search.
Tracks changes to selected tables in separate _log tables so rows can be queried as they existed at any past timestamp.
Tracks changes to selected tables in separate _log tables so rows can be queried as they existed at any past timestamp.
Track settings changes
Capture node OS metrics via SQL queries
Tracks changed blocks in PostgreSQL to power incremental backups via pg_probackup.
Tracks changed blocks in PostgreSQL to power incremental backups via pg_probackup.
Foreign data wrapper that queries data directly from PostgreSQL custom-format dump files for selective restore and analytics.
Foreign data wrapper that queries data directly from PostgreSQL custom-format dump files for selective restore and analytics.
Verifies integrity of PostgreSQL tables and b-tree indexes via page-level and item-level consistency checks.
Verifies integrity of PostgreSQL tables and b-tree indexes via page-level and item-level consistency checks.
tiktoken tokenizer for use with OpenAI models in postgres
tiktoken tokenizer for use with OpenAI models in postgres
Analyzes queries with hypothetical indexes and suggests candidate indexes that would improve execution plans.
Analyzes queries with hypothetical indexes and suggests candidate indexes that would improve execution plans.
Various functions for computing statistics on arrays of numbers
Various functions for computing statistics on arrays of numbers
Creates logical replication slots at a past LSN so logical streaming can resume after a physical replica is promoted (obsolete since PG 17).
Creates logical replication slots at a past LSN so logical streaming can resume after a physical replica is promoted (obsolete since PG 17).
Adds a PERIOD data type, functions, and indexing strategies for managing time ranges in PostgreSQL.
Adds a PERIOD data type, functions, and indexing strategies for managing time ranges in PostgreSQL.
PostgreSQL extension wrapper for Queen MQ - a simplified Kafka-style API for pub/sub message queuing directly in PostgreSQL.
PostgreSQL extension wrapper for Queen MQ - a simplified Kafka-style API for pub/sub message queuing directly in PostgreSQL.
PostgreSQL Git Foreign Data Wrapper
Adds an EFILE data type for accessing external files on the PostgreSQL server, similar to Oracle BFILE.
Adds an EFILE data type for accessing external files on the PostgreSQL server, similar to Oracle BFILE.
Provides trigger-based table auditing that stores row diffs as JSONB for easy querying.
Provides trigger-based table auditing that stores row diffs as JSONB for easy querying.
Tokenizers for full-text search
Pre Prepare your Statement server side
Foreign data wrapper for Firebird
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
Zstandard compression algorithm implementation in PostgreSQL
Foreign data wrapper that exposes MonetDB columnar database tables as PostgreSQL foreign tables.
Foreign data wrapper that exposes MonetDB columnar database tables as PostgreSQL foreign tables.
Provides a full-text-search parser that splits Chinese, Japanese, and Korean text into 2-gram tokens while keeping default behavior for other scripts.
Provides a full-text-search parser that splits Chinese, Japanese, and Korean text into 2-gram tokens while keeping default behavior for other scripts.
Adds a Chinese full-text search parser for to_tsvector based on the SCWS word-segmentation library.
Adds a Chinese full-text search parser for to_tsvector based on the SCWS word-segmentation library.
Provides a Rust foreign data wrapper for querying Google Cloud Bigtable and HBase-compatible databases as PostgreSQL tables.
Provides a Rust foreign data wrapper for querying Google Cloud Bigtable and HBase-compatible databases as PostgreSQL tables.
Foreign data wrapper that exposes Kyoto Tycoon key/value stores as PostgreSQL tables, supporting reads, writes, and transactions.
Foreign data wrapper that exposes Kyoto Tycoon key/value stores as PostgreSQL tables, supporting reads, writes, and transactions.
Pseudo-randomly permute sequences with a format-preserving encryption on elements
Pseudo-randomly permute sequences with a format-preserving encryption on elements
Provides cheat (but useful) functions
Generates time-sortable 64-bit Snowflake IDs using a custom epoch, instance ID, and sequence number.
Generates time-sortable 64-bit Snowflake IDs using a custom epoch, instance ID, and sequence number.
Function for collecting statistics about messages in logfile
Function for collecting statistics about messages in logfile
Fixed precision decimal data type backed by 64-bit integers, offering faster arithmetic than NUMERIC for monetary values.
Fixed precision decimal data type backed by 64-bit integers, offering faster arithmetic than NUMERIC for monetary values.
Provides automatic standby promotion and failover for a two-server PostgreSQL replication cluster.
Provides automatic standby promotion and failover for a two-server PostgreSQL replication cluster.
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
Go project template for Foreign Data Wrappers for PostgreSQL
Go project template for Foreign Data Wrappers for PostgreSQL
Adds integer-keyed and integer-valued hstore types that support arithmetic operators and SUM aggregates for analytics.
Adds integer-keyed and integer-valued hstore types that support arithmetic operators and SUM aggregates for analytics.
Foreign data wrapper that exposes LDAP directory servers as queryable PostgreSQL tables.
Foreign data wrapper that exposes LDAP directory servers as queryable PostgreSQL tables.
discover hidden correlations in your data with MIC
Small PostgreSQL background worker to report whether a node is a replication master or standby
Small PostgreSQL background worker to report whether a node is a replication master or standby
first() and last() aggregate functions
Adds extra functions and operators for manipulating jsonb values on PostgreSQL 9.4.
Adds extra functions and operators for manipulating jsonb values on PostgreSQL 9.4.
Send random signals to random processes
Adds Julia as a loadable procedural language for writing PostgreSQL functions, with type conversions for arrays and composite types.
Adds Julia as a loadable procedural language for writing PostgreSQL functions, with type conversions for arrays and composite types.
Provides an experimental foreign data wrapper for querying SQLite databases as PostgreSQL tables.
Provides an experimental foreign data wrapper for querying SQLite databases as PostgreSQL tables.
login_hook - hook to execute login_hook.login() at login time
login_hook - hook to execute login_hook.login() at login time
Foreign data wrapper that exposes Neo4j Cypher query results as PostgreSQL tables.
Foreign data wrapper that exposes Neo4j Cypher query results as PostgreSQL tables.
Exposes the Themis cryptographic library to Postgres for encrypting and decrypting data via Secure Cell and Secure Message primitives.
Exposes the Themis cryptographic library to Postgres for encrypting and decrypting data via Secure Cell and Secure Message primitives.
Foreign data wrapper for querying CouchDB document databases as PostgreSQL foreign tables.
Foreign data wrapper for querying CouchDB document databases as PostgreSQL foreign tables.
foreign data wrapper for DB2 access
Send redis pub/sub messages to Redis from PostgreSQL Directly
Send redis pub/sub messages to Redis from PostgreSQL Directly
Extends pgRouting with algorithms for solving Vehicle Routing Problems (VRP) using VROOM.
Extends pgRouting with algorithms for solving Vehicle Routing Problems (VRP) using VROOM.
Extra Window Functions for PostgreSQL
Foreign data wrapper that exposes delimited file rows as a single text[] column for variable field counts.
Foreign data wrapper that exposes delimited file rows as a single text[] column for variable field counts.
Implements an LSM-tree access method on top of standard PostgreSQL B-Tree indexes for fast inserts.
Implements an LSM-tree access method on top of standard PostgreSQL B-Tree indexes for fast inserts.
Visualise database pages in ascii code
Proof-of-concept extension that automatically repairs certain types of PostgreSQL data file corruption.
Proof-of-concept extension that automatically repairs certain types of PostgreSQL data file corruption.
Generates k-ordered, 12-byte globally unique IDs compatible with MongoDB ObjectIDs without central coordination.
Generates k-ordered, 12-byte globally unique IDs compatible with MongoDB ObjectIDs without central coordination.
Activate/deactivate/verify checksums in offline Postgres clusters
Activate/deactivate/verify checksums in offline Postgres clusters
Manages and freezes planner statistics so PostgreSQL can use saved snapshots instead of the latest stats when building execution plans.
Manages and freezes planner statistics so PostgreSQL can use saved snapshots instead of the latest stats when building execution plans.
Perl Compatible Regular Expression functions
Foreign data wrapper that reads OpenStreetMap PBF files as queryable PostgreSQL tables.
Foreign data wrapper that reads OpenStreetMap PBF files as queryable PostgreSQL tables.
Redis-like In-Memory DB Embedded in Postgres
Exposes the Linux operating-system process table through SQL so load, memory, CPU, and I/O stats can be queried from PostgreSQL.
Exposes the Linux operating-system process table through SQL so load, memory, CPU, and I/O stats can be queried from PostgreSQL.
Deletes records along with their foreign-key dependents in one recursive CTE, with an ASCII preview of the dependency graph.
Deletes records along with their foreign-key dependents in one recursive CTE, with an ASCII preview of the dependency graph.
Bundles JavaScript geometry libraries (d3, topojson, jsts, earcut) as PLV8 functions for geospatial data.
Bundles JavaScript geometry libraries (d3, topojson, jsts, earcut) as PLV8 functions for geospatial data.
Accelerates PostgreSQL query execution using vectorized executor nodes via the CustomScan framework.
Accelerates PostgreSQL query execution using vectorized executor nodes via the CustomScan framework.
Performs online shard migration for Citus clusters using logical replication to enable scale-out, scale-in, and worker replacement.
Performs online shard migration for Citus clusters using logical replication to enable scale-out, scale-in, and worker replacement.
Provides functions and views to inspect PostgreSQL object access privileges across roles.
Provides functions and views to inspect PostgreSQL object access privileges across roles.
Tools to migrate other databases to PostgreSQL
Queries IBM Informix databases as PostgreSQL foreign tables via the ESQL/C Client SDK, with read and write support.
Queries IBM Informix databases as PostgreSQL foreign tables via the ESQL/C Client SDK, with read and write support.
Foreign data wrapper that queries remote databases through ODBC driver managers and DSN connections.
Foreign data wrapper that queries remote databases through ODBC driver managers and DSN connections.
monitor connection attempts per user
foreign-data wrapper for remote PGSpider servers
foreign-data wrapper for remote PGSpider servers
Adds a 1-byte tinyint integer data type to PostgreSQL for compact columns and easier porting from other RDBMS.
Adds a 1-byte tinyint integer data type to PostgreSQL for compact columns and easier porting from other RDBMS.
Adds argmax, argmin, and anyold aggregate functions for picking row values by sort key.
Adds argmax, argmin, and anyold aggregate functions for picking row values by sort key.
Invalidates the shared_buffers cache globally or for a specific relation and fork.
Invalidates the shared_buffers cache globally or for a specific relation and fork.
Provides monitoring views and functions covering disk usage, WAL throughput, replication lag, and query sources for Prometheus, Zabbix, or Munin agents.
Provides monitoring views and functions covering disk usage, WAL throughput, replication lag, and query sources for Prometheus, Zabbix, or Munin agents.
Adds functions and views used by Barman to perform concurrent base backups on PostgreSQL versions older than 9.6.
Adds functions and views used by Barman to perform concurrent base backups on PostgreSQL versions older than 9.6.
Provides an extended tsvector type with better compression and no 1MB size limit, as a drop-in replacement.
Provides an extended tsvector type with better compression and no 1MB size limit, as a drop-in replacement.
Queries remote JDBC-compatible data sources from PostgreSQL with predicate push-down via a deparser.
Queries remote JDBC-compatible data sources from PostgreSQL with predicate push-down via a deparser.
Adds geospatial types and helper functions on top of PostGIS, including Time-Position-Velocity and OpenStreetMap opening_hours.
Adds geospatial types and helper functions on top of PostGIS, including Time-Position-Velocity and OpenStreetMap opening_hours.
Provides a foreign data wrapper for accessing RocksDB key-value storage as PostgreSQL tables.
Provides a foreign data wrapper for accessing RocksDB key-value storage as PostgreSQL tables.
Provides a distributed transaction manager for PostgreSQL using snapshot sharing across cluster nodes.
Provides a distributed transaction manager for PostgreSQL using snapshot sharing across cluster nodes.
foreign-data wrapper for Postgres log file access
foreign-data wrapper for Postgres log file access
Provides a range_agg aggregate that merges adjacent or overlapping range values, useful for temporal coalescing.
Provides a range_agg aggregate that merges adjacent or overlapping range values, useful for temporal coalescing.
Adds jsonb functions for data extraction, validation, and transformation using JSON path vectors.
Adds jsonb functions for data extraction, validation, and transformation using JSON path vectors.
The PostgreSQL Antivirus
Adds union, intersection, and difference operators for arrays of daterange and tstzrange values.
Adds union, intersection, and difference operators for arrays of daterange and tstzrange values.
spherical objects with useful functions, operators and index support
spherical objects with useful functions, operators and index support
What is a PostgreSQL Extension?
A PostgreSQL extension is a packaged set of SQL objects and (usually) compiled C, Rust, or Python code that adds new capability to a running Postgres server, whether new data types, index methods, functions, operators, or procedural languages. Extensions are installed at the database level via CREATE EXTENSION and tracked in the pg_extension catalog. The mechanism is the same one used by Postgres itself to ship its 'contrib' modules: pgcrypto, hstore, btree_gin, and uuid-ossp all ship with core Postgres but must be enabled explicitly per database. Most extensions are distributed as source on GitHub and packaged for major Linux distributions by the PGDG repository or community projects like Pigsty and pgxman.
When to Add an Extension to PostgreSQL
Reach for an extension when you need a capability that Postgres core deliberately leaves out: vector similarity search (pgvector), geospatial queries (PostGIS), columnar storage (Citus, Hydra), in-database scheduling (pg_cron), full-text search beyond tsvector (pg_search, ParadeDB), or compatibility with another database's dialect (Orafce for Oracle, babelfishpg_tsql for SQL Server). Two cautions: extensions that ship a shared library require server restart or shared_preload_libraries config, and managed services like AWS RDS and Supabase only allow extensions on their allow-list, so verify availability before you architect around one. For everything else, the standard answer is 'use a core feature'. Postgres ships more functionality every release that previously required an extension (JSONB indexing, parallel queries, declarative partitioning).
PostgreSQL extensions FAQ
What are PostgreSQL extensions?
How do I install a PostgreSQL extension?
How do I check which PostgreSQL extensions are installed?
Do PostgreSQL extensions work on AWS RDS, Supabase, and Neon?
What's the best PostgreSQL extension for vector search?
Manage PostgreSQL Visually
1bench is a modern GUI client for PostgreSQL. Install extensions, write queries, and inspect schemas without leaving the IDE.
Try 1bench for PostgreSQL