AI agent for database administrators
Database Capacity and Growth Agent
No database hits a capacity limit unplanned
What it does
Databases grow quietly, and without planning they hit storage or memory limits at the worst moment. Each week this agent collects size, growth rate, connection counts and resource use for every database and forecasts when each will reach a limit. It excludes one-off jumps, such as a bulk load, so the trend is not distorted. For predictable growth it proposes actions such as archiving old data, adding storage or adjusting settings. Before proposing an archive, it checks that the data is past its retention date and not referenced anywhere. If a forecast shows a limit inside the warning window, it drafts a plan with options and lead times. You approve archiving and capacity changes. Edge case: a database that grows only at month end is forecast on its monthly pattern, not a daily average.
How it works
Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.
Read the steps as a list
- Weekly capacity check
- Collect size, growth and resource metrics
- Forecast time to each limit, excluding one-off spikes
- Is any limit forecast within the warning window?If not: log a healthy result and stop. Back to step 2.
- Propose archiving, storage or setting changes
- Confirm archiving candidates are past retention and unreferenced
- DBA approves the capacity planThe agent waits here for your OK.
- Capacity plan or healthy log
How it decides
It forecasts from steady growth, excluding one-off spikes, and recommends action when a limit is forecast within the warning window.
- Exclude one-off bulk loads from the trend
- Archive only data past retention and unreferenced
- Warn when a limit is within the window
Make it yours
Every agent is a starting point. You choose these settings for your own situation.
- Warning window (default 14 days)
- Retention periods
- Databases in scope
- Preferred actions order
What keeps you in control
It always asks you first
- Archiving data
- Changing storage or database settings
Hard limits
- Never deletes data; archives only with approval
- Confirms retention before any archive
It stops when
- Done: capacity healthy or plan approved
- Stop: metrics history is too short to forecast
Set it up
We guide you through the set-up, step by step
Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.
- One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
- The agent then walks you through connecting your own data, one source at a time
- A downloadable copy with the flow chart, the rules and the full guide
