Dev tools · alternatives · 2026

24 alternatives to Parse your Postgres queries into a fully-typed AST in TypeScript

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…

pg-nano/pg-parser converts PostgreSQL queries into a fully-typed Abstract Syntax Tree (AST) for TypeScript developers. It's designed for teams building tools that need to statically analyze Postgres schemas across… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Parse your Postgres queries into a fully-typed AST in TypeScript launched in 2024; newer entries below may have overtaken it.

1
Pg-typesafe – Strongly typed queries for PostgreSQL and TypeScript▲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,…
Feb 2026 · github.com · its alternatives →
2
PgTyped – Typesafe SQL in TypeScript and Postgres▲269
pgTyped - Typesafe SQL in TypeScript. Contribute to adelsz/pgtyped development by creating an account on GitHub.
2020 · github.com · its alternatives →
3
PGlite – in-browser WASM Postgres with pgvector and live sync▲509
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 →
4
GraphQL for Postgres▲195
GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.
2015 · github.com · its alternatives →
5
A SQL database implemented purely in TypeScript type annotations▲426
A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql
2020 · github.com · its alternatives →
6
Pg_replicate – Build Postgres replication applications in Rust▲216
A high-performance Postgres replication engine written in Rust. Embed it in your Rust application or run it as a standalone binary. - supabase/etl
2024 · github.com · its alternatives →
7
Hasura – Fast, instant GraphQL APIs on Postgres▲382
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 →
8
Postgres.js – Fastest Full-Featured PostgreSQL Client for Node and Deno▲257
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare - porsager/postgres
2022 · github.com · its alternatives →
9
PRQL in PostgreSQL▲267
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 →
10
TypeScript to GraphQL conversion tool with type inference▲90
Build Typed GraphQL Queries in TypeScript without the code generation - acro5piano/typed-graphqlify
2018 · github.com · its alternatives →
11
I open-sourced the in-memory PostgreSQL I built at work for E2E tests▲379
In-memory Postgres for unit/E2E tests. Contribute to hexclave/pgmock development by creating an account on GitHub.
2024 · github.com · its alternatives →
12
Postgres as a VectorDB GUI▲162
Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.
2024 · github.com · its alternatives →
13
pg_flame – flamegraph visualizations of PostgreSQL query plans▲321
A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
2019 · github.com · its alternatives →
14
Cloud-Ready Postgres MCP Server▲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…
2025 · github.com · its alternatives →
15
Node.js ORM to query SQL database through an array-like API▲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.
2024 · github.com · its alternatives →
16
Pg_jsonschema – A Postgres extension for JSON validation▲203
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 →
17
BemiDB – Postgres read replica optimized for analytics▲209
Hi HN! We're Evgeny and Arjun, and we’re building a better way to do analytics with Postgres. We love Postgres for its simplicity, power, and rich ecosystem. But engineers have to still get bogged down with heavyweight and expensive OLAP systems when connecting an analytics data stack. Postgres is amazing at OLTP queries, but not for OLAP queries (large data scans and aggregations). Even in this case, we’ve still heard from countless scaling startups that they still try to use only a read replica to run analytics workloads since they don’t want to deal with the data engineering complexity of…
2024 · github.com · its alternatives →
18
Dbdot – Golang tool to help generate Postgres schema diagrams▲119
Generate DOT description for postgres db schema. Contribute to akarki15/dbdot development by creating an account on GitHub.
2019 · github.com · its alternatives →
19
Typed Postgres CRUD Queries▲29
Contribute to yasserf/postgres-typed development by creating an account on GitHub.
2021 · github.com · its alternatives →
20
Prostgles▲62
Isomorphic TypeScript client for PostgreSQL with replication
2020 · prostgles.com · its alternatives →
21PS
Peerdb Streams – Simple, native Postgres change data capture▲177
Hello HN, I am Sai Srirampur, one of the Co-founders of PeerDB. (https://github.com/PeerDB-io/peerdb). We spent the past 7 months building a solid experience to replicate data from Postgres to data warehouses. Now we're expanding to queues. PeerDB Streams provides a simple and native way to replicate changes as they happen in Postgres to Queues (Kafka, Redpanda, Google PubSub, etc). We use Postgres logical decoding to enable Change Data Capture (CDC). Blog post here: https://blog.peerdb.io/peerdb-streams-simple-native-postgres.... 10-min quickstart here:…
2024 · its alternatives →
22
pgMagic – a Mac Postgres client that lets you query in natural language▲49
Hi HN. This is a project I've been building for the last month. It's a macOS postgres client that uses your OpenAI key to generate and immediately execute queries against your database locally on your machine. I imagine the user being someone familiar with SQL and able to identify errors in the generated code, but regularly needs to write queries to answer relatively simple questions. This is my first software project I'm intending on selling myself and would love feedback on the product and landing page. I'd also love ideas on how to market it to users, as I'm very new to this. In the near…
2023 · pgmagic.app · its alternatives →
23
PeerDB▲110
Fast, native ETL for Postgres
2023 · peerdb.io · its alternatives →
24
PgJQ: Use Jq in Postgres▲39
jq extension for Postgres. Contribute to Florents-Tselai/pgJQ development by creating an account on GitHub.
2024 · 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 →