Dev tools · alternatives · 2026
24 alternatives to Pg-typesafe – Strongly typed queries for PostgreSQL and TypeScript
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,…
Pg-typesafe is a TypeScript library that provides automatic type safety for raw PostgreSQL queries without requiring manual type definitions. It works like the standard node-pg driver but automatically infers result… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes.
- 1
pgTyped - Typesafe SQL in TypeScript. Contribute to adelsz/pgtyped development by creating an account on GitHub.
2020 · github.com · its alternatives →
- 2
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 →
- 3
A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql
2020 · github.com · its alternatives →
- 4
pgTyped - Typesafe SQL in TypeScript. Contribute to adelsz/pgtyped development by creating an account on GitHub.
2019 · github.com · its alternatives →
- 5
Hey, Sam and the team from ElectricSQL here. PGlite is a WASM Postgres build packaged into a TypeScript/JavaScript client library, that enables you to run Postgres in the browser, Node.js and Bun, with no need to install any other dependencies. It's 3mb Gzipped, now has support for many Postgres extensions, including pgvector, and it has a reactive "live query" API. It's also fast, with CRUD style queries executing in under 0.3 ms, and larger, multi-row select queries occurring within a fraction of a single frame. PGlite started as an experimental project we shared on X, and the…
2024 · pglite.dev · its alternatives →
- 6
Contribute to yasserf/postgres-typed development by creating an account on GitHub.
2021 · github.com · its alternatives →
- 7
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 →
- 8KA
The most powerful type-safe SQL query builder for TypeScript
2023 · kysely.dev · its alternatives →
- 9
GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.
2015 · github.com · its alternatives →
- 10
PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!
2024 · github.com · its alternatives →
- 11
pg_jsonschema is a solution we're exploring to allow enforcing more structure on json and jsonb typed postgres columns. We initially wrote the extension as an excuse to play with pgx, the rust framework for writing postgres extensions. That let us lean on existing rust libs for validation (jsonschema), so the extension's implementation is only 10 lines of code :) https://github.com/supabase/pg_jsonschema/blob/fb7ab09bf6050... happy to answer any questions!
2022 · github.com · its alternatives →
- 12
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare - porsager/postgres
2022 · github.com · its alternatives →
- 13
Prostgles▲62Isomorphic TypeScript client for PostgreSQL with replication
2020 · prostgles.com · its alternatives →
- 14
Blazing fast, instant realtime GraphQL APIs on all your data with fine grained access control, also trigger webhooks on database events. - hasura/graphql-engine
2018 · github.com · its alternatives →
- 15
An extremely simple and explicit ORM for TypeScript - Seb-C/kiss-orm
2020 · github.com · its alternatives →
- 16
Build Typed GraphQL Queries in TypeScript without the code generation - acro5piano/typed-graphqlify
2018 · github.com · its alternatives →
- 17
Kretes is a programming environment for TypeScript applications built on top of Visual Studio Code. It combines a web framework with an editor into an integrated, battery-included solution.
2020 · kretes.dev · its alternatives →
- 18PE
2018 · bluejekyll.github.io · its alternatives →
- 19
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 →
- 20
JSON support in postgres is superb but sometimes you really want decimal, date, and binary types, "carefree" UTF8 string handling (i.e. no escaping), and robust roundtrippability. So I made an extension for BSON.
2024 · github.com · its alternatives →
- 21
Hi HN - Peter from DBOS here with my co-founder Qian (qianl_cs) Today we want to share our TypeScript library for lightweight durable execution. We’ve been working on it since last year and recently released v2.0 with a ton of new features and major API overhaul. https://github.com/dbos-inc/dbos-transact-ts Durable execution means persisting the execution state of your program while it runs, so if it is ever interrupted or crashes, it automatically resumes from where it left off. Durable execution is useful for a lot of things: - Orchestrating long-running or…
2025 · github.com · its alternatives →
- 22PS
PL/Swift allows you to write custom SQL functions and types for the PostgreSQL database server in the Swift programming language. Bringing Swift to the Backend of the Backend’s Backend!
2018 · alwaysrightinstitute.com · its alternatives →
- 23
- 24
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.
2024 · github.com · its alternatives →
Also compare
- PgTyped – Typesafe SQL in TypeScript and Postgres alternatives
- Parse your Postgres queries into a fully-typed AST in TypeScript alternatives
- A SQL database implemented purely in TypeScript type annotations alternatives
- PgTyped – Typesafe SQL – TypeScript types generator for raw SQL queries alternatives
- PGlite – in-browser WASM Postgres with pgvector and live sync alternatives
- Typed Postgres CRUD Queries alternatives
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 →