nowfound

Dev tools · alternatives · 2026

24 alternatives to Typed Postgres CRUD Queries

Contribute to yasserf/postgres-typed development by creating an account on GitHub.

Typed Postgres CRUD Queries is a GitHub-based project that generates type-safe database operations for PostgreSQL. It helps developers create Create, Read, Update, and Delete queries with built-in type checking… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Typed Postgres CRUD Queries launched in 2021; newer entries below may have overtaken it.

  1. 1

    pgTyped - Typesafe SQL in TypeScript. Contribute to adelsz/pgtyped development by creating an account on GitHub.

    2020 · github.com · its alternatives →

  2. 2

    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 →

  3. 3

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

    2015 · github.com · its alternatives →

  4. 4

    Powerful PostgreSQL tool is now open source for self-hosting

    2021 · supabase.com · its alternatives →

  5. 5

    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 →

  6. 6

    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 →

  7. 7

    Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.

    2017 · github.com · its alternatives →

  8. 8

    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 →

  9. 9

    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 →

  10. 10

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

    2024 · github.com · its alternatives →

  11. 11

    Branch your PostgreSQL Database like Git. Contribute to sastraxi/pgsh development by creating an account on GitHub.

    2019 · github.com · its alternatives →

  12. 12

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

    2024 · github.com · its alternatives →

  13. 13

    A Go SQL query builder and struct mapper. Contribute to samonzeweb/godb development by creating an account on GitHub.

    2016 · github.com · its alternatives →

  14. 14

    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 →

  15. 15

    Free private sample PostgreSQL databases

    2021 · uibakery.io · its alternatives →

  16. 16

    Generate DOT description for postgres db schema. Contribute to akarki15/dbdot development by creating an account on GitHub.

    2019 · github.com · its alternatives →

  17. 17

    Build Typed GraphQL Queries in TypeScript without the code generation - acro5piano/typed-graphqlify

    2018 · github.com · its alternatives →

  18. 18
    bit.io▲130

    All your data in one place

    2021 · its alternatives →

  19. 19

    Isomorphic TypeScript client for PostgreSQL with replication

    2020 · prostgles.com · its alternatives →

  20. 20

    Non-interactive PostgreSQL query tool. Contribute to soheilpro/pgcmd development by creating an account on GitHub.

    2019 · github.com · its alternatives →

  21. 21
    SafeQL▲69

    Write SQL queries with confidence

    2022 · its alternatives →

  22. 22

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

    2016 · github.com · its alternatives →

  23. 23KA

    The most powerful type-safe SQL query builder for TypeScript

    2023 · kysely.dev · its alternatives →

  24. 24

    Hi HN, we're excited to share our open source tool with the community! We previously posted here with the tagline “real-time events for Postgres” [0]. But after feedback from early users and the community, we’ve shifted our focus to working on tooling for manual database changes. We've consistently heard teams describe challenges with the way manual data updates are handled. Seemingly every engineer we spoke with had examples of errant queries that ended up causing significant harm in production environments (data loss/service interruptions). We’ve seen a few different approaches to how…

    2023 · github.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 →