Newsletter
Join the Community
Subscribe to our newsletter for the latest news and updates
Next.js 13 boilerplate for programmatic SEO campaigns with ISR, sitemaps, Prisma, and Tailwind.
Pseo Next is a Next.js 13 boilerplate for building programmatic SEO campaigns, combining static site generation, incremental static regeneration, and database-driven content into one deployable template.
Pseo Next is an open-source boilerplate that lets you generate large numbers of SEO-optimized pages from structured data. It uses the Next.js App Router and outputs pages at routes such as /variant/[slug] (for example, yoursite.com/hotels/spain-summer-2023). The template wires together static generation and ISR so pages load quickly on Vercel while still reflecting fresh database content. It is created by the maintainer of unzip.dev and lives at github.com/agamm/pseo-next.
The setup flow is: clone the repo, run npm install, start Docker for the local Postgres database, copy .env.example to .env, and add your schema to /prisma/schema.prisma. Then run npx prisma migrate dev --name init and npm run db to start developing. For production, connect the repo to Vercel, set the environment variables, and use the custom build command npm run prod:build. The template contains FIXME comments that walk you through the required customizations.
Variant pages live in /src/variant/[slug]. Add your rendering logic there and uncomment the section that fetches from Prisma to populate each slug with database content.
Yes. The template uses next-sitemap, which generates sitemap.xml and robots.txt automatically, even when ISR adds new pages during runtime.
Pseo Next uses Prisma with a Postgres-compatible database. Locally, you start Docker to run Postgres; in production, you can connect any Postgres-compatible database.
In Vercel, set the build command to npm run prod:build and add your environment variables before deploying.