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
- Quickstart: Getting started with TypeScript & SQLite
- Quickstart: Getting started with Node.js & SQLite
- Getting started
- Concepts
- Guides
- System requirements
- Reference
- Creating bug reports for Prisma
- Support
- What's new in Prisma docs
- About the Prisma documentation
- Prisma FAQs
- Limitations
- Prisma Roadmap – See what we are working on next
- Releases and maturity levels
- Ready-to-run examples for various Prisma use cases
- About
- 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)
- Start from scratch | TypeScript & PostgreSQL
- Start from scratch | TypeScript & MySQL
- Start from scratch | Node.js & PostgreSQL
- Start from scratch | Node.js & MySQL
- Set up Prisma
- Why Prisma? Comparison with SQL query builders & ORMs
- Should you use Prisma as a Node.js/TypeScript ORM?
- Prisma under the hood
- Overview
- What is introspection? (Reference)
- Prisma Studio (Reference)
- Components
- PostgreSQL database connector (Reference)
- MySQL database connector (Reference)
- SQLite database connector (Reference)
- Microsoft SQL Server database connector (Reference)
- Database connectors
- Editor and IDE setup (Reference)
- Codemod (Concepts)
- Add Prisma Migrate to an existing project
- Seeding your database with Prisma Client
- Prisma guides
- Deploy a Prisma app to Heroku
- How to deploy a Prisma app to Vercel
- Deploying to AWS Lambda
- Deploying to Netlify
- Deploy a Node.js application with Prisma
- Upgrade from Graphcool to Prisma 2
- Upgrade Guides (Guides)
- How to migrate from TypeORM to Prisma
- How to migrate from Sequelize to Prisma
- Migrate to Prisma (Guides)
- General Guides
- Prisma Client error reference (Reference)
- Prisma CLI Command Reference
- API Reference
- Database features matrix (Reference)
- Connection URLs (Reference)
- Databases supported by Prisma
- Database Reference
- Autocompletion in GraphQL resolvers with JavaScript
- Modeling and querying many-to-many relations
- Transactions
- Best practice for instantiating PrismaClient with Next.js
- Help articles (Support)
- MDX components in the Prisma docs
- Writing template (About)
- Prisma documentation style guide
- Telemetry and Editor Setup
- Telemetry (Reference)
- Querying models based on their relations existence
- Data modeling with Prisma
- What is Prisma? (Overview)
- Building REST APIs with Prisma
- Building GraphQL servers with Prisma
- How Prisma fits into your stack
- Is Prisma an ORM? | What is an ORM?
- Data sources (Reference)
- Generators (Reference)
- Data model (Reference)
- Relations (Reference)
- Prisma schema (Reference)
- CRUD (Reference)
- Select fields(Concepts)
- Filtering and sorting (Reference)
- Working with field types (Reference)
- Advanced usage of generated TypeScript types (Reference)
- Pagination (Reference)
- Aggregation, grouping, and summarizing (Concepts)
- Raw database access (Reference)
- Debugging (Reference)
- Query engine (Reference)
- Module bundlers (Reference)
- Database polyfills (Reference)
- Prisma Client (Reference)
- Migration flows (Concepts)
- Legacy Prisma Migrate (Reference)
- Prisma Migrate | Database, Schema, SQL Migration Tool
- Prisma CLI Installation (Reference)
- Prisma CLI
- Preview features (Reference)
- Prisma vs TypeORM
- Prisma vs Sequelize
- Prisma vs Mongoose
- Comparing Prisma to other ORMs and ODMs.
- How to upgrade from Prisma 1 to Prisma 2
- Schema Incompatibilities | PostgreSQL
- Schema Incompatibilities | MySQL
- Upgrading the Prisma layer to Prisma 2 | PostgreSQL
- Upgrading the Prisma layer to Prisma 2 | MySQL
- 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
- Upgrading a REST API from Prisma 1 to Prisma 2
- Upgrade from Prisma 1 to Prisma 2
- Create SQL views with Prisma and PostgreSQL)
- Create SQL views with Prisma and MySQL
- Database workflows (Guides)
- Generating the client (Concepts)
- Case sensitivity (Reference)
- Transactions (Reference)
- Null and undefined (Reference)
- Using custom model and field names (Concepts)
- Connection management (Reference)
- Configuring logging (Concepts)
- Configuring error formatting (Concepts)
- Working with PrismaClient (Concepts)
- Soft delete middleware (Reference)
- Logging middleware (Reference)
- Session Data Middleware (Reference)
- Middleware (Reference)
- SQL Server Start from Scratch | TypeScript | Prisma
- SQL Server Start from Scratch | Node.js | Prisma
- SQL Server connection string (Preview)
- SQL Server on Windows (Preview)
- SQL Server on Docker (Preview)
- Microsoft SQL Server Connector (Preview)
- 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
- Configure cascading deletes with Prisma and PostgreSQL
- Configure cascading deletes with Prisma and MySQL
- Configure cascading deletes with Prisma and SQLite
- Cascading deletes
- Data validation with CHECK constraints (PostgreSQL)
- Add input validation with the database
- Prisma Client API (Reference)
- Prisma Schema API (Reference)
- Deploying projects using Prisma to the cloud
- Instantiating the client (Concepts)
- Working with relations (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
- 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
- Prisma Admin (Beta): A Modern UI to Manage Your Data
- Announcing Prisma Day
- 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
- 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 - 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
- Prisma Migrate Preview - Database Migrations Simplified
- Announcing Nexus 1.0: A Major Release for Type-Safe, Code-First GraphQL APIs
- How to build a Real-Time Chat with GraphQL Subscriptions and Apollo 🌍
- GraphQL Server Basics: GraphQL Schemas, TypeDefs & Resolvers Explained
- 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
- New Datamodel Syntax: More Schema Control & Simpler Migrations
- Prisma 2 Preview: Type-safe Database Access & Declarative Migrations
- Prisma 2.0 is Now in Beta: Type-safe Database Access with Prisma Client
- Modern Backend with TypeScript, PostgreSQL, and Prisma: Continuous Integration and Continuous Deployment
- Build an App With Svelte and TypeScript
- Jamstack with Next.js and Prisma
- Full Stack Type Safety with Angular, Nest, Nx, and Prisma
- How do GraphQL remote schemas work?
- GraphQL vs Firebase
- How to wrap a REST API with GraphQL - A 3-step tutorial
- GraphQL Server 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
- Relay vs Apollo - An unopinionated comparison of GraphQL clients for React apps
- Modern Backend with TypeScript, PostgreSQL, and Prisma: Data Modeling, CRUD, and Aggregates
- 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
- An introduction to PostgreSQL column and table constraints
- What are databases?
- Top 8 TypeScript ORMs, Query Builders, & Database Libraries: Evaluating Type Safety
- Introduction to database schemas
- Top 11 Node.js ORMs, Query Builders & Database Libraries in 2021
- Comparing database types: how database types evolved to meet different needs
- Introduction to databases
- Intro (Don't Panic)
- Know Your Problem Space
- Tables, Tuples, Types
- Correctness and Constraints
- Making Connections
- Functional Units
- In Vivo: Information Ecosystems
- Database types
- The benefits of PostgreSQL
- Data Modeling
- Getting to know PostgreSQL
- Prisma's Data Guide - Articles to make databases more approachable
- 5 ways to host PostgreSQL databases
- 5 ways to host MySQL databases
- Setting up a local PostgreSQL database
- Setting up a local MySQL database
- Connecting to MySQL databases
- An introduction to PostgreSQL data types
- An introduction to MySQL column and table constraints
- Connecting to PostgreSQL databases
- How to create and delete databases and tables in MySQL
- PostgreSQL
- An introduction to MySQL data types
- How to manage users and authentication in MySQL
- MySQL
- How to manage privileges with roles in MySQL
- An introduction to authorization and authentication in MySQL
- Importing and exporting data in SQLite
- How to use `GRANT` and `REVOKE` to manage privileges in MySQL
- SQLite
- Authentication and authorization
- How to insert and delete data in MySQL
- Database tools | SQL, MySQL, Postgres | Prisma's Data Guide
- Importing and exporting data in MySQL
- How to update existing data in MySQL
- How to use `ON DUPLICATE KEY UPDATE` to upsert data in MySQL
- Comparing SQL, query builders, and ORMs
- Understanding and using transactions in MySQL
- What are database migrations?
- Inserting and modifying data
- An introduction to authorization and authentication in PostgreSQL
- How to perform basic queries with `SELECT` in MySQL
- Relational Databases
- How to filter query results in MySQL
- Managing roles and role attributes in PostgreSQL
- Using joins to combine data from different tables in MySQL
- Configuring PostgreSQL user authentication
- Reading and querying data
- Setting up a local SQLite database
- Managing privileges in PostgreSQL with grant and revoke
- How to use `INSERT ON CONFLICT` to upsert data in PostgreSQL
- Importing and exporting data in PostgreSQL
- Understanding and using transactions in PostgreSQL
- Inserting and modifying data
- 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
- Reading and querying data
- How to use single and double quotes in PostgreSQL
- Short guides
- How to update existing data in PostgreSQL
- How to create and delete databases and tables in PostgreSQL
- Authentication and authorization
- How to insert and delete data in PostgreSQL
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