PIGSTY

By PostgreSQL

PostgreSQL extensions unavailable by major version

PostgreSQL 18

Extensions NOT available for PostgreSQL 18

IDExtensionPackageDescription
5970adminpackadminpackadministrative functions for PostgreSQL
2760ageageAGE graph database extension
7050anonpg_anonPostgreSQL Anonymizer (anon) extension
9300babelfishpg_commonbabelfishpg_commonSQL Server Transact SQL Datatype Support
9330babelfishpg_moneybabelfishpg_moneySQL Server Money Data Type
9320babelfishpg_tdsbabelfishpg_tdsSQL Server TDS protocol extension
9310babelfishpg_tsqlbabelfishpg_tsqlSQL Server Transact SQL compatibility
2400cituscitusDistributed PostgreSQL as an extension
2401citus_columnarcitusCitus columnar storage engine
2410columnarhydraHydra Columnar extension
4850convertpg_convertconversion functions for spatial, routing and other specialized uses
8630db2_fdwdb2_fdwforeign data wrapper for DB2 access
3220dbt2dbt2OSDL-DBT-2 test kit
9000documentdbdocumentdbAPI surface for DocumentDB for PostgreSQL
9010documentdb_coredocumentdbCore API surface for DocumentDB for PostgreSQL
9020documentdb_distributeddocumentdbMulti-Node API surface for DocumentDB
2450duckdb_fdwduckdb_fdwDuckDB Foreign Data Wrapper
3850emailaddrpgemailaddrEmail address type for PostgreSQL
1050emajemajEnables fine-grained write logging and time travel on subsets of the database.
6370explain_uipg_explain_uieasily jump into a visual plan UI for any SQL query
3210fakerfakerWrapper for the Faker Python library
4840financialpg_financialFinancial aggregate functions
8750firebird_fdwfirebird_fdwForeign data wrapper for Firebird
8740hdfs_fdwhdfs_fdwforeign-data wrapper for remote hdfs servers
2770hllhlltype for storing hyperloglog data
8530jdbc_fdwjdbc_fdwforeign-data wrapper for remote servers available over JDBC
8730kafka_fdwkafka_fdwkafka Foreign Data Wrapper for CSV formatted messages
7140logerrorslogerrorsFunction for collecting statistics about messages in logfile
7150login_hooklogin_hooklogin_hook - hook to execute login_hook.login() at login time
1650mobilitydbmobilitydbMobilityDB geospatial trajectory data management & analysis platform
8700mongo_fdwmongo_fdwforeign data wrapper for MongoDB access
8510multicornmulticornFetch foreign data in Python in your PostgreSQL server.
8600mysql_fdwmysql_fdwForeign data wrapper for querying a MySQL server
8520odbc_fdwodbc_fdwForeign data wrapper for accessing remote databases using ODBC
5960old_snapshotold_snapshotutilities in support of old_snapshot_threshold
2951omniomnigresAdvanced adapter for Postgres extensions
2952omni_authomnigresBasic session management
2953omni_awsomnigresAmazon Web Services APIs (S3)
2954omni_cloudeventsomnigresCloudEvents support
2955omni_containersomnigresDocker container management
2956omni_credentialsomnigresApplication credential management
2958omni_emailomnigresE-mail framework
2959omni_httpomnigresBasic HTTP types
2960omni_httpcomnigresHTTP client
2961omni_httpdomnigresHTTP server
2962omni_idomnigresIdentity types
2963omni_jsonomnigresJSON toolkit
2964omni_kubeomnigresKubernetes (k8s) integration
2965omni_ledgeromnigresFinancial ledger
2966omni_manifestomnigresPackage installation manifests
2967omni_mimetypesomnigresMIME types
2968omni_osomnigresOperating system integration
2969omni_polyfillomnigresPostgres API polyfills
2970omni_pythonomnigresFirst-class Python support
2971omni_regexomnigresPCRE-compatible regular expressions
2972omni_restomnigresREST API toolkit (with PostgREST support)
2973omni_schemaomnigresAdvanced schema management tooling
2974omni_seqomnigresDistributed integer sequences
2975omni_serviceomnigresService management
2976omni_sessionomnigresSession management
2977omni_sqlomnigresProgrammatic SQL manipulation
2979omni_sqliteomnigresEmbedded SQLite
2980omni_testomnigresTesting framework
2981omni_txnomnigresTransaction management
2982omni_typesomnigresAdvanced types
2983omni_varomnigresScoped variables
2984omni_vfsomnigresVirtual File System
2985omni_vfs_types_v1omnigresVirtual File System types (v1)
2986omni_webomnigresCommon web stack primitives
2987omni_workeromnigresGeneralized worker pool
2988omni_xmlomnigresXML toolkit
2989omni_yamlomnigresYAML toolkit
2920orioledborioledbOrioleDB, the next generation transactional engine
2420pg_analyticspg_analyticsPostgres for analytics, powered by DuckDB
7100pg_auth_monpg_auth_monmonitor connection attempts per user
1100pg_backgroundpg_backgroundRun SQL queries in the background
4830pg_base58pg_base58Base58 Encoder/Decoder Extension for PostgreSQL
2140pg_bestmatchpg_bestmatchGenerate BM25 sparse vector inside PostgreSQL
2120pg_bigmpg_bigmcreate 2-gram (bigram) index for faster full text search.
9830pg_bulkloadpg_bulkloadpg_bulkload is a high speed data loading utility for PostgreSQL
2930pg_cardanopg_cardanoA suite of Cardano-related tools
5110pg_checksumspg_checksumsActivate/deactivate/verify checksums in offline Postgres clusters
1070pg_cronpg_cronJob scheduler for PostgreSQL
2430pg_duckdbpg_duckdbDuckDB Embedded in Postgres
9530pg_failover_slotspg_failover_slotsPG Failover Slots extension
2790pg_graphqlpg_graphqlAdd in-database GraphQL support
4500pg_idkitpg_idkitmulti-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
2800pg_jsonschemapg_jsonschemaPostgreSQL extension providing JSON Schema validation
1090pg_laterpg_laterRun queries now and get results later
2440pg_mooncakepg_mooncakeColumnstore Table in Postgres
4080pg_netpg_netAsync HTTP Requests
2460pg_parquetpg_parquetcopy data between Postgres and Parquet
1570pg_polylinepg_polylineFast Google Encoded Polyline encoding & decoding for postgres
6000pg_profilepg_profilePostgreSQL load profile repository and report builder
4300pg_readmepg_readmeGenerate a README.md document for a database extension or schema
4301pg_readme_test_extensionpg_readmeTest generating a README.md document for extension or schema
5120pg_readonlypg_readonlycluster database read only
4290pg_renderpg_renderRender HTML in SQL
5810pg_saviorpg_saviorPostgres extension to save OOPS mistakes
2100pg_searchpg_searchFull text search for PostgreSQL using BM25
7040pg_session_jwtpg_session_jwtManage authentication sessions using JWTs
4170pg_smtp_clientpg_smtp_clientPostgreSQL extension to send email using SMTP
6220pg_stat_kcachepg_stat_kcacheKernel statistics gathering
6230pg_stat_monitorpg_stat_monitorThe 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.
9130pg_statement_rollbackpg_statement_rollbackServer side rollback at statement level for PostgreSQL like Oracle or DB2
6250pg_store_planspg_store_planstrack plan statistics of all SQL statements executed
2530pg_strompg_stromPG-Strom - big-data processing acceleration using GPU and NVME
1860pg_summarizepg_summarizeText Summarization using LLMs. Built using pgrx
1080pg_taskpg_taskexecute any sql command at any specific time at background
7060pg_tdepg_tdePercona pg_tde access method
1870pg_tiktokenpg_tiktokentiktoken tokenizer for use with OpenAI models in postgres
2160pg_tokenizerpg_tokenizerTokenizers for full-text search
6010pg_tracingpg_tracingDistributed Tracing for PostgreSQL
4540pg_uuidv7pg_uuidv7Create UUIDv7 values in postgres
5880pgagentpgagentA PostgreSQL job scheduler
7080pgauditpgauditprovides auditing functionality
7090pgauditlogtofilepgauditlogtofilepgAudit addon to redirect audit log to an independent file
5150pgautofailoverpgautofailoverpg_auto_failover
5130pgddpgddIntrospect pg data dictionary via standard SQL
5060pgfincorepgfincoreexamine and manage the os buffer cache
4160pgjwtpgjwtJSON Web Token API for Postgresql
9520pgl_ddl_deploypgl_ddl_deployautomated ddl deployment using pglogical
3540pglite_fusionpglite_fusionEmbed an SQLite database in your PostgreSQL table
9500pglogicalpglogicalPostgreSQL Logical Replication
9501pglogical_originpglogicalDummy extension for compatibility when upgrading from Postgres 9.4
9510pglogical_tickerpglogical_tickerHave an accurate view on pglogical replication delay
1890pgmlpgmlRun AL/ML workloads with SQL interface
2110pgroongapgroongaUse Groonga as index, fast full text search platform for all languages!
2111pgroonga_databasepgroongaPGroonga database management module
7070pgsmcryptopgsmcryptoPostgreSQL SM Algorithm Extension
8540pgspider_extpgspider_extforeign-data wrapper for remote PGSpider servers
4200pgsql_tweakspgsql_tweaksSome functions and views for daily usage
4510pgx_ulidpgx_ulidulid type and methods
3050pldbgapipldebuggerserver-side support for debugging PL/pgSQL functions
3090pljavapljavaPL/Java procedural language
3070plprofilerplprofilerserver-side support for profiling PL/pgSQL functions
3040plprqlplprqlUse PRQL in PostgreSQL - Pipelined Relational Query Language
6810powapowaPostgreSQL Workload Analyser-core
8720redispg_redis_pubsubSend redis pub/sub messages to Redis from PostgreSQL Directly
9710repmgrrepmgrReplication manager for PostgreSQL
2780rumrumRUM index access method
5820safeupdatesafeupdateRequire criteria for UPDATE and DELETE
1850smlarsmlarEffective similarity search
9400spatspatRedis-like In-Memory DB Embedded in Postgres
8640sqlite_fdwsqlite_fdwSQLite Foreign Data Wrapper
6290system_statssystem_statsEnterpriseDB system statistics for PostgreSQL
8620tds_fdwtds_fdwForeign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
1000timescaledbtimescaledbEnables scalable inserts and complex queries for time-series data
1010timescaledb_toolkittimescaledb_toolkitLibrary of analytical hyperfunctions, time-series pipelining, and other SQL utilities
1020timeseriespg_timeseriesConvenience API for time series stack
3890timestamp9timestamp9timestamp nanosecond resolution
4600topntopntype for top-n JSONB
1680tzfpg_tzfFast lookup timezone name by GPS coordinates
1810vchordvchordVector database plugin for Postgres, written in Rust
2150vchord_bm25vchord_bm25A postgresql extension for bm25 ranking algorithm
1800vectorpgvectorvector data type and ivfflat and hnsw access methods
1830vectorizepg_vectorizeThe simplest way to do vector search on Postgres
1820vectorscalepgvectorscaleAdvanced indexing for vector data with DiskANN
9640wal2mongowal2mongoPostgreSQL logical decoding output plugin for MongoDB
8500wrapperswrappersForeign data wrappers developed by Supabase

PostgreSQL 17

Extensions NOT available for PostgreSQL 17

IDExtensionPackageDescription
5970adminpackadminpackadministrative functions for PostgreSQL
9300babelfishpg_commonbabelfishpg_commonSQL Server Transact SQL Datatype Support
9330babelfishpg_moneybabelfishpg_moneySQL Server Money Data Type
9320babelfishpg_tdsbabelfishpg_tdsSQL Server TDS protocol extension
9310babelfishpg_tsqlbabelfishpg_tsqlSQL Server Transact SQL compatibility
2410columnarhydraHydra Columnar extension
8630db2_fdwdb2_fdwforeign data wrapper for DB2 access
8530jdbc_fdwjdbc_fdwforeign-data wrapper for remote servers available over JDBC
8730kafka_fdwkafka_fdwkafka Foreign Data Wrapper for CSV formatted messages
8700mongo_fdwmongo_fdwforeign data wrapper for MongoDB access
5960old_snapshotold_snapshotutilities in support of old_snapshot_threshold
6890pg_logicalinspectpg_logicalinspectLogical decoding components inspection
6880pg_overexplainpg_overexplainAllow EXPLAIN to dump even more details
3040plprqlplprqlUse PRQL in PostgreSQL - Pipelined Relational Query Language
9640wal2mongowal2mongoPostgreSQL logical decoding output plugin for MongoDB

PostgreSQL 16

Extensions NOT available for PostgreSQL 16

IDExtensionPackageDescription
9300babelfishpg_commonbabelfishpg_commonSQL Server Transact SQL Datatype Support
9330babelfishpg_moneybabelfishpg_moneySQL Server Money Data Type
9320babelfishpg_tdsbabelfishpg_tdsSQL Server TDS protocol extension
9310babelfishpg_tsqlbabelfishpg_tsqlSQL Server Transact SQL compatibility
2920orioledborioledbOrioleDB, the next generation transactional engine
3830pg_durationpg_durationdata type for representing durations
6890pg_logicalinspectpg_logicalinspectLogical decoding components inspection
6880pg_overexplainpg_overexplainAllow EXPLAIN to dump even more details
7060pg_tdepg_tdePercona pg_tde access method
9400spatspatRedis-like In-Memory DB Embedded in Postgres

PostgreSQL 15

Extensions NOT available for PostgreSQL 15

IDExtensionPackageDescription
2920orioledborioledbOrioleDB, the next generation transactional engine
3830pg_durationpg_durationdata type for representing durations
2880pg_incrementalpg_incrementalIncremental Processing by Crunchy Data
6890pg_logicalinspectpg_logicalinspectLogical decoding components inspection
6880pg_overexplainpg_overexplainAllow EXPLAIN to dump even more details
7060pg_tdepg_tdePercona pg_tde access method
9400spatspatRedis-like In-Memory DB Embedded in Postgres

PostgreSQL 14

Extensions NOT available for PostgreSQL 14

IDExtensionPackageDescription
9300babelfishpg_commonbabelfishpg_commonSQL Server Transact SQL Datatype Support
9330babelfishpg_moneybabelfishpg_moneySQL Server Money Data Type
9320babelfishpg_tdsbabelfishpg_tdsSQL Server TDS protocol extension
9310babelfishpg_tsqlbabelfishpg_tsqlSQL Server Transact SQL compatibility
5950basebackup_to_shellbasebackup_to_shelladds a custom basebackup target called shell
5940basic_archivebasic_archivean example of an archive module
2400cituscitusDistributed PostgreSQL as an extension
2401citus_columnarcitusCitus columnar storage engine
9000documentdbdocumentdbAPI surface for DocumentDB for PostgreSQL
9010documentdb_coredocumentdbCore API surface for DocumentDB for PostgreSQL
9020documentdb_distributeddocumentdbMulti-Node API surface for DocumentDB
2920orioledborioledbOrioleDB, the next generation transactional engine
3830pg_durationpg_durationdata type for representing durations
2880pg_incrementalpg_incrementalIncremental Processing by Crunchy Data
6890pg_logicalinspectpg_logicalinspectLogical decoding components inspection
6880pg_overexplainpg_overexplainAllow EXPLAIN to dump even more details
7060pg_tdepg_tdePercona pg_tde access method
6940pg_walinspectpg_walinspectfunctions to inspect contents of PostgreSQL Write-Ahead Log
8540pgspider_extpgspider_extforeign-data wrapper for remote PGSpider servers
9400spatspatRedis-like In-Memory DB Embedded in Postgres
1000timescaledbtimescaledbEnables scalable inserts and complex queries for time-series data
1010timescaledb_toolkittimescaledb_toolkitLibrary of analytical hyperfunctions, time-series pipelining, and other SQL utilities