Skip to content

prisma/prisma-examples

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Prisma Examples

Ready-to-run Prisma example projects πŸš€

Website Β Β β€’Β Β  Docs Β Β β€’Β Β  Blog Β Β β€’Β Β  Discord Β Β β€’Β Β  Twitter Β Β β€’Β Β  Demo videos


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).

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-api-routes-auth Next.js app with a REST API (using Next.js API routes) and authentication (using NextAuth.js)
nextjs-express Next.js app with a REST API (using Express)
nuxt Nuxt.js app with a REST API
nextjs-graphql Next.js app with a GraphQL API (using Apollo Server and GraphQL Nexus)
sveltekit SvelteKit app using SvelteKit's actions and load functions
nextjs-trpc Next.js app with tRPC
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

Made with Prisma Made with Prisma

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 [email protected]