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 minutes12// Creating a new record
| 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
- 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.
- 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.
- 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
Find Us
Prisma © 2018-2020
Made with ❤️ in Berlin