TypeSafe SQL-Like ORM and Query Builders for TypeScript/JS

What it does

No need to learn a new query language, litdb lets you write familiar SQL you know using its type-safe expressions and query builders that's safe by default . APIs are designed to keep a close affinity to SQL making it clear what SQL is being generated, expressions utilize tagged templates to take away the tedium of maintaining table and column references, parameterizing values and catering for different SQL dialects to retain the expressive freedom of SQL, but portable across multiple RDBMS's. The primary difference between SQL is how queries are constructed, where the SELECT Query Builder directs queries to be constructed in the order they're run , by specifying the data sources first,…from litdb.dev

• 
  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

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

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

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

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

  The most powerful type-safe SQL query builder for TypeScript

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

• 
  Node.js ORM to query SQL database through an array-like API2024 · github.com · ▲123

  Hello everyone! I'm exited to share a NodeJS package I was working on for the past two months. The package is designed to simplify querying SQL databases through an array-like API. Qustar supports PostgreSQL, SQLite, MySQL, and MariaDB, and offers TypeScript support for a robust development experience. It's in early stage of development. I would like to hear your thoughts about it.

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

• 
  Lovable▲1,477

  Hey HN! Previous CERN physicist turned hacker here. We've developed a way to make AI coding actually work by systematically identifying and fixing places where LLMs typically fail in full-stack development. Today we're launching as Lovable (previously gptengineer.app) since it's such a big change. The problem? AI writing code typically make small mistakes and then get stuck. Those who tried know the frustration. We fixed most of this by mapping out where LLMs fail in full-stack dev and engineering around those pitfalls with prompt chains. Thanks to this, in all comparisons I found with: v0,…

  AI · 2024 · lovable.dev

• 
  Superchat▲1,427

  AI Agents for WhatsApp Business, Instagram & Co

  Growth · 2024 · superchat.com

• 
  Postiz▲1,188

  Streamline your social media with Postiz. Schedule posts, analyze performance, and manage all accounts in one place.

  Dev tools · 2024 · postiz.com

• 
  I built a(nother) house optimized for LAN parties▲1,117

  I wasn't quite sure if this qualified as "Show HN" given you can't really download it and try it out. However, dang said[0]: > If it's hardware or something that's not so easy to try out over the internet, find a different way to show how it actually works—a video, for example, or a detailed post with photos. Hopefully I did that? Additionally, I've put code and a detailed guide for the netboot computer management setup on GitHub: https://github.com/kentonv/lanparty Anyway, if this shouldn't have been Show HN, I apologize! [0]…

  Dev tools · 2024 · lanparty.house

• 
  Raycast Notes▲1,058

  Unlock a new level productivity with AI, Cloud Sync and more

  Work · 2024 · raycast.com

• 
  Cap▲1,047

  Beautiful screen recordings, owned by you. 100% open source.

  Dev tools · 2024 · cap.so