Hey Indie Hackers! I'm currently working on the MVP of DBAudit. If you're a developer, DBA, or just hate debugging slow queries โ I'd love your feedback or ideas! ๐
Hi Ferenc, Great concept debugging slow queries is a real challenge for both developers and DBAs.For your MVP, Iโd recommend focusing on: A clean UI where users can input queries and view execution plans or performance bottlenecks Actionable suggestions like adding indexes, avoiding SELECT *, or restructuring joins An optional feature to compare query performance before and after optimizations In terms of stack for fast development: Backend: Node.js with PostgreSQL Frontend: Next.js with Tailwind CSS Consider using pg_stat_statements or EXPLAIN ANALYZE for deep insights
Let me know if youโd like feedback during testing โ happy to contribute. Keep up the great work!
In the first iteration, we're adding support for the three most popular database engines โ Postgres, MySQL, and SQL Server โ along with checks for four key categories: Structural Analysis, Performance Insights, Security Checks, and Standards Compliance.
Thanks for the feedback! DbAudit helps you spot problems in your database โ like issues with tables or columns โ and suggests how to fix them.
thank you for this great information. It's really good and meaningful. I'm so happy to read this information
thank you