When comparing Sequelize vs Prisma, the Slant community recommends Prisma for most people. In the question“What are the best JavaScript ORMs?” Prisma is ranked 2nd while Sequelize is ranked 5th.
Ranked in these QuestionsQuestion Ranking
Pros
Pro Compatible with MSSQL
Sequelize has an offical MSSQL dialect for interacting with MSSQL databases.
Pro Great documentation
Pro Type safety
Prisma generates types out of a schema, enabling type safety across your application
Pro TypeScript native support
Pro VSCode plugin
Great support for VSCode with autocompletion, quick fixes, syntax highlighting of the Prisma schema
Pro Introspection
Introspects your database to generate a schema you can use to generate your client makes it simple to get started with existing databases.
Pro Declarative single source of truth for your database schema
Pro Integrated migration tool
Prisma Migrate makes it easy to create migrations for production.
Pro Great support
Actually responds on issues or the Prisma Slack with helpful answers.
Cons
Con No support for code first models
Can't add models in code first. You have to use Prisma's files to define your models and then let it generate the code for you.
Con Lack of NoSQL Support
Currently doesn't officially support NoSQL databases. There is a connector in preview for MongoDB, but no word on when it'll be fully released yet.