Sitemap
- Prisma - Database tools for modern application development
- About Prisma
- Prisma Migrate - Hassle-free database migrations
- Prisma Studio - Explore and manipulate your data
- Community - Prisma
- Next.js | Prisma
- GraphQL | Prisma
- Apollo | Prisma
- NestJS | Prisma
- Express | Prisma
- Hapi | Prisma
- Jobs at Prisma
- Prisma Ambassador Program
- Prisma Day 2021
- Prisma Day 2020
- Prisma Enterprise Event 2021
- Prisma Day 2019
Main site
- Concepts
- System requirements
- Getting started
- Guides
- Reference
- Creating bug reports for Prisma
- About
- Support
- Set up Prisma
- Why Prisma? Comparison with SQL query builders & ORMs
- Should you use Prisma as a Node.js/TypeScript ORM?
- Overview
- What is introspection? (Reference)
- Prisma Studio (Reference)
- Prisma Data Platform (Concept)
- Components
- PostgreSQL database connector (Reference)
- MySQL database connector (Reference)
- SQLite database connector (Reference)
- MongoDB database connector
- Database connectors
- Telemetry (Reference)
- Telemetry and Editor Setup
- Example schemas and queries
- Seeding your database
- Schema prototyping with db push
- Patching / hotfixing a database in production
- Editor and IDE setup
- Migration troubleshooting in production
- Development environment
- Query optimization
- Performance and optimization
- Transactions
- Integration testing with Prisma
- Testing with Prisma
- Deploying projects using Prisma to the cloud
- Deploying database changes with Prisma Migrate
- Deploy a Node.js application with Prisma
- Upgrading to use Preview features (Guides)
- Upgrade from Graphcool to Prisma 2
- How to migrate from TypeORM to Prisma
- Upgrading (Guides)
- How to migrate from Sequelize to Prisma
- Migrate to Prisma (Guides)
- General Guides
- Prisma CLI Command Reference
- Prisma error reference (Reference)
- Prisma environment variables reference
- API Reference
- Connection URLs (Reference)
- Database features matrix (Reference)
- Databases supported by Prisma
- Database Reference
- Autocompletion in GraphQL resolvers with JavaScript
- Modeling and querying many-to-many relations
- Querying models based on their relations existence
- Best practice for instantiating PrismaClient with Next.js
- Help articles (Support)
- Releases and maturity levels
- Ready-to-run examples for various Prisma use cases
- Prisma Roadmap – See what we are working on next
- Limitations
- About Prisma
- Prisma FAQs
- About the Prisma documentation
- About Prisma docs
- Database (Guides)
- Start from scratch with Prisma
- What is Prisma? (Overview)
- Building REST APIs with Prisma
- Building GraphQL servers with Prisma
- Data modeling with Prisma
- How Prisma fits into your stack
- Data sources (Reference)
- Generators (Reference)
- Is Prisma an ORM? | What is an ORM?
- Names in the underlying database
- Data model (Reference)
- Supporting features without a PSL equivalent
- Select fields (Concepts)
- CRUD (Reference)
- Pagination (Reference)
- Prisma schema (Reference)
- Filtering and sorting (Reference)
- Relation queries (Concepts)
- Transactions and batch queries (Reference)
- Case sensitivity (Reference)
- Full-Text Search (Preview)
- Aggregation, grouping, and summarizing (Concepts)
- Raw database access (Reference)
- Database polyfills (Concepts)
- Null and undefined (Reference)
- Prisma Client (Reference)
- Module bundlers (Reference)
- Debugging (Reference)
- Handling exceptions and errors (Reference)
- Supported database types and features
- db push
- Shadow database
- Legacy Prisma Migrate (Reference)
- Prisma Migrate limitations and known issues
- Prisma CLI
- Prisma Migrate | Database, Schema, SQL Migration Tool
- Prisma CLI Installation (Reference)
- Prisma CLI preview features
- Query engine (Concepts)
- Prisma engines
- Prisma Client and schema preview features
- Preview features (Reference)
- SQL Server on Windows
- SQL Server on Docker
- Microsoft SQL Server
- Prisma vs TypeORM
- Prisma vs Mongoose
- Prisma vs Sequelize
- Team development with Prisma Migrate
- Comparing Prisma to other ORMs and ODMs.
- Enable extensions for native database functions
- Baselining a database
- Adding Prisma Migrate to an existing project
- Include unsupported database features
- Customizing migrations
- Developing with Prisma Migrate
- Advanced database tasks (Guides)
- Using multiple .env files.
- Create SQL views with Prisma and PostgreSQL)
- Create SQL views with Prisma and MySQL
- Migration troubleshooting in development
- Managing .env files and setting variables
- Configure Prisma Client with PgBouncer
- Environment variables
- Deploying to AWS Lambda
- Connection management (Guide)
- How to deploy a Prisma app to Vercel
- Deploy a Prisma app to Heroku
- How to deploy a REST API to Azure Functions with Azure SQL
- Deploying to a different OS
- Deploying migrations from a local environment
- Deploying to Netlify
- Platforms Prisma supports for deployment
- Caveats when deploying to AWS platforms
- Codemods (Guides)
- Upgrading versions (Guides)
- How to upgrade from Prisma 1 to Prisma 2
- Schema Incompatibilities | PostgreSQL
- Schema Incompatibilities | MySQL
- Upgrading a REST API from Prisma 1 to Prisma 2
- Upgrade Prisma 1 with nexus-prisma to @nexus/schema
- Upgrading from Prisma 1 with prisma-binding to Nexus
- Upgrading from Prisma 1 with prisma-binding to SDL-first
- Upgrade from Prisma 1 to Prisma 2
- Database workflows (Guides)
- Writing template (About)
- MDX components in the Prisma docs
- Upgrading the Prisma layer to Prisma 2 | PostgreSQL
- Upgrading the Prisma layer to Prisma 2 | MySQL
- Frontmatter
- Prisma documentation style guide
- Connect your database
- Connect your database
- Connect your database
- Connect your database
- Connect your database
- Connect your database
- Using Prisma Migrate
- Using Prisma Migrate
- Using Prisma Migrate
- Using Prisma Migrate
- Using Prisma Migrate
- Using Prisma Migrate
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Querying the database
- Querying the database
- Querying the database
- Querying the database
- Querying the database
- Querying the database
- Next steps
- Next steps
- Next steps
- Next steps
- Next steps
- Next steps
- Start from scratch with relational databases (15 min)
- Start from scratch with relational databases (15 min)
- Start from scratch with relational databases (15 min)
- Start from scratch with relational databases (15 min)
- Start from scratch with relational databases (15 min)
- Start from scratch with relational databases (15 min)
- Creating the Prisma schema
- Creating the Prisma schema
- Connect your database
- Connect your database
- Install Prisma Client
- Install Prisma Client
- Querying the database
- Querying the database
- Start from scratch with MongoDB (15 min)
- Start from scratch with MongoDB (15 min)
- Connect your database
- Connect your database
- Connect your database
- Connect your database
- Connect your database
- Connect your database
- Next steps
- Next steps
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Introspection
- Introspection
- Introspection
- Introspection
- Introspection
- Introspection
- Next steps
- Next steps
- Next steps
- Next steps
- Next steps
- Next steps
- Querying the database
- Querying the database
- Querying the database
- Querying the database
- Querying the database
- Querying the database
- Add Prisma to an existing project that uses a relational database (15 min)
- Add Prisma to an existing project that uses a relational database (15 min)
- Add Prisma to an existing project that uses a relational database (15 min)
- Add Prisma to an existing project that uses a relational database (15 min)
- Add Prisma to an existing project that uses a relational database (15 min)
- Add Prisma to an existing project that uses a relational database (15 min)
- Connect your database
- Connect your database
- Creating the Prisma schema
- Creating the Prisma schema
- Install Prisma Client
- Install Prisma Client
- Querying the database
- Querying the database
- Next steps
- Next steps
- Add Prisma to an existing MongoDB project (15 min)
- Add Prisma to an existing MongoDB project (15 min)
- One-to-one relations
- One-to-many relations
- Relations (Reference)
- Many-to-many relations
- Self-relations
- Troubleshooting relations
- Generating the client (Concepts)
- Connecting and disconnecting (Concepts)
- Configuring logging (Concepts)
- Configuring error formatting (Concepts)
- Working with PrismaClient (Concepts)
- Working with scalar lists/arrays (Concepts)
- Working with Json fields (Concepts)
- Working with fields (Concepts)
- Operating against partial structures of your model types
- Prisma validator
- Advanced type safety (Reference)
- Soft delete middleware (Reference)
- Logging middleware (Reference)
- Session Data Middleware (Reference)
- Middleware (Reference)
- Configure cascading deletes with Prisma and PostgreSQL
- Configure cascading deletes with Prisma and MySQL
- Cascading deletes (Guide)
- Configure cascading deletes with Prisma and SQLite
- Data validation with CHECK constraints (PostgreSQL)
- Advanced data validation (Guides)
- Named constraints upgrade path
- Upgrade to Prisma 3
- Referential actions upgrade path
- Unique constraints & indexes with Prisma and PostgreSQL
- Unique constraints and indexes with Prisma and MySQL
- Unique constraints and indexes with Prisma and SQLite
- Add unique constraints & indexes to your database schema
- Configure foreign keys with Prisma and PostgreSQL
- Configure foreign keys with Prisma and MySQL
- Configure foreign keys with Prisma and SQLite
- Foreign keys
- Special rules for referential actions in SQL Server
- Referential actions
- Using custom model and field names (Concepts)
- Connection pool
- Instantiating the client (Concepts)
- Prisma schema API (Reference)
- Prisma Client API (Reference)
- What's new in Prisma docs
- Unit testing with Prisma
Documentation
- Connections, Edges & Nodes in Relay
- GraphQL Query Parameters - Best Practices for GraphQL API Design
- Relay Modern’s @connection directive
- GraphQL SDL — Schema Definition Language
- New Tooling to Improve Your GraphQL Workflows
- Introducing GraphQL Playground
- How to enable CORS for Express-GraphQL & Apollo Server
- Prisma raises $4.5M to build the GraphQL data layer for all databases
- How We're Constantly Improving the Performance of Prisma
- How HyreCar rewrote their app in 60 days with Prisma
- New Release Process for Prisma
- How Labelbox Supports Vast Machine Learning Needs with Prisma
- Prisma Admin (Beta): A Modern UI to Manage Your Data
- Announcing Prisma Day
- The Guild Takes over Development of the GraphQL CLI & Other Libraries
- Watch the Talks from Prisma Day 2019!
- State of Prisma 2 (December 2019)
- Prisma 2.10 Adds Preview Support for Microsoft SQL Server
- Prisma Studio - A Visual Interface for Your Database
- How Prisma Helps Rapha Manage Their Mobile Application Data
- Announcing Tweets for Trees
- How iopool refactored their app in less than 6 months with Prisma
- A Collaborative Data Browser for Your Database on the Web
- Prisma Ambassador Program — Building A Community of Experts
- How Poppy Uses Prisma Client to Ship Confidently
- New Course: Fullstack App Using Next.js, GraphQL, TypeScript & Prisma
- How Prisma Allowed Pearly to Scale Quickly with an Ultra-Lean Team
- Prisma Adopts Semantic Versioning (SemVer)
- Improving Performance with Apollo Query Batching
- How to use `create-react-app` with GraphQL & Apollo
- How to use `create-react-native-app` with GraphQL & Apollo
- All you need to know about Apollo Client 2
- GraphQL Server Basics: The Network Layer
- GraphQL Directive Permissions — Authorization Made Easy
- Reasons to use GraphQL | Top 5 Reasons Why and How to use GraphQL
- Open Sourcing GraphQL Middleware - Library to Simplify Your Resolvers
- GraphQL Europe 2018: The GraphQL community comes together in Berlin
- Prisma Client (Preview): Simplified & Type-safe Database Access
- Introducing GraphQL Nexus: Code-First GraphQL Server Development
- How Prisma and GraphQL fit together
- Prisma 2 is Coming Soon
- Prisma Raises $12M to Build the Next Generation of Database Tools
- How Prisma Supports Database Transactions
- Prisma Migrate Preview - Database Migrations Simplified
- Nexus 1.0: A Major Release for Type-Safe, Code-First GraphQL APIs
- 5 Tools for Documenting Your Web API
- How Grover Moves Faster with Prisma
- How migrating from Sequelize to Prisma allowed Invisible to scale
- Prisma 2.27 Adds Preview Support for MongoDB
- How to build a Real-Time Chat with GraphQL Subscriptions and Apollo 🌍
- GraphQL Server Basics: GraphQL Schemas, TypeDefs & Resolvers Explained
- How do GraphQL remote schemas work?
- GraphQL Schema Stitching explained: Schema Delegation
- Tutorial: Building a Realtime GraphQL Server with Subscriptions
- The Problems of "Schema-First" GraphQL Server Development
- Using GraphQL Nexus with a Database
- New Datamodel Syntax: More Schema Control & Simpler Migrations
- Prisma 2 Preview: Type-safe Database Access & Declarative Migrations
- Prisma 2.0 is in Beta: Type-safe Database Access with Prisma Client
- Backend with TypeScript, PostgreSQL & Prisma: CI & Deployment
- Jamstack with Next.js and Prisma
- Build an App With Svelte and TypeScript
- Full Stack Type Safety with Angular, Nest, Nx, and Prisma
- Database Access in React Server Components
- Hassle-Free Database Migrations with Prisma Migrate
- Application Monitoring Best Practices
- Microsoft SQL Server Support in Prisma is Production-Ready
- Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: Data Modeling
- GraphQL vs Firebase
- How to wrap a REST API with GraphQL - A 3-step tutorial
- GraphQL Basics: Demystifying the `info` Argument in GraphQL Resolvers
- Tutorial: Render Props in React Apollo 2.1
- Prisma 2.0: Confidence and productivity for your database
- Learn TypeScript: A Pocketguide Tutorial
- What's new in Prisma? (Q1/21)
- The Complete ORM for Node.js & TypeScript
- What's new in Prisma? (Q2/21)
- Relay vs Apollo - Comparing GraphQL clients for React apps
- Backend with TypeScript PostgreSQL & Prisma: Data Modeling & CRUD
- Getting Started with Relay Modern
- Backend with TypeScript, PostgreSQL & Prisma: REST, Validation & Tests
- Backend with TypeScript, PostgreSQL & Prisma: Authentication & Authz
- Building a fullstack app using TypeScript, PostgreSQL, Next.js, GraphQL and Prisma
- What is Nexus and how to use it to build GraphQL servers?
- Building a modern backend with TypeScript, PostgreSQL and Prisma
Blog
- Setting up a local SQL Server database
- Top 11 Node.js ORMs, Query Builders & Database Libraries in 2021
- Introduction to database schemas
- Comparing SQL, query builders, and ORMs
- What are databases?
- Connecting to PostgreSQL databases
- What are database migrations?
- Prisma's Data Guide - Articles to make databases more approachable
- Creating and deleting databases and tables with SQLite
- Managing privileges in PostgreSQL with grant and revoke
- Comparing database types: how database types evolved to meet different needs
- Introduction to databases
- An introduction to PostgreSQL column and table constraints
- Intro (Don't Panic)
- Tables, Tuples, Types
- Correctness and Constraints
- Know Your Problem Space
- Making Connections
- In Vivo: Information Ecosystems
- Data Modeling
- Database types
- Functional Units
- The benefits of PostgreSQL
- Getting to know PostgreSQL
- Setting up a local PostgreSQL database
- 5 ways to host PostgreSQL databases
- PostgreSQL
- How to create and delete databases and tables in PostgreSQL
- An introduction to PostgreSQL data types
- 5 ways to host MySQL databases
- Connecting to MySQL databases
- How to create and delete databases and tables in MySQL
- Setting up a local MySQL database
- MySQL
- Importing and exporting data in SQLite
- An introduction to MySQL data types
- SQLite
- Setting up a local SQLite database
- An introduction to MySQL column and table constraints
- Microsoft SQL Server
- Connecting to MongoDB databases
- Setting up a local MongoDB database
- How to manage users and authentication in MongoDB
- How to manage authorization and privileges in MongoDB
- How to manage databases and collections in MongoDB
- How to manage documents in MongoDB
- How to query and filter documents in MongoDB
- MongoDB
- Top 8 TypeScript ORMs, Query Builders, & Database Libraries: Evaluating Type Safety
- Database tools | SQL, MySQL, Postgres | Prisma's Data Guide
- Troubleshooting Database Outages and Connection Issues
- How to Spot Bottlenecks in Performance
- Syncing Development Databases Between Team Members
- Managing databases | Prisma's Data Guide
- Strategies for deploying database migrations
- Using the expand and contract pattern for schema changes
- Relational Databases
- An introduction to authorization and authentication in PostgreSQL
- Configuring PostgreSQL user authentication
- Managing roles and role attributes in PostgreSQL
- Authentication and authorization
- How to insert and delete data in PostgreSQL
- How to update existing data in PostgreSQL
- Importing and exporting data in PostgreSQL
- How to use `INSERT ON CONFLICT` to upsert data in PostgreSQL
- Inserting and modifying data
- How to perform basic queries with `SELECT` in PostgreSQL
- Understanding and using transactions in PostgreSQL
- Using joins to combine data from different tables in PostgreSQL
- How to filter query results in PostgreSQL
- Reading and querying data
- How to use single and double quotes in PostgreSQL
- Short guides
- How to manage privileges with roles in MySQL
- Authentication and authorization
- An introduction to authorization and authentication in MySQL
- How to insert and delete data in MySQL
- How to update existing data in MySQL
- How to use `GRANT` and `REVOKE` to manage privileges in MySQL
- How to manage users and authentication in MySQL
- How to use `ON DUPLICATE KEY UPDATE` to upsert data in MySQL
- Understanding and using transactions in MySQL
- Importing and exporting data in MySQL
- Inserting and modifying data
- How to perform basic queries with `SELECT` in MySQL
- How to filter query results in MySQL
- Reading and querying data
- Using joins to combine data from different tables in MySQL
Data Guide
Newsletter
Stay up to date with the latest features and changes to Prisma
Find Us
Prisma © 2018-2021.
Made with ❤️ in Berlin and worldwide