13 Open-source PostgreSQL Next.js Starters and Boilerplate (Vercel and Docker-based PostgreSQL)
Next.js, a popular React framework developed by Vercel, stands out for its powerful features and developer-friendly environment, making it a top choice for building modern web applications.
Vercel's PostgreSQL Next.js Starters are designed to streamline the development process for Next.js developers, offering a seamless way to integrate PostgreSQL databases into your projects. These starters provide a robust foundation for building scalable and performant applications.
In the following list, we offer you the best open-source PostgreSQL starter for Next.js that can speed up your production.
1. Onset
Onset is a Next.js starter that comes with step-by-step instructions to understand how everything works, easy for both beginners and experts alike and giving you the confidence to customize it to your needs. Built with Next.js 14, Drizzle (Postgres), NextAuth/Auth.js.
2. Vercel Postgres Next.js Starter (Recommended)
![](https://medevel.com/content/images/2024/07/Screenshot-2024-07-31-at-08.54.40.png)
This is the official Vercel PostgreSQL starter, that can be easily configured and customized.
![](https://vercel.com/api/og/templates?title=Vercel%20Postgres%20Next.js%20Starter&description=Simple%20Next.js%20template%20that%20uses%20Vercel%20Postgres%20as%20the%20database.&image=https://images.ctfassets.net/e5382hct74si/6nJ3m6LiIjo9BHZj04m1G2/519a0f10b99fe2dbbce36763553acf43/opengraph-image.png&framework=Next.js)
3. Next.js Prisma PostgreSQL Auth Starter with Shadcn
Prisma as the ORM, and Postgres database to persist the data. This application uses Shadcn for UI components, and Tailwind CSS for styling. It has integrated theming support, with support for multiple themes with a custom plugin.
4. Drizzle-ORM-and-Vercel-Postgres Starter
Build blazing fast and dynamic web applications with Next.js 13, TypeScript, Tailwind CSS, React, and React-Hot Toast.
This starter is an ideal option for starting point for anyone who wants to learn how to build modern, performant web applications with Next.js.
It includes all the essential features you need to get started, such as dynamic API routes, TypeScript support, and Tailwind CSS styling.
5. Next.js 14 Admin Dashboard Template
This is a free and open-source Next.js 14 Admin Template.
This is a starter template using the following stack:
- Framework - Next.js 14
- Language - TypeScript
- Auth - NextAuth.js
- Database - Postgres
- Deployment - Vercel
- Styling - Tailwind CSS
- Components - Shadcn UI
- Analytics - Vercel Analytics
- Formatting - Prettier
This template uses the new Next.js App Router. This includes support for enhanced layouts, colocation of components, tests, and styles, component-level data fetching, and more.
6. Next.js + PostgreSQL Auth Starter
This is a Next.js starter kit that uses NextAuth.js for simple email + password login, Drizzle as the ORM, and a Neon Postgres database to persist the data.
7. Next Starter Template
Next.js Starter Template for Next.js 13 that can be upgraded to Next.js 15 in no time.
This template wires a bunch of technologies together to facilitate a great user and developer experience.
- ⚛️ Next.js - the fullstack framework.
- 🚀 Typescript - for the superior developer experience and to catch issues early.
- 🎨 Tailwind CSS - never write CSS again, ship as little as possibl to the client.
- 🔗 tRPC - end to end typesafe APIs. This setup makes it easy to test procedures in isolation.
- 🌍 React Query - the best server state management library. The template includes a
useMutation
hooks that makes optimistic updates an absolute breeze. - 🔒 NextAuth.js - trivial authentication for Next.js apps while owning all of your data.
- 📙 Prisma - the best ORM for Typescript. This template assumes you'll be using PostgreSQL.
- 🐳 Docker - 100% offline development is enabled by a local PostgreSQL and email server.
- 🃏 Jest - unit tests with React Testing Library and msw. Integration tests that can talk to an ephemeral PostgreSQL database. Coverage is automatically collected.
- 🚢 Github Actions and Vercel - linting, testing; and full preview and production deployments.
- 🌳 Dependabot - to keep all your dependencies up to date.
- Supports Docker Install.
8. Vercel Postgres + Drizzle Next.js Starter
This is a simple Next.js template that uses Vercel Postgres as the database and Drizzle as the ORM.
9. Next.js with PostgreSQL and Drizzle ORM Starter
This is a free and open-source starter project/template for building web applications with Next.js, PostgreSQL, and Drizzle ORM.
This project includes a basic setup with Drizzle, an Object-Relational Mapping (ORM) library, and uses Docker for PostgreSQL, making it easy to kickstart your development with Next.js, PostgreSQL, Drizzle, and containerization.
It is an ideal solution if you wanna use PostgreSQL in a Docker and your app at Vercel.
10. Next.js + Auth.js + Drizzle + Docker starter
This is a simple Next.js + TypeScript boilerplate app that uses Auth.js for authentication and session management. When a user logs in, their data is upserted to the PostgreSQL database with Auth.js's @auth/drizzle-adapter adapter.
The SQL models required by the AuthJS are available on Auth.js's database models documentation. This project uses @auth/drizzle-adapter so we can use their pre-defined Drizzle schema for PostgreSQL to generate the correct migrations with Drizzle.
This project uses Docker Compose for an easy dev setup, so you don't need to run a database natively. It will also automatically run the migrations for you when the Next.js server starts.
11. Vercel Postgres + Kysely Next.js Starter
Simple Next.js template that uses Vercel Postgres as the database and Kysely as the query builder.
12- Vercel Postgres + Prisma Next.js
Starter
Simple Next.js template that uses Vercel Postgres as the database and Prisma as the ORM.