The Scenario
You are a DevOps engineer and your monthly infrastructure review is tomorrow morning. Six Prisma databases, three environments, two workspaces. Your engineering director wants a side-by-side comparison of storage usage and read/write operation counts for the last 30 days so the team can decide which databases need upsizing before next quarter.
The Prisma console shows these metrics one database at a time. There is no download. The meeting is in fourteen hours.
The bad version:
- Open the console, navigate to database one, click the Metrics tab, write down the numbers on a sticky note
- Repeat for each of the other five databases, switching browser tabs back and forth
- Transfer the sticky note numbers into an Excel table, realize you misread one storage value and need to go back and verify
- Format the table, add the comparison columns, share the workbook
An hour of careful clicking to produce numbers that are already partially stale by the time you finish.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook and, through its Prisma integration, can fetch usage metrics across all your databases and land them in a comparison table in one step.
Open the infrastructure review workbook and try:
Fetch usage metrics for all my Prisma databases for the last 30 days and write a sheet with columns: database name, storage bytes, total reads, total writes
What You Get
- One row per database in a single flat table
- Storage shown as a numeric byte count sortable in Excel
- Total read and write operations as integers
- Rows sorted by storage descending so the largest databases appear first
- Databases that returned zero metrics for the period show zeros, not blanks
What If the Data Is Not Quite Ready
I want the data pulled from a list of database IDs already in my workbook
For each database ID in column A of this Excel sheet, get the Prisma usage stats for the past 7 days and fill columns B, C, and D with storage used, read ops, and write ops
I want a read-to-write ratio column and a flag for write-heavy databases
Fetch 30-day usage metrics for all my Prisma databases, write database name, storage GB, total reads, total writes to columns A–D, and in column E calculate the read-to-write ratio — mark "write-heavy" in column F if writes exceed reads by more than 2x
I want storage in GB and a flag for databases over a specific threshold
Fetch usage metrics for all Prisma databases for the last 30 days, write database name to column A, storage GB (rounded to 1 decimal) to column B, and in column C mark "review" for any database over 5 GB
Pull 30-day metrics, flag anomalies, calculate ratios, and add resize recommendations in one shot
Fetch 30-day usage metrics for all Prisma databases, write name, storage GB, total reads, total writes to columns A–D, calculate read-to-write ratio in E, flag any database where storage exceeds 10 GB in column F, and in column G recommend "upsize" or "monitor" based on the combined storage and write load pattern
The pattern: fetch the metrics and apply the classification logic together so the workbook is director-ready without a second formatting pass.
Try It
Get the 7-day free trial of SheetXAI and open your infrastructure review workbook, then ask it to pull Prisma usage metrics across all your databases for the last 30 days. See also the spoke on inventorying all Prisma projects or the hub overview.