Introducing Prisma 2.0
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 minutesCode Editor
12// Creating a new record
Database
| id | firstName | active | |
|---|---|---|---|
| 1 | Patrick | patrick@prisma.io | true |
| 2 | Eden | eden@prisma.io | true |
| 3 | Dylan | dylan@prisma.io | false |
| 4 | Anki | anki@prisma.io | true |
| 5 | Juraci | juraci@prisma.io | false |
Take a Quick Tour
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.
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
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.
Explore the Prisma Client API
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 schemadatasource db {provider = "postgresql"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 18msRun prisma generate to generate Prisma Client.
Connect with other Prisma developers
Join Our Thriving Community
Ready to Try?
Add Prisma to Your App or Start From Scratch
Newsletter
Stay up to date with the latest features and changes to Prisma