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.

tsearch2 · Deprecated Amazon RDS PostgreSQL 10 compatibility extension for applications using pre-8.3 tsearch2 full-text-search APIs. · 1.0 · Full-text search · PostgreSQL · C · Not packagedpg_search · Full text search for PostgreSQL using BM25 · 0.25.9 · Full-text search · AGPL-3.0 · Rust · Packagedzombodb · Elasticsearch-backed full-text search and indexing for PostgreSQL · 3000.2.8 · Full-text search · Apache-2.0 · Rust · Not packagedpg_textsearch · Full-text search with BM25 ranking · 1.4.0 · Full-text search · PostgreSQL · C · Packagedzhparser · a parser for full-text search of Chinese · 2.3 · Full-text search · PostgreSQL · C · Packagedpgroonga · Use Groonga as index, fast full text search platform for all languages! · 4.0.4 · Full-text search · PostgreSQL · C · Packagedpgroonga_database · PGroonga database management module · 4.0.4 · Full-text search · PostgreSQL · C · Packagedacdat · Compiled Aho-Corasick double-array machines for exact multi-pattern matching and replacement in PostgreSQL. · 0.1.1 · Full-text search · Apache-2.0 · C · Packagedpg_jieba · Chinese full-text search parser based on cppjieba · 1.1.0 · Full-text search · BSD-3-Clause · C++ · Packagedvchord_bm25 · A postgresql extension for bm25 ranking algorithm · 0.3.0 · Full-text search · AGPL-3.0 · Rust · Packagedbiscuit · IAM-LIKE pattern matching with bitmap indexing · 3.1.0 · Full-text search · MIT · C · Packagedpg_biscuit · A fast bitmap-based index for PostgreSQL · 1.0 · Full-text search · MIT · C · Not packagedpg_bigm · create 2-gram (bigram) index for faster full text search. · 1.2 · Full-text search · PostgreSQL · C · Packagedpsql_bm25s · PostgreSQL extension for BM25-family lexical retrieval · 0.4.14 · Full-text search · Apache-2.0 · C · Packagedtin · TIN-compatible text search for development and testing · 1.0.3 · Full-text search · AGPL-3.0-or-later · Rust · Not packagedpg_bestmatch · Generate BM25 sparse vector inside PostgreSQL · 0.0.2 · Full-text search · Apache-2.0 · Rust · Packagedhunspell_cs_cz · Czech Hunspell Dictionary · 1.0 · Full-text search · PostgreSQL · Data · Packagedhunspell_de_de · German Hunspell Dictionary · 1.0 · Full-text search · PostgreSQL · Data · Packagedhunspell_en_us · en_US Hunspell Dictionary · 1.0 · Full-text search · PostgreSQL · Data · Packagedhunspell_fr · French Hunspell Dictionary · 1.0 · Full-text search · PostgreSQL · Data · Packagedhunspell_ne_np · Nepali Hunspell Dictionary · 1.0 · Full-text search · PostgreSQL · Data · Packagedhunspell_nl_nl · Dutch Hunspell Dictionary · 1.0 · Full-text search · PostgreSQL · Data · Packagedhunspell_nn_no · Norwegian (norsk) Hunspell Dictionary · 1.0 · Full-text search · PostgreSQL · Data · Packagedhunspell_pt_pt · Portuguese Hunspell Dictionary · 1.0 · Full-text search · PostgreSQL · Data · Packagedhunspell_ru_ru · Russian Hunspell Dictionary · 1.0 · Full-text search · PostgreSQL · Data · Packagedhunspell_ru_ru_aot · Russian Hunspell Dictionary (from AOT.ru group) · 1.0 · Full-text search · PostgreSQL · Data · 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_tokenizer · Tokenizers for full-text search · 0.1.1 · Full-text search · Apache-2.0 · Rust · Packagedpg_cjk_parser · CJK bigram parser derived from PostgreSQL full-text search · 0.1.0 · Full-text search · PostgreSQL · C · 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 packagedpg_kazsearch · Kazakh full-text search extension for PostgreSQL · 2.3.0 · Full-text search · LGPL-3.0 · Rust · 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 packagedpg_pinyin · Pinyin romanization and search helpers for PostgreSQL · 0.0.5 · Full-text search · MIT · Rust · 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 packagedfuzzystrmatch · determine similarities and distance between strings · 1.2 · Full-text search · PostgreSQL · C · 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_fts · Full-text search with BM25 and BM25F ranking · 1.8.3 · Full-text search · PostgreSQL · C · Packagedpg_probablepeople · CRF-based parsing of personal and organization names into structured components. · 0.0.1 · Full-text search · MIT · C · Not packagedpg_trgm · text similarity measurement and index searching based on trigrams · 1.6 · Full-text search · PostgreSQL · C · 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

105 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
tsearch2 1.0 Deprecated Amazon RDS PostgreSQL 10 compatibility extension for applications using pre-8.3 tsearch2 full-text-search APIs. FTS PostgreSQL C 10 22k
pg_search 0.25.9 Full text search for PostgreSQL using BM25 FTS AGPL-3.0 Rust 15–18 9.2k
zombodb 3000.2.8 Elasticsearch-backed full-text search and indexing for PostgreSQL FTS Apache-2.0 Rust 12–15 4.7k
pg_textsearch 1.4.0 Full-text search with BM25 ranking FTS PostgreSQL C 17–18 4.0k
zhparser 2.3 a parser for full-text search of Chinese FTS PostgreSQL C 14–18 870
pgroonga 4.0.4 Use Groonga as index, fast full text search platform for all languages! FTS PostgreSQL C 14–18 748
pgroonga_database 4.0.4 PGroonga database management module FTS PostgreSQL C 14–18 748
acdat 0.1.1 Compiled Aho-Corasick double-array machines for exact multi-pattern matching and replacement in PostgreSQL. FTS Apache-2.0 C 14–18 664
pg_jieba 1.1.0 Chinese full-text search parser based on cppjieba FTS BSD-3-Clause C++ 14–18 420
vchord_bm25 0.3.0 A postgresql extension for bm25 ranking algorithm FTS AGPL-3.0 Rust 14–18 376
biscuit 3.1.0 IAM-LIKE pattern matching with bitmap indexing FTS MIT C 16–18 300
pg_biscuit 1.0 A fast bitmap-based index for PostgreSQL FTS MIT C 300
pg_bigm 1.2 create 2-gram (bigram) index for faster full text search. FTS PostgreSQL C 14–18 152
psql_bm25s 0.4.14 PostgreSQL extension for BM25-family lexical retrieval FTS Apache-2.0 C 17–18 146
tin 1.0.3 TIN-compatible text search for development and testing FTS AGPL-3.0-or-later Rust 17–18 117
pg_bestmatch 0.0.2 Generate BM25 sparse vector inside PostgreSQL FTS Apache-2.0 Rust 14–18 100
hunspell_cs_cz 1.0 Czech Hunspell Dictionary FTS PostgreSQL Data 14–18 68
hunspell_de_de 1.0 German Hunspell Dictionary FTS PostgreSQL Data 14–18 68
hunspell_en_us 1.0 en_US Hunspell Dictionary FTS PostgreSQL Data 14–18 68
hunspell_fr 1.0 French Hunspell Dictionary FTS PostgreSQL Data 14–18 68
hunspell_ne_np 1.0 Nepali Hunspell Dictionary FTS PostgreSQL Data 14–18 68
hunspell_nl_nl 1.0 Dutch Hunspell Dictionary FTS PostgreSQL Data 14–18 68
hunspell_nn_no 1.0 Norwegian (norsk) Hunspell Dictionary FTS PostgreSQL Data 14–18 68
hunspell_pt_pt 1.0 Portuguese Hunspell Dictionary FTS PostgreSQL Data 14–18 68
hunspell_ru_ru 1.0 Russian Hunspell Dictionary FTS PostgreSQL Data 14–18 68
hunspell_ru_ru_aot 1.0 Russian Hunspell Dictionary (from AOT.ru group) FTS PostgreSQL Data 14–18 68
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_tokenizer 0.1.1 Tokenizers for full-text search FTS Apache-2.0 Rust 14–18 45
pg_cjk_parser 0.1.0 CJK bigram parser derived from PostgreSQL full-text search FTS PostgreSQL C 14–18 41
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
pg_kazsearch 2.3.0 Kazakh full-text search extension for PostgreSQL FTS LGPL-3.0 Rust 16–18 25
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
pg_pinyin 0.0.5 Pinyin romanization and search helpers for PostgreSQL FTS MIT Rust 14–18 13
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