The Scenario
You manage six Prisma databases across three environments. End of month, your engineering lead wants a capacity planning review — which databases are growing fastest, which are close to their storage limits, where read-versus-write ratios look lopsided. You have this data in Prisma's console, one database at a time, and the interface is not built for side-by-side comparison.
The bad version:
- Open the Prisma console, click into database one, navigate to usage metrics, note the numbers
- Repeat for each of the other five databases, switching tabs back and forth
- Type the numbers into a spreadsheet by hand, realize you misread two of them, go back and verify
Six databases takes thirty minutes to do carefully. With twelve databases it starts being a half-day. And the numbers are already a few clicks stale by the time you finish.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads what you are working with, and through its Prisma integration it can fetch usage metrics across all your databases and land them in a side-by-side comparison sheet in one step.
Open a sheet where you want the comparison table 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, all in a single view
- Storage shown in bytes (you can ask for GB if preferred)
- Total read operations and total write operations as integers
- Rows sorted by storage used descending so the largest databases surface first
- If a database returned no metrics for the period, its row shows zero rather than a blank
What If the Data Is Not Quite Ready
I want the last 7 days instead of 30, pulled from a list in my sheet
For each database ID in column A of this sheet, get the Prisma usage stats for the past 7 days and fill columns B, C, and D with storage used (GB), read ops, and write ops
I want a read-to-write ratio column calculated alongside the raw numbers
Fetch 30-day usage metrics for all my Prisma databases and write database name, storage GB, total reads, total writes, and in column E the read-to-write ratio rounded to 2 decimal places — mark "write-heavy" in column F if writes exceed reads
Storage is in bytes but I want to flag databases over 5 GB
Fetch usage metrics for all Prisma databases for the last 30 days, write storage bytes to column B, and in column C convert to GB rounded to 1 decimal — mark column D as "review" for any database over 5 GB
Pull 30-day metrics, flag anomalies, and add a recommendation column in one shot
Fetch 30-day usage metrics for all my 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 grew more than 20% compared to the prior 30 days in column F, and in column G suggest either "upsize" or "monitor" based on the pattern
The pattern: pull the raw metrics and the analysis logic in one prompt so the sheet is ready to share without a second formatting pass.
Try It
Get the 7-day free trial of SheetXAI and open a sheet where your team tracks infrastructure health, 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 for the full list of Prisma workflows.