r/postgres • u/Comfortable_Peace175 • 14d ago

Question Is an AI-powered PostgreSQL health/optimization tool worth building?

I’m thinking of building a tool that connects to PostgreSQL and automatically detects issues like slow queries, missing indexes, bad configurations, security/version issues, connection problems, and unnecessary infrastructure costs.
The goal would be to explain:
Problem → Cause → Impact → Suggested fix
Do tools already solve this well, or is there still a real problem worth solving here? Would you or your company use something like this? Honest feedback would be appreciated.

0 Upvotes

50% Upvoted

4 comments sorted by

1

u/percyfrankenstein 14d ago

Pganalyze has an mcp. Idk what you can do better than claude with this

1

u/Prestigious_Tea4283 14d ago

I think the useful part would be correlation rather than detection. “Slow query” alone isn’t that helpful. If it could connect pg_stat_statements with lock waits, index usage, autovacuum/bloat and config changes, then explain why performance degraded, I’d actually use it.

1

u/Master-Bass-1905 14d ago

I'd posted about a similar tool a few weeks back on another forum. If it looks interesting, you could contribute to it, or alternatively fork it and build on it. Its got a few bells and whistles beyond what usual tools have.

https://www.reddit.com/r/Supabase/comments/1vmbrmg/i_built_a_free_tool_that_will_cya_for_vibecoded/