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.

find_bucket_ts · Artifacts of BaCon. For VLDB26 reviewers only. · 1.0 · Time series · Unknown · Python · Not packagedcartodb · Archived PostgreSQL extension for turning a database into a CartoDB user database. · 0.37.1 · Geospatial · BSD-3-Clause · Python · Not packagedcrankshaft · Archived CARTO spatial-analysis functions for clustering, segmentation, and spatial statistics. · 0.9.0 · Geospatial · BSD-3-Clause · Python · Not packageds2 · PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy · 0.0.2 · Geospatial · MIT · Python · Not packagedli3ds · PostgreSQL extension for managing 3D sensor data · 1.0.0 · Geospatial · MIT · Python · Not packagedai · Helper functions for AI workflows in PostgreSQL · 0.11.3-dev · AI and vectors · PostgreSQL · Python · Not packagedjev · Natural-language row filtering, ranking and classification through TypeSafe · 0.2.0 · AI and vectors · PostgreSQL · Python · Packagedpgpyml · Run scikit-learn machine-learning models inside PostgreSQL through PL/Python functions and triggers. · 0.3.1 · AI and vectors · PostgreSQL · Python · Not packagedpg_sentence_transformer · Runs a Hugging Face sentence-transformer model inside a preload background worker and maintains pgvector embeddings for a configured table. · 0.1 · AI and vectors · BSD-2-Clause · Python · Not packagedpgai · In-database predictive analytics using LSTM, Prophet, ARIMA, and SARIMA models. · 1.0 · AI and vectors · Unknown · Python · Not packagedpgembed · Generate vector embeddings through Ollama, OpenAI, or custom HTTP services · 0.1.0 · AI and vectors · LicenseRef-Tecnisys-Community-1.0 · Python · Not packagedpgtoken · PostgreSQL extension for compact, codebook-compressed LLM token ID storage. Encode once, retrieve forever. O(1) token count without decoding. · 1.0 · AI and vectors · MIT · Python · Not packagedlshvector · a feature vector type and a locality sensitive hashing index · 1.0 · AI and vectors · Unknown · Python · Not packagedpg_ocr · Self-contained OCR functions via PL/Python · 0.0.1 · AI and vectors · Unknown · Python · Not packagedpg_optigraph · pg Optigraph is a PostgreSQL extension which uses OptiGraph ML model. · 0.1.0 · AI and vectors · MIT · Python · Not packagedpspacy · PL/Python full-text-search helpers that use spaCy for multilingual lemmatization, tsvector generation and tsquery generation. · 1.0 · Full-text search · Unknown · Python · Not packageddbtune_mab · DBTune MAB advisor for PostgreSQL · 0.0.1 · Features · Unknown · Python · Not packagedfaker · Wrapper for the Faker Python library · 0.5.3 · Procedural languages · PostgreSQL · Python · Packagedpg_agg · Experimental aggregate-query support extension; its install script currently creates the untrusted PL/Python language. · 1.0 · Procedural languages · Unknown · Python · Not packagedpgsmtp · Send SMTP email and file attachments from PostgreSQL using untrusted PL/Python functions. · 0.1.1 · Utilities · PostgreSQL · Python · Not packagedpg_purr · A PostgreSQL extension (via PL/Python) that brings quantum computing capabilities. · 0.2.0 · Functions and aggregates · MIT · Python · Not packagedstreamvis_udfs · A logging client and server for self-hosted data logging and visualization · 1.0 · Monitoring · Unknown · Python · Not packagedverisql · Audit-grade verification gateway for AI-generated SQL — catches silently wrong queries before they hit your dashboard, keeps tamper-evident audit trails, verifies migration equivalence. Zero LLM tokens for 90% of checks. · 0.1.0 · Security · MIT · Python · Not packagedgdpr_anatomizer · Prototype GDPR/anatomy anonymization extension implemented with PL/Python and PL/pgSQL helpers. · 0.0.1 · Security · Unknown · Python · Not packagedaudit_stream · Postgres extension that emits audit-stream-py-compatible governance events on watched table CRUD via pg notify, plus a Python LISTEN bridge daemon. The database-tier governance producer for the Kinetic Gain Protocol Suite. · 0.1.0 · Security · MIT · Python · Not packagedofarm_ed25519 · OFARM verification-only strict Ed25519 primitive · 1.0 · Security · Apache-2.0 · Python · Not packagedneo4j-fdw · Multicorn-based foreign data wrapper and Cypher functions for Neo4j. · 4.3.2-dev · Foreign data wrappers · GPL-3.0 · Python · Not packagedadvcopy · PL/Python PostgreSQL extension for copying data to and from S3. · 0.0.2 · Replication and streams · Unknown · Python · Not packagedpanda_post · Python Pandas data in Postgres · 0.2.1 · Replication and streams · BSD-2-Clause · Python · Not packagedpandapost · Python Pandas data in Postgres · 0.2.0 · Replication and streams · BSD-2-Clause · Python · Not packagedcdc_webhook · Change Data Capture webhook extension · 1.0 · Replication and streams · Unknown · Python · Not packaged

31 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
ai 0.11.3-dev Helper functions for AI workflows in PostgreSQL RAG PostgreSQL Python 16–18 5.8k
jev 0.2.0 Natural-language row filtering, ranking and classification through TypeSafe RAG PostgreSQL Python 14–17 195
cartodb 0.37.1 Archived PostgreSQL extension for turning a database into a CartoDB user database. GIS BSD-3-Clause Python 11–18 112
neo4j-fdw 4.3.2-dev Multicorn-based foreign data wrapper and Cypher functions for Neo4j. FDW GPL-3.0 Python 10–12 58
crankshaft 0.9.0 Archived CARTO spatial-analysis functions for clustering, segmentation, and spatial statistics. GIS BSD-3-Clause Python 54
faker 0.5.3 Wrapper for the Faker Python library LANG PostgreSQL Python 14–18 24
s2 0.0.2 PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy GIS MIT Python 21
pgpyml 0.3.1 Run scikit-learn machine-learning models inside PostgreSQL through PL/Python functions and triggers. RAG PostgreSQL Python 18
pg_sentence_transformer 0.1 Runs a Hugging Face sentence-transformer model inside a preload background worker and maintains pgvector embeddings for a configured table. RAG BSD-2-Clause Python 17
advcopy 0.0.2 PL/Python PostgreSQL extension for copying data to and from S3. ETL Python 12
li3ds 1.0.0 PostgreSQL extension for managing 3D sensor data GIS MIT Python 12
pgai 1.0 In-database predictive analytics using LSTM, Prophet, ARIMA, and SARIMA models. RAG Python 10
panda_post 0.2.1 Python Pandas data in Postgres ETL BSD-2-Clause Python 5
pandapost 0.2.0 Python Pandas data in Postgres ETL BSD-2-Clause Python 5
pgsmtp 0.1.1 Send SMTP email and file attachments from PostgreSQL using untrusted PL/Python functions. UTIL PostgreSQL Python 10–18 5
pspacy 1.0 PL/Python full-text-search helpers that use spaCy for multilingual lemmatization, tsvector generation and tsquery generation. FTS Python 12–13 5
streamvis_udfs 1.0 A logging client and server for self-hosted data logging and visualization STAT Python 5
pg_purr 0.2.0 A PostgreSQL extension (via PL/Python) that brings quantum computing capabilities. FUNC MIT Python 3
verisql 0.1.0 Audit-grade verification gateway for AI-generated SQL — catches silently wrong queries before they hit your dashboard, keeps tamper-evident audit trails, verifies migration equivalence. Zero LLM tokens for 90% of checks. SEC MIT Python 3
pgembed 0.1.0 Generate vector embeddings through Ollama, OpenAI, or custom HTTP services RAG LicenseRef-Tecnisys-Community-1.0 Python 13–18 2
pgtoken 1.0 PostgreSQL extension for compact, codebook-compressed LLM token ID storage. Encode once, retrieve forever. O(1) token count without decoding. RAG MIT Python 2
cdc_webhook 1.0 Change Data Capture webhook extension ETL Python 1
gdpr_anatomizer 0.0.1 Prototype GDPR/anatomy anonymization extension implemented with PL/Python and PL/pgSQL helpers. SEC Python 12 1
lshvector 1.0 a feature vector type and a locality sensitive hashing index RAG Python 1
pg_ocr 0.0.1 Self-contained OCR functions via PL/Python RAG Python 1
pg_optigraph 0.1.0 pg Optigraph is a PostgreSQL extension which uses OptiGraph ML model. RAG MIT Python 1
audit_stream 0.1.0 Postgres extension that emits audit-stream-py-compatible governance events on watched table CRUD via pg notify, plus a Python LISTEN bridge daemon. The database-tier governance producer for the Kinetic Gain Protocol Suite. SEC MIT Python
dbtune_mab 0.0.1 DBTune MAB advisor for PostgreSQL FEAT Python
find_bucket_ts 1.0 Artifacts of BaCon. For VLDB26 reviewers only. TIME Python
ofarm_ed25519 1.0 OFARM verification-only strict Ed25519 primitive SEC Apache-2.0 Python
pg_agg 1.0 Experimental aggregate-query support extension; its install script currently creates the untrusted PL/Python language. LANG Python 12