• Stars
    star
    6,000
  • Rank 6,719 (Top 0.2 %)
  • Language
    TypeScript
  • License
    Apache License 2.0
  • Created over 6 years ago
  • Updated 4 months ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

🚀 Ready-to-run Prisma example projects

Prisma Examples

Ready-to-run Prisma example projects 🚀

Website   •   Docs   •   Blog   •   Slack   •   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).

TypeScript

Fullstack

Demo Description
rest-nextjs-api-routes Next.js app with a REST API (using Next.js API routes)
rest-nextjs-api-routes-auth Next.js app with a REST API (using Next.js API routes) and authentication (using NextAuth.js)
rest-nextjs-express Next.js app with a REST API (using Express)
rest-nuxtjs Nuxt.js app with a REST API
graphql-nextjs Next.js app with a GraphQL API (using Apollo Server and GraphQL Nexus)
rest-sveltekit SvelteKit app with a REST API
sveltekit SvelteKit app using SvelteKit's actions and load functions
trpc-nextjs Next.js app with tRPC
remix Remix app

Backend only

Demo Description
graphql-apollo-server GraphQL server based on @apollo/server and Nexus Schema
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
graphql-fastify GraphQL server based on Fastify, Mercurius, and the SDL-first approach of graphql-tools
graphql-fastify-sdl-first GraphQL server based on Fastify, Mercurius, and the SDL-first approach of graphql-tools
graphql-hapi GraphQL server based on Hapi and Nexus Schema
graphql-hapi-sdl-first GraphQL server based on Hapi and the SDL-first approach of Apollo Server Integration for Hapi
graphql-nestjs GraphQL server based on NestJS (code-first)
graphql-nestjs-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
rest-express REST API with Express
rest-fastify REST API with Fastify
rest-koa REST API with Koa
rest-hapi REST API with hapi
rest-nestjs 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

JavaScript (Node.js)

Fullstack

Demo Description
rest-nextjs Next.js app with a REST API (using Next.js API routes)
rest-nuxtjs NuxtJS app with a REST API
rest-sveltekit SvelteKit app with a REST API

Backend only

Demo Description
graphql-apollo-server GraphQL server based on @apollo/server
graphql-auth GraphQL server with email-password authentication & permissions
graphql-sdl-first GraphQL server based on GraphQL Yoga
grpc gRPC API including runnable client scripts for testing
rest-express REST API with Express
rest-fastify REST API with Fastify
rest-koa REST API with Koa
script Usage of Prisma Client JS in a Node.js script

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

  • 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: An open-source link shortener with built-in analytics and free custom domains
  • Umami: A simple, fast, privacy-focused alternative to Google Analytics
  • Rallly: A self-hostable doodle poll alternative (based on Next.js, tRPC, and TailwindCSS)
  • snoopForms: An open-source alternative to Typeform (easy online surveys)
  • 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)
  • ironfish-api: Public API for Iron Fish (A novel cryptocurrency focused on privacy and accessibility)
  • Indie Stack: Remix Stack for deploying to Fly with SQLite, authentication, testing, linting, formatting
  • Blues Stack: Remix Stack for deploying to Fly with PostgreSQL, authentication, testing, linting, formatting
  • Tottem: Fullstack app for "social library management" (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.
  • Snippy: An open-source code-snippet sharing website.
  • Hitori: An open-source serverless Discord bot

About this repository

The latest branch of this repository contains the examples with the latest stable version of Prisma CLI and Prisma Client (@latest on npm). These dependencies are kept up to date with a GitHub Action workflow, which updates them every time a new version of Prisma is released.

There are also the automated branches dev and patch-dev, which mirror the code from latest (synced via a GitHub Action workflow), but they use the respective development channels of Prisma CLI and Prisma Client from npm instead (@dev and @patch-dev, also updated via a GitHub Action workflow). Thanks to the test coverage of all projects, this can point us to incompatibilities early.

Security

If you have a security issue to report, please contact us at [email protected]

CI status

CI Status Branch
test latest latest
test dev dev
test patch-dev patch-dev
CI Status
keep-prisma-dependencies-updated
keep-dev-branches-in-sync-with-latest

More Repositories

1

prisma

Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
TypeScript
38,335
star
2

prisma1

💾 Database Tools incl. ORM, Migrations and Admin UI (Postgres, MySQL & MongoDB) [deprecated]
Scala
16,552
star
3

studio

🎙️ The easiest way to explore and manipulate your data in all of your Prisma projects.
1,830
star
4

prisma-client-js

Type-safe database client for TypeScript & Node.js (ORM replacement)
TypeScript
1,468
star
5

prisma-engines

🚂 Engine components of Prisma ORM
Rust
1,173
star
6

docs

📚 Prisma Documentation
MDX
968
star
7

migrate

Issues for Prisma Migrate are now tracked at prisma/prisma. This repo was used to track issues for Prisma Migrate Experimental and is now deprecated.
TypeScript
767
star
8

quaint

SQL Query AST and Visitor for Rust
Rust
582
star
9

tiberius

TDS 7.2+ (Microsoft SQL Server) driver for Rust
Rust
310
star
10

lens

🔬 Prisma design system
TypeScript
287
star
11

language-tools

🌐 Prisma Language Tools = Language Server and Prisma's VS Code extension.
TypeScript
250
star
12

awesome-links

Users browse through a list of curated links and bookmark their favorite ones. Code for prisma.io course.
TypeScript
209
star
13

database-schema-examples

Database Schema Examples we strive to support in Prisma
TSQL
205
star
14

ecosystem-tests

🥼🧬🧪🔬🧫🦠 - Continuously tests Prisma Client with various operating systems, frameworks, platforms, databases and more.
JavaScript
187
star
15

react-native-prisma

TypeScript
176
star
16

prisma-client-extensions

Examples of Prisma Client extensions.
TypeScript
165
star
17

blog-backend-rest-api-nestjs-prisma

A simple backend REST API for a blog built using NestJS, Prisma, PostgreSQL and Swagger.
TypeScript
157
star
18

dataguide

🗄️ Prisma's Data Guide - A growing library of articles focused on making databases more approachable.
MDX
151
star
19

prisma-test-utils

A collection of data model agnostic test utils.
TypeScript
112
star
20

blogr-nextjs-prisma

TypeScript
110
star
21

extension-read-replicas

Prisma Client Extension to add read replica support to your Prisma Client
TypeScript
100
star
22

fullstack-prisma-nextjs-blog

Fullstack Blog with Next.js and Prisma
TypeScript
99
star
23

specs

⚠ This repository is not actively used any more, please check out the Prisma Documentation for updated information on Prisma. ⚠
Go
87
star
24

deployment-example-vercel

Prisma deployment to Vercel example
JavaScript
80
star
25

text-editors

TypeScript
79
star
26

templates

Ready-to-use Prisma schema examples
TypeScript
63
star
27

faunadb-rust

FaundaDB client for Rust
Rust
62
star
28

prisma-templates

Prisma templates for major cloud providers
52
star
29

prisma1-upgrade

Prisma 1 Upgrade is a CLI tool to help Prisma 1 users upgrade to Prisma 2.x or newer.
TypeScript
51
star
30

try-prisma

TypeScript
48
star
31

vim-prisma

Prisma support for Vim
Vim Script
46
star
32

nuxt-prisma

Prisma ORM integration for Nuxt
TypeScript
44
star
33

women-world-wide

JavaScript
40
star
34

codemods

A Collection of Codemods for Prisma 2
JavaScript
34
star
35

prisma-nuxt

Prisma example showing how to use Prisma in a Nuxt application.
Vue
28
star
36

nestjs-workshop-prisma-day-22

REST API for a rudimentary blog - from Prisma Day 22 NestJS workshop
TypeScript
24
star
37

engines-wrapper

🌯 @prisma/engines-version npm package
TypeScript
21
star
38

accelerate-speed-test

TypeScript
19
star
39

prisma-edge-functions

TypeScript
17
star
40

deployment-example-netlify

Prisma deployment to Netlify example
JavaScript
16
star
41

quickstart

🏁 Starter templates for the 5min Quickstart in the Prisma docs.
JavaScript
16
star
42

studio-vercel-guide

A guide to deploying Studio alongside your app on Vercel
JavaScript
15
star
43

demo-sveltekit

Demo app for Sveltekit article
Svelte
13
star
44

prisma-client-extension-starter

Starter template repository for building publishable Prisma Client extensions
TypeScript
12
star
45

prisma-fmt-wasm

💾 Build and release automation for @prisma/prisma-fmt-wasm
Shell
12
star
46

ent

An entity layer for Prisma 1 that uses the DataMapper pattern.
TypeScript
12
star
47

connection-string

connection-string + @pimeys/connection-string
Rust
12
star
48

reflector

🪞 Utilities for meta-level interactions with the Prisma toolkit in Node.js.
TypeScript
12
star
49

prisma1-json-schema

JSON schema of prisma.yml files
TypeScript
11
star
50

engine-images

🖼️ Build & test images for Prisma engines.
Shell
11
star
51

eslint-config-prisma

🧹 Prisma's .eslintrc as an extensible shared config.
JavaScript
11
star
52

pris.ly

Prisma shortlink service (hosted on Vercel)
10
star
53

styles

Shared style resources between Graphcool projects
CSS
9
star
54

pulse-starter

A Pulse starter project. To be used inside of a railway.app template, locally, or with another Pulse-ready database.
TypeScript
7
star
55

prisma1-examples

TypeScript
7
star
56

sublimeText3

Sublime Text 3 package supporting syntax highlighting.
6
star
57

migrate-from-sequelize-to-prisma

A migration guide from Sequelize to Prisma example
JavaScript
6
star
58

opentls

TLS connections for Rust using OpenSSL
Rust
6
star
59

prisma-admin-custom-components

Examples of custom components for Prisma Admin
JavaScript
6
star
60

prisma-content-feedback

Feedback for documentation, articles, tutorials, examples, ...
6
star
61

prisma-admin-feedback

Feedback for Prisma Admin (currently in invite-only preview)
6
star
62

prisma-1-cloud-feedback

Feedback for Prisma Cloud
5
star
63

binding-argument-transform

A library to make Prisma 1 arguments compatible with Prisma 2.
TypeScript
5
star
64

migrate-from-typeorm-to-prisma

TypeScript
5
star
65

pulse-starter-old

A starter project to get you up and running with pulse.
TypeScript
4
star
66

nextjs-edge-functions

Demo of using Next.js with Prisma ORM deployed to Vercel Edge Functions
TypeScript
4
star
67

metrics-tutorial-prisma

Database Metrics with Prisma, Prometheus & Grafana
TypeScript
4
star
68

prisma-day

Prisma Day Code of Conduct
4
star
69

prisma-read-replica-middleware

TypeScript
4
star
70

prisma-platformatic

Prisma 💚 Platformatic exploration
JavaScript
4
star
71

p1-to-p2-upgrade-path-feedback

4
star
72

presskit

Presskit for Prisma
3
star
73

deployment-example-cloudflare-workers

Cloudflare workers deployment example
TypeScript
3
star
74

prisma-example-starter-template

3
star
75

pulse-railway-pg-config

A railway.app project template. Contains a Pulse ready postgres database and set up service. Read more about pulse
TypeScript
3
star
76

tech-writer-task-template

This repository is a template for Technical Writer candidates to use.
JavaScript
3
star
77

orm-benchmarks

Benchmark application to compare query latency of TypeScript ORMs.
JavaScript
3
star
78

fullstack-prisma-turso-embedded-db

TypeScript
2
star
79

db-push-non-idempotent-schemas

Collection of schemas that don't roundtrip if you db pull, then db push
Nix
2
star
80

prisma-fundamentals

An Instruqt lab to introduce students to the Prisma Schema
Shell
2
star
81

prisma-indexes

TypeScript
2
star
82

deployment-example-lambda-serverless-framework

TypeScript
2
star
83

.github

Org level configuration for installed GitHub apps
2
star
84

tracing-tutorial-prisma

Reference code for "Get Started With Tracing Using OpenTelemetry and Prisma Tracing".
TypeScript
2
star
85

benching_setup

TypeScript
2
star
86

client-planning

Placeholder repository for client planning tickets
1
star
87

fivetran-npm-downloads

Python
1
star
88

prisma-client-lib-go

Runtime of Prisma (v1) Go Client.
Go
1
star
89

read-replicas-demo

TypeScript
1
star
90

migrate-from-mongoose-to-prisma

JavaScript
1
star
91

fullstack-prisma-turso

TypeScript
1
star
92

accelerate-nextjs-starter

TypeScript
1
star
93

ci-reports

Repository for various reports from pull requests
HTML
1
star
94

pulse-resend-demo

TypeScript
1
star
95

language-tools-gitpod

Shell
1
star
96

test-vercel-access

HTML
1
star
97

action-node-cache-dependencies

Install and cache node modules.
1
star
98

docs-tools

Python
1
star
99

orm-cloudflare-worker-list-binaries

A cloudflare worker to list the contents of the `prisma-builds` bucket
TypeScript
1
star
100

pdp-spike-nextjs-opentelemetry

TypeScript
1
star