PgJQ: Use Jq in Postgres

In plain words

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 designed for database users who need advanced JSON filtering, transformation, and extraction capabilities without leaving their Postgres environment. It stands out by bringing a specialized JSON processing tool into the database layer, enabling more complex data operations natively.

written from the facts on this page · September 2026

• 
  Pg_jsonschema – A Postgres extension for JSON validation2022 · github.com · ▲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!

• 
  jql – Easier jq Alternative with a Lispy Syntax Written in Go2020 · github.com · ▲217

  Easy JSON Query Processor with a Lispy syntax in Go - cube2222/jql

• 
  PRQL in PostgreSQL2024 · github.com · ▲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.

• 
  gq – like jq or zq, but you use Go2022 · github.com · ▲107

  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.

• 
  Json2graphql – From a JSON file to Postgres-backed realtime GraphQL2019 · github.com · ▲120

  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

• 
  jnv: interactive JSON filter using jq2024 · github.com · ▲373

  Interactive JSON filter using jq. Contribute to ynqa/jnv development by creating an account on GitHub.

• 
  /dev/null▲486

  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

• 
  Dub.co▲1,475

  Short links with superpowers

  Dev tools · 2024 · dub.co

• 
  3 years and 1M users later, I just open-sourced my "Internet OS"▲1,274

  🌐 The Internet Computer! Free, Open-Source, and Self-Hostable. - HeyPuter/puter

  Dev tools · 2024 · github.com

• 
  Microlaunch▲1,115

  Launch and get feedback on both the idea and product

  Dev tools · 2024 · microlaunch.net

• 
  Milestone▲1,113

  Interactive, gamified product tours for SaaS

  Growth · 2024 · milestoneflow.io

• 
  Hunted Space▲1,004

  Insights on Product Hunt launches

  Growth · 2024 · hunted.space

• 
  Creatie▲850

  The one-stop product design tool amplified by AI

  AI · 2024 · creatie.ai