P
License:Apache-2.0
Open source Self-hostable Prisma
About
A next-generation Node.js and TypeScript ORM with a declarative schema, type-safe queries and powerful migrations. Works with Postgres, MySQL, SQLite, SQL Server and MongoDB.
Pricing
Free
Prisma is an open-source ORM that makes database access type-safe and ergonomic. You define models in the Prisma Schema, and Prisma generates a fully typed client plus migration tooling.
Key Features
- Declarative schema in
schema.prisma. - Type-safe queries with full autocompletion.
- Migrations for versioned schema changes.
- Relations, enums and indexes supported natively.
- Prisma Studio: visual data browser.
- Works with PostgreSQL, MySQL, SQLite, SQL Server, MongoDB and CockroachDB.
Pricing
Prisma ORM is free and open source under Apache-2.0. Prisma Postgres and Prisma Pulse (cloud data platform) are separately priced.
Getting Started
npm install prisma --save-dev
npx prisma init
datasource db { provider = "postgresql", url = env("DATABASE_URL") }
Define models, run npx prisma migrate dev, and import the generated PrismaClient for type-safe queries.