AIops-tools/Postgres-AIops

Overview

Governed AI-ops for PostgreSQL that performs root cause analysis on slow queries, bloat, and locks, and suggests indexes, vacuum, and replication actions. It includes audit trails, budgets, undo capabilities, and risk tiers for safer automated changes. Currently in preview and written in Python.

Best for

Best for
DBAs and platform teams exploring governed AI-ops for PostgreSQL

Use cases

• Diagnose slow query and lock contention causes
• Identify table bloat and vacuum requirements
• Propose index changes with undo and audit support

Notes

Governed AI-ops for PostgreSQL that performs root cause analysis on slow queries, bloat, and locks, and suggests indexes, vacuum, and replication actions. It includes audit trails, budgets, undo capabilities, and risk tiers for safer automated changes. Currently in preview and written in Python.

0 stars on GitHub. Last updated 2026-09-02. Licensed MIT.

Use cases

• Diagnose slow query and lock contention causes
• Identify table bloat and vacuum requirements
• Propose index changes with undo and audit support

Pros

• Covers multiple PostgreSQL operational areas in one tool
• Includes governance features like budgets and risk tiers
• Open source with Python codebase

Cons

• Preview status and zero GitHub stars suggest unproven reliability
• Limited community and documentation expected
• Governance features add setup and learning overhead

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.