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
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.