Express + Prisma REST API (TypeScript + SQLite + Zod)

A production REST API boilerplate — CRUD, validation, pagination

A complete Node.js + Express + TypeScript + Prisma + SQLite REST API. Users and Posts with relations, Zod validation, pagination, standardized errors — ready to extend.

What's included

• Full CRUD — Users and Posts with relations
• Pagination — ?page=1&limit=10 with metadata
• Validation — Zod schemas (400 with details)
• Standardized responses — { data } / { error }
• Central error handling — middleware + 404 handler
• SQLite — zero external services, runs anywhere
• Seed data — 5 users + 5 posts
• 7 smoke tests — Node.js node:test

Quick Start

npm install
npx prisma migrate dev
npm run seed
npm run dev

Stack

Node.js 18+ · Express 5 · TypeScript · Prisma 6 · SQLite · Zod

Use cases

• REST API foundations
• MVP backends
• Internal services
• Learning/training projects