AI · alternatives · 2026

24 alternatives to Pg_textsearch – BM25 Ranking for Postgres

I built pg_textsearch, a Postgres extension that brings proper BM25 ranking to full-text search. It's designed for AI/RAG workloads where search quality directly impacts LLM output. Postgres native ts_rank lacks corpus-aware signals (no IDF, no TF saturation, no length normalization). This causes mediocre documents to rank above excellent matches, which matters when your LLM depends on retrieval quality. Quick example: CREATE EXTENSION pg_textsearch; CREATE INDEX articles_idx ON articles USING bm25(content); SELECT title, content to_bm25query('database performance', 'articles_idx') AS…

pg_textsearch is a Postgres extension that implements BM25 ranking for full-text search. It addresses limitations in Postgres's native ts_rank function by adding corpus-aware signals like inverse document frequency… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Prices are shown for the 1 we have checked on their own sites, 1 of them free or with a free tier.

1
Postgres extension for BM25 relevance-ranked full-text search▲203
Last summer we faced a conundrum at my company, Tiger Data, a Postgres cloud vendor whose main business is in timeseries data. We were trying to grow our business towards emerging AI-centric workloads and wanted to provide a state-of-the-art hybrid search stack in Postgres. We'd already built pgvectorscale in house with the goal of scaling semantic search beyond pgvector's main memory limitations. We just needed a scalable ranked keyword search solution too. The problem: core Postgres doesn't provide this; the leading Postgres BM25 extension, ParadeDB, is guarded behind AGPL; developing our…
Mar 2026 · github.com · its alternatives →
2
AI Search Console▲493
Prompt analytics and citation mapping for AI search
Jul 2026 · search-console.ai · its alternatives →
3
PgQueuer – Transform PostgreSQL into a Job Queue▲376
PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!
2024 · github.com · its alternatives →
4
PGlite – in-browser WASM Postgres with pgvector and live sync▲509
Hey, Sam and the team from ElectricSQL here. PGlite is a WASM Postgres build packaged into a TypeScript/JavaScript client library, that enables you to run Postgres in the browser, Node.js and Bun, with no need to install any other dependencies. It's 3mb Gzipped, now has support for many Postgres extensions, including pgvector, and it has a reactive "live query" API. It's also fast, with CRUD style queries executing in under 0.3 ms, and larger, multi-row select queries occurring within a fraction of a single frame. PGlite started as an experimental project we shared on X, and the…
2024 · pglite.dev · its alternatives →
5
pg_flame – flamegraph visualizations of PostgreSQL query plans▲321
A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
2019 · github.com · its alternatives →
6PN
PostgresML, now with analytics and project management▲444
We've been hard at work for a few weeks and thought it's time for another update. In case you missed our first post, PostgresML is an end-to-end machine learning solution, running alongside your favorite database. This time we have more of a suite offering: project management, visibility into the datasets and the deployment pipeline decision making. Let us know what you think! Demo link is on the page, and also here: https://demo.postgresml.org
2022 · postgresml.org · its alternatives →
7
Meilisearch AI▲241
Boost relevance and UX with fast hybrid and semantic search
2025 · meilisearch.com · its alternatives →
8
LLMrefs▲314
AI SEO Keyword Rank Tracker for LLM Search Engines
2025 · llmrefs.com · its alternatives →
9
Pgsemantic – Point at your Postgres DB, get vector search instantly▲18
Zero-config semantic search for any PostgreSQL database. pip install pgsemantic, three commands, done - varmabudharaju/pgsemantic
Mar 2026 · github.com · its alternatives →
10LA
Lantern – a PostgreSQL vector database for building AI applications▲196
We are excited to share Lantern! Lantern is a PostgreSQL vector database extension for building AI applications. Install and use our extension here: https://github.com/lanterndata/lantern We have the most complete feature set of all the PostgreSQL vector database extensions. Our database is built on top of usearch — a state of the art implementation of HNSW, the most scalable and performant algorithm for handling vector search. There’s three key metrics we track. CREATE INDEX time, SELECT throughput, and SELECT latency. We match or outperform pgvector and pg_embedding…
2023 · docs.lantern.dev · its alternatives →
11
PostgreSQL index advisor▲417
This is a Postgres extension that can determine if a query should have an index. For example, for this table: create table book( id int primary key, title text not null ); You can run `index_advisor()` to see if there should be an index on a select statement: select * from index_advisor('select book.id from book where title = $1'); And it will return (summarized): {"CREATE INDEX ON public.book USING btree (title)"} It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database. It leans heavily on HypoPG[1], an…
2024 · github.com · its alternatives →
12WS
Web search using a ChatGPT-like model that can cite its sources▲318
We’ve trained a generative AI model to browse the web and answer questions/retrieve code snippets directly. Unlike ChatGPT, it has access to primary sources and is able to cite them when you hover over an answer (click on the text to go to the source being cited). We also show regular Bing results side-by-side with our AI answer. The model is an 11-billion parameter T5-derivative that has been fine-tuned on feedback given on hundreds of thousands of searches done (anonymously) on our platform. Giving the model web access lessens its burden to need to store a snapshot of human knowledge…
2022 · beta.sayhello.so · its alternatives →
13
Retake – Open-Source Hybrid Search for Postgres▲88
Hey HN! We're Phil and Ming, co-founders of Retake (https://github.com/getretake/retake). Retake is an open source tool that adds keyword and semantic (i.e hybrid) search to databases. We’ve started by extending the capabilities of Postgres with an SDK for lightning-fast queries. We built Retake to fix two issues: keeping vectors in sync with Postgres in real time is difficult, and most vector databases aren’t built for hybrid search. A quick refresher: “keyword search” refers to a technique where results are scored based on the appearance of exact words or terms.…
2023 · github.com · its alternatives →
14
SereneDBfree▲262
Ultra-Fast Search & Analytics Database, Agentic AI ready
Sep 2026 · serenedb.com · its alternatives →
15WB
We built a fast substring search engine in Go▲145
2013 · tamber.com · its alternatives →
16
Parse your Postgres queries into a fully-typed AST in TypeScript▲116
Hey all, I'm the creator of @pg-nano/pg-parser. I'm using it in pg-nano[1] to statically analyze Postgres schemas spread across multiple SQL files for a couple of reasons: 1. Each CREATE statement needs to be in topological order, so pg-nano's dev command can execute them without issue. 2. pg-nano has a plugin system like Vite that allows SQL generation based on the parsed schema. Probably to the surprise of no one, working with an untyped AST feels like you're back in the days of JavaScript, because well... you are. Most of you know by now just how great TypeScript and static types in…
2024 · github.com · its alternatives →
17
BloomSearch – Keyword search with hierarchical Bloom filters▲66
Hey HN! I got nerd-sniped by Bloom Filters this weekend, specifically for searching datasets with high "cardinality" (number of unique items). They're an _amazing_ data structure that, at a fixed size, tracks potential set membership. That means unlike normal b-tree indexes, they don't grow with the number of unique items in the dataset. This makes them great for "needle in a haystack" search (logs, document) as implementations like VictoriaMetrics and Bing's BitFunnel show. I've used them in the past, but they've never been center-stage in my projects. I wanted high cardinality keyword…
2025 · github.com · its alternatives →
18
pg_search on Neon▲8
Get 1,000x faster full-text search in Neon Postgres
2025 · neon.com · its alternatives →
19
I wrote a full text search engine in Go▲131
Full Text Search Engine - built for Hackers not Hyperscalers - 0xnyn/blaze
2025 · github.com · its alternatives →
20
Improve Text-to-SQL Accuracy with LLM▲17
A repository that contains models, datasets, and fine-tuning techniques for DB-GPT, with the purpose of enhancing model performance in Text-to-SQL - eosphoros-ai/DB-GPT-Hub
2023 · github.com · its alternatives →
21
pgMagic – a Mac Postgres client that lets you query in natural language▲49
Hi HN. This is a project I've been building for the last month. It's a macOS postgres client that uses your OpenAI key to generate and immediately execute queries against your database locally on your machine. I imagine the user being someone familiar with SQL and able to identify errors in the generated code, but regularly needs to write queries to answer relatively simple questions. This is my first software project I'm intending on selling myself and would love feedback on the product and landing page. I'd also love ideas on how to market it to users, as I'm very new to this. In the near…
2023 · pgmagic.app · its alternatives →
22
ZomboDB – Postgres extension for indexes backed by Elasticsearch▲88
Making Postgres and Elasticsearch work together like it's 2023 - zombodb/zombodb
2015 · github.com · its alternatives →
23
Pg-typesafe – Strongly typed queries for PostgreSQL and TypeScript▲69
Throughout my career, I tried many tools to query PostgreSQL, and in the end, concluded that for what I do, the simplest is almost always the best: raw SQL queries. Until now, I typed the results manually and relied on tests to catch problems. While this is OK in e.g., GoLang, it is quite annoying in TypeScript. First, because of the more powerful type system (it's easier to guess that updated_at is a date than it is to guess whether it's nullable or not), second, because of idiosyncrasies (INT4s are deserialised as JS numbers, but INT8s are deserialised as strings). So I wrote pg-typesafe,…
Feb 2026 · github.com · its alternatives →
24
Polygres▲58
Polygres turns the Postgres you already run into internal search for AI agents. Rows, relationships, and embeddings: one hybrid query, one ranked answer.
Jul 2026 · polygres.com · its alternatives →

Also compare

Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →