The Scenario
You are spinning up a new client onboarding system. Each new client gets their own isolated Prisma Postgres database — one per client, in their preferred cloud region. Ten clients are ready to onboard this week. Their names and region preferences are already in a spreadsheet. Doing this one at a time through the Prisma console means ten separate project-creation flows, ten copy-paste operations to get connection strings back into the sheet, and a non-trivial chance you'll mix up which string belongs to which client.
The bad version:
- Open the Prisma console, click "New Project," type client name one, select region, wait for provisioning
- Copy the connection string from the results screen
- Paste into the sheet, go back to the console, repeat for client two
- Realize you skipped client four and now your row numbering is off by one
Ten clients in the console takes forty minutes of careful clicking. With twenty, it is a task that gets scheduled for a dedicated afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your spreadsheet data, and through its Prisma integration it can create new projects and databases from the data already in your rows and write the returned connection strings back into the sheet 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 client that owns them
- Any row that fails provisioning (invalid region, duplicate name) gets an error note in column C instead of silently skipping
- Existing rows with connection strings already populated are skipped to avoid duplicate provisioning
What If the Data Is Not Quite Ready
All databases should go into the same region regardless of what column B says
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 written back
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 full connection string into column D
Some rows already have connection strings — skip those and only create for empty rows
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, write back connection strings, and generate a Prisma schema starter for each 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 one-line note confirming the region the database was provisioned in
The pattern: read from the sheet, create in Prisma, and write results back — all in one prompt so the sheet stays as the single source of truth.
Try It
Get the 7-day free trial of SheetXAI and open any sheet where you track client or environment configurations, then ask it to provision the Prisma databases from your rows and write the connection strings back. See also the spoke on inventorying all Prisma projects or the hub overview.