How to generate next.js app router trpc procedures from excel data schemas
- Step 1Upload schema Excel — Upload a file whose headers match your database entity columns.
- Step 2Name the router — Use the convention entityNameRouter (e.g. postsRouter, commentsRouter).
- Step 3Add to server/api/routers/ — Place the generated file in your tRPC routers directory.
- Step 4Register in root router — Import and add it to appRouter in server/api/root.ts.
Frequently asked questions
Does the generated router include input sanitization?+
Zod schemas provide type coercion and validation at the boundary. All string inputs are z.string() with .optional() where needed.
What auth guard pattern is used?+
The generated mutations use protectedProcedure — a placeholder for your auth middleware. Swap it with your actual auth procedure (e.g. from NextAuth or Clerk).
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.