Dev tools · alternatives · 2026
24 alternatives to PgJQ: Use Jq in Postgres
jq extension for Postgres. Contribute to Florents-Tselai/pgJQ development by creating an account on GitHub.
PgJQ is a PostgreSQL extension that integrates the jq JSON query language into Postgres databases. It allows developers to process and manipulate JSON data using jq's syntax directly within SQL queries. The tool is… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. PgJQ: Use Jq in Postgres launched in 2024; newer entries below may have overtaken it.
- 1
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 →
- 2
Easy JSON Query Processor with a Lispy syntax in Go - cube2222/jql
2020 · github.com · its alternatives →
- 3
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 →
- 4
Hi HN. I've gotten pretty tired of needing to learn a custom programming language for a tool I use once a week or less. So I figured, it might be easier to pick up if `jq` used a programming language I already know. Voila, gq.
2022 · github.com · its alternatives →
- 5
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 →
- 6
Interactive JSON filter using jq. Contribute to ynqa/jnv development by creating an account on GitHub.
2024 · github.com · its alternatives →
- 7
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 →
- 8
JSON Query▲154I'm working on a tool that will probably involve querying JSON documents and I'm asking myself how to expose that functionality to my users. I like the power of `jq` and the fact that LLMs are proficient at it, but I find it right out impossible to come up with the right `jq` incantations myself. Has anyone here been in a similar situation? Which tool / language did you end up exposing to your users?
Oct 2025 · jsonquerylang.org · 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 →
- 10PE
2018 · bluejekyll.github.io · its alternatives →
- 11
GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.
2015 · github.com · its alternatives →
- 12
Non-interactive PostgreSQL query tool. Contribute to soheilpro/pgcmd development by creating an account on GitHub.
2019 · github.com · its alternatives →
- 13
Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.
2024 · github.com · its alternatives →
- 14
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 →
- 15
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 →
- 16
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare - porsager/postgres
2022 · github.com · its alternatives →
- 17
simplest possible native GUI for inspecting JSON objects with jq - fiatjaf/jqview
2020 · github.com · its alternatives →
- 18
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 →
- 19
Hey HN! Jaiqu is an AI agent for creating repeatable JSON transforms using jq query language syntax. Jaiqu translates complex JSON structures into repeatable jq queries. jq is a command line utility built for fast, reliable JSON queries. Jaiqu takes advantage of the LLMs for both constructing jq queries as well as using feedback to fix errors/invalid results if those queries are incorrect. Writing code to parse JSON is super annoying. It usually involves manually reading huge JSON balls, parsing the keys in a language of your choice, and pulling the data manually. Also, you're likely to…
2024 · github.com · its alternatives →
- 20PJ
PLJS is a new, modern JavaScript trusted language extension, bundling QuickJS, a small and fast JavaScript runtime with Postgres, providing fast type conversion between Postgres and JavaScript, fast execution, and a very light footprint. Here are bencharks that show how it compares to PLV8: https://github.com/plv8/pljs/blob/main/docs/BENCHMARKS.md This is the first step toward a truly light-weight, fast, and extensible JavaScript runtime embedded inside of Postgres. The initial roadmap has been published at…
2025 · its alternatives →
- 21
Firebase2GraphQL▲106Migrate from Firebase to GraphQL on Postgres
2018 · firebase2graphql.com · its alternatives →
- 22
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/firebase2graphql at master · hasura/graphql-engine
2018 · github.com · its alternatives →
- 23
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 →
- 24
Interactive jq tutorial: learn to filter and wrangle JSON files using a command-line interface in your browser.
2021 · sandbox.bio · its alternatives →
Also compare
- Pg_jsonschema – A Postgres extension for JSON validation alternatives
- jql – Easier jq Alternative with a Lispy Syntax Written in Go alternatives
- PRQL in PostgreSQL alternatives
- gq – like jq or zq, but you use Go alternatives
- Json2graphql – From a JSON file to Postgres-backed realtime GraphQL alternatives
- jnv: interactive JSON filter using jq 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 →