HN Showcase
Back to browse
GitHub Repository

Pure-SQL diagnostic functions for PostgreSQL - load via psql, no extensions required

1 starsPLpgSQL

pgtk - Pure SQL diagnostic functions for PostgreSQL

by mnafees·Feb 19, 2026·1 point·0 comments
Visit ProjectView on HN

AI Analysis

●●SolidSolve My ProblemNiche Gem

Zero-install Postgres diagnostics, but pg_stat_statements and pgAdmin already exist.

Strengths
  • •No C extensions, shared libs, or restarts—loads into any managed Postgres instance including RDS, Supabase, Neon.
  • •Well-curated diagnostic functions (bloat, idle transactions, duplicate indexes, cache hit) address real pain points.
  • •Pure SQL implementation is transparent and auditable, easy to fork or adapt per-org.
Weaknesses
  • •Feature set is narrow—lacks query performance profiling, explain plan analysis, or memory/CPU insights.
  • •Requires explicit schema permissions; doesn't differentiate privilege escalation from data access on managed services.
  • •Very early stage (4 commits, 0 stars); unclear roadmap or whether this will be maintained actively.
Target Audience

PostgreSQL DBAs and backend engineers managing production instances

Similar To

pg_stat_statements · pgAdmin · pg_ash

Similar Projects

Developer Tools●●●Banger

MegaHAL in Pure SQL

MegaHAL chatbot runs in pure SQL—no PL/pgSQL escape hatches, just CTEs and recursive queries.

WizardryBig BrainNiche Gem
tgies
113mo ago