Prisma Database Toolkit

Prisma is a free and open-source next-generation Node.js and TypeScript ORM (Object-Relational Mapper) that provides a type-safe database client, declarative schema definition, and automated database migrations. Founded by Johannes Schickling in 2015 as the Graphcool framework (later renamed to Prisma), the company is headquartered in Berlin, Germany, and has raised over $40 million in funding (Series A from Kleiner Perkins in 2021). Prisma has become one of the most popular ORMs for Node.js, used by companies like AOL, Elastic, and GitHub. Key features: Prisma Schema: a declarative schema definition language (.prisma files) that describes database models (tables), fields, types, and relationships (one-to-many, many-to-many, one-to-one). The schema is the single source of truth for the database structure. Prisma Client: an auto-generated, type-safe query builder based on the schema definition. Queries are fully type-checked at compile time, catching errors before runtime. The client supports filtering, sorting, pagination, nested reads/writes, transactions, and raw SQL queries. Prisma Migrate: a declarative migration system that generates SQL migration files from schema changes. Developers modify the schema, run prisma migrate dev to generate and apply migrations in development, and prisma migrate deploy in production. Migration history is tracked for auditability. Database support: PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, and CockroachDB. Connection pooling via Prisma Data Proxy for serverless deployments. Prisma Studio: a visual database browser GUI for viewing and editing data. Prisma Accelerate: edge caching and connection pooling service. Prisma Pulse: real-time database change events via CDC (Change Data Capture). Written in Rust (query engine) and TypeScript (client). Apache-2.0.