Awesome
<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> • </span> <a href="https://www.prisma.io/docs/">Docs</a> <span> • </span> <a href="https://www.prisma.io/blog">Blog</a> <span> • </span> <a href="https://pris.ly/discord/">Discord</a> <span> • </span> <a href="https://twitter.com/prisma">Twitter</a> <span> • </span> <a href="https://www.youtube.com/watch?v=0RhtQgIs-TE&list=PLn2e1F9Rfr6k9PnR_figWOcSHgc_erDr5&index=1">Demo videos</a> </div> <hr> <div align="center">
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 Accelerate
The accelerate folder contains examples of projects using Prisma Accelerate for connection pooling and global caching.
| Demo | Description |
|---|---|
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 Pulse
The pulse folder contains examples of projects using Prisma Pulse to listen to real-time database change events.
| Demo | Description |
|---|---|
starter | A Prisma Pulse starter app |
email-with-resend | An example app to send emails to new users using Prisma Pulse and Resend |
fullstack-leaderboard | A live leaderboard (built with Next.js) |
fullstack-simple-chat | A simple chat app (built with Next.js & Express) |
product-search-with-typesense | A cron job that syncs data into Typesense (built with Hono.js) |
data-sync-with-bigquery | A script that automatically syncs data into Google BigQuery |
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. |
Prisma ORM
Fullstack
| Demo | Description |
|---|---|
nextjs-api-routes | Next.js app with a REST API (using Next.js API routes) |
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 |
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.
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.
[](https://prisma.io)
[](https://prisma.io)
Security
If you have a security issue to report, please contact us at security@prisma.io