Life & fun · alternatives · 2026

24 alternatives to pg-primer - Beginner's guide to administering/managing PostgreSQL

I created this small guide for people starting with postgresql. I added some queries I commonly used as well. Any feedback?

pg-primer is a beginner's guide to administering and managing PostgreSQL. It targets people new to PostgreSQL and includes commonly used queries alongside introductory documentation. The guide is hosted on GitHub and… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. pg-primer - Beginner's guide to administering/managing PostgreSQL launched in 2023; newer entries below may have overtaken it.

1. 1
   Postgres Playground▲161

   Hands-on tutorials to learn Postgres

   2022 · crunchydata.com · its alternatives →

2. 2
   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 →

3. 3
   postgres.new▲774

   The in-browser Postgres sandbox with AI assistance

   2024 · database.build · its alternatives →

4. 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. 5
   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 →

6. 6
   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 →

7. 7
   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 →

8. 8
   Open Source PostgreSQL Studio▲407

   Powerful PostgreSQL tool is now open source for self-hosting

   2021 · supabase.com · its alternatives →

9. 9
   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 →

10. 10PA
    Pgit – A Git-like CLI backed by PostgreSQL▲126

    Mar 2026 · oseifert.ch · its alternatives →

11. 11
    PgDog▲227

    Scale PostgreSQL without changing your app

    Jul 2026 · pgdog.dev · its alternatives →

12. 12PE
    Pg-extend-rs – Easy Postgres extensions in Rust▲244

    2018 · bluejekyll.github.io · its alternatives →

13. 13
    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 →

14. 14AU
    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 →

15. 15
    Pg_replicate – Build Postgres replication applications in Rust▲216

    A high-performance Postgres replication engine written in Rust. Embed it in your Rust application or run it as a standalone binary. - supabase/etl

    2024 · github.com · its alternatives →

16. 16
    SQL playground▲156

    Free private sample PostgreSQL databases

    2021 · uibakery.io · its alternatives →

17. 17PN
    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 →

18. 18
    GraphQL for Postgres▲195

    GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.

    2015 · github.com · its alternatives →

19. 19
    Postgres as a VectorDB GUI▲162

    Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.

    2024 · github.com · its alternatives →

20. 20
    I open-sourced the in-memory PostgreSQL I built at work for E2E tests▲379

    In-memory Postgres for unit/E2E tests. Contribute to hexclave/pgmock development by creating an account on GitHub.

    2024 · github.com · its alternatives →

21. 21
    Postgresqlco.nf: PostgreSQL Configuration for Humans▲223

    We like open source, we develop open source software, and we are very active and well known at Postgres community. We also develop custom products for clients, always around Postgres environment

    2020 · ongres.com · its alternatives →

22. 22PA
    Pgcli – A CLI for Postgres with auto-completion and syntax highlighting▲227

    2015 · pgcli.com · its alternatives →

23. 23
    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 →

24. 24
    PgRebase, codebase management for Postgres▲66

    Easy postgres codebase injection - aka postgres non data live reload - oelmekki/pgrebase

    2016 · github.com · its alternatives →

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 →