The Scenario
You are a data engineer. The product team has handed you an Excel workbook with 200 new product records — name, SKU, price, and category for each row — and they need them in the products table of your Prisma Postgres database before the catalog launch tomorrow morning.
You could write a Python script. You could set up a local migration. You could spend two hours on infrastructure work to solve a data problem.
The bad version:
- Export the workbook to CSV
- Write a Node or Python script to read the CSV and fire parameterized INSERTs
- Hit a type error on the price column — it came out of Excel as a string, the table expects numeric
- Fix the type coercion, re-run, get 12 failures on rows with parentheses in the product name
- Fix the escaping, re-run, verify the count in the database, notice row 47 is missing
- Trace the failure back to a null category field that your script did not handle
That is three hours on a good day. And if the workbook changes before launch, you run it all again.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the table directly, and through its Prisma integration it can execute parameterized INSERT and UPDATE statements against your database without any external script.
With product data in columns A through D, try:
Read each row from columns A–D (name, sku, price, category) and run bulk INSERTs into the products table of my Prisma database — use parameterized queries for each row
What You Get
- One parameterized INSERT per data row — no SQL injection surface
- Rows with type mismatches flagged with a specific error rather than silently skipped
- Insert count written at the top of the sheet when the batch completes
- Failed rows highlighted with the Prisma error message so you can fix and re-run targeted rows
What If the Data Is Not Quite Ready
Some rows already exist — I want upserts, not duplicate inserts
Read each row from columns A–D (name, sku, price, category) and run INSERT INTO products ... ON CONFLICT (sku) DO UPDATE SET name=EXCLUDED.name, price=EXCLUDED.price, category=EXCLUDED.category against my Prisma database
I need to UPDATE existing user records by ID rather than insert new ones
Use the user IDs in column A and new plan values in column B to run 'UPDATE users SET plan=? WHERE id=?' for each row against my Prisma Postgres database — write "updated" or the error message to column C
The price column has currency symbols that need to be stripped before insert
Read columns A–D (name, sku, price, category) — strip any currency symbols from column C values before inserting — run bulk parameterized INSERTs into the products table of my Prisma database and write results to column E
Read all rows, upsert to the database, verify the count, and flag discrepancies in one shot
Read all rows from columns A–D (name, sku, price, category), run INSERT INTO products ... ON CONFLICT (sku) DO UPDATE for each row against my Prisma database, then query SELECT COUNT(*) FROM products to verify the total, and write a summary row at the top: inserted count, updated count, failed count
The pattern: drive the bulk write from the workbook in one prompt — including the verification step — so you know the database is ready for launch without running a separate count query.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you have records staged for a database import, then ask it to run the bulk inserts against your Prisma Postgres table. See also the spoke on running SELECT queries into a workbook or the hub overview.