SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Postgre Open-Source Projects
-
supabase
The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
Supabase is an open-source backend platform built around managed PostgreSQL. You get a database, auto-generated REST APIs (via PostgREST), Auth, file Storage, Realtime subscriptions, and Edge Functions - with a dashboard and SQL editor on top.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Grafana
The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
Project mention: OpenTelemetry: The Foundation of Modern Cloud-Native Observability — Traces, Metrics, Logs, and the Future of Observability | dev.to | 2026-05-28Grafana Labs ecosystem Datadog New Relic Dynatrace Splunk Elastic Custom data lakes and analytics systems
-
coolify
An open-source, self-hostable PaaS alternative to Vercel, Heroku & Netlify that lets you easily deploy static sites, databases, full-stack applications and 280+ one-click services on your own servers.
Install Coolify (free, open source) on a VPS and deploy Memos from its catalog. You get a web UI and auto-updates, but Coolify itself wants ~2 GB of RAM, which is heavier than the app it is managing. Worth it only if you are already running Coolify for other apps.
-
Metabase
The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
Project mention: Metabase VS onequery - a user suggested alternative | libhunt.com/r/metabase | 2026-06-01 -
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Project mention: Performance Comparison: Flyway 10.0 vs. Liquibase 4.28 vs. Prisma Migrate 6.0 for Database Migrations | dev.to | 2026-04-30⭐ prisma/prisma — 45,859 stars, 2,180 forks
-
payload
Payload is the open-source, fullstack Next.js framework, giving you instant backend superpowers. Get a full TypeScript backend and admin panel instantly. Use Payload as a headless CMS or for building powerful applications.
Project mention: EmDash: A spiritual successor to WordPress and plugin security | news.ycombinator.com | 2026-04-01Payload can be deployed to Cloudflare Workers: https://github.com/payloadcms/payload/tree/main/templates/wi...
-
Project mention: Code Story: Optimizing Our PostgreSQL 16 Queries with EXPLAIN and Drizzle 0.30 Cut Response Time by 40% | dev.to | 2026-05-07
⭐ drizzle-team/drizzle-orm — 34,254 stars, 1,360 forks
-
Hasura
Blazing fast, instant realtime GraphQL APIs on all your data with fine grained access control, also trigger webhooks on database events.
Project mention: One Brain to Query: Wiring a 60-Person Company into a Single Slack Bot | news.ycombinator.com | 2026-04-09Shameless plug: My org does this, and we deactived our Slack server to dogfood
https://promptql.io
By building Hasura [0], we already had the ability to generate data catalogs + metadata layer from DB's + API's so the foundational infra was there
[0] https://github.com/hasura/graphql-engine
-
infisical
Infisical is the open-source platform for secrets, certificates, and privileged access management.
Project mention: Ask HN: How do small teams securely share env files? | news.ycombinator.com | 2026-05-23IMO env files are a bit of an anti-pattern, env vars should be set outside the context of your app so that your app doesn't need to care where they come from, it just uses standard env var APIs to read them.
With that said, the problem still exists just one layer higher. If they are secrets, I use Infisical (https://infisical.com/) which is free and self-hostable, and let's you inject secrets at runtime via their CLI. Very handy for small teams.
On top of that, I use direnv (https://direnv.net/) with a hook to infisical's export command. This means when I 'cd' into a project, infisical runs and injects the secrets for my developer environment.
Everything that isn't secret just lives in .envrc and gets loaded by direnv, and you can just send those files however you want because they aren't sensitive.
-
-
Project mention: AirLLM Shrinks 70B LLMs to 4GB VRAM; DPO & Supermemory Boost Open Models | dev.to | 2026-06-03
-
I’m doing offline-first apps at work and want to emphasize that you’re constraining yourself a lot trying to do this.
As mentioned, everything fast(ish) is using SQLite under the hood. If you don’t already know, SQLite has a limited set of types, and some funky defaults. How are you going to take this loosey-goosey typed data and store it in a backend database when you sync? What about foreign key constraints, etc., can you live without those? Some of the sync solutions don’t support enforcing them on the client.
Also, the SQLite query planner isn’t great in my experience, even when you’re only joining on ids/indexes.
Document databases seem more friendly/natural, but as mentioned indexeddb is slow.
I wish this looked at https://rxdb.info/ more. They have some posts that lead me to believe they have a good grasp on the issues in this space at least
-
TimescaleDB
A time-series database for high-performance real-time analytics packaged as a Postgres extension
-
neon
Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, code-like database branching, and scale to zero.
Project mention: The $0 Infrastructure: Launching a Rails SaaS for Free in 2026 | dev.to | 2026-02-09The Solution: Neon Neon separates storage from compute. It scales down to zero when no one is using it.
-
Project mention: AI Coding: Building a 1-Hour App Clone Is Easy. Shipping It Is the Work | dev.to | 2026-03-18
If you’re coming from the Parse ecosystem, it may help to know that Parse itself is a long-running open source backend framework. You can start from the official Parse Platform site, or go deeper with the community’s Parse Server repository. Our own developer docs are organized around that reality. If you want implementation-level guides, start with our SashiDo Documentation.
-
Project mention: Is Airtable Too Expensive? 5 Self-Hosted Alternatives Compared by Cost & Features | dev.to | 2025-06-29
-
Gravitational Teleport
The easiest, and most secure way to access and protect all of your infrastructure.
-
Project mention: Zero Downtime Database Migrations: A Practical Guide for PostgreSQL | dev.to | 2026-05-01
-
sqlx
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. (by transact-rs)
I don’t like strict tables, because it conflates two concerns, with one somewhat good and one distinctly bad effect (in my assessments).
The somewhat good: it gets rid of most of the weak typing. It still coerces, in line with other SQL databases, but at least a column will only store values of one type. Personally I’d prefer to opt out of the coercion. And I don’t think most ways of writing SQL (in applications especially, but also manually) will ever actually trigger the strict differences. So it doesn’t feel like it’s actually particularly useful.
The distinctly bad: you’re limited to six datatype names. You may well now want external documentation or load-bearing comments in your schema, and your application code may be hobbled, if it liked to infer types based on the datatype name. For example, in sqlx, SQLite datatype BOOLEAN can automatically map to Rust type bool <https://github.com/transact-rs/sqlx/blob/75bc0487eb661da811b...>. Without that, you have to resort to a variety of less-pleasant techniques, such as selecting `done as "done: bool"` or overriding things in sqlx.toml.
I really, really wish they’d implement some form of CREATE TYPE and let that work with strict tables. If I could `CREATE TYPE BOOLEAN FROM INTEGER` and such, I’d be all in on strict tables.
-
Price: Free (open source) URL: github.com/nextjs/saas-starter
-
-
I primarily use psql for quick queries, but pgcli is definitely what I'd reach for when I want a richer terminal experience. The autocompletion and syntax highlighting save time. That said, pgxcli's zero-dependency approach is compelling — if you're in environments where Python setup is friction (containers, minimal systems), it's worth trying. The startup speed difference is noticeable too. Ultimately, both are solid; it comes down to whether you prefer Python's maturity or Go's simplicity.
-
Finally a Lambda function, security group and role which can connect to the RDS Proxy using IAM authentication. Now we can just use pg with the rds-signer package to work with Postgres the way you are used to!
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
Postgres discussion
Postgres related posts
-
Supabase basics with Node.js
-
We Built an Open-Source GraphQL Engine to Replace Hasura
-
Show HN: Constellation is an open-source Hasura-compatible GraphQL engine in Go
-
Show HN: Streambed – Stream Postgres to Iceberg on S3, Supports Postgres Wire
-
How to Auto-Provision API Keys for Your Users on Sign Up with Supabase and Zuplo
-
Can a Marketer Vibe-Code a Working App? 6 Lessons From My First Build
-
PostgreSQL backup tool Databasus released backup verification in real database Docker containers
-
A note from our sponsor - SaaSHub
www.saashub.com | 7 Jun 2026
Index
What are some of the best open-source Postgre projects? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | supabase | 103,630 |
| 2 | Grafana | 74,122 |
| 3 | coolify | 56,519 |
| 4 | Metabase | 47,581 |
| 5 | Prisma | 46,065 |
| 6 | payload | 42,781 |
| 7 | drizzle-orm | 34,694 |
| 8 | Hasura | 32,003 |
| 9 | infisical | 27,211 |
| 10 | postgrest | 27,201 |
| 11 | supermemory | 25,415 |
| 12 | RxDB | 23,216 |
| 13 | TimescaleDB | 22,824 |
| 14 | neon | 22,121 |
| 15 | parse-server | 21,395 |
| 16 | teable | 21,297 |
| 17 | Gravitational Teleport | 20,463 |
| 18 | migrate | 18,568 |
| 19 | sqlx | 17,091 |
| 20 | saas-starter | 15,862 |
| 21 | pglite | 15,353 |
| 22 | pgcli | 13,200 |
| 23 | PostgreSQL | 13,149 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com