Open Source AI Observability for PostgreSQL - Live Demo & Q&A | pgEdge
Open source monitoring and optional AI-assisted diagnosis for any Postgres 14+, including RDS, Supabase, Azure Flexible Server, & more. No agent on your PostgreSQL hosts. Dave Page (CTO, founder of pgAdmin, PostgreSQL Core Team member), Paul Rothrock (Solutions Engineer), and Antony Pegg (Director of Product Management) walk through the pgEdge AI DBA Workbench live and unscripted. A mixed fleet - Postgres 14 through 18, primary-replica and Spock replication - and open Q&A throughout. At the end, Dave answers one last question: what was the coolest thing you built? His answer is worth hearing. ────────────────────────────── CHAPTERS ────────────────────────────── 0:00 Introduction and speakers 1:27 What the AI DBA Workbench does 3:38 Demo: your entire Postgres estate at a glance 4:49 Drill into a cluster: metrics and event timeline 6:20 Anomaly detection that learns your patterns 7:22 AI analysis on individual metrics 8:40 Grafana, Google, and a terminal - now one place 9:41 Query summaries and query plan analysis 10:21 Ellie: ask your cluster anything 12:27 Blackout windows and maintenance scheduling 13:07 RBAC and access control 14:02 Probes and alert configuration 15:00 Notification channels: Slack, Mattermost, webhooks 15:59 Ellie's persistent memory 16:14 Cluster groups and organization 17:03 Q&A 17:11 Q: Do alerts run without the client open? 18:02 Q: Connection pooling and server load 19:03 Q: Controlling AI costs 19:28 Q: Connecting Claude Code and Cursor directly 22:50 Q: Storage footprint at scale 30:09 Q: Secrets management and credential rotation 30:25 Q: Replication monitoring and lag alerts 32:31 Dave: what was the coolest thing to build? ────────────────────────────── WHAT'S COVERED ────────────────────────────── - Agentless monitoring: connects over the standard Postgres wire protocol, nothing installed on your hosts - 3-tier anomaly detection: statistical baselines, pattern similarity, then LLM classification - Ellie, the optional AI assistant: persistent memory, natural language interface to your metrics - Alerting, blackout windows, RBAC - Self-hosted, air-gap ready - bring your own LLM: Claude, OpenAI, Gemini, Ollama, LM Studio - Replication monitoring: binary, logical, and Spock multi-master - Live Q&A ────────────────────────────── LINKS ────────────────────────────── GitHub: https://github.com/pgEdge/ai-dba-workbench Docs: https://docs.pgedge.com/ai-dba-workbench Try pgEdge Cloud free: https://app.pgedge.com All pgEdge webinars: https://www.pgedge.com/webinars #PostgreSQL #Postgres #DatabaseMonitoring #Observability #OpenSource #DBA #SRE #AIAgent #pgEdge