PostgreSQL Hotspots
Postgres on fire? Start here
What it does
A diagnostic cli tool built for high-pressure “database down” situations... All Metrics have been mapped into a diagnosis-ready format for rapid trouble-shooting. Besides, all reports are written into an interactive html file + txt file so the result can be shared and used with customers easily. As it is built on top of Google Cloud Monitoring, it doesn't cause overhead and It cannot modify database configuration, execute SQL, drop tables, or change your GCP infrastructure. All compute locally.
Does a similar job
all alternatives →- IOI open-sourced the in-memory PostgreSQL I built at work for E2E tests2024 · github.com · ▲379
- PSPgDog – Scale Postgres without changing the appFeb 2026 · github.com · ▲326
Hey HN! Lev and Justin here, authors of PgDog (https://pgdog.dev/), a connection pooler, load balancer and database sharder for PostgreSQL. If you build apps with a lot of traffic, you know the first thing to break is the database. We are solving this with a network proxy that works without requiring application code changes or database migrations. Our post from last year: https://news.ycombinator.com/item?id=44099187 The most important update: we are in production. Sharding is used a lot, with direct-to-shard queries (one shard per query) working pretty much…
- PNpg_netstat, a Postgres extension to monitor database network traffic2022 · github.com · ▲158
pg_netstat is a Postgres extension to monitor database network traffic. It uses libpcap to capture packets and aggregates at user-specified interval.
- SDSafe Data Changes in PostgreSQL2023 · github.com · ▲47
Hi HN, we're excited to share our open source tool with the community! We previously posted here with the tagline “real-time events for Postgres” [0]. But after feedback from early users and the community, we’ve shifted our focus to working on tooling for manual database changes. We've consistently heard teams describe challenges with the way manual data updates are handled. Seemingly every engineer we spoke with had examples of errant queries that ended up causing significant harm in production environments (data loss/service interruptions). We’ve seen a few different approaches to how…
- CRCloud-Ready Postgres MCP Server2025 · github.com · ▲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…
- IBI built this Postgres logger2023 · rocketgraph.io · ▲94
Hey HN, Some of you were really interested in Postgres logging with pgAudit in my previous post here: https://news.ycombinator.com/item?id=37082827 So I built this logger: https://rocketgraph.io/logger-demo using pgAudit to show you what can be done with Postgres auditing. It offers some powerful features like "get me all the CREATE queries that ran in the past hour". These are generated by AWS RDS Instance running on my Rocketgraph account. Then they are forwarded to Cloudwatch for complex querying. In the future we can connect these logs to slack so you can…
More dev tools this month
the category →
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 3d ago · opentrailpaper.com
Lettertrace▲375Track your AI visibility for free (using your own API keys!)
Dev tools · 26d ago · lettertrace.com
