The Scenario
You joined as platform lead three months ago. Nobody left documentation. There are eight Prisma projects across three workspaces, some of them created by contractors who are long gone, and you have a quarterly infrastructure review with the CTO next week. She wants a complete asset inventory — project IDs, database regions, creation dates, and current statuses — in an Excel workbook.
The Prisma console organizes everything by workspace. To get a flat view, you would need to click through three workspaces, expand each project, read off each database, and build the table row by row.
The bad version:
- Open workspace one, note down each project name and ID
- Navigate to workspace two, repeat — and realize "db-prod-3" could be in either workspace one or two, go back to verify
- Open workspace three, finish the list
- Transfer everything to Excel, discover your row count does not match the number of projects you thought you had
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook context, and through its Prisma integration it can list all workspaces, projects, and databases in one flat inventory without any console navigation.
Open a blank infrastructure inventory workbook and try:
List all my Prisma workspaces and projects and write a sheet with columns: workspace name, project name, project ID, creation date
What You Get
- One row per project across all workspaces
- Workspace name in column A so you can filter by team or environment
- Project IDs ready to copy into any follow-up prompt or script
- Creation dates as YYYY-MM-DD for correct Excel sorting
- A complete flat view — nothing missed from a workspace you might have skipped
What If the Data Is Not Quite Ready
I want databases listed too, not just projects
Pull all Prisma databases across every project in my workspace into this Excel table with columns: database ID, project name, region, status, creation date
I want one Excel worksheet per workspace
List all Prisma workspaces and for each one create a separate Excel worksheet listing project name, project ID, creation date, and database count under each project
I want to flag projects with no active databases
List all Prisma projects across all workspaces, write project name, project ID, creation date, and database count to this Excel table, then mark column E as "empty" for any project with zero associated databases
Pull the full inventory, annotate by age, and flag legacy projects in one shot
List all Prisma workspaces, projects, and databases — write workspace, project name, project ID, database ID, region, and status to this Excel sheet, flag any project created before 2024-01-01 in column G as "legacy-review", and sort by creation date ascending
The pattern: generate the full asset inventory and the classification logic together so the workbook is CTO-ready without a second pass.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook for your infrastructure inventory, then ask it to list all Prisma projects and databases across your workspaces. See also the spoke on auditing active API connections or the hub overview.