Dev tools · alternatives · 2026
24 alternatives to Pg_jsonschema – A Postgres extension for JSON validation
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!
pg_jsonschema is a PostgreSQL extension that validates JSON and JSONB data against defined schemas. Built using pgx, a Rust framework for PostgreSQL extensions, it leverages existing Rust validation libraries to… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Pg_jsonschema – A Postgres extension for JSON validation launched in 2022; newer entries below may have overtaken it.
- 1PE
2018 · bluejekyll.github.io · its alternatives →
- 2TA
TypeSchema is a JSON specification to describe data models in a programming language neutral format.
2024 · typeschema.org · its alternatives →
- 3
Compile JSON Schema to TypeScript type declarations - bcherny/json-schema-to-typescript
2017 · github.com · its alternatives →
- 4
jq extension for Postgres. Contribute to Florents-Tselai/pgJQ development by creating an account on GitHub.
2024 · github.com · its alternatives →
- 5
verify-json. Contribute to yusufnb/verify-json development by creating an account on GitHub.
2020 · github.com · its alternatives →
- 6BA
2016 · bedquiltdb.github.io · its alternatives →
- 7
Blazing fast, instant realtime GraphQL APIs on all your data with fine grained access control, also trigger webhooks on database events. - graphql-engine/community/tools/json2graphql at master · hasura/graphql-engine
2019 · github.com · its alternatives →
- 8
2018 · npoint.io · its alternatives →
- 9
Import CSV and JSON into PostgreSQL the easy way. Contribute to lukasmartinelli/pgfutter development by creating an account on GitHub.
2015 · github.com · its alternatives →
- 10
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 →
- 11
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 →
- 12
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 →
- 13
- 14
After two years of improvement, I think it's time to share it with you all. Here’s a quick overview: - Common features include validation, formatting, minification, and more. - Visualize JSON in a graph or table view. - Structured comparison with fallback to text comparison. - Navigate though JSON using JSON pointer. - Supports jq. Would love to hear the community's questions, thoughts and comments!
2024 · github.com · its alternatives →
- 15
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 →
- 16
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 →
- 17
SQL micro-dialect implementation for querying JSON objects. Written purely in Scala. - mmalek06/JsonSql
2020 · github.com · its alternatives →
- 18
pg_netstat is a Postgres extension to monitor database network traffic. It uses libpcap to capture packets and aggregates at user-specified interval.
2022 · github.com · its alternatives →
- 19
Generate DOT description for postgres db schema. Contribute to akarki15/dbdot development by creating an account on GitHub.
2019 · github.com · its alternatives →
- 20
Non-interactive PostgreSQL query tool. Contribute to soheilpro/pgcmd development by creating an account on GitHub.
2019 · github.com · its alternatives →
- 21
Enforced, Annotated Schema for Ruby Sequel Models. Contribute to karthikv/model_schema development by creating an account on GitHub.
2015 · github.com · its alternatives →
- 22
Generate, validate, and parse React forms using Mongoose-inspired JSON schemas - SteveVitali/react-form-generator
2015 · github.com · its alternatives →
- 23
Fast time-series extension for PostgreSQL. Contribute to xataio/deltax development by creating an account on GitHub.
May 2026 · github.com · its alternatives →
- 24
Hello HN! Keeping Elasticsearch or Algolia in sync with Postgres is a pain when your data spans multiple tables. Traditional CDC tools like Debezium capture table-level events but don’t help when you need to index a full entity composed of related records. That's why I built PG-Capture. PG-Capture lets you define a schema as complex as you need, aggregate table-level events, and reconstruct structured objects spanning multiple tables. It then publishes them as meaningful domain-level events to any queue (RabbitMQ, SQS, etc.). PG-Capture does NOT replace Debezium, it works on top of it (or…
2025 · pg-capture.onrender.com · its alternatives →
Also compare
- Pg-extend-rs – Easy Postgres extensions in Rust alternatives
- TypeSchema – A JSON specification to describe data models alternatives
- JSONSchema to TypeScript compiler alternatives
- PgJQ: Use Jq in Postgres alternatives
- Verify JSON using minimal schema alternatives
- BedquiltDB – A Mongo-like JSON doc store built on Postgres 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 →