Sitemap
- Prisma - Database tools for modern application development
- About Prisma
- Community - Prisma
- Next.js | Prisma
- GraphQL | Prisma
- Jobs at Prisma
- Prisma Day 2020
- Prisma Day 2019
Main site
- MongoDB
- Prisma Documentation (Concepts, Reference & Guides)
- Getting started
- Concepts
- Guides
- Reference
- What's new in Prisma docs
- About the Prisma documentation
- Creating bug reports for Prisma
- Prisma FAQs
- Limitations
- Prisma Roadmap – See what we are working on next
- Releases and maturity levels
- About
- Set up Prisma
- Why Prisma? Comparison with SQL query builders & ORMs
- Prisma under the hood
- Overview
- Prisma Studio (Reference)
- Components
- SQLite database connector (Reference)
- Microsoft SQL Server database connector (Reference)
- Database connectors
- Editor and IDE setup (Reference)
- Codemod (Concepts)
- Telemetry (Reference)
- Telemetry and Editor Setup
- Deploy a Node.js application with Prisma
- Migrate to Prisma (Guides)
- Upgrade from Graphcool to Prisma 2
- Troubleshooting
- Autocompletion in GraphQL resolvers with JavaScript
- General Guides
- Upgrade Guides (Guides)
- API Reference
- Database Reference
- Databases supported by Prisma
- MDX components in the Prisma docs
- Connection URLs (Reference)
- Building REST APIs with Prisma
- How Prisma fits into your stack
- Data sources (Reference)
- Generators (Reference)
- Generating Prisma Client (Reference)
- Prisma Client Constructor (Reference)
- Case sensitivity (Reference)
- Null and undefined (Reference)
- Distinct (Reference)
- Prisma Client error reference (Reference)
- Pagination (Reference)
- Connection management (Reference)
- Logging (Reference)
- Working with JSON fields (Reference)
- Debugging (Reference)
- Error formatting (Reference)
- Query engine (Reference)
- Module bundlers (Reference)
- Database polyfills (Reference)
- Aggregations (Reference)
- Prisma Client (Reference)
- Prisma CLI Installation (Reference)
- Prisma CLI
- Prisma vs Sequelize
- Preview features (Reference)
- Comparing Prisma to other ORMs and ODMs.
- Prisma vs Mongoose
- Upgrade from Prisma 1 to Prisma 2
- Upgrading a REST API from Prisma 1 to Prisma 2
- Database workflows (Guides)
- Logging middleware (Reference)
- Session Data Middleware (Reference)
- Middleware (Reference)
- SQL Server connection string (Preview)
- SQL Server on Windows (Preview)
- Microsoft SQL Server Connector (Preview)
- SQL Server on Docker (Preview)
- Extended native types support (Reference)
- Foreign keys
- Add unique constraints & indexes to your database schema
- Cascading deletes
- Add input validation with the database
- Ready-to-run examples for various Prisma use cases
- Prisma Migrate (Reference)
- Introspection (Reference)
- PostgreSQL database connector (Reference)
- MySQL database connector (Reference)
- Deploying to Vercel (ZEIT Now)
- Deploying to Heroku
- Deploying to Netlify
- Deploying to AWS Lambda
- Prisma documentation style guide
- Data modeling with Prisma
- What is Prisma? (Overview)
- Building GraphQL servers with Prisma
- Prisma schema (Reference)
- Configuring the Prisma Client API (Reference)
- Sorting (Reference)
- Filtering (Reference)
- Field selection (Reference)
- Raw database access (Reference)
- Deploying projects using Prisma to the cloud
- How to upgrade from Prisma 1 to Prisma 2
- Create SQL views with Prisma and PostgreSQL)
- Create SQL views with Prisma and MySQL
- Create SQL views with Prisma and PostgreSQL
- Start from scratch with SQL Server (Preview)
- Start from scratch with SQL Server (Preview)
- Start from scratch with SQL Server (Preview)
- Configure foreign keys with Prisma and MySQL
- Configure foreign keys with Prisma and SQLite
- Configure foreign keys with Prisma and PostgreSQL
- Unique constraints & indexes with Prisma and PostgreSQL
- Unique constraints and indexes with Prisma and MySQL
- Unique constraints and indexes with Prisma and SQLite
- Data validation with CHECK constraints (PostgreSQL)
- Quickstart (TypeScript & SQLite)
- Quickstart (Node.js & SQLite)
- Database features matrix (Reference)
- Data model (Reference)
- Relation queries (Reference)
- Schema Incompatibilities | PostgreSQL
- Schema Incompatibilities | MySQL
- Problems and workarounds for Prisma 1 and 2.0 schemas
- Upgrade Prisma 1 with nexus-prisma to @nexus/schema
- Soft delete middleware (Reference)
- Type mapping reference (Reference)
- Configure cascading deletes with Prisma and MySQL
- Start from scratch | Migrate | TypeScript & PostgreSQL
- Start from scratch | Prisma Migrate | TypeScript & MySQL
- Start from scratch | Migrate | Node.js & PostgreSQL
- Start from scratch | Prisma Migrate | Node.js & MySQL
- Prisma CLI Command Reference
- Is Prisma an ORM?
- Prisma vs TypeORM
- Configure cascading deletes with Prisma and PostgreSQL
- Configure cascading deletes with Prisma and SQLite
- Start from scratch (TypeScript & PostgreSQL)
- Start from scratch (TypeScript & MySQL)
- Start from scratch (Node.js & PostgreSQL)
- Start from scratch (Node.js & MySQL)
- Set up a new project with Prisma from scratch (SQL)
- Add to existing project (TypeScript & PostgreSQL)
- Add to existing project (TypeScript & MySQL)
- Add to existing project (Node.js & PostgreSQL)
- Add to existing project (Node.js & MySQL)
- How to migrate from TypeORM to Prisma
- CRUD (Reference)
- Upgrading from Prisma 1 with prisma-binding to Nexus
- Prisma Schema API (Reference)
- Relations (Reference)
- Upgrading from Prisma 1 with prisma-binding to SDL-first
- Upgrading the Prisma layer to Prisma 2 | PostgreSQL
- Upgrading the Prisma layer to Prisma 2 | MySQL
- Upgrading the Prisma layer to Prisma 2
- Transactions (Reference)
- Advanced usage of generated types (Reference)
Documentation
- Connections, Edges & Nodes in Relay
- Designing Powerful APIs with GraphQL Query Parameters - Learnings & 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
- How We're Constantly Improving the Performance of Prisma
- New Release Process for Prisma
- How HyreCar rewrote their app in 60 days with Prisma
- How Labelbox Supports Vast Machine Learning Needs with Prisma
- Prisma Admin (Beta): A Modern UI to Manage Your Data
- Announcing Prisma Day
- Watch the Talks from Prisma Day 2019!
- State of Prisma 2 (December 2019)
- The Guild Takes over Development of the GraphQL CLI & Other Libraries
- Prisma 2.10 Adds Preview Support for Microsoft SQL Server
- Prisma Studio - A Visual Interface for Your Database
- How to use `create-react-app` with GraphQL & Apollo
- How to use `create-react-native-app` with GraphQL & Apollo
- Improving Performance with Apollo Query Batching
- 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 - A 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 Series A to Build the Next Generation of Database Tools
- How Prisma Supports Database Transactions
- 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
- Using GraphQL Nexus with a Database
- The Problems of "Schema-First" GraphQL Server Development
- Prisma 2 Preview: Type-safe Database Access & Declarative Migrations
- Prisma 2.0 is Now in Beta: Type-safe Database Access with Prisma Client
- New Datamodel Syntax: More Schema Control & Simpler Migrations
- Modern Backend with TypeScript, PostgreSQL, and Prisma: Continuous Integration and Continuous Deployment
- GraphQL vs Firebase
- GraphQL Server 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
- Relay vs Apollo - An unopinionated comparison of GraphQL clients for React apps
- Modern Backend with TypeScript, PostgreSQL, and Prisma: Data Modeling, CRUD, and Aggregates
- Learn TypeScript: A Pocketguide Tutorial
- Getting Started with Relay Modern
- Modern Backend with TypeScript, PostgreSQL, and Prisma: REST API, Validation, and Testing
- Modern Backend with TypeScript, PostgreSQL, and Prisma: Passwordless Authentication and Authorization
- Building a modern backend with TypeScript, PostgreSQL and Prisma
- What is Nexus and how to use it to build GraphQL servers?
Blog
- Introduction to databases
- Top 11 Node.js ORMs, Query Builders & Database Libraries in 2020
- Correctness and Constraints
- Making Connections
- How to manage users and authentication in MySQL
- How to use `GRANT` and `REVOKE` to manage privileges in MySQL
- How to manage privileges with roles in MySQL
- Prisma's Data Guide - Articles to make databases more approachable
- Comparing database types: how database types evolved to meet different needs
- What are databases?
- Intro (Don't Panic)
- Introduction to database schemas
- Know Your Problem Space
- In Vivo: Information Ecosystems
- Tables, Tuples, Types
- Data Modeling
- Database types
- Functional Units
- The benefits of PostgreSQL
- Getting to know PostgreSQL
- 5 ways to host PostgreSQL databases
- Setting up a local PostgreSQL database
- Connecting to PostgreSQL databases
- How to create and delete databases and tables in PostgreSQL
- PostgreSQL
- An introduction to PostgreSQL data types
- An introduction to PostgreSQL column and table constraints
- Importing and exporting data in MySQL
- Setting up a local MySQL database
- MySQL
- Importing and exporting data in SQLite
- Setting up a local SQLite database
- SQLite
- Database tools | SQL, MySQL, Postgres | Prisma's Data Guide
- Relational Databases
- Top 8 TypeScript ORMs, Query Builders, & Database Libraries: Evaluating Type Safety
- An introduction to authorization and authentication in PostgreSQL
- Comparing SQL, query builders, and ORMs
- Authentication and authorization
- Managing privileges in PostgreSQL with grant and revoke
- Managing roles and role attributes in PostgreSQL
- How to update existing data in PostgreSQL
- Configuring PostgreSQL user authentication
- How to insert and delete 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
- Inserting and modifying data
- How to filter query results in PostgreSQL
- Using joins to combine data from different tables in PostgreSQL
- Reading and querying data
- How to use single and double quotes in PostgreSQL
- Short guides
- An introduction to authorization and authentication in MySQL
- Authentication and authorization
- Understanding and using transactions in PostgreSQL
Data Guide
Newsletter
Stay up to date with the latest features and changes to Prisma
Find Us
Prisma © 2018-2020.
Made with ❤️ in Berlin and worldwide