Stop Spending Hours on What Should Take Minutes: A DBA's Guide to EDB Postgres® AI’s Agentic Database Capabilities

Every DBA knows this morning. A developer Slacks you at 9:14 AM: “Hey, my database is slow. Checkout is timing out."

You open the console, start digging through slow query logs, pull up pg_stat_statements, start cross-referencing execution times against recent schema changes, check if statistics are stale, wonder if someone dropped an index last night, open a second terminal to check active connections, and somewhere around 10:30 you find it! A missing index on a filtered column that has been killing every checkout query since the last deployment.

An hour and twenty minutes. A developer blocked. Customers frustrated. And the fix itself took about ten seconds: one CREATE INDEX CONCURRENTLY.

That gap between finding the problem and fixing it used to be an annoyance. Now it's a liability, because of the rise of agents. The agentic era doesn't just change the kinds of applications enterprises build; it changes how they interact with their own infrastructure. Traditional database infrastructure simply can't keep pace with how fast they move.

The answer to all of this isn't to ask people to operate faster. It's to let the database operate itself. EDB Postgres® AI (EDB PG AI) embeds intelligence directly into the engine so it continuously self-tunes, self-scales, and self-heals at the pace agents move — keeping everything optimized and enterprise-grade so agents and developers have an operational foundation they can trust. And it does this without adding complexity and without taking away control: every autonomous action runs inside guardrails the organization sets, with optional human-in-the-loop approval.

This post walks through how that works in practice, including what our agentic database does, how it works, and how it changes the way you work with PostgreSQL.

What "Agentic Database" Actually Means

"Agentic" gets thrown around loosely. In EDB Postgres AI, it means something specific: the system watches your clusters continuously, reasons about what it sees, forms recommendations, and can take action under whatever level of governance you configure. It's built on more than 20 years of EDB Postgres expertise, packaging patterns and tuning into an automation layer that runs against your actual workload, not a generic benchmark. The result shifts database operations from reactive (something broke, go fix it) to proactive (something is about to become a problem, here's the fix, do you want me to apply it?).

The Recommendation Scorecard: Your Database's Health Report Card

The first place to land when you open a cluster in the EDB Postgres AI console is the Recommendation Scorecard. Think of it as a continuous health check that never sleeps.

Your cluster's Postgres health is graded across five dimensions:

1. Indexes — Is your workload actually using the right indexes? Are there obvious gaps?
2. Statistics — Is the query planner working with fresh, accurate statistics?
3. Configuration — Are your Postgres settings tuned for your environment and workload profile?
4. Security — Are there hardening gaps — open roles, weak authentication, unencrypted connections?
5. Workload — A forthcoming dimension that will add even deeper runtime analysis

Each gets a letter grade, A through F, so there's no ambiguity about severity. But unlike a dashboard that shows a red light and leaves you to figure out the rest, the scorecard shows you exactly what it found and exactly how to fix it.

Here's what this looks like in practice. An example cluster, LedgerDB, running a financial transactions workload comes up with an Index grade of D. The system has been watching the workload for about ten minutes. In that time it read pg_stat_statements, identified the slowest query patterns, analyzed which columns those queries filter on, and concluded that a specific index is missing. The recommendation isn't vague. It's:

CREATE INDEX CONCURRENTLY idx_transactions_status_account
ON public.transactions (status, account_id);

And it estimates this single index will reduce query costs by over 90% on the observed workload. No log scraping. No cross-referencing query plans. No guessing. The system observed, reasoned, and produced the exact SQL. You can approve it right there. More on that in the Automations section.

This LedgerDB example isn't a one-off. Every recommendation comes from your actual workload, not a generic rulebook, which is how EDB PG AI can deliver up to 8x faster application performance and lower resource costs per workload (internally benchmarked). Speed and cost usually trade off against each other, but here they improve together, because the platform optimizes the workload instead of throwing more resources at the problem. At fleet scale that adds up to real money and the kind of efficiency agents demand once they start hitting your database at machine speed.

But first — how does the system know what it knows? That leads us to the chatbot.

The AI Chatbot: A Senior DBA Always On Duty

The AI Chatbot adds a conversational layer for deeper insights. The critical thing to understand is that it isn't talking to generic Postgres documentation. It's connected live to your cluster, reading pg_stat_statements directly. Every answer is grounded in what your database is actually doing right now.

So instead of opening five tabs and writing queries yourself, you ask: "Looking at the queries running against LedgerDB, what schema changes would improve performance the most?" The response isn't a list of best practices. It gives an analysis of your workload. It pulls the top queries by total execution time, explains each access pattern in plain language, and produces numbered, prioritized recommendations: a composite index here, a partial index there, an account_id that will exceed INTEGER bounds within 18 months.

Every recommendation cites the specific query that motivated it and the reasoning behind it. A senior DBA would do the same analysis, but it would take 45 to 60 minutes, not 30 seconds.

You can also go deeper and ask why a recommendation was made, what queries it's based on, the current execution plan, and the risks of applying it. The chatbot walks you through the full chain, including build time, locking behavior, and what happens if the workload pattern later changes. That's the kind of write-up that used to require a DBA to reproduce the query, pull EXPLAIN ANALYZE, and document it by hand. Now it's one follow-up question.

Automations: The System That Doesn't Sleep

If the chatbot and scorecard tell you what to do, Automations do it for you, on a schedule, within guardrails you define, at the pace agents actually move. Some actions are safe to run fully autonomously; others you'll want to gate behind a human. You set that line per automation. The current release ships five types:

1. Disk Autoscale — adds storage in set increments when utilization crosses a threshold, up to a hard cap. Nobody gets paged at 2 AM.

2. Index Recommendations — evaluates the workload on an interval and queues an apply-index task. Builds run with CREATE INDEX CONCURRENTLY, so traffic keeps flowing.

3. Minor Version Upgrades — watches for new minor-version images and queues upgrades pinned to your maintenance window.

4 and 5. CPU and Memory Autoscale — threshold-triggered scaling to right-size based on demand, but with configurable ceilings.

For each one, you choose the approval mode: fully autonomous or mandatory human sign-off. You're not trading speed for control — you're configuring the balance that fits your environment.

Visible, Governed Execution

Every automated action flows through the platform’s Task Manager, which shows what the task is, the exact SQL it will run, its approval status, and why approval is required. If sign-off is needed, you review the task and approve.

Everything is then written to an immutable, timestamped Activity Log. When an auditor asks what changed on LedgerDB last Tuesday and who authorized it, the answer is there: every automated action attributed to its automation, every approval to its human. The same log doubles as the context window for AI agents working alongside the system.

Same Expertise for Any AI Agent

The advisory surface that powers the chatbot and scorecard is also exposed as an MCP (Model Context Protocol) server. External agents — Claude, your own co-pilots, any MCP-compatible tool — can query cluster health, retrieve recommendations, read the activity log, and trigger approved actions through the same interface, the same expertise, the same guardrails. EDB PG AI’s advisory layer becomes composable with the rest of your AI toolchain.

The Real Productivity Math

Let's be concrete about what these capabilities add up to.

Before: A slow query alert comes in. A DBA starts investigating:

After, with EDB Postgres AI Console:

That's not a marginal improvement—that’s up to 10x faster to optimize your production clusters. That's a structural change in how database operations work. The compounding effect matters too. The hours you're not spending on routine index investigations go toward work that genuinely needs expert judgment like capacity planning and schema design. And for teams running many clusters, one DBA can now maintain visibility and responsiveness across an environment that used to require a team.

Why This Matters Even if You're Not a DBA

The framing so far has been DBA-centric, but that's not the whole picture.

The Recommendation Scorecard and chatbot were deliberately designed so that a developer who has never tuned a database can use them. If you're an engineer who deployed a new feature last week and now the query that feature runs is the top entry in pg_stat_statements, you don't need to understand B-tree index internals to ask: "Why is this query slow and how do I fix it?"

The system will tell you, in plain language, with the SQL to fix it.

This democratization of Postgres expertise is one of the less-obvious but more significant aspects of what EDB has built. The expertise that used to require years of experience, or expensive consulting engagements, or a very patient senior DBA, is now a conversation.

Get Started with EDB PG AI’s Agentic Database

The Recommendation Scorecard, the AI chatbot, the five automations, the Task Manager, the Activity Log, and the MCP integration are all shipping today in EDB Postgres AI. The best way to understand what changes is to point it at a real cluster with a real workload, let it watch for ten minutes, and ask the chatbot what it would change. It will probably know something about your database that would have taken you an hour to find on your own.

See a demo of this today, and stay tuned for a full deep dive on these capabilities coming to EDB’s website soon.