How to generate trpc, zod, and prisma boilerplate from an excel data model
- Step 1Prepare your data model sheet — Ensure your Excel file has a header row with column names matching your intended Prisma model fields.
- Step 2Upload and name the router — Upload the file and enter a camelCase router name like 'productsRouter'.
- Step 3Review generated types — Check the inferred Zod types and adjust manually if needed (e.g. change z.string() to z.string().email() for email columns).
- Step 4Integrate into T3/Next.js project — Drop the file into your server/api/routers/ directory and register it in the root appRouter.
Frequently asked questions
Does it generate Prisma schema (.prisma file) as well?+
Not yet — the tool generates the tRPC router layer. Prisma schema generation is on the roadmap.
Can I use this with Drizzle ORM instead of Prisma?+
Yes — replace the ctx.db.entity.findMany() placeholders with your Drizzle select() queries. The Zod schemas and router structure are ORM-agnostic.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.