Prisma

Prisma is an open-source next-generation TypeScript and Node.js ORM created by the Prisma team formerly known as Graphcool, founded by Johannes Schickling in 2016 and headquartered in Berlin, providing a type-safe database client, declarative schema modeling, migration management, and a visual database browser, adopted by over two hundred fifty thousand weekly npm downloaders and companies including Auth0, Vercel, Tripadvisor, and Decathlon for database access in TypeScript applications, supporting PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, and CockroachDB. The Prisma schema defines database models using a declarative domain-specific language with relations, enums, indexes, and constraints, serving as the single source of truth that generates fully type-safe client code through the Prisma Client, eliminating the entire class of SQL injection vulnerabilities and type mismatch errors that plague raw SQL and traditional ORMs, with auto-completion for all queries in VS Code and other editors. The query builder provides a fluent, type-safe API for CRUD operations, filtering, sorting, pagination, nested inserts and updates, transactions, and raw SQL escape hatches, with the query engine automatically optimizing joins and reducing the number of database round trips through batch queries and prefetching related records. The migration system generates SQL migration files from schema changes, with a declarative migration workflow that ensures database schema stays in sync with the schema file, supporting development, preview, and production migrations with zero-downtime deployment strategies. The Prisma Studio provides a visual database browser for inspecting and editing records. The Data Platform offers connection pooling through PgBouncer, database monitoring, and edge caching. Designed for TypeScript developers, full-stack engineers, and backend teams.