samirketema

samirketema / pg_roast

Public

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

github.comsamirketemapg_roastblobmainREADME.md database extension management postgres postgresql
11
2
100% credibility
Found Apr 22, 2026 at 11 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
PLpgSQL
AI Summary

A database auditor that inspects your data setup for mistakes, security gaps, and inefficiencies, delivering opinionated feedback in a humorous style.

How It Works

1
🔍 Discover pg_roast

You hear about this fun database checker that roasts your setup with honest feedback to make it better.

2
📥 Get it ready

Download the checker and prepare it on your computer so it's all set to join your database.

3
⚙️ Add to your database home

Place the checker into your database's main setup area and restart your database to wake it up.

4
📝 Pick your database

Tell the checker which of your databases to watch and how often to check it.

5
🚀 Launch the first check

Run a quick check and watch it scan your database for issues big and small.

6
📋 Read the roasts

Get a list of sharp, funny critiques highlighting problems like loose security or sloppy design.

✅ Database gets healthier

Fix what needs fixing or ignore the rest, and set it to check automatically so issues never sneak up again.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 11 to 11 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is pg_roast?

pg_roast is a PostgreSQL extension in PLpgSQL and C that audits your database schema, queries, security, and ops settings, roasting anti-patterns with brutal one-liners like "68% nullable columns—what does a valid row even look like?" It catches issues like missing PKs, float prices, superuser app logins, and fsync=off before they explode. Fire it up post-install with `SELECT * FROM roast.run();` for instant critiques via views like `roast.latest` and `roast.summary`; a background worker handles periodic scans.

Why is it gaining traction?

No external agents or accounts like pganalyze—just `CREATE EXTENSION` inside Postgres, joining staples like pg_trgm, uuid-ossp, or vector in your postgres extensions list. The hook? Savage, shareable roasts that shame bad habits (varchar(255)? "Thinking of MySQL?") without fluff, perfect for pg roasts in Slack or pig roast jokes at standup. Self-contained audits beat github postgres exporter tools or operators needing extra infra.

Who should use this?

Backend devs cleaning MySQL-migrated schemas spotting offset pagination or EAV traps. DBAs reviewing prod configs for public schema grants or sequence exhaustion in PG 13 roasts. Teams using postgres extension manager or VSCode Postgres extensions for quick health checks before deploys.

Verdict

Worth installing for dev/staging laughs and fixes—docs shine, checks are thorough, but 11 stars and 1.0% credibility score flag it as early alpha. Test alongside your vector or dblink extensions; skip prod until more battle scars.

(198 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.