Dev tools · alternatives · 2026
24 alternatives to pgcmd – An alternative to psql with JSON output
Non-interactive PostgreSQL query tool. Contribute to soheilpro/pgcmd development by creating an account on GitHub.
pgcmd is a command-line tool for PostgreSQL databases that serves as an alternative to psql. It provides JSON output formatting, making it useful for developers who need to programmatically process database query… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. pgcmd – An alternative to psql with JSON output launched in 2019; newer entries below may have overtaken it.
- 1
Happy Cyber Monday!
2014 · psequel.com · its alternatives →
- 2
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 →
- 3
A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
2019 · github.com · its alternatives →
- 4
Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.
2024 · github.com · its alternatives →
- 5AU
pgMustard is a Postgres EXPLAIN visualisation tool that also gives performance advice, scored based on its potential to speed up your query.
2019 · pgmustard.com · its alternatives →
- 6
GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.
2015 · github.com · its alternatives →
- 7
Easy JSON Query Processor with a Lispy syntax in Go - cube2222/jql
2020 · github.com · its alternatives →
- 8
Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.
2017 · github.com · its alternatives →
- 9
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
pgTyped - Typesafe SQL in TypeScript. Contribute to adelsz/pgtyped development by creating an account on GitHub.
2020 · github.com · its alternatives →
- 11
Powerful PostgreSQL tool is now open source for self-hosting
2021 · supabase.com · its alternatives →
- 12
jq extension for Postgres. Contribute to Florents-Tselai/pgJQ development by creating an account on GitHub.
2024 · github.com · its alternatives →
- 13
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 →
- 14
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 →
- 15PA
2015 · pgcli.com · its alternatives →
- 16
- 17
An MCP server to query any Postgres database in natural language. - subnetmarco/pgmcp
2025 · github.com · its alternatives →
- 18
PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat
2022 · github.com · its alternatives →
- 19
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 →
- 20
Generate DOT description for postgres db schema. Contribute to akarki15/dbdot development by creating an account on GitHub.
2019 · github.com · its alternatives →
- 21
A Go SQL query builder and struct mapper. Contribute to samonzeweb/godb development by creating an account on GitHub.
2016 · github.com · its alternatives →
- 22
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 →
- 23
Import CSV to PostgreSQL, generate a mock API, and 20+ more
2021 · retool.com · its alternatives →
- 24
Hands-on tutorials to learn Postgres
2022 · crunchydata.com · its alternatives →
Also compare
- PSequel – a free PostgreSQL GUI Tool for Mac OS X alternatives
- PgQueuer – Transform PostgreSQL into a Job Queue alternatives
- pg_flame – flamegraph visualizations of PostgreSQL query plans alternatives
- Postgres as a VectorDB GUI alternatives
- A user interface for Postgres EXPLAIN that also gives tips alternatives
- GraphQL for 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 →