nowfound

Dev tools · August 27, 2021

Typed Postgres CRUD Queries

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

Typed Postgres CRUD Queries launched on August 27, 2021 with 29 votes, #1,133 of 2,953 launches that month and more than 75% of that year's launches. The site was still online in September 2026, 5 years on.

In plain words

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, reducing runtime errors when working with Postgres databases. The tool is designed for developers who want to ensure their database interactions match their application's type system, making code more reliable and easier to maintain.

written from the facts on this page · September 2026

Does a similar job

all alternatives →
  • PgTyped – Typesafe SQL in TypeScript and Postgres2020 · github.com · ▲269

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

  • Pg-typesafe – Strongly typed queries for PostgreSQL and TypeScriptFeb 2026 · github.com · ▲69

    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,…

  • GraphQL for Postgres2015 · github.com · ▲195

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

  • Open Source PostgreSQL Studio2021 · supabase.com · ▲407

    Powerful PostgreSQL tool is now open source for self-hosting

  • Parse your Postgres queries into a fully-typed AST in TypeScript2024 · github.com · ▲116

    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…

  • Cloud-Ready Postgres MCP Server2025 · github.com · ▲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…

More dev tools this month

the category →
  • /dev/null▲481

    a social network for devs

    Dev tools · 2d ago · dev-null.sh

  • open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

    Dev tools · 27d ago · github.com

  • Contribute to reladraw/reladraw development by creating an account on GitHub.

    Dev tools · 25d ago · github.com

  • OpenBot▲362

    Grok Bot alternative: free, local, open-source, multiplayer

    Dev tools · 22d ago · openbot.run

  • Talanoa▲341

    Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

    Dev tools · 20d ago · talanoa.email

  • CoreSpeed▲332

    One MCP for everything your agents need: apps, memory, tools

    Dev tools · 27d ago · corespeed.io

Source: Show HN post ↗

Launched alongside, August 2021

the whole month →
  • II

    Hey all My name is Sindre, and I am the CTO of Scrimba (YC S20). For the last 7 years, I have written all my web apps in a full-stack programming language called Imba. It compiles to JavaScript and its main goal is to make web developers more productive. I just launched a major overhaul of Imba, so I wanted to share it here on HN, in case anyone are interested in learning more about it. It is very opinionated, so some of you might not like it, but I would love to hear anyones feedback regardless. Constructive criticism appreciated! The backstory: Imba initially started in 2012 as an effort…

    Life & fun · 2021

  • WB

    Hello HN, Over the last year we've been building ente[1], a privacy-friendly, easy-to-use alternative to Google Photos. We've so far built Android[2][3], iOS[4], web[5] apps that encrypt your files and back them up in the background. You can access these across your devices, and share them with other ente users, end-to-end encrypted. You can also use our electron app[6] to maintain a local copy of your backed up files. We've built a fault-tolerant data replication layer that replicates your data to two different storage providers in the EU. We will be providing additional replicas as an…

    Life & fun · 2021

  • SigmaOS▲1,026

    The browser that makes YOU fast

    Work · 2021 · sigmaos.com

  • OpenAI's smartest and most intuitive to use model yet

    AI · 2021 · openai.com

  • Publication dedicated to bootstrapping founders

    Growth · 2021 · bootstrappers.com

  • Poet.so▲767

    Capture and share Twitter posts as beautiful images

    Growth · 2021 · poet.so