I did not personally evaluate Prisma, but someone I work with did, and they mostly liked it, for these reasons: Good TS support: Auto-generates types based on a schema definition Has entity (schema) definitions Has migrations Good documentation A lot of help with testing/mocking JSON type support Supports MongoDB too Two points against it: No native support in NestJS. We ran into some weirdness with it not behaving in our monorepo/yarn workspaces. I unfortunately don't have the specifics. We ended up choosing MikroORM instead, mostly due to better Nest support. Answer from mackstann on reddit.com
Prisma
prisma.io
Prisma ORM
Prisma gives TypeScript and Node.js teams Prisma ORM, Prisma Postgres, and Prisma Compute: a type-safe ORM, managed Postgres, and Compute for deploying TypeScript apps, from schema to deployed app.
GitHub
github.com › prisma › prisma
GitHub - prisma/prisma: Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB · GitHub
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB - prisma/prisma
Starred by 47.4K users
Forked by 2.4K users
Languages TypeScript 98.9% | JavaScript 0.9% | Shell 0.1% | Dockerfile 0.1% | PLpgSQL 0.0% | Batchfile 0.0%
Is Prisma ORM still next generation, or has it finally become current generation?
I've been on a project using it this year. I have a love/hate relationship with it. The TypeScript integration, generated types, and the ability to represent properly typed queries as objects is super impressive. Sometimes I need to do something and I'm able to just represent it so quickly and easily and I walk truly actively thinking, "damn, thanks Prisma!" The migration model is just a little bit mind numbingly painful to make work in all the ways you often need. But it's fucking fine I guess. And then every now and then there's something you need out of the schema language and there's always a 3 year old Github issue with 3000 👍's on it and it's been marked stale because they didn't respond. They're almost definitely trying to focus their time on their limited monetized products that nobody uses so that they can make money to support the core product. A tale as old as software ♂️ Overall, I would say that I still recommend it, but would also recommend comparing it to alternatives for your use case. It's not a clear winner in every situation. More on reddit.com
210
33
November 14, 2024AMA: I work at Prisma, we're moving from Rust to TS
“instead of relying on a Rust-based query engine, Prisma ORM will pass the query to a WASM compiler, which will return the query plan” I didn’t really follow what this means in the blog post. Why is wasm necessary here? Will the query plan be constructed using Rust? More on reddit.com
53
240
February 17, 2025Sequelize vs Prisma
Sequelize is ancient compared to other ORMs and I couldn't recommend it at this point. Prisma has started getting so blowback as well due to large bundle sizes, and inefficient querying. Personally, I use Drizzle and have no complaints. For more complex queries, I just fallback to raw SQL, which Drizzle also supports. More on reddit.com
50
19
October 9, 2023What's the point in using Prisma with my Supabase backend?
Portable migrations If you ever want to leave Supabase, you can run the same migrations on another Postgres instance (or even another DBMS if its simple enough). Additionally you can have the JS/TS field that is returned from prisma different from what the SQL column name is. For example, in Javascript, camelCase is preferred whereas I see a lot of under_scores in SQL. Prisma allows you to have a SQL column name like member_id but accessible in runtime by memberId. 2. Query Interface The way you query the database is different than Supabase, especially if you have joins. It's more javascript-y and ORM-y than the more SQL like Supabase/Postgrest interface. 3. Raw access Sometimes neither Prisma or the Supabase client is able to generate the SQL you need. The Supabase client doesn't allow you to pass in a raw SQL query whereas Prisma will. This can come up more if you install search extensions or something like PostGIS. Prisma has raw capabilities. However, with Supabase, you can create your own Postgres function and use the Supabase rpc function for more customized SQL queries. Edit: As a sidenote, Drizzle seems to be a promising ORM as an alternative to Prisma More on reddit.com
24
17
June 27, 2023Videos
06:53
A Basic Introduction To Prisma ORM - YouTube
02:36:02
Prisma ORM Full Course 2025 | Become a Prisma Pro in 2.5 Hours ...
08:17
Prisma ORM + Prisma Postgres: 5-Minutes Quickstart - YouTube
11:09
Intro to Prisma ORM - YouTube
Prisma in 100 Seconds
12:27
Master Prisma ORM Node JS Integration: Step by Step Tutorial - YouTube
Reddit
reddit.com › r/node › is prisma a good orm?
r/node on Reddit: Is Prisma a good ORM?
March 24, 2022 -
So I wanted to try Prisma for my new project and it seemed really great. The DX seemed to be really nice but right off the bat I needed polymorphism and I assumed that prisma would have support for it. Turns out there is a github issue for it and turns out the team wants/wanted to do it but currently doesn't support it. Alright, might repeat myself a little but I don't need polymorphism THAT much. I can ignore it.
Right after this, I want to exclude fields/columns like "password". Turns out there is a github issue for that too and it is not supported yet. Ok I can do select: {column1: true, column2: true, ...}. Again, repeating myself a bit but it's not too bad.
And right after that (I don't know if this is a prisma related problem though) I get an error related to big int. And there is also a github issue for the error and the suggested solution is expanding the JSON.stringify prototype which just seems too much.
So now I'm wondering that if I'm just terribly unlucky to encounter these issues all at once or is prisma just really problematic. I remember typeorm didn't have most of these issues but I haven't worked with it so much. And if prisma is problematic, do you have any suggestions? Thanks
Top answer 1 of 16
16
Honestly ive tried several ORMs now. At least 5. Ive never found one that worked properly. They sound great on paper, but in practise i always end up having to do plain SQL. Im still open to a ORM if anyone can point out one that actually does what its supposed to do. I.e. gives the ability to change the datbase design without losing data. Allows me to unit tests my database queries without having to do full system tests.
2 of 16
10
I did not personally evaluate Prisma, but someone I work with did, and they mostly liked it, for these reasons: Good TS support: Auto-generates types based on a schema definition Has entity (schema) definitions Has migrations Good documentation A lot of help with testing/mocking JSON type support Supports MongoDB too Two points against it: No native support in NestJS. We ran into some weirdness with it not behaving in our monorepo/yarn workspaces. I unfortunately don't have the specifics. We ended up choosing MikroORM instead, mostly due to better Nest support.
DEV Community
dev.to › sandrockjustin › the-prisma-orm-a-brief-overview-and-introduction-353m
The Prisma ORM: A Brief Overview and Introduction - DEV Community
December 19, 2024 - Prisma is an object relational mapper (ORM) that can be used alongside several databases including PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, and more. Prisma claims that its main goal is to make application developers more productive when ...
NestJS
docs.nestjs.com › recipes › prisma
Prisma | NestJS - A progressive Node.js framework
Prisma is an open-source ORM for Node.js and TypeScript. It is used as an alternative to writing plain SQL, or using another database access tool such as SQL query builders (like knex.js) or ORMs (like TypeORM and Sequelize).
npm
npmjs.com › package › prisma
prisma - npm
April 22, 2026 - Prisma is an open-source database toolkit. It includes a JavaScript/TypeScript ORM for Node.js, migrations and a modern GUI to view and edit the data in your database. You can use Prisma in new projects or add it to an existing one..
» npm install prisma
Published Apr 22, 2026
Version 7.8.0
Nearform
nearform.com › digital-community › prisma-orm
What is Prisma and Why Do We Need Another ORM? | Nearform
June 9, 2021 - Prisma is a next-generation object–relational mapper (ORM) that claims to help developers build faster and make fewer errors. Prisma takes a different approach to ORMs compared to traditional ORMs.
Medium
medium.com › @pushkarajworkspace › introduction-to-prisma-orm-a-beginners-guide-60cf045d3583
Introduction to Prisma ORM: A Beginner’s Guide | by Pushkarajworkspace | Medium
March 17, 2025 - Introduction to Prisma ORM: A Beginner’s Guide What is Prisma? Prisma is a modern Object-Relational Mapper (ORM) that simplifies database access in Node.js and TypeScript applications. It provides …
Reddit
reddit.com › r/node › is prisma orm still next generation, or has it finally become current generation?
r/node on Reddit: Is Prisma ORM still next generation, or has it finally become current generation?
November 14, 2024 -
I always find it funny that tools describe them as 'next-gen' either stay in the 'upcoming' or 'next-gen' status, or die out before they become current lol. Did they finally fix their SQL joins?
Top answer 1 of 22
60
I don't use it. It did (not sure if it's fixed) have a famously bad n+1 problem that caused huge performance issues because it did joins in the app code instead of having the database do the join. Personally, I prefer as little abstraction over the database as possible. But to each their own. Just make sure you understand the tradeoffs.
2 of 22
27
I've been on a project using it this year. I have a love/hate relationship with it. The TypeScript integration, generated types, and the ability to represent properly typed queries as objects is super impressive. Sometimes I need to do something and I'm able to just represent it so quickly and easily and I walk truly actively thinking, "damn, thanks Prisma!" The migration model is just a little bit mind numbingly painful to make work in all the ways you often need. But it's fucking fine I guess. And then every now and then there's something you need out of the schema language and there's always a 3 year old Github issue with 3000 👍's on it and it's been marked stale because they didn't respond. They're almost definitely trying to focus their time on their limited monetized products that nobody uses so that they can make money to support the core product. A tale as old as software ♂️ Overall, I would say that I still recommend it, but would also recommend comparing it to alternatives for your use case. It's not a clear winner in every situation.
PingCAP
pingcap.com › home › articles › understanding prisma orm
Understanding Prisma ORM
December 12, 2024 - What is Prisma? Prisma ORM is a cutting-edge tool that simplifies database interactions for Node.js and TypeScript applications. In modern web development, Object-Relational Mappers (ORMs) are crucial as they bridge the gap between relational ...
Paigeniedringhaus
paigeniedringhaus.com › blog › tips-and-tricks-for-using-the-prisma-orm
Tips and Tricks for Using the Prisma ORM | Paige Niedringhaus
Prisma.io is a very powerful, very popular, JavaScript-friendly ORM for interacting with all sorts of databases.
GitHub
github.com › lewisojile › Prisma-ORM
GitHub - lewisojile/Prisma-ORM · GitHub
Prisma replaces traditional ORMs and simplifies database workflows:
Author lewisojile
Mondrianframework
mondrianframework.com › docs › docs › guides › prisma
Prisma ORM Integration
The Node.js framework for building modular server-side applications ready to evolve
Better Stack
betterstack.com › community › guides › scaling-nodejs › prisma-orm
Getting Started with Prisma ORM for Node.js and PostgreSQL | Better Stack Community
Prisma is an ORM that consists of three main components: Prisma Client, Prisma Schema, and Prisma Migrate.
Thoughtworks
thoughtworks.com › home, united states, english › insights › technology radar | guide to technology landscape › languages & frameworks › prisma orm
Prisma ORM | Technology Radar | Thoughtworks United States
Prisma ORM is an open-source database toolkit that simplifies working with databases in Node.js and TypeScript applications. It offers a modern, type-safe approach to database access, automates database schema migrations and provides an intuitive ...
WorkOS
workos.com › blog › prisma-orm-for-typescript
Prisma ORM for TypeScript - A technical primer — WorkOS
April 10, 2025 - Prisma is one of the most popular Object-Relational Mappers (ORMs) in the TypeScript/JavaScript ecosystem due to its robust type-safety guarantees and seamless integration with frameworks like Next.js.
Reddit
reddit.com › r › prismaorm › hot
r/prismaorm
January 14, 2021 - r/prismaorm: Prisma: Next-generation ORM for Node.js and TypeScript
Mintlify
mintlify.com › explore › prisma › prisma
Introduction to Prisma ORM - Prisma ORM
March 1, 2026 - Prisma ORM is a next-generation ORM that makes working with databases easy and type-safe.
Medium
tanmayshende007.medium.com › prisma-orm-a-comprehensive-guide-with-examples-c85d5770b226
Prisma ORM: A Comprehensive Guide with Examples | by Tanmay Shende | Medium
May 15, 2024 - What is Prisma ORM? Prisma is an open-source ORM (Object-Relational Mapping) tool for Node.js and TypeScript applications. It provides a type-safe way to interact with databases by generating code based on your data model definitions.
Medium
medium.com › yavar › prisma-next-generation-orm-377bc633ed52
Prisma- Next generation ORM
July 28, 2022 - Prisma is a next-generation ORM that makes working with databases easy for application developers.