Life & fun · alternatives · 2026

24 alternatives to pg_plan_guarantee – Postgres Query Optimizer Hints, on Steroids.

Postgres Query Optimizer Extension that guarantees your desired plan will not change - DrPostgres/pg_plan_guarantee

pg_plan_guarantee is a PostgreSQL extension that provides query optimizer hints to control how the database executes SQL queries. It allows developers and database administrators to override the query planner's… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. pg_plan_guarantee – Postgres Query Optimizer Hints, on Steroids. launched in 2022; newer entries below may have overtaken it.

1
PRQL in PostgreSQL▲267
This extension let's you write PRQL functions in PostgreSQL. When I first saw PRQL on Hacker News a few months ago, I was immediately captivated by the idea, yet equally disappointed that there was no integration for PostgreSQL. Having previous experience with writing PostgreSQL extensions in C, I thought this was a great opportunity to try out the pgrx framework and decided to integrate PRQL with PostgreSQL myself. The maintainers of both PRQL and pgrx were very nice to work with. Thanks guys.
2024 · github.com · its alternatives →
2
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 →
3
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 →
4
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 →
5
Pg_yregress, Structured Testing for Postgres▲56
Originally inspired by pg_regress, pg_yregress provides a TAP-compatible test executor that allows for better test organization, easier instance management, native JSON handling and so on.
2023 · github.com · its alternatives →
6
PRQL 0.2 – a better SQL▲378
Hi everyone — thanks for your interest in PRQL — let us know any questions or feedback! We're excited to be releasing 0.2[1], the first version of PRQL you can use in your own projects. It wouldn't exist without the feedback we got from HackerNews when we originally posted the proposal. [1]: https://github.com/prql/prql/releases/tag/0.2.0
2022 · github.com · its alternatives →
7
Cloud-Ready Postgres MCP Server▲167
Hey HN, I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant and runs over HTTP/SSE (not stdio) Features - Supports multiple database connections from multiple agents - Schema Introspection: Returns table structures, types, indexes and constraints; enriched with descriptions from pg_catalog. (for well documented databases) - Read-Only Queries: Controlled execution of queries via MCP. - EXPLAIN Tool: Helps smart agents optimize queries before execution. - Extension…
2025 · github.com · its alternatives →
8
PgDog – Scale Postgres without changing the app▲326
Hey HN! Lev and Justin here, authors of PgDog (https://pgdog.dev/), a connection pooler, load balancer and database sharder for PostgreSQL. If you build apps with a lot of traffic, you know the first thing to break is the database. We are solving this with a network proxy that works without requiring application code changes or database migrations. Our post from last year: https://news.ycombinator.com/item?id=44099187 The most important update: we are in production. Sharding is used a lot, with direct-to-shard queries (one shard per query) working pretty much…
Feb 2026 · github.com · its alternatives →
9PN
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 →
10
Pg_CRDT – an experimental CRDT extension for Postgres▲296
This is an experimental extension for CRDTs, pg_crdt: GitHub repo[0]. It supports Yjs/Yrs and Automerge. The linked blog post [1] describes how we're thinking about this extension in a Supabase context. I want to emphasise this part: "pg_crdt has not been released onto the Supabase platform (and it may never be). We’re considering many options for offline-sync/support and, while CRDTs will undoubtedly factor in, we’re not sure if this is the right approach." [0] GitHub repo: https://github.com/supabase/pg_crdt [1] Blog post:…
2022 · supabase.com · its alternatives →
11PE
Pg-extend-rs – Easy Postgres extensions in Rust▲244
2018 · bluejekyll.github.io · its alternatives →
12
pg-primer - Beginner's guide to administering/managing PostgreSQL▲58
I created this small guide for people starting with postgresql. I added some queries I commonly used as well. Any feedback?
2023 · github.com · its alternatives →
13
PgCat, Postgres pooler with sharding, load balancing and failover▲233
PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat
2022 · github.com · its alternatives →
14
PG Extras – a set of tools for debugging PostgreSQL performance issues▲12
PostgreSQL database queries are a common performance bottleneck for web apps. Before you resort to more complex optimization techniques like caching or read replicas, you should double-check if your database engine does not need tuning and queries are not underperforming. In this blog post, I presen
2021 · pawelurbanek.com · its alternatives →
15
PgDog▲227
Scale PostgreSQL without changing your app
Jul 2026 · pgdog.dev · its alternatives →
16
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 →
17
BemiDB – Postgres read replica optimized for analytics▲209
Hi HN! We're Evgeny and Arjun, and we’re building a better way to do analytics with Postgres. We love Postgres for its simplicity, power, and rich ecosystem. But engineers have to still get bogged down with heavyweight and expensive OLAP systems when connecting an analytics data stack. Postgres is amazing at OLTP queries, but not for OLAP queries (large data scans and aggregations). Even in this case, we’ve still heard from countless scaling startups that they still try to use only a read replica to run analytics workloads since they don’t want to deal with the data engineering complexity of…
2024 · github.com · its alternatives →
18
pganalyze Index Advisor for Postgres▲78
A better way to index your Postgres database
2021 · pganalyze.com · its alternatives →
19AU
A user interface for Postgres EXPLAIN that also gives tips▲50
pgMustard is a Postgres EXPLAIN visualisation tool that also gives performance advice, scored based on its potential to speed up your query.
2019 · pgmustard.com · its alternatives →
20
Pg_analytica – Speed up queries by exporting tables to columnar format▲42
Postgres extension that speeds up analytics queries by upto 90% - sushrut141/pg_analytica
2024 · github.com · its alternatives →
21
pg_netstat, a Postgres extension to monitor database network traffic▲158
pg_netstat is a Postgres extension to monitor database network traffic. It uses libpcap to capture packets and aggregates at user-specified interval.
2022 · github.com · its alternatives →
22
Postgres as a VectorDB GUI▲162
Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.
2024 · github.com · its alternatives →
23
pganalyze▲84
Automated EXPLAIN Plan Visualization & Insights for Postgres
2019 · pganalyze.com · its alternatives →
24
PG Lens▲3
Stop guessing which queries are hurting your Postgres.
Feb 2026 · pglens.dev · 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 →