Introducing Prisma 2

Modern Database Access for TypeScript & Node.js

Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.

Try Prisma in 5 minutes
Code Editor
1
2
// Creating a new record
Database
idfirstNameemailactive
1Patrickpatrick@prisma.iotrue
2Edeneden@prisma.iotrue
3Dylandylan@prisma.iofalse
4Ankianki@prisma.iotrue
5Juracijuraci@prisma.iofalse
Supported databases

Take a
Quick Tour

Setup Prisma
Play VideoPlay Video

Be More Productive with Your Database

Prisma makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders. Start with a new database or introspect an existing one to get started. Prisma currently supports PostgreSQL, MySQL & SQLite – more to come!
API Server
  • No more CRUD boilerplate
  • Supports all web frameworks

Designed for building APIs
(REST, GraphQL, gRPC, ...)

Prisma is the perfect companion for building web APIs. It saves repetitive CRUD boilerplate and provides a flexible API for common use cases such as pagination and filtering.

prisma.user.findMany();
Prisma Client
  • Developer-friendly API
  • Autocompletion for DB queries

Focus on your data –
not on complex SQL queries

Prisma Client makes it easy to reason about database queries. No more debugging of SQL or complex ORM models – only an intuitive API and plain old JavaScript objects.

SELECT * from User;
Database
  • Tailored to your data
  • Incrementally adoptable
  • Postgres
  • MySQL
  • SQLite

Incremental adoption with your existing database

Introspect your database schema and start sending queries with Prisma Client. You can use Prisma Client side-by-side with existing ORMs or SQL queries in your application.

Try a Prisma Example

REST API
View all example projects

Explore the Prisma Client API

Read the full API reference in the documentation.
Getting started
Reading data
Writing data
Selecting fields

Installation & DB Setup

# Install Prisma CLI 
 
$ npm install @prisma/cli --save-dev
# Create Prisma schema in current directory 
 
$ npx prisma init
Show the result
✔ Your Prisma schema was created at prisma/schema.prisma.
  You can now open it in your favorite editor.
// prisma/schema.prisma
// Connect database via environment variable in Prisma schema
 
datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}
# Introspect your database schema 
 
$ npx prisma introspect
Show the result
Introspecting based on datasource defined in prisma/schema.prisma …
 
✔ Wrote Prisma data model into prisma/schema.prisma in 18ms
 
Run prisma generate to generate Prisma Client.

Connect with other Prisma developers

Join Our Thriving Community

Photographs

So happy we chose @prisma Client & Migrate for @redwoodjs. Finally we have something akin to Rails' ActiveRecord but for JavaScript & the future of JAMstack apps!

avatar
Tom Preston-Werner
GitHub Co-Founder

Prisma Youtube Channel

For livestreams, videos & meetups

Slack

Join 30,000 Prisma fans

GitHub

Submit issues and ask questions

Image of a CLI

Ready to Try?

Add Prisma to Your App or Start From Scratch

Try Prisma in 5 minutes
Prisma Logo

Products

Prisma ClientPrisma 1 Cloud

Resources

DocsGet StartedAPI ReferenceExamplesHow to GraphQLData GuidePrisma with Next.js

Community

Meet the CommunitySlackGitHubDiscussionsGraphQL MeetupTypeScript Meetup

Company

AboutJobsCauses Black Lives MatterBlogTerms & PrivacyHTML Sitemap

Newsletter

Stay up to date with the latest features and changes to Prisma

Find Us

Prisma © 2018-2020.

Made with ❤️ in Berlin and worldwide