PostgresAI

•
140
•

Deliver AI-native PostgreSQL observability, health checks, and root cause analysis designed for human engineers and autonomous AI agents.

PostgresAI bridges traditional database monitoring and modern AI workflows by offering an observability platform tailored for both developers and LLM agents. Built on battle-tested practices and supporting PostgreSQL 14 through 18, it features express health checks, production-safe diagnostic queries, and a full monitoring stack powered by pgwatch v3, VictoriaMetrics, and curated Grafana dashboards. With native Model Context Protocol (MCP) server support and Claude Code plugins, AI agents can inspect active session history, detect issues like bloat or slow queries, and directly suggest or execute remediation steps from within standard development environments.

主な機能

01Over 45 express health checks covering index usage, bloat, queries, settings, and security
02Production-safe diagnostic engine designed to prevent observer effect with strict timeouts and limits
03Pre-configured Grafana dashboards delivering expert node, query, wait-event, and replication views
04Native Model Context Protocol (MCP) server for integration into IDEs like Cursor, Claude Code, and Windsurf
05Full-stack local and remote metrics collection backed by pgwatch v3 and VictoriaMetrics
06140 GitHub stars

ユースケース

01Diagnosing PostgreSQL performance regressions and receiving AI-generated remediation plans within coding environments
02Automating database health checks and schema inspections as part of continuous delivery or agentic maintenance workflows
03Deploying a standalone, Docker-based metrics and Grafana observability stack for production database clusters