The Scenario
Your company just received a SOC 2 audit questionnaire. One of the questions asks for a complete list of all active API connections across your production databases — who created them, when, and what they have access to. You manage twelve Prisma databases. The connections are all in the Prisma console, organized one database at a time, with no export option.
You have until Tuesday. Your security lead wants the sheet by end of day Friday.
The bad version:
- Open the Prisma console, navigate to database one, click the Connections tab
- Record each connection name, ID, and creation date manually
- Switch to database two, repeat eleven more times
- Notice that database seven has a connection named "test-key-temp" that has been there for nine months and probably should not exist
Twelve databases, with an average of four connections each, is forty-eight rows to write by hand. One missed tab and the audit sheet has a gap.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your spreadsheet context, and through its Prisma integration it can pull all API key connections across all your databases and write the full list into a sheet in one step.
Open a blank audit sheet and try:
List all connections for every database across all my Prisma projects and write a sheet with columns: database name, connection name, connection ID, created date
What You Get
- One row per connection across all databases
- Database name in column A for easy filtering by environment (prod vs. staging)
- Connection name and ID in columns B and C — ready to flag or annotate
- Created date formatted as YYYY-MM-DD so you can sort by age
- All databases covered in one pass, nothing missed because you clicked past a tab
What If the Data Is Not Quite Ready
I only want connections for the databases listed in column A
Pull all API key connections from the database IDs listed in column A and fill columns B, C, and D with connection name, connection ID, and created date in this sheet
I want to flag connections older than 90 days
List all connections across all my Prisma databases, write database name, connection name, connection ID, created date to this sheet, and in column E mark "stale" for any connection created more than 90 days ago
I want the list grouped by database so I can review one database at a time
List all connections across my Prisma databases, sort by database name so all connections for each database are grouped together, write database name, connection name, connection ID, and created date
Pull connections, flag stale ones, and generate an audit-ready summary note in one shot
List all connections across all my Prisma databases, write database name, connection name, connection ID, created date to columns A–D, in column E mark "stale" if created more than 90 days ago, and in column F write "revoke" for any connection whose name contains "test" or "temp"
The pattern: pull the raw access data and apply the audit classification logic in one prompt so the sheet is ready for your security lead without additional cleanup.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet for your Prisma access audit, then ask it to pull all active connections across your databases and flag anything that looks like a stale credential. See also the spoke on workspace integration audits or the hub overview.