The Scenario
You are a platform engineer at an agency. Ten new clients signed contracts this week. Each one gets an isolated Prisma Postgres database in their preferred cloud region. The client names and regions are in an Excel workbook. Creating these one at a time through the Prisma console means ten separate flows, ten copy-paste operations to capture connection strings, and a real possibility of pairing the wrong string with the wrong client row.
Your project manager is watching you do this. She has already asked twice if there is a faster way.
The bad version:
- Open the Prisma console, click "New Project," type the first client name, select the region, wait for provisioning
- Copy the connection string from the confirmation screen, switch back to Excel, paste into the right row
- Return to the console for client two — and notice you accidentally pasted client one's string into client two's row
- Start over, more carefully, and spend 45 minutes doing something that should take five
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your table data, and through its Prisma integration it can create new Prisma projects and databases from the rows in your workbook and write the returned connection strings back into the correct cells automatically.
With client names in column A and regions in column B, try:
Read the client names in column A and regions in column B, create a new Prisma project and database for each row, and write the returned connection string into column C
What You Get
- One new Prisma project and database provisioned per row
- Connection strings written back into column C, row-matched to the correct client
- Rows that fail provisioning get an error note in column C instead of a silent gap
- Rows in column C that already have a value are skipped to avoid duplicate provisioning
What If the Data Is Not Quite Ready
All databases should use the same region regardless of column B
Use the project IDs in column A to create one new Prisma database per row in the 'us-east-1' region and fill column B with each new database ID
I want both the database ID and the connection string captured
Read client names in column A and regions in column B, create a Prisma project and database for each, write the database ID into column C and the connection string into column D
Some rows already have connection strings — skip those
Read column A for client names and column B for regions — for any row where column C is empty, create a new Prisma project and database and write the connection string to column C; skip rows where column C already has a value
Create the databases, capture connection strings, and add a region confirmation note in one shot
Read client names in column A and regions in column B, create a Prisma project and database for each row, write the connection string to column C, and in column D write a confirmation of the region the database was actually provisioned in
The pattern: drive provisioning from the workbook, write all results back into the correct rows, and keep the Excel table as the single source of truth.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you track client environments or infrastructure configurations, then ask it to provision the Prisma databases from your rows and capture the connection strings automatically. See also the spoke on inventorying all Prisma projects or the hub overview.