prisma / prisma-examples

<br /> <div align="center"> <h1>Prisma Examples</h1> <p><h3 align="center">Ready-to-run Prisma example projects 🚀</h3></p> <a href="https://www.prisma.io/">Website</a> <span>&nbsp;&nbsp;•&nbsp;&nbsp;</span> <a href="https://www.prisma.io/docs/">Docs</a> <span>&nbsp;&nbsp;•&nbsp;&nbsp;</span> <a href="https://www.prisma.io/blog">Blog</a> <span>&nbsp;&nbsp;•&nbsp;&nbsp;</span> <a href="https://pris.ly/discord?utm_source=github&utm_medium=prisma_examples&utm_content=repo_readme">Discord</a> <span>&nbsp;&nbsp;•&nbsp;&nbsp;</span> <a href="https://pris.ly/x?utm_source=github&utm_medium=prisma_examples&utm_content=repo_readme">Twitter</a> <span>&nbsp;&nbsp;•&nbsp;&nbsp;</span> <a href="https://pris.ly/youtube?utm_source=github&utm_medium=prisma_examples&utm_content=repo_readme">Demo videos</a> </div> <hr> <div align="center">

View full CI status

</div> <hr>

This repository contains a number of ready-to-run example projects demonstrating various use cases of Prisma. Pick an example and follow the instructions in the corresponding README.

You can also find links to real-world and production ready examples further below in this README.

Are you missing an example? Please feel free to open an issue (read the contribution guidelines for more info).

<!-- Please keep the absolute URLs so it's easier to copy&paste to prisma/prisma/README.md -->

Prisma ORM

Fullstack

Demo	Description
nextjs	Next.js 15 app using the App Router with Prisma Postgres
nextjs-graphql	Next.js app with a GraphQL API (using Apollo Server and GraphQL Nexus)
nextjs-trpc	Next.js app with tRPC
nuxt	Nuxt.js app with a REST API
sveltekit	SvelteKit app using SvelteKit's actions and load functions
remix	Remix app
nuxt-prisma-module	A nuxt example app using the Prisma Nuxt module

Backend only

Demo	Description
graphql-auth	GraphQL server with email-password authentication & permissions
graphql-sdl-first	GraphQL server based on GraphQL Yoga
graphql-subscriptions	GraphQL server with realtime subscriptions based on apollo-server and Nexus Schema
graphql-typegraphql	GraphQL server based on @apollo/server and TypeGraphQL
graphql-typegraphql-crud	CRUD GraphQL API based on @apollo/server and TypeGraphQL
fastify-graphql	GraphQL server based on Fastify, Mercurius, and the SDL-first approach of graphql-tools
fastify-graphql-sdl-first	GraphQL server based on Fastify, Mercurius, and the SDL-first approach of graphql-tools
hapi-graphql	GraphQL server based on Hapi and Nexus Schema
hapi-graphql-sdl-first	GraphQL server based on Hapi and the SDL-first approach of Apollo Server Integration for Hapi
nest-graphql	GraphQL server based on NestJS (code-first)
nest-graphql-sdl-first	GraphQL server based on NestJS and the SDL-first approach of graphql-tools
graphql	GraphQL server based on GraphQL Yoga and Pothos
graphql-nexus	GraphQL server based on @apollo/server and Nexus Schema
grpc	gRPC API including runnable client scripts for testing
postgis-express	Demo of spatial queries using Postgis and Express
express	REST API with Express
fastify	REST API with Fastify
koa	REST API with Koa
hapi	REST API with hapi
nest	REST API with NestJS
script	Usage of Prisma Client JS in a TypeScript script
testing-express	Demo of integration tests with Jest, Supertest and Express

New prisma-client generator

The following examples are fullstack examples using the new prisma-client generator:

Demo	Description
nextjs-starter-webpack	A Next.js 15 starter that uses Webpack 5 as the bundler and runs on Node.js.
nextjs-starter-turbopack	A Next.js 15 starter powered by Turbopack (alpha) for bundling, running on Node.js.
nextjs-starter-webpack-monorepo	A monorepo-based Next.js 15 starter using Webpack 5 and Node.js, managed with pnpm.
nextjs-starter-webpack-with-middleware	A Next.js 15 starter with Webpack 5, running on Node.js for main pages and Vercel Edge Light for middleware.

Prisma Accelerate

The accelerate folder contains examples of projects using Prisma Accelerate for connection pooling and global caching.

Demo	Description
starter	A simple starter project using Prisma Accelerate's caching and connection pooling
nextjs-starter	A Next.js project using Prisma Accelerate's caching and connection pooling
svelte-starter	A SvelteKit project using Prisma Accelerate's caching and connection pooling
solidstart-starter	A Solidstart project using Prisma Accelerate's caching and connection pooling
remix-starter	A Remix project using Prisma Accelerate's caching and connection pooling
nuxt-starter	A Nuxt.js project using Prisma Accelerate's caching and connection pooling
astro-starter	An Astro project using Prisma Accelerate's caching and connection pooling

Prisma Optimize

The optimize folder contains examples of projects using Prisma Optimize to identify and improve the performance of slow queries.

Demo	Description
starter	A Prisma Optimize starter app
optimize-excessive-rows	An example app demonstrating the "Excessive number of rows returned" recommendation provided by Optimize.
optimize-full-table-scan	An example app demonstrating the "Full table scans caused by LIKE operations" recommendation provided by Optimize.
optimize-unindexed-column	An example app demonstrating the "Query filtering on an unindexed column" recommendation provided by Optimize.

Deployment platforms

The projects in the deployment-platforms directory show what "Prisma Client"-based deployment setups look like for various deployment providers. Learn more about deployment in the Prisma documentation.

Real-world & production-ready example projects with Prisma

• Inbox Zero: Open source email management tools to reach inbox zero fast
• NextCRM: An open-source Customer Relationship Management system (CRM)
• Papermark: An open-source DocSend alternative with built-in analytics and custom domains
• Hoppscotch: An open-source API development ecosystem
• FeastQR: An open-source SaaS online menu system for restaurants
• Formbricks: An open-source survey and experience management tool
• OpenformStack: An open-source form backend that allows you to collect form submissions without writing any backend code
• Documenso: An open-source alternative to Docusign
• abby: An open-source feature flag, remote config and A/B testing platform for developers
• ghostfolio: An open-source dashboard for your personal finances
• revert: An open-source unified API to build B2B product integrations
• Scholarsome: An interactive, studying system
• Dittofeed: An open-source customer engagement; intuitive marketing tools that scale
• Trigger.dev: Effortless automation built for developers (Zapier alternative)
• Webstudio: A NoCode visual design tool for building apps and websites
• Dyrector: A self-hosted container management platform
• reduced.to: An open-source link shortener
• Linen: An open-source alternative to Slack and Discord with lots of great features
• Coolify: An open-source & self-hostable Heroku / Netlify alternative
• Dub.co: An open-source link management platform for modern marketing teams
• Umami: A simple, fast, privacy-focused alternative to Google Analytics
• Rallly: A self-hostable doodle poll alternative (based on Next.js, tRPC, and TailwindCSS)
• Typebot: A conversational form builder that you can self-host
• Cal.com: An open-source alternative to Calendly (calender-based event scheduling service)
• Beam: A simple tool that allows members to write posts to share across your organization (based on Next.js)
• Dundring: An in-browser training application created to control and track you training with a smart bike trainer
• Expense.fyi: A tool for tracking and managing expenses
• Letterpad: A publishing platform for creatives
• Teable: A no-code real-time database built on Postgres with a simple interface for enterprise-level app development.

<hr>

Starter kits

• T3 Stack: Starter kit based on Next.js, TypeScript, tRPC, Prisma, Tailwind CSS, and NextAuth.js.
• Indie Stack: Remix Stack for deploying to Fly with SQLite, authentication, testing, linting, and formatting.
• Blues Stack: Remix Stack for deploying to Fly with PostgreSQL, authentication, testing, linting, and formatting.
• NestJS Prisma Starter: NestJS, Prisma, and authentication starter template.
• Supastarter: Full-stack SaaS starter kit using Next.js/Nuxt.js/SvelteKit and Prisma with authentication, emails, payment, testing, linting, and formatting.
• Saas Kit Prisma: Full-stack SaaS starter kit using React.js, Next.js, TypeScript, Tailwind, Shadcn, Stripe, NextAuth, Prisma, Postgres, and Playwright.
• Saas Kit Prisma by BoxyHQ: An open-source enterprise SaaS starter kit using Prisma ORM.
• NextReady: A ready-to-use Next.js boilerplate with Prisma, TypeScript, Tailwind CSS, and more.

Badges

Built something awesome with Prisma? 🌟 Show it off with these badges, perfect for your readme or website.

[![Made with Prisma](http://made-with.prisma.io/dark.svg)](https://prisma.io)

[![Made with Prisma](http://made-with.prisma.io/indigo.svg)](https://prisma.io)

Security

If you have a security issue to report, please contact us at security@prisma.io