The Scenario
It is the third week of January and your security team is doing its quarterly credential review. Someone has added a task to the audit checklist: produce a complete list of all active API key connections across your twelve production Prisma databases — who created them, when, and what they are named. The list needs to be in an Excel workbook so the team can annotate and track revocations.
The Prisma console shows connections per database, one at a time. There is no export. You have twelve databases. This is going to be a while.
The bad version:
- Navigate to database one in the Prisma console, open the Connections tab, write down each connection name, ID, and created date
- Switch to database two, repeat
- Lose track of which database you were on after database seven, re-click to verify
- Assemble the workbook from your notes and realize you missed two connections from database four because the console only showed the first page
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 it can pull all API key connections across every database and write the full list into your table in one step.
Open your quarterly access review workbook 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 twelve databases
- Database name in column A for filtering by environment
- Connection name and ID ready to annotate with revocation status
- Created dates as YYYY-MM-DD so you can sort by age and spot old credentials quickly
- Everything in one table — no console tab-switching, nothing missed
What If the Data Is Not Quite Ready
I only want connections for specific database IDs already in my workbook
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 Excel sheet
I want to flag connections older than 90 days as stale
List all connections across all my Prisma databases, write database name, connection name, connection ID, created date to this Excel sheet, and in column E mark "stale" for any connection created more than 90 days ago
I want connections grouped by database for easier per-database review
List all connections across my Prisma databases, sort by database name so all connections for each database are grouped, write database name, connection name, connection ID, and created date in this workbook
Pull all connections, flag stale ones, flag suspicious names, and generate a revocation list in one shot
List all connections across all my Prisma databases, write database name, connection name, connection ID, created date to columns A–D, mark "stale" in column E if created more than 90 days ago, mark "suspicious" in column F if the name contains "test" or "temp", and in column G write "revoke" for any row where both E and F are flagged
The pattern: pull the complete access inventory and apply the risk classification together in one prompt so the security team has an annotated workbook ready for review.
Try It
Get the 7-day free trial of SheetXAI and open your quarterly security review workbook, then ask it to pull all active Prisma connections and flag anything stale or suspicious. See also the spoke on auditing workspace OAuth integrations or the hub overview.