{"data":[{"slug":"supabase","name":"Supabase","tagline":"Open-source Firebase alternative built on Postgres","category":"databases","url":"https://supabase.com","github":"https://github.com/supabase/supabase","pricing":"freemium","hook":"Supabase is Postgres with auth, realtime, and storage bolted on.","whatsGood":"Real Postgres underneath means you are not locked in. Auth, storage, edge functions, and realtime subscriptions in one platform. The dashboard is genuinely useful. Row-level security enables fine-grained access control.","theCatch":"The all-in-one convenience creates dependency. Complex queries hit performance limits. Self-hosting requires significant operational knowledge.","verdict":"The Firebase alternative for developers who want real Postgres.","addedAt":"2026-08-19","featured":true,"domain":"Databases","subSpecialty":"Data","subcategory":"Postgres","tags":["free-tier","permissive","auth","realtime","postgres","active"],"capabilities":["auth","realtime"],"surfaces":["Hosted"],"ecosystem":["Multi-platform"],"licenseModel":"Freemium","githubStars":111751,"starsPerWeek":305,"access":"free","archived":false,"repo":{"createdAt":"2019-10-12","pushedAt":"2026-10-19","license":"Apache-2.0","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/supabase","html":"/gems/supabase","markdown":"/gems/supabase.md"}},{"slug":"pglite","name":"PGlite","tagline":"Apache-2.0 Postgres compiled to WASM for browser, Node, Bun and Deno","category":"databases","url":"https://pglite.dev","github":"https://github.com/electric-sql/pglite","pricing":"open-source","hook":"PGlite is real Postgres compiled to WebAssembly and wrapped in a TypeScript client, so you can run a Postgres database in the browser, Node.js, Bun or Deno with one npm install and no server.","whatsGood":"Apache-2.0 (electric-sql/pglite), release @electric-sql/pglite 0.5.10 (2026-10-14). About 3 MB gzipped, no Linux VM underneath, runs in memory or persists to the file system (Node/Bun/Deno) or IndexedDB in the browser. Good for local-first apps, per-test throwaway databases in CI and agent sandboxes that need real SQL, and it pairs with Electric for sync. Postgres extensions such as pgvector are available as add-ons. ★~16.2k.","theCatch":"It is single user and single connection, so it is not a replacement for a Postgres server behind a multi-user backend. Performance and memory are bounded by the WASM runtime, and only the extensions the project has ported can be loaded. It is still 0.x, so expect API changes between minor versions.","verdict":"The easiest way to get real Postgres in tests, the browser or a local-first app — not your production server.","addedAt":"2026-10-18","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"Postgres","tags":["self-host","local-first","permissive","postgres","active"],"capabilities":["browser"],"surfaces":["Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"Apache-2.0","githubStars":16170,"starsPerWeek":116,"access":"free","archived":false,"repo":{"createdAt":"2024-02-19","pushedAt":"2026-10-14","license":"Apache-2.0","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/pglite","html":"/gems/pglite","markdown":"/gems/pglite.md"}},{"slug":"pgcli","name":"pgcli","tagline":"BSD-3-Clause Postgres CLI with smart autocompletion","category":"databases","url":"https://www.pgcli.com","github":"https://github.com/dbcli/pgcli","pricing":"open-source","hook":"pgcli is a drop-in replacement for psql with smart autocompletion of tables, columns and keywords, syntax highlighting and nicer output — the terminal Postgres client you actually enjoy using.","whatsGood":"BSD-3-Clause (dbcli/pgcli), release v4.7.1 (2026-09-20), maintained since 2014. Install with pip, apt or brew, then connect with the same arguments as psql. It is context-aware (suggests columns from the tables in your FROM clause), supports most backslash commands, named queries, pagers, multi-line editing and vi/emacs keys. Sibling project mycli does the same for MySQL. ★~13.4k.","theCatch":"It is a Python app, so startup is slower than psql and you need a Python environment. Some psql meta-commands and scripting behaviours differ, so keep psql for scripts. Huge schemas can make the completion refresh slow.","verdict":"Install it once and you will stop using bare psql for interactive work.","addedAt":"2026-10-18","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"Postgres","tags":["cli","self-host","permissive","postgres","active"],"capabilities":["cli"],"surfaces":["CLI","Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"BSD-3-Clause","githubStars":13419,"starsPerWeek":21,"access":"free","archived":false,"repo":{"createdAt":"2014-10-12","pushedAt":"2026-10-15","license":"BSD-3-Clause","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/pgcli","html":"/gems/pgcli","markdown":"/gems/pgcli.md"}},{"slug":"citus","name":"Citus","tagline":"AGPL-3.0 Postgres extension for distributed tables","category":"databases","url":"https://www.citusdata.com","github":"https://github.com/citusdata/citus","pricing":"open-source","hook":"Citus is a PostgreSQL extension that turns Postgres into a distributed database: shard tables across a cluster of nodes and run queries in parallel, while it stays Postgres to your app.","whatsGood":"AGPL-3.0 (citusdata/citus), release v14.2.0 (2026-08-06), developed since 2016 and now maintained by Microsoft. Distributed tables are sharded across nodes, reference tables are replicated everywhere for joins, the distributed query engine parallelises SELECT and DML, and columnar storage speeds scans. Strong fit for multi-tenant SaaS (shard by tenant), real-time analytics and time series. The project says Citus is 100% open source. ★~12.8k.","theCatch":"Sharding means choosing a distribution column well; a poor choice makes cross-shard queries slow. AGPL-3.0 matters if you modify Citus and offer it as a service. Not every managed Postgres lets you install it, so you often self-host or use Azure's managed version. Cluster ops are more involved than one Postgres box.","verdict":"The most Postgres-native way to scale out — pick your shard key carefully.","addedAt":"2026-10-18","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"Postgres","tags":["self-host","copyleft","postgres","active"],"capabilities":[],"surfaces":["Self-host","Hosted"],"ecosystem":["Multi-platform"],"licenseModel":"AGPL-3.0","githubStars":12818,"starsPerWeek":23,"access":"free","archived":false,"repo":{"createdAt":"2016-02-01","pushedAt":"2026-10-18","license":"AGPL-3.0","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/citus","html":"/gems/citus","markdown":"/gems/citus.md"}},{"slug":"usql","name":"usql","tagline":"MIT universal psql-style CLI for SQL and NoSQL databases","category":"databases","url":"https://github.com/xo/usql","github":"https://github.com/xo/usql","pricing":"open-source","hook":"usql is one command-line client for PostgreSQL, MySQL, Oracle, SQLite, SQL Server and many other SQL and NoSQL databases, modelled on psql with its variables, backticks and backslash commands.","whatsGood":"MIT (xo/usql), release v0.21.6 (2026-09-22), developed since 2017. A single Go binary with drivers for dozens of databases, context-based completion, copying data between different databases, and terminal graphics. Ideal for anyone who knows psql and has to touch other databases too. ★~10.1k.","theCatch":"Still 0.x. Some drivers are only included in certain build tags, so check your binary supports the database you need. Completion and meta-commands are not as deep as pgcli or the native clients.","verdict":"One CLI for every database — perfect for ops and scripting across engines.","addedAt":"2026-10-18","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"Postgres","tags":["cli","self-host","permissive","postgres","active"],"capabilities":["cli"],"surfaces":["CLI","Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"OSS/MIT","githubStars":10149,"starsPerWeek":20,"access":"free","archived":false,"repo":{"createdAt":"2017-03-02","pushedAt":"2026-10-13","license":"MIT","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/usql","html":"/gems/usql","markdown":"/gems/usql.md"}},{"slug":"parse-server","name":"Parse Server","tagline":"Apache-2.0 self-hosted backend on Node.js with MongoDB or Postgres","category":"databases","url":"https://parseplatform.org","github":"https://github.com/parse-community/parse-server","pricing":"open-source","hook":"Parse Server is the open-source backend that outlived Facebook's hosted Parse: data storage with a REST and GraphQL API, users and auth, files, push notifications, cloud functions and live queries, running on any Node.js host or mounted inside an existing Express app.","whatsGood":"Apache-2.0 (parse-community/parse-server), release 8.6.110 (2026-10-19). Works with MongoDB 7/8 or PostgreSQL 16–18 (with PostGIS), tested on Node.js 20, 22 and 24. Client SDKs cover JavaScript, iOS, Android, Flutter, .NET, PHP and more, and Parse Dashboard gives a data browser. Clear long-term-support policy for the previous major version, a Docker image, and a large, stable community after a decade of use. ★~21k.","theCatch":"It is a mature, opinionated object model rather than plain SQL, so it feels dated next to Supabase or PocketBase, and complex relational queries can fight the abstraction. You operate the database, scaling and backups yourself. Releases are frequent, so pin versions and read the changelog before major upgrades.","verdict":"A proven, fully self-hosted backend-as-a-service — best when you want the Parse SDKs and model.","addedAt":"2026-10-19","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"Postgres","tags":["api","self-host","permissive","auth","postgres","active"],"capabilities":["api","auth"],"surfaces":["API","Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"Apache-2.0","githubStars":21398,"starsPerWeek":38,"access":"free","archived":false,"repo":{"createdAt":"2016-01-28","pushedAt":"2026-10-19","license":"Apache-2.0","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/parse-server","html":"/gems/parse-server","markdown":"/gems/parse-server.md"}},{"slug":"timescale","name":"Timescale","tagline":"Time-series superpowers for Postgres","category":"databases","url":"https://timescale.com","github":"https://github.com/timescale/timescaledb","pricing":"freemium","hook":"Timescale is Postgres that handles time-series at scale.","whatsGood":"Full Postgres compatibility means your existing tools work. Automatic partitioning handles time-series data at scale. Continuous aggregates precompute expensive queries. The managed platform handles operations.","theCatch":"License first: TimescaleDB is split — the core is Apache-2.0, but features in the tsl directory (compression, continuous aggregates and more) are under the Timescale License (TSL), which is source-available and bars offering TimescaleDB as a database service. Adds complexity to Postgres operations. Some hypertable features have limitations. The learning curve for optimal performance is real.","verdict":"Time-series data without leaving Postgres.","addedAt":"2026-08-19","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"Postgres","tags":["free-tier","postgres","active"],"capabilities":[],"surfaces":["Hosted"],"ecosystem":["Multi-platform"],"licenseModel":"Open-Core","githubStars":23717,"starsPerWeek":47,"access":"free-tier","archived":false,"repo":{"createdAt":"2017-03-07","pushedAt":"2026-10-18","license":"NOASSERTION","archived":false,"checkedAt":"2026-10-19"},"links":{"self":"/api/gems/timescale","html":"/gems/timescale","markdown":"/gems/timescale.md"}}],"meta":{"total":7,"count":7,"offset":0,"limit":null,"sort":"curated","sorts":["curated","catalog","new","stars","trending","name"],"filters":{"subcategory":"postgres"},"next":null,"categories":["agents","nextjs","python","shopify","databases","devops","design","observability","rust","payments","comms","notifications","libraries"],"tags":["mcp","cli","tui","api","sdk","desktop-app","web-ui","editor-plugin","self-host","local-first","free-tier","paid-only","paid-led","permissive","copyleft","source-available","license-unclear","coding-agents","local-llm","rag","memory","evals","browser-automation","scraping","sandbox","skills","voice","security","auth","payments","realtime","postgres","vector","kubernetes","containers","observability","testing","workflows","graphics-3d","git","active","stale","archived","young-repo","fast-stars"]}}