Back to browse
GitHub Repository

A Postgres extension that audits your database and harshly judges everything it finds.

39 starsPLpgSQL

pg_roast – A Postgres extension that harshly judges your database

by samirketema·Apr 21, 2026·2 points·1 comment

AI Analysis

●●SolidNiche GemCozy

pganalyze for schema mistakes, not performance — runs as CREATE EXTENSION with zero external deps.

Strengths
  • Lives entirely inside Postgres — no agents, no accounts, no data leaving your server
  • Covers schema anti-patterns, security misconfigs, and operational health in one tool
  • Personality-driven feedback makes dry audit results actually memorable and actionable
Weaknesses
  • Requires shared_preload_libraries and Postgres restart — higher friction than query-only tools
  • Database auditing is a known category with established players like pganalyze
Target Audience

PostgreSQL developers and DBAs who want automated schema auditing

Similar To

pganalyze · pgMustard · HypoPG

Similar Projects