pgbot

pgbot is an open-source PostgreSQL intelligence tool that provides real-time database health monitoring, performance analysis, and AI-powered insights. It acts as an 'AI DBA' by analyzing database statistics to offer actionable recommendations, helping users identify and resolve performance bottlenecks without manual dashboard monitoring.

pgbot is an open-source PostgreSQL intelligence tool that provides real-time database health monitoring, performance analysis, and AI-powered insights. It acts as an 'AI DBA' by analyzing database statistics to offer actionable recommendations, helping users identify and resolve performance bottlenecks without manual dashboard monitoring.

• 01Real-time PostgreSQL health monitoring including locks, transactions, and cache hit ratios
• 02AI-powered root-cause analysis and plain-English recommendations
• 03Comprehensive query performance tracking for slow queries and regressions
• 04Table and index analytics to identify unused or missing indexes
• 05Support for Model Context Protocol (MCP) for integration with AI agents
• 06Secure, read-only architecture for production environments