Postgres + Drizzle Next.js Starter

The Postgres + Drizzle Next.js Starter is a minimal Next.js boilerplate from the Vercel examples repository that connects a Postgres database to a Next.js app through the Drizzle ORM.

What is the Postgres + Drizzle Next.js Starter?

The Postgres + Drizzle Next.js Starter is a starter template, not a full product. It gives you a Next.js application pre-configured with a Postgres database and Drizzle ORM, so you can begin building data-driven features immediately. The template is published in Vercel's official examples repository on GitHub and is designed for deployment on Vercel, though it runs locally with pnpm dev. A live demo is hosted at https://postgres-drizzle.vercel.app/.

Key Features

• Drizzle ORM integration — Uses Drizzle, a lightweight TypeScript ORM, to define tables and run queries against Postgres. The schema lives in code.
• Vercel Postgres database — The demo configuration points to Vercel Postgres, a serverless Postgres offering, and the one-click deploy provisions the database connection through the Vercel dashboard.
• Tailwind CSS styling — The UI is styled with Tailwind CSS, giving you utility classes for rapid layout changes.
• One-click deploy — A Vercel deploy button clones the repository, creates the project, and deploys it without manual configuration.
• Local development setup — You can bootstrap with pnpm create next-app --example https://github.com/vercel/examples/tree/main/storage/postgres-drizzle, then run pnpm dev.
• Related starter variants — Vercel also publishes comparable starters using Prisma and Kysely, which share the same storage example layout.

Who is it for?

The Postgres + Drizzle Next.js Starter is for Next.js developers who want a working Postgres connection without writing boilerplate. It is also useful for developers evaluating Drizzle ORM who want to see a minimal, real-world schema and query setup. Finally, it suits anyone deploying a data-backed app to Vercel who prefers clicking a deploy button over configuring infrastructure.

What can you do with it?

• Quickly bootstrap a data app: Start from this template to get a Next.js app that can read and write to Postgres out of the box.
• Learn Drizzle patterns: Examine the small, idiomatic schema and query code to understand how Drizzle maps to Postgres.
• Deploy to production instantly: Use the Vercel deploy link to generate a live URL with the database wired up.

How does it work?

The template offers two entry paths. First, you can click the "Deploy with Vercel" button from the README, which clones the repository and starts a Vercel deployment with a Vercel Postgres integration. Alternatively, you can run pnpm create next-app --example with the example's GitHub path, install dependencies, and start the development server with pnpm dev. Either path yields the same Next.js application.

FAQ

What ORM does this starter use?

Drizzle ORM is the object-relational mapper for this template. Drizzle is a TypeScript ORM that lets you define Postgres tables as schema objects and run type-safe queries without code generation.

Does the template include a database?

The starter expects a Postgres database. In the one-click Vercel deploy flow, it uses Vercel Postgres. When running locally, you provide your own Postgres connection string through environment variables.

Is this template free?

The starter code is part of Vercel's public examples repository and is free to use. Hosting the app on Vercel follows Vercel's pricing; the template itself carries no license fee.

How do I deploy this to my own Vercel account?

Click the deploy button in the README or manually create a new project from the Git repository, then add the Postgres integration. The environment variables for the database connection are handled by the Vercel integration.