pgEdge Postgres Copilot Launched

PostgreSQL is the database under many business apps, and pgEdge said on April 22 it launched an open-source AI DBA Workbench to watch those systems and suggest fixes. (pgedge.com) The product is aimed at PostgreSQL 14 and newer, and pgEdge said it works with local deployments, Amazon Relational Database Service, Supabase, and pgEdge Cloud without requiring a database migration. (pgedge.com) A database administrator, or DBA, is the person who keeps a database fast, available, and recoverable when queries slow down, storage fills up, or replication falls behind. pgEdge said its tool continuously collects metrics on query performance, vacuum activity, connection health, write-ahead log throughput, and replication lag. (pgedge.com) The system is split into three services: a collector that pulls metrics, an alerter that evaluates rules and anomalies, and a server that exposes a web interface, a Representational State Transfer application programming interface, and a Model Context Protocol endpoint. pgEdge said the stack is self-hosted and stores nothing outside the customer’s network. (pgedge.com) Model Context Protocol, or MCP, is an open standard for connecting artificial intelligence applications to outside tools and data sources. The protocol’s documentation describes it as a client-server system that lets tools expose actions, resources, and prompts to models such as Claude or ChatGPT. (modelcontextprotocol.io) pgEdge’s GitHub repository says the Workbench combines that MCP server with a web client and data collector so users can query and manage PostgreSQL systems with natural language as well as conventional controls. The repository showed 552 commits and active updates on April 23. (github.com) pgEdge said the monitoring layer uses 34 built-in probes and a three-tier anomaly system built from statistical baselines, vector-similarity pattern matching, and artificial-intelligence classification. The company also said teams can run it as a standard observability tool first and turn on AI features later. (pgedge.com; pgedge.com) When the assistant, called Ellie, identifies a problem, pgEdge said it can run query-plan analysis, inspect schemas, pull historical metrics, and produce SQL for a human administrator to review before applying. The company said the product is designed to keep a person in the approval loop rather than execute repairs automatically. (pgedge.com) The release also targets environments that block software-as-a-service tools. pgEdge said customers can deploy related AI tooling on premises, including in air-gapped setups, and the Workbench quick-start guide lists Linux x86_64 for server components plus a separate PostgreSQL datastore for the product itself. (prnewswire.com; github.com) pgEdge tied the launch to a staffing problem as PostgreSQL use grows. In its announcement, the company cited the latest Stack Overflow Developer Survey for a 55% usage figure and said experienced DBAs remain hard to hire, especially in regulated settings where security clearances can delay staffing for months. (pgedge.com) For database teams, the pitch is not that AI replaces the DBA. The pitch is that more PostgreSQL fleets can be monitored around the clock, with a human still deciding whether a suggested fix reaches production. (pgedge.com)