“I was surprised how many things were wrong in my ‘perfect’ database”
I thought my database was solid.
Clean schema, decent indexes, no weird shortcuts.
But then I ran it through DBaudit.org (a tool I’ve been building)... and wow 😅
Here’s what came up:
❌ A few missing foreign key constraints
🐢 Unused indexes slowing down inserts
🔓 A table with overly broad permissions
🤯 Inconsistent naming across tables (I knew that
user_infotable would bite me one day)
What really surprised me is how easy it is to miss this kind of stuff when you're focused on building features fast.
That’s why I built DBaudit — to help indie hackers and devs like me catch these things before they become real problems.
It supports Postgres, MySQL, and SQL Server.
If you give it a spin, I’d love to hear what your “perfect” database is hiding 😉
👉 https://dbaudit.org
