PgTyped – Typesafe SQL in TypeScript and Postgres

In plain words

PgTyped is a developer tool that enables typesafe SQL queries in TypeScript applications using Postgres databases. It generates TypeScript types automatically from SQL statements, ensuring queries match their corresponding type definitions at compile time. The tool is designed for TypeScript developers who want to catch database-related errors before runtime. PgTyped integrates SQL directly into TypeScript code while maintaining type safety across database operations.

written from the facts on this page · September 2026

• 
  PgTyped – Typesafe SQL – TypeScript types generator for raw SQL queries2019 · github.com · ▲9

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

• 
  A SQL database implemented purely in TypeScript type annotations2020 · github.com · ▲426

  A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql

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

• KA
  Kysely, a type-safe SQL query builder for TypeScript2023 · kysely.dev · ▲90

  The most powerful type-safe SQL query builder for TypeScript

• 
  ORM for TypeScript with no query-builder, supporting full SQL queries2020 · github.com · ▲220

  An extremely simple and explicit ORM for TypeScript - Seb-C/kiss-orm

• 
  /dev/null▲487

  a social network for devs

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

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

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

  Dev tools · 28d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

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

  Dev tools · 26d ago · github.com

• 
  OpenBot▲362

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

  Dev tools · 23d ago · openbot.run

• 
  Talanoa▲346

  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 · 21d ago · talanoa.email

• 
  CoreSpeed▲332

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

  Dev tools · 28d ago · corespeed.io

• 
  Blush▲1,462

  Illustrations for everyone

  Dev tools · 2020 · blush.design

• 
  SHA-256 Animation▲1,053

  Animation of the SHA-256 hash function in your terminal. - in3rsha/sha256-animation

  Dev tools · 2020 · github.com

• 
  This Word Does Not Exist▲956

  This Word Does Not Exist uses an artificial intelligence model named GPT-2 to invent new English words.

  AI · 2020 · thisworddoesnotexist.com

• P3
  Plotting 3 years of hourly data in 150ms▲785

  Life & fun · 2020 · leeoniya.github.io

• 
  Untools▲783

  Hand-picked tools for better thinking

  Work · 2020 · untools.co

• 
  Copytesting▲781

  Improve your website copy based on data from your audience

  Growth · 2020 · wynter.com