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.

zombodb · Elasticsearch-backed full-text search and indexing for PostgreSQL · 3000.2.8 · Full-text search · Apache-2.0 · Rust · Not packagedpg_biscuit · A fast bitmap-based index for PostgreSQL · 1.0 · Full-text search · MIT · C · Not packagedtin · TIN-compatible text search for development and testing · 1.0.3 · Full-text search · AGPL-3.0-or-later · Rust · Not packagedaddressing_dictionary · Address handling dictionaries for PostgreSQL, applying smarter handling to addresses in text search. · 1.1 · Full-text search · MIT · SQL · Not packagedsphinx · C connector for querying and updating an external SphinxSearch server from PostgreSQL. · 0.3 · Full-text search · MIT · C · Not packagedpg_scws · a parser for full-text search of Chinese · 1.0 · Full-text search · BSD-3-Clause · C · Not packagedthai_parser · Thai-language parser and text search configuration for PostgreSQL full-text search. · 1.0.0 · Full-text search · Unknown · C · Not packagedkor_search · A PostgreSQL extension for Korean-English text search. · 1.0.0 · Full-text search · MIT · C · Not packagedtsvector2 · Compressed alternative to PostgreSQL tsvector without the original 1 MB limit, with compatible search functions and GIN, GiST, and optional RUM indexing. · 1.0 · Full-text search · PostgreSQL · C · Not packagedchamkho_parser · Rust full-text-search parser using the Chamkho word-cut engine, ported from pg-search-thai. · 0.6.0 · Full-text search · GPL-2.0 · Rust · Not packagedsphinxlink · C extension for issuing SphinxSearch or ManticoreSearch queries from PostgreSQL through the MySQL-compatible protocol. · 1.4 · Full-text search · Unknown · C · Not packagedpg_tsparser · Parser for PostgreSQL text search · 1.0 · Full-text search · PostgreSQL · C · Not packagedtsexample · Example C extension that defines a custom full-text parser, dictionary template, dictionary, and text-search configuration. · 1.0 · Full-text search · Unknown · C · Not packageditalian_fts · Italian full-text search dictionary · 1.2 · Full-text search · GPL-2.0 · SQL · Not packageddict_voikko · Finnish full-text-search dictionary using Voikko morphological analysis. · 1.0 · Full-text search · PostgreSQL · C · Not packagedtsexact · Full-text-search helpers for exact phrase matching on PostgreSQL 9.5 and earlier. · 1.0 · Full-text search · PostgreSQL · C · Not packagedvgram · Variable-length grams · 1.0 · Full-text search · PostgreSQL · C · Not packagedfuzzywuzzy · fuzzywuzzy ratio for postgres · 0.0.2 · Full-text search · PostgreSQL · SQL · Not packagedtsp_semantic_headline · Phrase highlighting and improved semantics for ts_headline · 1.0 · Full-text search · GPL-3.0 · SQL · Not packagedshared_ispell · Shared-memory ispell dictionary template for reducing per-session initialization and memory. · 1.0.0 · Full-text search · BSD-2-Clause · C · Not packagedpg_bigmr · text similarity measurement and index searching based on bigrams · 0.1.0 · Full-text search · PostgreSQL · Rust · Not packagedunidecode · ASCII transliterations of Unicode text · 0.0.6 · Full-text search · Unknown · C · Not packagedwildspeed · GIN operator class for fast wildcard LIKE searches using permuterm indexing · 1.0 · Full-text search · GPL-2.0 · C · Not packagedpg_mystem · Runs Yandex Mystem worker processes to provide Russian-language lemmatization from PostgreSQL queries. · 1.0.1 · Full-text search · MIT · C++ · Not packagedsnowball_bilingual · snowball_bilingual - add-on dictionary template using the combined results of two snowball stemmers · 1.0 · Full-text search · AGPL-3.0 · C · Not packagedtsearch_extras · Full-text-search helpers for returning match locations and extracting tsvector lexemes. · 1.0 · Full-text search · PostgreSQL · C · Not packagedjiebaparser · Postgresql full-text search extension for chinese (jiaba engine) using shared mem. · 1.0 · Full-text search · Apache-2.0 · C++ · Not packagednorasearch · NoraSearch is a high-performance search engine for PostgreSQL. · 1.0 · Full-text search · MIT · C · Not packagedpg_hspell · Full text search dictionary template for Hebrew text using libhspell · 1.0 · Full-text search · MPL-2.0 · C · 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 packageddict_exclude · Full-text search dictionary that filters stop words using regular-expression rules. · 1.0 · Full-text search · PostgreSQL · C · Not packageddict_id · Indonesian-language full-text search stemming dictionary based on cSastrawi · 1.0 · Full-text search · PostgreSQL · C · Not packagedmusicbrainz_unaccent · Removes accents from Unicode data · 1.0.0 · Full-text search · GPL-2.0 · C · Not packagedpg_tre · Native PostgreSQL index access method for approximate regular-expression matching · 3.0.2 · Full-text search · MIT · C · Not packagedpg_icu_parser · Full text search parser using ICU boundary analysis · 1.0 · Full-text search · MPL-2.0 · C · Not packagedsimple_parser · C full-text-search parser that splits input only at ASCII space characters, preserving punctuation such as underscores inside tokens. · 1.0 · Full-text search · PostgreSQL · C · Not packagedstannum · Experimental TINQL text search with BM25 and persistent indexes · 0.1.0 · Full-text search · AGPL-3.0-only · Rust · Not packagedtest_parser · Example C extension implementing a custom PostgreSQL full-text-search parser. · 1.0 · Full-text search · Unknown · C · Not packagedall_substrings_tokenizer · Tokenizes text to all substrings bigger than a fixed character length. · 0.1 · Full-text search · Unknown · C · Not packageddict_regex · Full-text-search dictionary with regular-expression rules. · 1.0 · Full-text search · Unknown · C · Not packageddict_translate · Text search dictionary template that normalizes lexemes and expands them to configured translations. · 1.0 · Full-text search · Unknown · C · Not packagedhsearch · Tantivy-backed BM25 index access method with WAL-logged storage. · 0.4.1 · Full-text search · AGPL-3.0-only · Rust · Not packagedhunspell_xal · Kalmyk Hunspell dictionary for PostgreSQL full-text search · 0.1 · Full-text search · BSD-3-Clause · SQL · Not packagedpg_cld2 · Detects likely human language and script in PostgreSQL using CLD2. · 1.0.0 · Full-text search · MIT · C++ · Not packagedpg_fts_greek · Postgres FTS Improvements for Greek · 0.1 · Full-text search · Unknown · SQL · Not packagedsetrank · TF-IDF and cover-density ranking functions for tsvector/tsquery using document-frequency statistics from a table. · 1.0 · Full-text search · Unknown · C · Not packagedsimilarity · C extension that computes a normalized similarity score between two strings using an fstrcmp-style approximate matching algorithm. · 1.0 · Full-text search · GPL-2.0 · C · Not packagedsnowball_ext · Extensible Snowball text-search dictionary template with a Nepali stemmer. · 1.0 · Full-text search · PostgreSQL · C · Not packagedsoundex-type · soundex - type · 1.0.0 · Full-text search · PostgreSQL · C · Not packagedcologne_pg · Cologne phonetics function for PostgreSQL built with pgrx. · 0.0.0 · Full-text search · MIT · Rust · Not packagedcontent_utils · Utility functions for news management and full-text search. · 1.0.0 · Full-text search · GPL-2.0 · SQL · Not packageddict_roman · Full-text search dictionary that converts Roman numeral tokens to Arabic integers. · 1.0 · Full-text search · Unknown · C · Not packagedfzy · FZY algorithm for PostgreSQL · 0.0.1 · Full-text search · MIT · C · Not packagedkham_pg · Thai word-segmentation FTS parser — tsvector, soundex, RTGS romanization, NER · 0.8.2 · Full-text search · MIT · Rust · Not packagedludia_funcs · Ludia full-text search helper functions · 1.0 · Full-text search · LGPL-2.1 · C · Not packagedmipt-asj · Abbreviation-aware approximate string joins using the Tao-Deng-Stonebraker algorithm · 0.1 · Full-text search · MIT · C · Not packagedpg_ac · PostgreSQL extension for full text search · 0.1 · Full-text search · Unknown · C · Not packagedpg_bm25 · Full text search for PostgreSQL using BM25 · 0.0.0 · Full-text search · AGPL-3.0 · Rust · Not packagedpg_textparser · Text search parser · 1.0 · Full-text search · MIT · C · Not packagedproxquery · positional proximity predicates for tsvector full-text search · 0.5.2 · Full-text search · Unknown · Rust · Not packagedsoundex-function · soundex - function for comparing strings · 1.0.0 · Full-text search · PostgreSQL · C · Not packagedtwitter_parser · Minimal C full-text-search parser that tokenizes Twitter-style hashtags and mentions. · 1.0 · Full-text search · Unknown · C · Not packageddict_maxlen · text search template for a dictionary filtering out long words · 1.0 · Full-text search · Unknown · C · Not packagedfuzzering · search string content · 0.0.1 · Full-text search · Unknown · C · Not packagedfuzzysearch · PostgreSQL extension for strings fuzzy matching · 1.0 · Full-text search · Unknown · C · Not packagedjieba_parser · Jieba parser for full-text search. · 1.0 · Full-text search · Unknown · C++ · Not packagedjusquci · French tokenizer and PostgreSQL full-text-search parser. · 1.0 · Full-text search · GPL-3.0 · C · Not packagedmorpheme_funcs · PostgreSQL extension built with pgrx; upstream metadata did not provide a specific description. · 0.0.0 · Full-text search · Unknown · Rust · Not packagedparodydb · A toy full-text search extension for Postgres, written in Rust using pgrx · 0.0.0 · Full-text search · Unknown · Rust · Not packagedpg_bert · BERT tokenizer implemented as a PostgreSQL full-text-search parser. · 0.0.0 · Full-text search · Apache-2.0 · Rust · Not packagedpg_bleve · PostgreSQL extension for Bleve search integration · 1.0.0 · Full-text search · AGPL-3.0 · Go · Not packagedpg_probablepeople · CRF-based parsing of personal and organization names into structured components. · 0.0.1 · Full-text search · MIT · C · Not packagedpg_weave · BM25 lexical search through the weave index access method · 0.10.0 · Full-text search · PostgreSQL · C · Not packagedtag_parser · PostgreSQL Text Search parser extension for character separated lexemes · 0.1.0 · Full-text search · MIT · C · Not packagedvmatch · Text similarity functions and a fuzzy-match /= operator with typo-aware weighting. · 1.0 · Full-text search · Unknown · C · Not packaged

75 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
zombodb 3000.2.8 Elasticsearch-backed full-text search and indexing for PostgreSQL FTS Apache-2.0 Rust 12–15 4.7k
pg_biscuit 1.0 A fast bitmap-based index for PostgreSQL FTS MIT C 300
tin 1.0.3 TIN-compatible text search for development and testing FTS AGPL-3.0-or-later Rust 17–18 117
addressing_dictionary 1.1 Address handling dictionaries for PostgreSQL, applying smarter handling to addresses in text search. FTS MIT SQL 10–18 59
sphinx 0.3 C connector for querying and updating an external SphinxSearch server from PostgreSQL. FTS MIT C 51
pg_scws 1.0 a parser for full-text search of Chinese FTS BSD-3-Clause C 41
thai_parser 1.0.0 Thai-language parser and text search configuration for PostgreSQL full-text search. FTS C 10–18 41
kor_search 1.0.0 A PostgreSQL extension for Korean-English text search. FTS MIT C 16 37
tsvector2 1.0 Compressed alternative to PostgreSQL tsvector without the original 1 MB limit, with compatible search functions and GIN, GiST, and optional RUM indexing. FTS PostgreSQL C 10–13 27
chamkho_parser 0.6.0 Rust full-text-search parser using the Chamkho word-cut engine, ported from pg-search-thai. FTS GPL-2.0 Rust 26
sphinxlink 1.4 C extension for issuing SphinxSearch or ManticoreSearch queries from PostgreSQL through the MySQL-compatible protocol. FTS C 18
pg_tsparser 1.0 Parser for PostgreSQL text search FTS PostgreSQL C 17
tsexample 1.0 Example C extension that defines a custom full-text parser, dictionary template, dictionary, and text-search configuration. FTS C 15
italian_fts 1.2 Italian full-text search dictionary FTS GPL-2.0 SQL 14
dict_voikko 1.0 Finnish full-text-search dictionary using Voikko morphological analysis. FTS PostgreSQL C 12
tsexact 1.0 Full-text-search helpers for exact phrase matching on PostgreSQL 9.5 and earlier. FTS PostgreSQL C 10–18 12
vgram 1.0 Variable-length grams FTS PostgreSQL C 13–18 12
fuzzywuzzy 0.0.2 fuzzywuzzy ratio for postgres FTS PostgreSQL SQL 11
tsp_semantic_headline 1.0 Phrase highlighting and improved semantics for ts_headline FTS GPL-3.0 SQL 14–18 11
shared_ispell 1.0.0 Shared-memory ispell dictionary template for reducing per-session initialization and memory. FTS BSD-2-Clause C 10–18 10
pg_bigmr 0.1.0 text similarity measurement and index searching based on bigrams FTS PostgreSQL Rust 12–17 7
unidecode 0.0.6 ASCII transliterations of Unicode text FTS C 10–18 7
wildspeed 1.0 GIN operator class for fast wildcard LIKE searches using permuterm indexing FTS GPL-2.0 C 7
pg_mystem 1.0.1 Runs Yandex Mystem worker processes to provide Russian-language lemmatization from PostgreSQL queries. FTS MIT C++ 6
snowball_bilingual 1.0 snowball_bilingual - add-on dictionary template using the combined results of two snowball stemmers FTS AGPL-3.0 C 6
tsearch_extras 1.0 Full-text-search helpers for returning match locations and extracting tsvector lexemes. FTS PostgreSQL C 10–11 6
jiebaparser 1.0 Postgresql full-text search extension for chinese (jiaba engine) using shared mem. FTS Apache-2.0 C++ 5
norasearch 1.0 NoraSearch is a high-performance search engine for PostgreSQL. FTS MIT C 16–18 5
pg_hspell 1.0 Full text search dictionary template for Hebrew text using libhspell FTS MPL-2.0 C 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
dict_exclude 1.0 Full-text search dictionary that filters stop words using regular-expression rules. FTS PostgreSQL C 4
dict_id 1.0 Indonesian-language full-text search stemming dictionary based on cSastrawi FTS PostgreSQL C 4
musicbrainz_unaccent 1.0.0 Removes accents from Unicode data FTS GPL-2.0 C 4
pg_tre 3.0.2 Native PostgreSQL index access method for approximate regular-expression matching FTS MIT C 17–18 4
pg_icu_parser 1.0 Full text search parser using ICU boundary analysis FTS MPL-2.0 C 10–16 3
simple_parser 1.0 C full-text-search parser that splits input only at ASCII space characters, preserving punctuation such as underscores inside tokens. FTS PostgreSQL C 3
stannum 0.1.0 Experimental TINQL text search with BM25 and persistent indexes FTS AGPL-3.0-only Rust 17–18 3
test_parser 1.0 Example C extension implementing a custom PostgreSQL full-text-search parser. FTS C 3
all_substrings_tokenizer 0.1 Tokenizes text to all substrings bigger than a fixed character length. FTS C 2
dict_regex 1.0 Full-text-search dictionary with regular-expression rules. FTS C 2
dict_translate 1.0 Text search dictionary template that normalizes lexemes and expands them to configured translations. FTS C 2
hsearch 0.4.1 Tantivy-backed BM25 index access method with WAL-logged storage. FTS AGPL-3.0-only Rust 18 2
hunspell_xal 0.1 Kalmyk Hunspell dictionary for PostgreSQL full-text search FTS BSD-3-Clause SQL 2
pg_cld2 1.0.0 Detects likely human language and script in PostgreSQL using CLD2. FTS MIT C++ 10–18 2
pg_fts_greek 0.1 Postgres FTS Improvements for Greek FTS SQL 2
setrank 1.0 TF-IDF and cover-density ranking functions for tsvector/tsquery using document-frequency statistics from a table. FTS C 2
similarity 1.0 C extension that computes a normalized similarity score between two strings using an fstrcmp-style approximate matching algorithm. FTS GPL-2.0 C 2
snowball_ext 1.0 Extensible Snowball text-search dictionary template with a Nepali stemmer. FTS PostgreSQL C 2
soundex-type 1.0.0 soundex - type FTS PostgreSQL C 2
cologne_pg 0.0.0 Cologne phonetics function for PostgreSQL built with pgrx. FTS MIT Rust 11–16 1