stacks / nextjs postgres prisma vercel

Next.js + Postgres + Prisma + Vercel

The default choice when you need SEO, server rendering, and typed database access in one codebase.

Circumstances — when to use it

  • Public content must be indexable and fast on first paint
  • You want API routes and UI in the same repo and the same deploy
  • The schema is non-trivial and you want migrations under version control

Synergy — how the pieces fit

Next.js renders on the server, so data fetching happens next to the database instead of over the public internet. Prisma turns the schema into TypeScript types, so a column rename becomes a compile error rather than a runtime 500. Vercel runs the framework it maintains, so routing, caching, and image optimization work without hand-tuning. The result is one mental model: write a server component, query Postgres, return HTML.

The tech and its role

Next.js (App Router)Framework, SSR/SSG, routing
React Server ComponentsServer-side data fetching
PostgresPrimary datastore
PrismaTyped ORM and migrations
Better AuthSessions and OAuth providers
VercelHosting, edge caching, previews

Architectural examples

Each example links to a public source — no claims about private internals.

Cal.com

Open-source scheduling platform whose public repo shows the full shape: Next.js app, Prisma schema and migrations, Postgres database.

source

Notion's marketing site

Built with Next.js on Vercel and runs hundreds of experiments a year at the edge — the indexable site is kept separate from the Notion app itself.

source

Skip if

Skip if your app is a purely internal dashboard behind a login — the server rendering cost buys you SEO you will never use.

Other playbooks

WWADD — Moves. Stacks. Judgment calls.

FREE REFERENCE · NO LOGIN · NO TRACKING