{"repo":"jasonmassie01/pg_sage","free":true,"listed":false,"github":"https://github.com/jasonmassie01/pg_sage","clone":"git clone https://github.com/jasonmassie01/pg_sage.git","description":"An Agentic PostgreSQL DBA— monitors, analyzes, and optimizes any PostgreSQL 14-18 database with LLM-powered actions","language":"Go","stars":13,"topics":["database-monitoring","dba","devops","postgres","postgresql","self-hosted","go","prometheus","ai-agent","alloydb"],"license":"AGPL-3.0","category":"databases-storage","readme_excerpt":"pg sage Agentic Postgres DBA. No extension required. What It Does pg sage runs as a single Go binary alongside your PostgreSQL instance. It connects over the standard wire protocol, collects performance data from catalog views and pg stat statements , projects issues into DBA Cases , and optionally uses an LLM for deeper analysis. A trust-ramped executor proposes or applies typed actions with guardrails, approval gates, rollback metadata, and a shadow-mode report showing what autonomous policy would have handled. Works on Lakebase, Cloud SQL, AlloyDB, Aurora, RDS, and self-managed Postgres. Quick Start Dashboard at http://localhost:8080 -- API and Prometheus metrics at :8080/api/v1/ and :9187/metrics . On first start, pg sage creates admin@pg-sage.local and prints a one-time initial admin password to stderr. The dashboard and JSON API use the sage session login cookie; unauthenticated API calls return 401 . For Docker, retrieve the password with: Features Area What You Get ------ ------------- Cases Work Queue Findings, incidents, migration risks, and action history are projected into ranked DBA cases with why-now context and next actions Incident Playbooks Runaway queries, lock blockers, connection exhaustion, WAL/replication risk, and sequence exhaustion become typed diagnostics or reviewed action scripts Vacuum/Bloat/Freeze Autopilot Table bloat, dead tuples, XID runway, freeze blockers, and per-table autovacuum tuning produce guarded candidates with verification plans Que","default_branch":null,"files":null,"tree":[],"storefront":"/r/jasonmassie01","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jasonmassie01/pg_sage/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}