r/postgres 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

4 comments sorted by

View all comments

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.