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
- Getting started
- Concepts
- Guides
- Reference
- Creating bug reports for Prisma
- Support
- About the Prisma documentation
- Limitations
- What's new in Prisma docs
- Prisma Roadmap – See what we are working on next
- Prisma FAQs
- About
- Releases and maturity levels
- Ready-to-run examples for various Prisma use cases
- Set up Prisma
- Why Prisma? Comparison with SQL query builders & ORMs
- Overview
- Prisma Studio (Reference)
- Should you use Prisma as a Node.js/TypeScript ORM?
- Components
- Prisma Data Platform (Concept)
- SQLite database connector (Reference)
- Microsoft SQL Server database connector (Reference)
- MySQL database connector (Reference)
- PostgreSQL database connector (Reference)
- Telemetry (Reference)
- Database connectors
- Editor and IDE setup (Reference)
- What is introspection? (Reference)
- Patching / hotfixing a database in production
- Telemetry and Editor Setup
- Migration troubleshooting in production
- Database (Guides)
- Performance and optimization
- Query optimization
- Integration testing with Prisma
- Transactions
- Testing with Prisma
- Deploying projects using Prisma to the cloud
- Unit testing with Prisma
- Deploying database changes with Prisma Migrate
- Deploy a Node.js application with Prisma
- Upgrading (Guides)
- Upgrade from Graphcool to Prisma 2
- Migrate to Prisma (Guides)
- General Guides
- How to migrate from Sequelize to Prisma
- How to migrate from TypeORM to Prisma
- Prisma environment variables reference
- API Reference
- Database features matrix (Reference)
- Connection URLs (Reference)
- Database Reference
- Databases supported by Prisma
- Prisma error reference (Reference)
- Querying models based on their relations existence
- Modeling and querying many-to-many relations
- Autocompletion in GraphQL resolvers with JavaScript
- Help articles (Support)
- Best practice for instantiating PrismaClient with Next.js
- Writing template (About)
- Frontmatter
- MongoDB
- MDX components in the Prisma docs
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Prisma documentation style guide
- Connect your database
- Connect your database
- Connect your database
- Connect your database
- Querying the database
- Querying the database
- Querying the database
- Querying the database
- Using Prisma Migrate
- Using Prisma Migrate
- Using Prisma Migrate
- Using Prisma Migrate
- Next steps
- Next steps
- Next steps
- Next steps
- Start from scratch (15 min)
- Start from scratch (15 min)
- Start from scratch (15 min)
- Start from scratch (15 min)
- Connect your database
- Connect your database
- Connect your database
- Connect your database
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Install Prisma Client
- Introspection
- Introspection
- Introspection
- Introspection
- Add Prisma to an existing project (15 min)
- Add Prisma to an existing project (15 min)
- Add Prisma to an existing project (15 min)
- Add Prisma to an existing project (15 min)
- Next steps
- Next steps
- Next steps
- Next steps
- Querying the database
- Querying the database
- Querying the database
- Querying the database
- Building REST APIs with Prisma
- What is Prisma? (Overview)
- Data modeling with Prisma
- How Prisma fits into your stack
- Building GraphQL servers with Prisma
- Data sources (Reference)
- Generators (Reference)
- Supporting features without a PSL equivalent
- Prisma schema (Reference)
- Is Prisma an ORM? | What is an ORM?
- Relations (Reference)
- Select fields(Concepts)
- CRUD (Reference)
- Filtering and sorting (Reference)
- Data model (Reference)
- Pagination (Reference)
- Case sensitivity (Reference)
- Transactions and batch queries (Reference)
- Aggregation, grouping, and summarizing (Concepts)
- Null and undefined (Reference)
- Debugging (Reference)
- Module bundlers (Reference)
- Database polyfills (Reference)
- Handling exceptions and errors (Reference)
- Raw database access (Reference)
- Prisma Client (Reference)
- Supported database types and features
- db push
- Legacy Prisma Migrate (Reference)
- Prisma Migrate limitations and known issues
- Prisma CLI
- Preview features (Reference)
- Query engine (Concepts)
- Prisma engines
- Prisma CLI preview features
- Prisma Client preview features
- Managing .env files and setting variables
- Using multiple .env files.
- Environment variables
- Prisma vs Mongoose
- Prisma vs Sequelize
- Comparing Prisma to other ORMs and ODMs.
- Adding Prisma Migrate to an existing project
- Prisma vs TypeORM
- Baselining a database
- Enable extensions for native database functions
- Include unsupported database features
- Configure Prisma Client with PgBouncer
- Advanced database tasks (Guides)
- Connection management (Guide)
- Create SQL views with Prisma and PostgreSQL)
- Create SQL views with Prisma and MySQL
- How to deploy a REST API to Azure Functions with Azure SQL
- Deploying to AWS Lambda
- How to deploy a Prisma app to Vercel
- Caveats when deploying to AWS platforms
- Deploying migrations from a local environment
- Deploying to Netlify
- Deploying to a different OS
- Platforms Prisma supports for deployment
- Codemod (Guides)
- Upgrading to latest (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
- Upgrade from Prisma 1 to Prisma 2
- Database workflows (Guides)
- Upgrading from Prisma 1 with prisma-binding to Nexus
- Upgrading from Prisma 1 with prisma-binding to SDL-first
- Instantiating the client (Concepts)
- Upgrading the Prisma layer to Prisma 2 | PostgreSQL
- Upgrading the Prisma layer to Prisma 2 | MySQL
- Connection pool
- Connecting and disconnecting (Concepts)
- Using custom model and field names (Concepts)
- Configuring logging (Concepts)
- Working with PrismaClient (Concepts)
- Configuring error formatting (Concepts)
- Working with fields (Concepts)
- Working with scalar lists/arrays (Concepts)
- Operating against partial structures of your model types
- Working with Json fields (Concepts)
- Prisma validator
- Advanced type safety (Reference)
- Session Data Middleware (Reference)
- Logging middleware (Reference)
- Middleware (Reference)
- Soft delete middleware (Reference)
- SQL Server on Windows (Preview)
- SQL Server on Docker (Preview)
- SQL Server connection URL (Preview)
- SQL Server Start from Scratch | TypeScript | Prisma
- SQL Server Start from Scratch | Node.js | Prisma
- Microsoft SQL Server Connector (Preview)
- Cascading deletes (Guide)
- Configure cascading deletes with Prisma and PostgreSQL
- Configure cascading deletes with Prisma and MySQL
- Advanced data validation (Guides)
- Data validation with CHECK constraints (PostgreSQL)
- Configure cascading deletes with Prisma and SQLite
- Unique constraints & indexes with Prisma and PostgreSQL
- Configure foreign keys with Prisma and PostgreSQL
- Unique constraints and indexes with Prisma and SQLite
- Unique constraints and indexes with Prisma and MySQL
- Foreign keys
- Configure foreign keys with Prisma and MySQL
- Add unique constraints & indexes to your database schema
- Configure foreign keys with Prisma and SQLite
- Prisma schema API (Reference)
- System requirements
- Prisma CLI Installation (Reference)
- Generating the client (Concepts)
- Seeding your database
- Schema prototyping with db push
- Team development with Prisma Migrate
- Customizing migrations
- Migration troubleshooting in development
- Developing with Prisma Migrate
- Deploy a Prisma app to Heroku
- Prisma CLI Command Reference
- Shadow database
- Prisma Migrate | Database, Schema, SQL Migration Tool
- Relation queries (Concepts)
- Prisma Client API (Reference)
Documentation
- Connections, Edges & Nodes in Relay
- GraphQL Query Parameters - Best Practices for GraphQL API Design
- GraphQL SDL — Schema Definition Language
- Relay Modern’s @connection directive
- 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
- New Release Process for Prisma
- How We're Constantly Improving the Performance of Prisma
- How HyreCar rewrote their app in 60 days with Prisma
- How Labelbox Supports Vast Machine Learning Needs with Prisma
- Announcing Prisma Day
- Prisma Admin (Beta): A Modern UI to Manage Your Data
- Watch the Talks from Prisma Day 2019!
- The Guild Takes over Development of the GraphQL CLI & Other Libraries
- 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
- How Poppy Uses Prisma Client to Ship Confidently
- Prisma Ambassador Program — Building A Community of Experts
- 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
- GraphQL Europe 2018: The GraphQL community comes together in Berlin
- Open Sourcing GraphQL Middleware - Library to Simplify Your Resolvers
- 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 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
- Hassle-Free Database Migrations with Prisma Migrate
- Database Access in React Server Components
- Application Monitoring Best Practices
- GraphQL vs Firebase
- GraphQL Basics: Demystifying the `info` Argument in GraphQL Resolvers
- How to wrap a REST API with GraphQL - A 3-step tutorial
- 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
- 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 modern backend with TypeScript, PostgreSQL and Prisma
- What is Nexus and how to use it to build GraphQL servers?
Blog
- Comparing database types: how database types evolved to meet different needs
- Understanding and using transactions in MySQL
- Making Connections
- Introduction to database schemas
- Understanding and using transactions in PostgreSQL
- Correctness and Constraints
- Inserting and modifying data
- Introduction to databases
- Reading and querying data
- Intro (Don't Panic)
- Inserting and modifying data
- Setting up a local SQL Server database
- Know Your Problem Space
- Reading and querying data
- Tables, Tuples, Types
- Microsoft SQL Server
- Strategies for deploying database migrations
- Functional Units
- Using the expand and contract pattern for schema changes
- What are databases?
- Data Modeling
- In Vivo: Information Ecosystems
- Database types
- Setting up a local MongoDB database
- Prisma's Data Guide - Articles to make databases more approachable
- The benefits of PostgreSQL
- MongoDB
- Connecting to PostgreSQL databases
- Top 11 Node.js ORMs, Query Builders & Database Libraries in 2021
- Getting to know PostgreSQL
- Syncing Development Databases Between Team Members
- 5 ways to host PostgreSQL databases
- Top 8 TypeScript ORMs, Query Builders, & Database Libraries: Evaluating Type Safety
- Setting up a local PostgreSQL database
- Database tools | SQL, MySQL, Postgres | Prisma's Data Guide
- How to create and delete databases and tables in PostgreSQL
- PostgreSQL
- How to Spot Bottlenecks in Performance
- An introduction to PostgreSQL data types
- Troubleshooting Database Outages and Connection Issues
- An introduction to PostgreSQL column and table constraints
- Setting up a local MySQL database
- Managing databases | Prisma's Data Guide
- Connecting to MySQL databases
- 5 ways to host MySQL databases
- How to create and delete databases and tables in MySQL
- MySQL
- An introduction to MySQL column and table constraints
- Setting up a local SQLite database
- Importing and exporting data in SQLite
- SQLite
- An introduction to MySQL data types
- Comparing SQL, query builders, and ORMs
- What are database migrations?
- Relational Databases
- Configuring PostgreSQL user authentication
- Managing privileges in PostgreSQL with grant and revoke
- An introduction to authorization and authentication in PostgreSQL
- Authentication and authorization
- How to insert and delete data in PostgreSQL
- Managing roles and role attributes in PostgreSQL
- How to update existing data in PostgreSQL
- How to use `INSERT ON CONFLICT` to upsert data in PostgreSQL
- Importing and exporting data in PostgreSQL
- How to perform basic queries with `SELECT` in PostgreSQL
- Using joins to combine data from different tables in PostgreSQL
- How to filter query results in PostgreSQL
- Short guides
- How to use single and double quotes in PostgreSQL
- An introduction to authorization and authentication in MySQL
- How to manage users and authentication in MySQL
- How to manage privileges with roles in MySQL
- How to use `GRANT` and `REVOKE` to manage privileges in MySQL
- Authentication and authorization
- How to insert and delete data in MySQL
- How to update existing data in MySQL
- How to use `ON DUPLICATE KEY UPDATE` to upsert data in MySQL
- Importing and exporting data in MySQL
- How to perform basic queries with `SELECT` in MySQL
- How to filter query results in MySQL
- 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