# Prisma Website ## Web - [Page not found | Prisma](/404): Prisma is the easiest way to access a database from a Next.js application in Node.js & TypeScript. - [500: Internal Server Error](/500): No description available. - [Apollo & Prisma & Database | Next-Generation ORM for SQL Databases](/apollo): Prisma is a next-generation ORM. It's the easiest way to build a GraphQL API with Apollo Server and MySQL, PostgreSQL & SQL Server databases. - [Prisma Blog | Articles & Updates | Prisma, ORMs, Databases](/blog): Stay up to date with the latest from Prisma. Guides, announcements, and articles about Prisma, ORMs, databases, and the data access layer. - [Careers | Prisma](/careers): See open positions at Prisma. Join us to empower developers to build data-intensive applications. - [Prisma Client - Auto-generated query builder for your data](/client): Prisma is a next-generation ORM that can be used to build GraphQL servers, REST APIs, microservices & more. - [Prisma & CockroachDB | ORM for the cloud-distributed database](/cockroachdb): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to build applications with CockroachDB. - [Community | Prisma](/community): Have a question, idea, or contribution for the Prisma ORM? You are not alone! Join hundreds of thousands of Prisma developers. - [Prisma Data Proxy](/data-platform/proxy): Prisma Data Proxy was an external connection pool that helped scale database connections in Serverless environments. - [Prisma ORM Ecosystem](/ecosystem): Explore the variety of tools (from generators, to middleware, to CLIs) created by the Prisma community. - [Prisma Enterprise Event 2021](/enterprise-event-2021): An online conference focused on the challenges large companies and enterprises face with the management of application data. - [Streamline your enterprise development workflow with Prisma](/enterprise): Learn how Prisma ORM can improve your team's productivity and explore our tailored ORM support solutions for enterprises and solution providers. - [Prisma - Event Code of Conduct](/event-code-of-conduct): Read our Event Code of Conduct and how it relates to you. - [Prisma Events](/events): Upcoming events or meetups, conferences and and explore the content from previous events. - [Express & Prisma | Next-Generation ORM for SQL DBs](/express): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to build Express apps with MySQL, PostgreSQL & SQL Server databases. - [Fastify & Prisma | Next-Generation ORM for SQL DBs](/fastify): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to build Fastify apps with MySQL, PostgreSQL, SQL Server and MongoDB databases. - [Prisma Global Traffic | Prisma](/global): Real time activity of the Prisma global data network. - [GraphQL with Database & Prisma | Next-Generation ORM for SQL Databases](/graphql): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to build GraphQL servers with MySQL, PostgreSQL & SQL Server databases. - [Hapi Database & Prisma | Next-Generation ORM for SQL DBs](/hapi): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to build hapi apps with MySQL, PostgreSQL & SQL Server databases. - [Learn how to build applications with Prisma | Prisma](/learn): Explore tutorials, examples and other resources to learn how to build web applications using Prisma and various technologies like Next.js, Remix, GraphQL or NestJS. - [Prisma Migrate | Hassle-free Database Migrations](/migrate): Automatically generate fully customizable database schema migrations for PostgreSQL, MySQL, MariaDB or SQLite. - [Prisma & MongoDB | ORM for the scaleable serverless database](/mongodb): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to build applications with MongoDB. - [NestJS Database & Prisma | Type-safe ORM for SQL Databases](/nestjs): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to build NestJS apps with MySQL, PostgreSQL & SQL Server databases. - [Sign up for Prisma's monthly newsletter](/newsletter): The Prisma newsletter is packed with all the latest releases, updates, blogs, and more. Sign up today to stay up-to-date with Prisma. - [Next.js Database with Prisma | Next-Generation ORM for SQL Databases](/nextjs): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to build Next.js apps with MySQL, PostgreSQL & SQL Server databases. - [Prisma | Affiliates network](/partners/affiliates): Prisma Affiliate Program offers 20% commission for 24 months on referred users. Get access to exclusive resources, early features, and a creator community. - [Prisma Partner Network - Terms of Services](/partners/tos): Terms of Services applicable to the Prisma Partner Network. - [Prisma & PlanetScale | ORM for the scaleable serverless database](/planetscale): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to build applications with PlanetScale - [Prisma Playground | Learn the Prisma ORM in your browser](/playground): The Playground is an interactive learning environment for Prisma. Learn how to send database queries and explore migrations workflows with the Prisma ORM. - [Privacy Policy | Prisma](/privacy): Read our privacy policy and see how it relates to you. - [React with Prisma | Next-Generation Node.js and TypeScript ORM](/react-server-components): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to connect React apps to MySQL, PostgreSQL, SQL Server, CockroachDB, and MongoDB databases. - [React with Prisma | Next-Generation Node.js and TypeScript ORM](/react): Prisma is a next-generation ORM for Node.js & TypeScript. It's the easiest way to connect React apps to MySQL, PostgreSQL, SQL Server, CockroachDB, and MongoDB databases. - [Page /sanity-studio/[[...index]]](/sanity-studio/[[...index]]): No description available. - [Serverless Deep Dive](/serverless): The latest trends, challenges, and solutions in the world of serverless technology shared by practitioners and innovators. - [Prisma Showcase | Customer Success stories](/showcase): Learn how companies are leveraging our powerful, next-generation, type-safe ORM for Node.js. - [HTML Sitemap | Prisma](/sitemap): www.prisma.io sitemap. Find content, documentation, and other useful information about Prisma, databases, and ORMs. - [Service Level Agreement (SLA) | Prisma](/sla): Explore our Service Level Agreement (SLA) detailing our monthly uptime percentage, service credits, and any exclusions. - [Prisma Startup Program](/startups): The Prisma Startup Program is designed to help early-stage founders focus on scaling their businesses, and not managing databases. - [Support Policy | Prisma](/support-policy): Read our support policy and see how it relates to you. - [Prisma Support](/support): Explore comprehensive support articles, resources, and guides for Prisma ORM, Accelerate, and Pulse. Find the best solution and get help from our team. - [Terms of Service](/terms): Read our terms of services and see how they relate to you. - [TypedSQL: Fully type-safe raw SQL in Prisma ORM ](/typedsql): Write raw sql queries with fully type-safety and auto-completion in Prisma ORM. Get type-safe database queries without sacrificing the power and flexibility of raw SQL. - [TypeScript & Prisma | TypeScript ORM for SQL Databases](/typescript): Prisma is a TypeScript ORM that makes you more confident with type safe database access. It's the easiest way to access SQL databases in Node.js with TypeScript - [A Business Case for Extended ESOP Exercise Windows](/blog/esop-exercise-windows): Explore extending ESOPs to 10 years, considering fairness, economics, benefits, challenges with Prisma's example, and startup compensation. - [Prisma 2.10 Adds Preview Support for Microsoft SQL Server](/blog/prisma-sql-server-support-preview-a4anl2gd8d3a): No description available. - [How TypeScript 4.9 `satisfies` Your Prisma Workflows](/blog/satisfies-operator-ur8ys8ccq7zb): Learn how TypeScript 4.9''s new `satisfies` operator can help you write type-safe code with Prisma - [Bringing Prisma ORM to React Native and Expo](/blog/bringing-prisma-orm-to-react-native-and-expo): Prisma ORM now provides Early Access support for React Native and Expo. The integration introduces reactive queries, using React hooks to auto-update the UI when the underlying data changes. - [Prisma ORM Support for Edge Functions is Now in Preview](/blog/prisma-orm-support-for-edge-functions-is-now-in-preview): We're thrilled to share that you can now access your database with Prisma ORM from Vercel Edge Functions and Cloudflare Workers. - [How We're Constantly Improving the Performance of Prisma](/blog/performance-engineering-aeduv0rei0jk): No description available. - [Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: Deployment](/blog/fullstack-nextjs-graphql-prisma-5-m2fna60h7c): Learn how to build a fullstack app using TypeScript, PostgreSQL, Next.js, GraphQL and Prisma. In this article you are going to deploy your app to Vercel - [Improve your application’s performance with AI-driven analysis and recommendations](/blog/optimize-now-generally-available): Enhance database performance with Prisma Optimize's AI-powered query insights. - [Announcing Tweets for Trees](/blog/tweets-for-trees-arboreal): With Earth Day coming up on the 22nd, Prisma will be planting a tree for every tweet about Prisma we see in April - [ORM v6.17.0, New Usage Metrics & Direct Connections in GA for Prisma Postgres ](/blog/orm-v6-17-0-new-usage-metrics-and-direct-connections-in-ga-for-prisma-postgres): Prisma ORM v6.17.0 is out with fixes and improvements. Connecting to Prisma Postgres via your favorite ORM/DB tool is now GA. Read the full update. - [Prisma Products Are Now Available on AWS Marketplace](/blog/aws-marketplace): AWS Marketplace customers can purchase Prisma products through AWS Marketplace. - [Prisma Raises $12M to Build the Next Generation of Database Tools](/blog/prisma-raises-series-a-saks1zr7kip6): No description available. - [How Prisma and GraphQL fit together](/blog/prisma-and-graphql-mfl5y2r7t49c): No description available. - [Prisma Client (Preview): Simplified & Type-safe Database Access](/blog/prisma-client-preview-ahph4o1umail): No description available. - [How Prisma Helps Rapha Manage Their Mobile Application Data](/blog/helping-rapha-access-data-across-platforms-n3jfhtyu6rgn): No description available. - [Key takeaways from the Discover Data DX virtual event](/blog/datadx-event-recap-z5Pcp6HzBz5m): Highlights from the Discover Data DX virtual event hosted by Prisma on December 7th, 2023, where industry leaders discussed the significance and principles of Data DX. - [Announcing Prisma 7](/blog/announcing-prisma-orm-7-0-0): Prisma ORM 7 delivers major performance gains, a Rust-free client, and a streamlined developer experience, plus deeper Prisma Postgres integration. - [Prisma Client Extensions Are Now Production Ready](/blog/client-extensions-ga-4g4yIu8eOSbB): Make Prisma Client do even more with Client extensions, now Generally Available. Extend your client, models, queries, and results to tailor Prisma Client to your use case. - [Prisma 2.0 is in Beta: Type-safe Database Access with Prisma Client](/blog/prisma-2-beta-b7bcl0gd8d8e): No description available. - [Accelerate in Preview: Global Database Cache & Scalable Connection Pool](/blog/accelerate-preview-release-ab229e69ed2): Accelerate is going into Preview! Learn how to enable high-speed, scalable applications with a global cache and connection pooler. - [Announcing Prisma ORM 7.2.0](/blog/announcing-prisma-orm-7-2-0): Prisma ORM 7.2.0 is out with key improvements: the return of the --url flag, smarter prisma init configs for Node and Bun, better CLI errors, and fixes for @db.Money. Upgrade today. - [Prisma Ambassador Program — Building A Community of Experts](/blog/ambassador-program-nxkWGcGNuvFx): We are thrilled to announce the launch of the Ambassador Program to empower the Prisma community, while also helping individual contributors build their own brand. - [Build A Fullstack App with Remix, Prisma & MongoDB: Authentication](/blog/fullstack-remix-prisma-mongodb-2-ZTmOy58p4re8): Learn how to build and deploy a fullstack application using Remix, Prisma, and MongoDB. In this article, we will be setting up authentication for our Remix application using session-based authentication. - [ORM 6.12.0: ESM-Compatible Generator in Preview & New Options for Prisma Config](/blog/orm-6-12-0-esm-compatible-generator-in-preview-and-new-options-for-prisma-config): Check out the latest Prisma release with our new ESM-compatible generator and New Options for Prisma Config! - [Why the Prisma CLI Asks for Your Feedback](/blog/why-the-prisma-cli-asks-for-your-feedback): To capture the voice of our community we’ve started prompting for feedback directly in the CLI—an unconventional choice that deserves a short explanation. - [We Made Prisma Studio Even Better](/blog/we-made-prisma-studio-even-better): Prisma Studio has just received some great new UX/DX upgrades and is now available in the Prisma Console. Read to find out how you can be more productive in Prisma Studio! - [Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: Data Modeling](/blog/fullstack-nextjs-graphql-prisma-oklidw1rhw): Build a fullstack app using TypeScript, PostgreSQL, Next.js, GraphQL and Prisma. In this article we're going to create the app's data model - [Prisma Client Just Became a Lot More Flexible: Prisma Client Extensions (Preview)](/blog/client-extensions-preview-8t3w27xkrxxn): Learn how Prisma Client extensions (Preview) enable a variety of new use cases for the Prisma ORM. - [Operations-Based Billing: A Simpler Pricing Model for Modern Databases](/blog/operations-based-billing): Serverless pricing for databases is notoriously difficult to grok and predict accurately. When thinking of how to solve this pricing dilemma for Prisma Postgres, we wanted to make things easy. Our operations-based pricing model simplifies pricing and removes the need to think about resource sizes or abstract compute time metrics. - [Prisma Adopts Semantic Versioning (SemVer)](/blog/prisma-adopts-semver-strictly): We are adjusting Prisma's release policy to adhere more strictly to Semantic Versioning. In the future, breaking changes in the stable development surface (General Availability) will only be rolled out in major version increments. - [Enabling CORS for Express-GraphQL & Apollo Server | Prisma](/blog/enabling-cors-for-express-graphql-apollo-server-1ef999bfb38d): No description available. - [Vibe Coding an E-commerce App with Prisma MCP and Next.js](/blog/vibe-coding-with-prisma-mcp-and-nextjs): Learn how we used Prisma MCP and Next.js to rapidly build an e-commerce app through vibe coding. - [Prisma Accelerate now in General Availability](/blog/accelerate-ga-release-I9cQM6bSf2g6): Supercharge your applications with Prisma Accelerate's scalable connection pooling and global edge caching. Plus, enjoy our exclusive launch offer. - [New Tooling to Improve Your GraphQL Workflows](/blog/new-tooling-to-improve-your-graphql-workflows-7240c81e1ba3): No description available. - [Prisma Postgres®: Building a Modern PostgreSQL Service Using Unikernels & MicroVMs](/blog/announcing-prisma-postgres-early-access): At Prisma, we believe that deploying a database should be as simple as adding a new page in Notion. Today, we are excited to share the first milestone towards this vision: Prisma Postgres® gives developers an always-on database with pay-as-you-go pricing, thanks to our unique architecture design. - [Improving Query Performance with Indexes using Prisma: Hash Indexes](/blog/improving-query-performance-using-indexes-3-kduk351qv1): Learn how you can optimize a slow database query in your application with a Hash index using Prisma - [How Co.dev Uses Prisma Postgres to Power AI-Driven App Development for Non-Developers](/blog/how-co-dev-uses-prisma-postgres-to-power-ai-driven-app-development-for-non-developers): Discover why Co.dev chose Prisma Postgres: simple API & MCP integration, explicit schema support, and one-shot authentication in its AI-driven app creation flow. - [Try the New "Rust-free" Version of Prisma ORM (Early Access)](/blog/try-the-new-rust-free-version-of-prisma-orm-early-access): No description available. - [Studio for Prisma Postgres (Preview): View & Edit Your Data Online](/blog/studio-for-prisma-postgres-view-and-edit-your-data-online): Prisma Studio is now available in the Platform Console for Prisma Postgres databases. It’s the easiest way to explore and manipulate the data in your Prisma Postgres instance. - [About MCP Servers & How We Built One for Prisma](/blog/about-mcp-servers-and-how-we-built-one-for-prisma): No description available. - [How Poppy Uses Prisma Client to Ship Confidently](/blog/poppy-customer-success-story-swnWQcGRRvpd): Poppy offers rides of all kinds through its mobile app. Whether it's a car, scooter, or e-step, Poppy has it. Prisma plays a vital role in helping Poppy ship quickly and confidently and is a big reason they've just hit 1.5 million total rides taken. - [Building a REST API with NestJS and Prisma: Error Handling](/blog/nestjs-prisma-error-handling-7D056s1kOop2): In this tutorial, you will implement error handling in a NestJS application. You will learn two ways to handle errors: directly in your application code and by creating an exception filter. - [Building on an Established Community: Prisma Now on Discord](/blog/announcing-discord-1LiAOpS7lxV9): Prisma is excited to expand the established Prisma Community Discord and further collaborate with the Prisma community. - [How Solin Uses Prisma Accelerate to Serve 2.5M Database Queries per Day](/blog/how-solin-uses-prisma-accelerate-to-serve-2-5m-database-queries-per): Learn how Prisma Accelerate has contributed to Solin's success by enhancing performance and reliability with its scalable connection pool and global database cache. - [How We Sped Up Serverless Cold Starts with Prisma by 9x](/blog/prisma-and-serverless-73hbgKnZ6t): Learn about the Prisma's goals, the hurdles we are overcoming, and how you can help. - [Try Prisma: The Fastest Way to Explore Prisma Examples](/blog/try-prisma-announcment-Kv6bwRcdjd): Announcing: Try Prisma. A CLI utility that allows you to easily set up and try out an example projects using Prisma. - [Introducing Instant App Deployments in Partnership with Vercel](/blog/introducing-instant-app-deployments-in-partnership-with-vercel): Instant App Deployment with Prisma Postgres and Vercel makes going from generated code to production effortless. Provision a Postgres database, deploy globally, and let users claim full ownership with a single API call. Perfect for AI coding platforms, no-code tools, and modern app builders. - [What's new in Prisma? (Q1/22)](/blog/wnip-q1-dsk0golh8v): Learn about everything that has happened in the Prisma ecosystem and community from January to March 2022. - [Prisma ORM 6.18.0, Postgres Database Metrics and Config Modernization](/blog/announcing-prisma-6-18-0): Catch up on the lates 6.18.0 release for Prisma ORM and Prisma Postgres. - [Make Your Applications Fast Globally](/blog/make-your-applications-fast-globally): Speed up edge and serverless apps by fixing database latency, cold starts, and slow queries. - [We Transitioned Prisma Accelerate to IPv6 Without Anyone Noticing](/blog/accelerate-ipv6-first): In July 2023, AWS announced the decision to begin charging for IPv4 addresses beginning in February 2024. This move had a major impact on Prisma Accelerate for reasons we’ll get into, prompting us to go all-in on IPv6. Join us for a deep dive into how we approached our IPv6 migration, lessons learned, and the outcome for users of Prisma Accelerate. - [Speed and Savings: Caching Database Queries with Prisma Accelerate](/blog/caching-database-queries-with-prisma-accelerate): Achieve faster performance and cost savings with Prisma Accelerate's easy per-query caching, eliminating the need for maintaining caching infrastructure. Experience faster queries, without the hassle! - [Prisma Adds Support for MongoDB — Join Our Launch Week Celebrations 🎉](/blog/mongodb-general-availability-pixnun6mffmu): Prisma now supports MongoDB! Read this article to learn more about the benefits developers get when using MongoDB with Prisma and join our one-week celebration at the end of April. - [Cloudflare, Unikernels & Bare Metal: Life of a Prisma Postgres Query](/blog/cloudflare-unikernels-and-bare-metal-life-of-a-prisma-postgres-query): Take a look under the hood of the most innovative PostgreSQL database on the market and learn how a query travels through Cloudflare, unikernels and bare metal. - [ORM v6.11.0, Embedded Prisma Studio, Rust-free ORM for MySQL in Preview & More](/blog/orm-v6-11-0-embedded-prisma-studio-rust-free-orm-for-mysql-in-preview-and-more): What’s new: Prisma ORM without Rust in Preview for MySQL & Neon, embedded Prisma Studio for your React apps, new region for Prisma Postgres & more. - [The Ultimate Guide to Testing with Prisma: Unit Testing](/blog/testing-series-2-xPhjjmIEsM): Learn about what unit testing is and how to approach it in an application using Prisma Client. - [Using GraphQL Nexus with a Database](/blog/using-graphql-nexus-with-a-database-pmyl3660ncst): No description available. - [Prisma Support for Tracing and Metrics Is Now in Preview](/blog/tracing-launch-announcement-pmk4rlpc0ll): We are excited to launch two new features in Preview: Tracing and Metrics. Try them out and let us know what you think! - [Relay Modern’s @connection directive](/blog/relay-moderns-connection-directive-1ecd8322f5c8): No description available. - [Relay vs Apollo - Comparing GraphQL clients for React apps](/blog/relay-vs-apollo-comparing-graphql-clients-for-react-apps-b40af58c1534): No description available. - [Improving Query Performance with Indexes using Prisma: Introduction](/blog/improving-query-performance-using-indexes-1-zuLNZwBkuL): Learn the fundamentals of database indexes: what they are, the problem they solve, and their benefit and cost - [Announcing Prisma Day 2022! Our First Hybrid Prisma Day.](/blog/prisma-day-2022-announcement-v8t178dsf): We’re thrilled to announce that this summer, Prisma Day will feature both in-person and remote events and workshops. Prisma Day will take place June 15th and 16th' - [Increase Database Security With Static IP Support in Prisma Accelerate](/blog/accelerate-static-ip-support): Prisma Accelerate now supports Static IPs, ensuring secure database connections with predictable IPs for controlled access. - [How to use `create-react-native-app` with GraphQL & Apollo](/blog/tutorial-using-create-react-native-app-with-graphql-apollo-e630aee3ae1e): No description available. - [Organize Your Prisma Schema into Multiple Files in v5.15](/blog/organize-your-prisma-schema-with-multi-file-support): With Prisma ORM 5.15.0 you can now use multiple Prisma Schema files instead of just one. Learn how to enable this Preview feature and check out a real-world example. - [How Panther champions talent over geography with Prisma](/blog/Panther-customer-story-pdmdrRhTupsl): Prisma plays a key role in the Panther's tech stack, allowing individual teams to have the freedom they need while also maintaining data consistency - [Support for Serverless Database Drivers in Prisma ORM Is Now in Preview](/blog/serverless-database-drivers-KML1ehXORxZV): Prisma support for JavaScript-based serverless database drivers is now in Preview, enabling you to connect to Neon and PlanetScale via HTTP and WebSockets. - [Prisma Is Expanding Its Executive Team](/blog/coo-announcement-aer1fgviirjb): Announcement about new COO joining Prisma - [Prisma 2.0: Confidence and productivity for your database](/blog/announcing-prisma-2-n0v98rzc8br1): No description available. - [The Ultimate Guide to Testing with Prisma: Mocking Prisma Client](/blog/testing-series-1-8eRB5p0Y8o): Learn about mocking and spying, why they are useful, and how they can be done with Prisma Client. - [Launching the Data DX Manifesto: Shaping a new paradigm in data-driven development](/blog/datadx-manifesto-ikgyqj170k8h): Prisma introduces Data DX (Data Developer Experience) as a fresh approach for effortlessly building data-driven applications. - [Performance Benchmarks: Comparing Query Latency across TypeScript ORMs & Databases](/blog/performance-benchmarks-comparing-query-latency-across-typescript-orms-and-databases): Which ORM is the fastest? We have created open-source performance benchmarks to compare query latencies for Prisma ORM, TypeORM and Drizzle ORM. - [Backend with TypeScript, PostgreSQL & Prisma: Authentication & Authz](/blog/backend-prisma-typescript-orm-with-postgresql-auth-mngp1ps7kip4): No description available. - [Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: Image upload](/blog/fullstack-nextjs-graphql-prisma-4-1k1kc83x3v): Learn how to build a fullstack app using TypeScript, PostgreSQL, Next.js, GraphQL and Prisma. In this article you are going to learn how to add image upload using AWS S3 - [5 Tools for Documenting Your Web API](/blog/documenting-apis-mjjpZ7E7NkVP): No description available. - [Nexus 1.0: A Major Release for Type-Safe, Code-First GraphQL APIs](/blog/announcing-the-release-of-nexus-schema-v1-b5eno5g08d0b): Nexus, the library for building code-first, type-safe GraphQL APIs has just reached 1.0. - [ORM 6.15.0, AI Safety Guardrails for Destructive Commands & More](/blog/orm-6-15-0-ai-safety-guardrails-for-destructive-commands-and-more): Protect your DB from AI mishaps with Prisma ORM v6.15.0—new safety guardrails, ESM-first client updates & better Postgres tooling. - [How to use `create-react-app` with GraphQL & Apollo](/blog/how-to-use-create-react-app-with-graphql-apollo-62e574617cff): No description available. - [Build A Fullstack App with Remix, Prisma & MongoDB: CRUD, Filtering & Sorting](/blog/fullstack-remix-prisma-mongodb-3-By5pmN5Nzo1v): Learn how to build and deploy a fullstack application using Remix, Prisma, and MongoDB. In this article, we will be building the functionality that allows users to send kudos to each other along with some searching and sorting options. - [Developer Experience Redefined: Prisma & Cloudflare Lead the Way to Data DX](/blog/cloudflare-partnership-qerefgvwirjq): Prisma introduces Data DX and announces a partnership with Cloudflare - [Type-safe JavaScript with JsDoc](/blog/type-safe-js-with-jsdoc-typeSaf3js): JsDoc is a great tool for documenting code and providing type-safety in your JavaScript project without any additional configuration. Learn what JsDoc is, how it works, the benefits it provides, and how to use it in your project. - [Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: Authentication](/blog/fullstack-nextjs-graphql-prisma-3-clxbrcqppv): Learn how to build a fullstack app using TypeScript, PostgreSQL, Next.js, GraphQL, and Prisma. In this article, you will learn how to add authentication and authorization to your application using Auth0 - [Announcing the Prisma FOSS Fund](/blog/prisma-foss-fund-announcement-XW9DqI1HC24L): Prisma has started a fund to support independent free and open source software (FOSS) teams. Each month, we will donate $5,000 to a selected project to maintain its work and continue its development. - [Improving the Prisma Visual Studio Code Extension with WebAssembly](/blog/vscode-extension-prisma-rust-webassembly): Learn about the Prisma schema and how we improved reliability and simplified the Prisma Visual Studio Extension with Rust and WebAssembly. - [Achievement Unlocked: Compliance for SOC2 Type II, HIPAA, GDPR, and ISO27001](/blog/compliance-reqs-complete): Prisma completes the compliance requirements for GDPR, HIPAA, ISO27001 and SOC2-TypeII certifications - [The Ultimate Guide to Testing with Prisma: End-To-End Testing](/blog/testing-series-4-OVXtDis201): Learn all about end-to-end testing, how to set up a testing environment and how to write tests using Playwright and Prisma. - [Introducing the Read Replicas Extension for Prisma Client](/blog/read-replicas-prisma-client-extension-f66prwk56wow): Distribute read traffic across replicas using the new read replicas extension for Prisma Client. - [Database Access in Serverless Environments with the Prisma Data Proxy](/blog/prisma-data-proxy-xb16ba0p21): The Prisma Data Proxy (Early Access) enables developers to use databases in serverless environments by managing a connection pool. - [Prisma 2.27 Adds Preview Support for MongoDB](/blog/prisma-mongodb-preview-release): Prisma support for MongoDB - bringing the power of type safety in Prisma to MongoDB - [Announcing TypedSQL: Make your raw SQL queries type-safe with Prisma ORM](/blog/announcing-typedsql-make-your-raw-sql-queries-type-safe-with-prisma-orm): Prisma ORM now supports the ability to write raw sql queries and have the inputs and outputs be fully type-safe! Get the benefit of a high-level API with the power of raw SQL. - [End-To-End Type-Safety with GraphQL, Prisma & React: Codegen & Deployment](/blog/e2e-type-safety-graphql-react-4-JaHA8GbkER): Learn how to build a fully type-safe application with GraphQL, Prisma, and React. This article walks you through setting up code generation to allow you to keep your TypeScript types in sync across your frontend and API. You will also deploy your completed project. - [The Prisma Data Platform is now Generally Available](/blog/prisma-data-platform-now-generally-available-8D058s1BqOL1): The Prisma Data Platform solves problems developers face when working with databases in production, and is now generally available. - [Best Practices To Speed Up Your Serverless Applications](/blog/how-to-improve-startup-times-kdRB9MjPEv): Learn about some best practices to speed up your serverless applications using Prisma. - [How Prisma & Serverless Fit Together](/blog/how-prisma-and-serverless-fit-together-iaSfcPQVi0): Learn about how Prisma views the evolution of deployment types, serverless and the edge, and the problems we want to solve in the space. - [Building a REST API with NestJS and Prisma: Input Validation & Transformation](/blog/nestjs-prisma-validation-7D056s1kOla1): Learn how to build a backend REST API with NestJS, Prisma, PostgreSQL and Swagger. In this article, you will learn how to perform input validation and transformation for your API. - [Optimizing Postgres for Global Apps](/blog/optimizing-postgres-for-global-apps): No description available. - [Why Use Prisma to Build Your Data Layer in 2024?](/blog/why-prisma-2024): Discover how Prisma's powerful tools help you build a scalable, secure, and high-performing data layer. From the popular TypeScript and Node.js ORM to advanced features like connection pooling, caching, and query optimization, Prisma equips you to scale your app to millions of users. - [Introducing our Build, Fortify, Grow (BFG) Framework](/blog/bfg): An overview of how Prisma products interoperate at each stage and aid in enhancing data-driven application development. - [Prisma Playground: An Interactive Learning Experience for Prisma](/blog/announcing-prisma-playground-xeywknkj0e1p): Explore the Prisma Client API to send database queries and Prisma Migrate worklfows to evolve your database schema in an interactive environment. - [Prisma Support for CockroachDB Is Production Ready 🪳](/blog/cockroach-ga-5JrD9XVWQDYL): Prisma's support for CockroachDB is now in production ready! Read this article to learn about the features and benefits of Prisma with CockroachDb. - [How Elsevier Piloted an Innovative Publication Process Quickly and Flexibly with Prisma](/blog/elsevier-customer-story-SsAASKagMHtN): Elsevier is a global leader in information and analytics in scientific publishing. Learn how they modernized the publication process efficiently and flexibly with Prisma. - [Prisma Postgres: The Future of Serverless Databases](/blog/prisma-postgres-the-future-of-serverless-databases): Prisma Postgres is finally ready for production! Built on unikernels, it enables a unique set of benefits like no cold starts, connection pooling, edge caching, & more! - [End-To-End Type-Safety with GraphQL, Prisma & React: Frontend](/blog/e2e-type-safety-graphql-react-1-I2GxIfxkSZ): Learn how to build a fully type-safe application with GraphQL, Prisma, and React. This article walks you through building a type-safe React app that accesses a GraphQL API. - [Prisma 6.9.0: Rust-Free ORM in Preview, Connect To Prisma Postgres With Any Tool, & More](/blog/prisma-6-9-0-release): Explore Prisma 6.9.0: Connect any tool to Prisma Postgres (Drizzle, Kysely, etc.), try the new Rust-free Prisma ORM for PostgreSQL & SQLite, run local Prisma Postgres with persistent data, and manage databases via a new VS Code UI. - [Introducing GraphQL Nexus: Code-First GraphQL Server Development](/blog/introducing-graphql-nexus-code-first-graphql-server-development-ll6s1yy5cxl5): No description available. - [What's new in Prisma? (Q2/21)](/blog/whats-new-in-prisma-q2-2021-z70muetl386d): Learn about everything that has happened in the Prisma ecosystem and community from April to June 2021. - [What's new in Prisma? (Q2/22)](/blog/wnip-q2-2022-pmn7rulcj8x): Learn about everything that has happened in the Prisma ecosystem and community from April to July 2022. - [Prisma ORM Manifesto: Clarity and Collaboration](/blog/prisma-orm-manifesto): Refocusing Prisma on what matters most: clear governance, better issue management, timely feature releases, and community collaboration - [GraphQL Server Basics: The Network Layer](/blog/graphql-server-basics-the-network-layer-51d97d21861): No description available. - [Build A Fullstack App with Remix, Prisma & MongoDB: Project Setup](/blog/fullstack-remix-prisma-mongodb-1-7D0BfTXBmB6r): Learn how to build and deploy a fullstack application using Remix, Prisma, and MongoDB. In this article, we will be setting up our project, the MongoDB instance, Prisma, and begin modeling out some of our data for the next section of this series. - [Watch the Talks from Prisma Day 2019!](/blog/watch-prisma-day-talks-z11sg6ipb3i1): No description available. - [Join the Prisma Insider Program and Shape the Future of our Products](/blog/prisma-insider-program): No description available. - [Why Prisma ORM Generates Code into Node Modules & Why It’ll Change](/blog/why-prisma-orm-generates-code-into-node-modules-and-why-it-ll-change): Prisma has historically generated client code into node_modules, but this is changing in the future. - [Prisma ORM 6.6.0: ESM Support, D1 Migrations & MCP Server](/blog/prisma-orm-6-6-0-esm-support-d1-migrations-and-prisma-mcp-server): The v6.6.0 Prisma ORM release is packed with exciting features: ESM support, migrations on Cloudflare D1, an MCP server to manage DBs & a lot more. - [Prisma Migrate Preview - Database Migrations Simplified](/blog/prisma-migrate-preview-b5eno5g08d0b): Prisma Migrate Preview - database schema migrations simplified with declarative data modeling and auto-generated and customizable SQL migrations - [Application Monitoring Best Practices](/blog/monitoring-best-practices-monitor5g08d0b): Learn the best practices for monitoring your application and how it fits into the development cycle. - [Open Sourcing GraphQL Middleware - Library to Simplify Your Resolvers](/blog/graphql-middleware-zie3iphithxy): No description available. - [Database access on the Edge with Next.js, Vercel & Prisma Accelerate](/blog/database-access-on-the-edge-8F0t1s1BqOJE): Learn how you can query databases in Edge environments using Prisma and the Prisma Accelerate. - [Helping Founders Scale Faster and Build Smarter](/blog/prisma-startup-program): No description available. - [GraphQL Schema Stitching explained: Schema Delegation](/blog/graphql-schema-stitching-explained-schema-delegation-4c6caf468405): No description available. - [How Grover Moves Faster with Prisma](/blog/grover-customer-success-story-nxkWGcGNuvFd): Grover has many individual development teams that each work in slightly different stacks. Prisma is catching on as a way to help their teams move faster and be more confident in their code. - [Monitor Your Server with Tracing Using OpenTelemetry & Prisma](/blog/tracing-tutorial-prisma-pmkddgq1lm2): This tutorial will help you to get started with Prisma's tracing feature and OpenTelemetry in Node.js. Learn how to integrate tracing and OpenTelemetry into a web server built with Express and Prisma. - [Database Caching: A Double-Edged Sword? Examining the Pros and Cons](/blog/benefits-and-challenges-of-caching-database-query-results-x2s9ei21e8kq): Discover the advantages and hurdles of caching database query results. Learn how caching enhances performance, scalability, and resource utilization, while also delving into the associated challenges. - [Hassle-Free Database Migrations with Prisma Migrate](/blog/prisma-migrate-ga-b5eno5g08d0b): Prisma Migrate is ready for use in production - Database schema migration tool with declarative data modeling and auto-generated, customizable SQL migrations - [How do GraphQL remote schemas work?](/blog/how-do-graphql-remote-schemas-work-7118237c89d7): No description available. - [GraphQL SDL — Schema Definition Language](/blog/graphql-sdl-schema-definition-language-6755bcb9ce51): No description available. - [Getting Started with Relay Modern](/blog/getting-started-with-relay-modern-46f8de6bd6ec): No description available. - [Prisma Postgres is completely free during Early Access](/blog/prisma-postgres-free-during-early-access): We decided to make Prisma Postgres free to use during Early Access so everyone can try it - [How Tryg has leveraged Prisma to democratize data](/blog/tryg-customer-story-pdmdrRhTupvd): Prisma was a critical technology that enabled Tryg to democratize billions of records from different data sources, through the Tryg 360 platform. - [All you need to know about Apollo Client 2](/blog/all-you-need-to-know-about-apollo-client-2-7e27e36d62fd): No description available. - [Introducing Accelerate in Early Access](/blog/announcing-accelerate-usrvpi6sfkv4): Query up to 1000x faster on any Prisma-supported database with our new distributed cache and scalable connection pool for Serverless apps. - [Learn TypeScript: A Pocketguide Tutorial](/blog/learn-typescript-a-pocketguide-tutorial-q329XmXQHUjz): No description available. - [Prisma 7 Performance and Benchmarks](/blog/prisma-7-performance-benchmarks): We reviewed community benchmarks comparing Prisma 6 and Prisma 7. Here’s what they measure, where regressions exist, and how we’re fixing them. - [Prisma Postgres: Now in Your Favorite Environment](/blog/prisma-postgres-now-in-your-favorite-environment): Integrate Prisma Postgres in your Netlify site in less 5 minutes or quickly try it out without leaving your browser using the official Project IDX template. - [Announcing Prisma's MCP Server: Vibe Code with Prisma Postgres](/blog/announcing-prisma-s-mcp-server-vibe-code-with-prisma-postgres): With Prisma’s MCP server, Cursor, Windsurf and other AI tools, can now provision and manage Postgres databases for your apps.. - [Prisma 2 Preview: Type-safe Database Access & Declarative Migrations](/blog/announcing-prisma-2-zq1s745db8i5): No description available. - [Announcing: Instant Prisma Postgres for AI Coding Agents](/blog/announcing-prisma-postgres-for-ai-coding-agents): No description available. - [Vibe Coding with Limits — How to Build Apps in the Age of AI](/blog/vibe-coding-with-limits-how-to-build-apps-in-the-age-of-ai): Discover how developers can use AI coding tools to build robust, maintainable software without sacrificing quality. - [Full Stack Type Safety with Angular, Nest, Nx, and Prisma](/blog/full-stack-typesafety-with-angular-nest-nx-and-prisma-CcMK7fbQfTWc): No description available. - [Adding Database Access to your SvelteKit App with Prisma](/blog/sveltekit-prisma-kvCOEoeQlC): Learn how you can interact with a database from a SvelteKit application using Prisma. - [Announcing Prisma Day](/blog/announcing-prisma-day-50cg22nn40qk): No description available. - [How Bucket Uses Prisma ORM to Make Shipping Feature Releases Faster](/blog/how-bucket-uses-prisma-orm): Learn how Bucket uses Prisma - [The Guild Takes over Development of the GraphQL CLI & Other Libraries](/blog/the-guild-takes-over-oss-libraries-vvluy2i4uevs): No description available. - [Build an App With Svelte and TypeScript](/blog/build-an-app-with-svelte-and-typescript-PZDY3t93qAtd): No description available. - [Prisma Raises $40M to Build the Application Data Platform](/blog/series-b-announcement-v8t12ksi6x): We are excited to announce that we have raised our Series B funding. Read this article to learn more about our vision of an Application Data Platform built for development teams and organizations. - [Announcing: Prisma Postgres Integration for Vercel Marketplace](/blog/connect-your-apps-to-prisma-postgres-via-vercel-marketplace-integration): We’re thrilled to announce that you can now create and manage Prisma Postgres instances without leaving your Vercel Dashboard. - [How Prisma ORM Became the Most Downloaded ORM for Node.js](/blog/how-prisma-orm-became-the-most-downloaded-orm-for-node-js): Reflect on three years of Prisma ORM development with this article showing how Prisma ORM became the most downloaded ORM for Node.js - [Formbricks and Prisma Accelerate: Solving scalability together](/blog/formbricks-and-prisma-accelerate-solving-scalability-together): Learn how Formbricks tackled performance bottlenecks and enhanced server performance and user experience with Prisma Accelerate. - [How iopool refactored their app in less than 6 months with Prisma](/blog/iopool-customer-success-story-uLsCWvaqzXoa): In 2020, iopool decided to rearchitect its app and use Prisma for their database needs. Doing so helped them move fast with confidence and has greatly simplified their development process. - [ORM 6.13.0, CI/CD Workflows & pgvector for Prisma Postgres](/blog/orm-6-13-0-ci-cd-workflows-and-pgvector-for-prisma-postgres): Prisma ORM v6.13.0 introduces Prisma Config & multi-schema support in GA, pgvector for Prisma Postgres, a new Management API for CI/CD, SQL view enhancements, and a redesigned Prisma Console UI. - [Microsoft SQL Server Support in Prisma is Production-Ready](/blog/prisma-microsoft-sql-server-azure-sql-production-ga): Microsft SQL Server and Azure SQL support in Prisma is now Generally Available - [GraphQL vs Firebase](/blog/graphql-vs-firebase-496498546142): No description available. - [What's new in Prisma? (Q3/21)](/blog/wnip-q3-hpk7pyth8v): Learn about everything that has happened in the Prisma ecosystem and community from July to September 2021.' - [Prisma ORM Now Lets You Choose the Best Join Strategy (Preview)](/blog/prisma-orm-now-lets-you-choose-the-best-join-strategy-preview): Choose between DB-level and application-level joins to pick the most performant approach for your relation queries. - [Prisma ORM v6.14.0, Relationships for SQL Views, More Robust Management API & More](/blog/prisma-orm-v6-14-0-relationships-for-sql-views-more-robust-management-api-and-more): We just released Prisma ORM v6.14.0 with the ability to define relations across views, a robust API for programmatically provisioning Prisma Postgres & more. - [Overcoming Database Challenges in Serverless & Edge Applications](/blog/overcoming-challenges-in-serverless-and-edge-environments-TQtONA0RVxuW): Learn best practices around deploying stateful apps in traditionally stateless environments. - [Prisma raises $4.5M to build the GraphQL data layer for all databases](/blog/prisma-raises-4-5m-to-build-the-graphql-data-layer-for-all-databases-663484df0f60): No description available. - [Tutorial: Render Props in React Apollo 2.1](/blog/tutorial-render-props-in-react-apollo-2-1-199e9e2bd01e): No description available. - [SQLite on the Edge: Prisma Support for Turso is in Early Access](/blog/prisma-turso-ea-support-rXGd_Tmy3UXX): Prisma support for Turso is now in Early Access, enabling you to bring SQLite closer to your users. Try it out! - [Improving Query Performance with Indexes using Prisma: B-Tree Index](/blog/improving-query-performance-using-indexes-2-MyoiJNMFTsfq): Learn how you can optimize a slow database query in your application with a B-Tree index using Prisma - [Prisma's Cloud Connectivity Report 2024](/blog/cloud-connectivity-report-2024): The Prisma Cloud Connectivity Report 2024 analyzes AWS and Cloudflare latency, highlighting regions with the fastest and slowest connectivity. - [From Rust to TypeScript: A New Chapter for Prisma ORM](/blog/from-rust-to-typescript-a-new-chapter-for-prisma-orm): Why is Prisma ORM switching from Rust to TypeScript? Read the full architectural rationale and what the new Query Compiler means for your app's speed - [Introducing Prisma Nuxt: Simplifying Data Management for Nuxt Apps](/blog/introducing-prisma-nuxt): Use Prisma ORM in your Nuxt.js app easily with the Prisma Nuxt module for type-safe queries and database management. - [Prisma 5: Faster by Default](/blog/prisma-5-f66prwkjx72s): Prisma 5.0.0 introduces new changes that make it significantly faster. These changes especially improve the experience using Prisma in serverless environments. - [A Collaborative Data Browser for Your Database on the Web](/blog/prisma-online-data-browser-ejgg5c8p3u4x): Prisma's online data browser allows you to easily collaborate with your team on your data. Try the Early Access version and share your feedback with us! - [Prisma Schema Language: The Best Way to Define Your Data](/blog/prisma-schema-language-the-best-way-to-define-your-data): An article discussing the Prisma Schema Language and comparing it to TypeScript-based schemas. - [Build A Fullstack App with Remix, Prisma & MongoDB: Referential Integrity & Image Uploads](/blog/fullstack-remix-prisma-mongodb-4-l3MwEp4ZLIm2): Learn how to build and deploy a fullstack application using Remix, Prisma, and MongoDB. In this article, we will be building the profile settings section of the website and enhancing the data model to provide better referential integrity.' - [GraphQL Europe 2018: The GraphQL community comes together in Berlin](/blog/graphql-eu-18-eiw8bishe2di): No description available. - [State of Prisma 2 (December 2019)](/blog/state-of-prisma-2-december-rcrwcqyu655e): No description available. - [How Prisma Allowed Pearly to Scale Quickly with an Ultra-Lean Team](/blog/pearly-plan-customer-success-pdmdrRhTupve): Pearly provides platforms for dentists to create better and reliable revenue streams and affordable care plans for their patients. Learn how Prisma has helped them scale quickly with Prisma with an ultra-lean team. - [Enabling static egress IPs in the Prisma Data Platform](/blog/data-platform-static-ips): Static egress IP support ensures that the Prisma Data Platform connects to your databases through public static IP addresses helping you keep your database secure. - [Database Access in React Server Components](/blog/database-access-in-react-server-components-r2xgk9aztgdf): No description available. - [How migrating from Sequelize to Prisma allowed Invisible to scale](/blog/how-migrating-from-Sequelize-to-Prisma-allowed-Invisible-to-scale-i4pz2mwu6q): Invisible combines best-in-class, easy to implement, scalable automation solutions. Prisma was crucial in future proofing their stack and supporting its scale. - [New Release Process for Prisma](/blog/improving-prismas-release-process-yaey8deiwaex): No description available. - [Top 5 Myths about Prisma ORM](/blog/top-5-myths-about-prisma-orm): Discover the truth behind five common misconceptions about Prisma ORM. In this article, we debunk the myths, explore their origins, and separate fact from fiction. - [What's new in Prisma? (Q4/21)](/blog/wnip-q4-dsk0golh8v): Learn about everything that has happened in the Prisma ecosystem and community from October to December 2021 - [Announcing Prisma 6.19.0](/blog/announcing-prisma-6-19-0): Prisma 6.19 release includes pooled Postgres connections and VS Code extension improvements - [Prisma support for CockroachDB is now in Preview](/blog/prisma-preview-cockroach-db-release): Learn about the Preview release of the Prisma CockroachDB connector and the benefits of using Prisma with CockroachDB. - [Securely Access Prisma Postgres from the Frontend (Early Access)](/blog/securely-access-prisma-postgres-from-the-frontend-early-access): Define security rules for Prisma Postgres in TypeScript and securely talk to your database directly from your React, Vue, Svelte, or any other frontend apps. - [Prisma 6: Better Performance, More Flexibility & Type-Safe SQL](/blog/prisma-6-better-performance-more-flexibility-and-type-safe-sql): Today, we are releasing Prisma v6! Since the last major version, we have been hard at work incorporating user feedback, making Prisma ORM faster and more flexible, and adding amazing features like type-safe raw SQL queries. - [Backend with TypeScript, PostgreSQL & Prisma: REST, Validation & Tests](/blog/backend-prisma-typescript-orm-with-postgresql-rest-api-validation-dcba1ps7kip3): No description available. - [New Datamodel Syntax: More Schema Control & Simpler Migration](/blog/datamodel-v11-lrzqy1f56c90): No description available. - [Introducing Platform Environments](/blog/introducing-platform-environments): Introducing Platform Environments & Early Access Prisma Data Platform integration to Prisma CLI. - [Backend with TypeScript, PostgreSQL & Prisma: CI & Deployment](/blog/backend-prisma-typescript-orm-with-postgresql-deployment-bbba1ps7kip5): No description available. - [Tutorial: Building a Realtime GraphQL Server with Subscriptions](/blog/tutorial-building-a-realtime-graphql-server-with-subscriptions-2758cfc6d427): No description available. - [Building a REST API with NestJS and Prisma: Authentication](/blog/nestjs-prisma-authentication-7D056s1s0k3l): In this tutorial, you will learn how to implement JWT authentication with NestJS, Prisma and PostgreSQL. You will also learn about salting passwords, security best practises and how to integrate with Swagger. - [Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: GraphQL API](/blog/fullstack-nextjs-graphql-prisma-2-fwpc6ds155): Learn how to build a fullstack app using TypeScript, PostgreSQL, Next.js, GraphQL and Prisma. In this article you are going to create a GraphQL API' - [How Prisma Supports Database Transactions](/blog/how-prisma-supports-transactions-x45s1d5l0ww1): No description available. - [GraphQL Server Basics: GraphQL Schemas, TypeDefs & Resolvers Explained](/blog/graphql-server-basics-the-schema-ac5e2950214e): No description available. - [Build Applications at the Edge with Prisma ORM & Cloudflare D1 (Preview)](/blog/build-applications-at-the-edge-with-prisma-orm-and-cloudflare-d1-preview): Prisma ORM now supports Cloudflare D1 databases. Read this article to learn how to query D1 from a Cloudflare Worker. - [Why Prisma ORM Checks Types Faster Than Drizzle](/blog/why-prisma-orm-checks-types-faster-than-drizzle): Discover why Prisma ORM outperforms Drizzle ORM in TypeScript type checking. Our benchmarks show Prisma checks queries 72% faster on average, thanks to code generation that keeps editors snappy and CI runs smooth. - [Rust-free Prisma ORM is Ready for Production](/blog/rust-free-prisma-orm-is-ready-for-production): The future of Prisma ORM is here: The Rust-free version of Prisma ORM and the ESM-first prisma-client generator are both Generally Available in v6.16.0. - [ORM 6.10.0, New Features for Prisma Postgres, Remote MCP & More](/blog/orm-6-10-0-new-features-for-prisma-postgres-remote-mcp-and-more): This week comes packed with major improvements for Prisma Postgres & Prisma ORM. Read this article to learn more! - [Prisma 6.8.0: VS Code Agent Mode, Local Prisma Postgres, Native Deno Support](/blog/prisma-6-8-0-release): With Prisma 6.8.0, spin up a local Postgres instance in seconds, create databases with VS Code Agent Mode, query docs via GitHub Copilot, and run Prisma ORM natively on Deno. - [End-To-End Type-Safety with GraphQL, Prisma & React: API Prep](/blog/e2e-type-safety-graphql-react-2-j9mEyHY0Ej): Learn how to build a fully type-safe application with GraphQL, Prisma, and React. This article walks you through setting up a TypeScript project, a PostgreSQL database, and Prisma. - [GraphQL Basics: Demystifying the `info` Argument in GraphQL Resolvers](/blog/graphql-server-basics-demystifying-the-info-argument-in-graphql-resolvers-6f26249f613a): No description available. - [The Problems of "Schema-First" GraphQL Server Development](/blog/the-problems-of-schema-first-graphql-development-x1mn4cb0tyl3): No description available. - [Working With Data in Large Teams](/blog/working-with-data-in-large-teams): Scale your data workflows without slowing down your team. This guide helps engineering leads adopt CI for database changes, define clear ownership, and balance velocity with safety using proven patterns like expand-contract and schema validation. - [How to build a Real-Time Chat with GraphQL Subscriptions and Apollo 🌍](/blog/how-to-build-a-real-time-chat-with-graphql-subscriptions-and-apollo-d4004369b0d4): No description available. - [GraphQL Directive Permissions — Authorization Made Easy](/blog/graphql-directive-permissions-authorization-made-easy-54c076b5368e): No description available. - [Prisma ORM without Rust: Latest Performance Benchmarks](/blog/prisma-orm-without-rust-latest-performance-benchmarks): No description available. - [The Ultimate Guide to Testing with Prisma: Integration Testing](/blog/testing-series-3-aBUyF8nxAn): Learn about how to plan, set up and write integration tests for your API. - [Explore insights and improve app performance with Prisma Optimize](/blog/prisma-optimize-early-access): Explore insights into your database operations to diagnose performance problems and enhance your application's performance and user experience. - [Building a REST API with NestJS and Prisma](/blog/nestjs-prisma-rest-api-7D056s1BmOL0): Learn how to build a backend REST API with NestJS, Prisma, PostgreSQL and Swagger. In this article, you will learn how to set up the project, build the API and document it with Swagger. - [How Labelbox Supports Vast Machine Learning Needs with Prisma](/blog/labelbox-simnycbotiok): No description available. - [Reasons to use GraphQL | Top 5 Reasons Why and How to use GraphQL](/blog/top-5-reasons-to-use-graphql-b60cfa683511): No description available. - [Prisma Studio - A Visual Interface for Your Database](/blog/prisma-studio-3rtf78dg99fe): No description available. - [Advanced Database Schema Management with Atlas & Prisma ORM](/blog/advanced-database-schema-management-with-atlas-and-prisma-orm): Atlas is a powerful data modeling and migrations tool enabling advanced DB schema management workflows, like CI/CD, schema monitoring, versioning, and more. - [Improving Performance with Apollo Query Batching](/blog/improving-performance-with-apollo-query-batching-66455ea9d8b): No description available. - [Database Metrics with Prisma, Prometheus & Grafana](/blog/metrics-tutorial-prisma-pmoldgq10kz): This tutorial will help you to get started with Prisma's metrics feature. Learn how to integrate metrics into a web server using Prometheus and Grafana. - [Rust to TypeScript Update: Boosting Prisma ORM Performance](/blog/rust-to-typescript-update-boosting-prisma-orm-performance): A blog post showing how the new Query Compiler project, where the Prisma query engine is being re-written from Rust to TypeScript, is improving performance. - [Restructuring Prisma](/blog/restructure-announcement-1a9ek279du8j): Restructuring Prisma - [Backend with TypeScript PostgreSQL & Prisma: Data Modeling & CRUD](/blog/backend-prisma-typescript-orm-with-postgresql-data-modeling-tsjs1ps7kip1): No description available. - [Introducing global omit for model fields in Prisma ORM 5.16.0!](/blog/introducing-global-omit-for-model-fields-in-prisma-orm-5-16-0): Prisma ORM v5.16.0 allows you to omit fields globally or per-query. This blog post overviews the change and how to omit fields in your Prisma Client queries. - [Jamstack with Next.js and Prisma](/blog/jamstack-with-nextjs-prisma-jamstackN3XT): Learn how to build interactive Jamstack apps with Next.js and Prisma and incremental static re-generation. - [What's new in Prisma? (Q1/21)](/blog/whats-new-in-prisma-q1-2021-spjyqp0e2rk1): Learn about everything that has happened in the Prisma ecosystem and community from January to March 2021. - [What's new in Prisma? (Q4/22)](/blog/wnip-q4-2022-f66prwkjx72s): Here’s all you need to know about the Prisma ecosystem and community from August to December 2022. - [Data DX: The name for Prisma’s developer experience philosophy](/blog/datadx-name-for-prismas-philosophy): Explore the evolution of Data DX at Prisma, from its inception before naming to the launch of a new category. - [Build A Fullstack App with Remix, Prisma & MongoDB: Deployment](/blog/fullstack-remix-prisma-mongodb-5-gOhQsnfUPXSx): Learn how to build and deploy a fullstack application using Remix, Prisma, and MongoDB. In this article, we will be deploying the application we have built throughout this series. - [Building a REST API with NestJS and Prisma: Handling Relational Data](/blog/nestjs-prisma-relational-data-7D056s1kOabc): In this tutorial, you will learn how to handle relational data in a REST API built with NestJS, Prisma and PostgreSQL. You will create a new User model and learn how to model relations in the data layer and API layer. - [The Complete ORM for Node.js & TypeScript](/blog/prisma-the-complete-orm-inw24qjeawmb): After more than two years of development, we are excited to share that all Prisma tools are ready for production. - [The Ultimate Guide to Testing with Prisma: CI Pipelines](/blog/testing-series-5-xWogenROXm): Learn how to set up a CI pipeline to automatically run tests against your application that uses Prisma. - [Why SiteGPT Chose Prisma Postgres for Scalable AI-Powered Chatbots](/blog/why-sitegpt-chose-prisma-postgres-for-scalable-ai-powered-chatbots): Learn why SiteGPT migrated from their previous database to Prisma Postgres. Discover how transparent pricing, zero server management, and seamless ORM integration provided the simplicity and confidence they needed to build and scale. - [End-To-End Type-Safety with GraphQL, Prisma & React: GraphQL API](/blog/e2e-type-safety-graphql-react-3-fbV2ZVIGWg): Learn how to build a fully type-safe application with GraphQL, Prisma, and React. This article walks you through building a type-safe GraphQL API - [Introducing Auto-Scaling for Prisma Accelerate’s Connection Pool](/blog/introducing-auto-scaling-for-prisma-accelerate): Prisma Accelerate’s new auto-scaling feature improves connection pooling, ensuring efficient and scalable database management. - [Saving Black Friday With Connection Pooling](/blog/saving-black-friday-with-connection-pooling): Ensure stability and performance during high traffic periods with Prisma Accelerate's connection pooling - [Plot Twist: We're All Building the Same ORM](/blog/convergence): Why Drizzle's relational API v2 mirrors Prisma: production database problems at scale lead to similar patterns. A look at ORM convergence. - [Database vs Application: Demystifying JOIN Strategies](/blog/database-vs-application-demystifying-join-strategies): Joining data from multiple tables is a complicated topic. There are two main strategies: database-level and application-level joins. Prisma ORM offers both options. In this article you’ll learn the tradeoffs between the two so you can pick the best strategy. - [Improving Prisma Migrate DX with two new commands](/blog/prisma-migrate-dx-primitives): Learn how the new Prisma Migrate commands, migrate diff and db execute help troubleshooting schema migrations. - [How MasterBoard simplified CI/CD testing with Prisma Postgres](/blog/how-masterboard-simplified-ci-cd-testing-with-prisma-postgres): MasterBoard replaced AWS with Prisma Postgres to simplify infrastructure and streamline testing. Discover how they spin up fresh databases for every PR, test with real data, and ship faster with less setup, more speed, and top-tier support from Prisma. - [How Deno and Prisma Partnered to Power Per-Branch Databases](/blog/how-deno-and-prisma-partnered-to-power-per-branch-databases): Deno Deploy integrates Prisma Postgres for instant per-branch databases, enabling seamless full-stack deployment and modern developer workflows. - [New Course: Fullstack App Using Next.js, GraphQL, TypeScript & Prisma](/blog/announcing-upcoming-course-8s41wdqrlgc7): We are working on a course, where you are going to learn how to build a fullstack app using Next.js, GraphQL, TypeScript and Prisma! - [Connections, Edges & Nodes in Relay](/blog/connections-edges-nodes-in-relay-758d358aa4c7): No description available. - [How Prisma helps Amplication evolutionize backend development](/blog/amplication-customer-story-nmlkBNlLlxnN): How Prisma helps Amplication evolutionize backend development - [How GreatFrontEnd Supercharged Development with Prisma ORM](/blog/how-greatfrontend-supercharged-development-with-prisma-orm): Discover how GreatFrontEnd revolutionized their database operations by integrating Prisma ORM—achieving type safety, streamlined schema management, and a more efficient development pipeline. - [How to wrap a REST API with GraphQL - A 3-step tutorial](/blog/how-to-wrap-a-rest-api-with-graphql-8bf3fb17547d): No description available. - [Announcing On-Demand Cache Invalidation for Prisma Accelerate](/blog/announcing-on-demand-cache-invalidation-for-prisma-accelerate): Boost app performance with precise control using Prisma's on-demand cache invalidation. # Prisma Documentation ## Docs - [`client`: Add methods to Prisma Client](docs//orm/prisma-client/client-extensions/client.md): Extend the functionality of Prisma Client, client component - [`model`: Add custom methods to your models](docs//orm/prisma-client/client-extensions/model.md): Extend the functionality of Prisma Client, model component - [`query`: Create custom Prisma Client queries](docs//orm/prisma-client/client-extensions/query.md): Extend the functionality of Prisma Client, query component - [`result`: Add custom fields and methods to query results](docs//orm/prisma-client/client-extensions/result.md): Extend the functionality of Prisma Client, result component - [2 docs tagged with "database"](docs//tags/database.md) - [2 docs tagged with "deployment"](docs//tags/deployment.md) - [2 docs tagged with "migration"](docs//tags/migration.md) - [2 docs tagged with "Vercel"](docs//tags/vercel.md) - [3 docs tagged with "best-practices"](docs//tags/best-practices.md) - [3 docs tagged with "Monorepo"](docs//tags/monorepo.md) - [4 docs tagged with "Next.js"](docs//tags/next-js.md) - [About](docs//about.md): About the Prisma docs. - [About migration histories](docs//orm/prisma-migrate/understanding-prisma-migrate/migration-histories.md): About migration histories - [About the Platform CLI](docs//platform/platform-cli/about.md): This guide demonstrates how to access the Prisma Data Platform using the Prisma CLI. Get started by ensuring you have the Prisma CLI installed, following our setup instructions. - [About the shadow database](docs//orm/prisma-migrate/understanding-prisma-migrate/shadow-database.md): About the shadow database - [Accelerate FAQ](docs//accelerate/faq.md): Frequently asked questions about Accelerate. - [Add Prisma ORM to an existing CockroachDB project](docs//getting-started/prisma-orm/add-to-existing-project/cockroachdb.md): Add Prisma ORM to an existing TypeScript project with CockroachDB and learn database introspection, baselining, and querying. - [Add Prisma ORM to an existing MongoDB project](docs//getting-started/prisma-orm/add-to-existing-project/mongodb.md): Add Prisma ORM to an existing TypeScript project with MongoDB and learn database introspection and querying. - [Add Prisma ORM to an existing MySQL project](docs//getting-started/prisma-orm/add-to-existing-project/mysql.md): Add Prisma ORM to an existing TypeScript project with MySQL and learn database introspection, baselining, and querying. - [Add Prisma ORM to an existing PlanetScale project](docs//getting-started/prisma-orm/add-to-existing-project/planetscale.md): Add Prisma ORM to an existing TypeScript project with PlanetScale MySQL and learn database introspection and querying. - [Add Prisma ORM to an existing PostgreSQL project](docs//getting-started/prisma-orm/add-to-existing-project/postgresql.md): Add Prisma ORM to an existing TypeScript project with PostgreSQL and learn database introspection, baselining, and querying. - [Add Prisma ORM to an existing Prisma Postgres project](docs//getting-started/prisma-orm/add-to-existing-project/prisma-postgres.md): Add Prisma ORM to an existing TypeScript project with Prisma Postgres and learn database introspection, baselining, and querying. - [Add Prisma ORM to an existing project](docs//orm/getting-started/add-to-existing-project.md): This section provides a step-by-step guide to add Prisma ORM to an existing project. - [Add Prisma ORM to an existing SQL Server project](docs//getting-started/prisma-orm/add-to-existing-project/sql-server.md): Add Prisma ORM to an existing TypeScript project with SQL Server and learn database introspection, baselining, and querying. - [Add Prisma ORM to an existing SQLite project](docs//getting-started/prisma-orm/add-to-existing-project/sqlite.md): Add Prisma ORM to an existing TypeScript project with SQLite and learn database introspection, baselining, and querying. - [Aggregation, grouping, and summarizing](docs//orm/prisma-client/queries/aggregation-grouping-summarizing.md): Use Prisma Client to aggregate, group by, count, and select distinct. - [AI tools](docs//orm/more/ai-tools.md): Learn tips and best practices for using Prisma ORM in AI coding tools, like Cursor, ChatGPT, Tabnine, Lovable, v0 and more. - [An introduction to PostgreSQL data types](docs//orm/more/help-and-troubleshooting/dataguide/introduction-to-data-types.md): PostgreSQL's data type system allows you to define your data structures and store data in various formats. These are some of the most common data types. - [API reference](docs//postgres/database/api-reference.md): API reference documentation for Prisma Postgres. - [API Reference](docs//accelerate/api-reference.md): API reference documentation for Accelerate. - [Autocompletion in GraphQL resolvers with JavaScript](docs//orm/more/help-and-troubleshooting/autocompletion-in-graphql-resolvers-with-js.md): Learn how you can get autocompletion for Prisma Client queries in GraphQL resolvers with plain JavaScript - [Backups](docs//postgres/database/backups.md): Learn about backups in Prisma Postgres - [Baselining a database](docs//orm/prisma-migrate/workflows/baselining.md): How to initialize a migration history for an existing database that contains important data. - [Beyond Prisma ORM](docs//orm/overview/beyond-prisma-orm.md): Prisma ORM addresses many development needs, but Prisma's additional products like Prisma Postgres, Accelerate and Optimize can further enhance scalability and performance for your applications. - [Boilerplate content](docs//about/style-guide/boilerplate-content.md): Boilerplate content for the Prisma docs. - [Build faster with Prisma + AI](docs//ai.md): AI - [Caching queries in Prisma Accelerate](docs//accelerate/caching.md): Learn everything you need to know to use Accelerate's global database caching. - [Caching queries in Prisma Postgres](docs//postgres/database/caching.md): Learn about caching queries in Prisma Postgres - [Case sensitivity](docs//orm/prisma-client/queries/case-sensitivity.md): How Prisma Client handles case sensitivity when filtering and sorting. - [Caveats when deploying to AWS platforms](docs//orm/prisma-client/deployment/caveats-when-deploying-to-aws-platforms.md): Known caveats when deploying to an AWS platform - [ChatGPT](docs//orm/more/ai-tools/chatgpt.md): Learn how to add the remote Prisma MCP server to ChatGPT to manage your Prisma Postgres databases. - [Cloudflare D1](docs//orm/overview/databases/cloudflare-d1.md): Guide to Cloudflare D1 - [CockroachDB](docs//orm/overview/databases/cockroachdb.md): Guide to CockroachDB - [Codemods](docs//orm/more/upgrade-guides/upgrading-versions/codemods.md): Use codemods to upgrade your codebase as Prisma ORM evolves. - [Commands](docs//platform/platform-cli/commands.md): This document describes the Prisma Data Platform's integrated Prisma CLI commands, arguments, and options. - [Compare Accelerate](docs//accelerate/compare.md): Learn how Prisma Accelerate compares to other connection poolers like pgbouncer. - [Compare columns of the same table with raw queries](docs//orm/more/help-and-troubleshooting/comparing-columns-through-raw-queries.md): Compare columns with inbuilt raw query methods in Prisma - [Comparing Prisma ORM](docs//orm/more/comparisons.md): Learn how Prisma ORM compares to other ORMs, ODMs, and database libraries, like TypeORM, Sequelize and Mongoose. - [Composite types](docs//orm/prisma-client/special-fields-and-types/composite-types.md): Composite types - [Comprehensive Guide to Using Prisma ORM with Next.js](docs//orm/more/help-and-troubleshooting/nextjs-help.md): Learn best practices, monorepo strategies, and dynamic usage techniques for Prisma ORM in Next.js applications. - [Computed fields](docs//orm/prisma-client/queries/computed-fields.md): This page explains how to use client extensions to add computed fields to Prisma models. - [Configure Prisma Client with PgBouncer](docs//orm/prisma-client/setup-and-configuration/databases-connections/pgbouncer.md): Configure Prisma Client with PgBouncer and other poolers: when to use pgbouncer=true, required transaction mode, prepared statements, and Prisma Migrate workarounds. - [Configuring error formatting](docs//orm/prisma-client/setup-and-configuration/error-formatting.md): This page explains how to configure the formatting of errors when using Prisma Client. - [Connecting to PostgreSQL databases](docs//orm/more/help-and-troubleshooting/dataguide/connecting-to-postgresql-databases.md): Before you can manage your data with PostgreSQL, you need to be able to connect to the database server. In this guide, we'll use the `psql` command line client to demonstrate how to connect to PostgreSQL databases. - [Connection management](docs//orm/prisma-client/setup-and-configuration/databases-connections/connection-management.md): This page explains how database connections are handled with Prisma Client and how to manually connect and disconnect your database. - [Connection pool](docs//orm/prisma-client/setup-and-configuration/databases-connections/connection-pool.md): Prisma ORM's query engine creates a connection pool to store and manage database connections. - [Connection pooling](docs//postgres/database/connection-pooling.md): Learn about connection pooling in Prisma Postgres - [Connection Pooling](docs//accelerate/connection-pooling.md): Learn about everything you need to know to use Accelerate's connection pooling. - [Connection URLs](docs//orm/reference/connection-urls.md): Learn about the format and syntax Prisma ORM uses for defining database connection URLs for PostgreSQL, MySQL and SQLite. - [connection-pool](docs//reference/errors/connection-pool.md) - [Converting Implicit many-to-many relation to Explicit many-to-many relation](docs//orm/more/help-and-troubleshooting/implicit-to-explicit-conversion.md): Learn how to convert implicit many-to-many relation to explicit many-to-many relation - [CRUD](docs//orm/prisma-client/queries/crud.md): How to perform CRUD with Prisma Client. - [Cursor](docs//orm/more/ai-tools/cursor.md): Learn tips and best practices for using Prisma ORM with the Cursor AI code editor. - [Custom model and field names](docs//orm/prisma-client/setup-and-configuration/custom-model-and-field-names.md): Learn how you can decouple the naming of Prisma models from database tables to improve the ergonomics of the generated Prisma Client API. - [Custom models](docs//orm/prisma-client/queries/custom-models.md): This page explains how to wrap Prisma Client in custom models - [Custom validation](docs//orm/prisma-client/queries/custom-validation.md): This page explains how to add custom validation to Prisma Client - [Customizing migrations](docs//orm/prisma-migrate/workflows/customizing-migrations.md): How to edit a migration file before applying it to avoid data loss in production. - [Data migrations](docs//orm/prisma-migrate/workflows/data-migration.md): How to migrate data using Prisma ORM with the expand and contract pattern. - [Data model](docs//orm/prisma-schema/data-model.md): Learn everything you need about the Prisma schema data model. - [Data modeling](docs//orm/overview/introduction/data-modeling.md): Learn how data modeling with Prisma differs from data modeling with SQL or ORMs. Prisma uses a declarative data modeling language to describe a database schema. - [Data sources](docs//orm/prisma-schema/overview/data-sources.md): Data sources enable Prisma to connect to your database. This page explains how to configure data sources in your Prisma schema. - [Data validation with CHECK constraints (PostgreSQL)](docs//orm/more/help-and-troubleshooting/check-constraints.md): Learn how to configure CHECK constraints for data validation with Prisma ORM and PostgreSQL by following the step-by-step instructions in this practical guide. - [Database](docs//postgres/database.md): Explore core database features in Prisma Postgres, including caching, connection pooling, backups, and API access. - [Database connections](docs//orm/prisma-client/setup-and-configuration/databases-connections.md): Databases connections - [Database drivers](docs//orm/overview/databases/database-drivers.md): Learn how Prisma connects to your database using the built-in drivers and how you can use Prisma along with other JavaScript database drivers using driver adapters (Preview) - [Database features matrix](docs//orm/reference/database-features.md): Learn which database features are supported in Prisma ORM and how they map to the different Prisma ORM tools. - [Database mapping](docs//orm/prisma-schema/data-model/database-mapping.md): Database mapping in Prisma schema - [Database polyfills](docs//orm/prisma-client/setup-and-configuration/database-polyfills.md): Prisma Client provides features that are not achievable with relational databases. These features are referred to as "polyfills" and explained on this page. - [Databases](docs//orm/overview/databases.md): Databases - [Dataguide](docs//orm/more/help-and-troubleshooting/dataguide.md): Learn how databases work, how to choose the right one, and how to use databases with your applications to their full potential. - [Debugging](docs//orm/prisma-client/debugging-and-troubleshooting/debugging.md): This page explains how to enable debugging output for Prisma Client by setting the `DEBUG` environment variable. - [Debugging & troubleshooting](docs//orm/prisma-client/debugging-and-troubleshooting.md): Debugging & troubleshooting - [Deploy migrations from a local environment](docs//orm/prisma-client/deployment/deploy-migrations-from-a-local-environment.md): Learn how to deploy Node.js and TypeScript applications that are using Prisma Client locally. - [Deploy Prisma ORM](docs//orm/prisma-client/deployment/deploy-prisma.md): Learn more about the different deployment paradigms for Node.js applications and how they affect deploying an application using Prisma Client. - [Deploy to a different OS](docs//orm/prisma-client/deployment/deploy-to-a-different-os.md): Learn how to deploy Node.js and TypeScript applications that are using Prisma Client to a different operating system. - [Deploy to AWS Lambda](docs//orm/prisma-client/deployment/serverless/deploy-to-aws-lambda.md): Learn how to deploy your Prisma ORM-backed applications to AWS Lambda with AWS SAM, Serverless Framework, or SST - [Deploy to Azure Functions](docs//orm/prisma-client/deployment/serverless/deploy-to-azure-functions.md): Learn how to deploy a Prisma Client based REST API to Azure Functions and connect to an Azure SQL database - [Deploy to Cloudflare Workers & Pages](docs//orm/prisma-client/deployment/edge/deploy-to-cloudflare.md): Learn the things you need to know in order to deploy an app that uses Prisma Client for talking to a database to a Cloudflare Worker or to Cloudflare Pages. - [Deploy to Deno Deploy](docs//orm/prisma-client/deployment/edge/deploy-to-deno-deploy.md): Learn how to deploy a TypeScript application to Deno Deploy. - [Deploy to Fly.io](docs//orm/prisma-client/deployment/traditional/deploy-to-flyio.md): Learn how to deploy a Node.js server that uses Prisma ORM to Fly.io. - [Deploy to Heroku](docs//orm/prisma-client/deployment/traditional/deploy-to-heroku.md): Learn how to deploy a Node.js server that uses Prisma ORM to Heroku. - [Deploy to Koyeb](docs//orm/prisma-client/deployment/traditional/deploy-to-koyeb.md): Learn how to deploy a Node.js server that uses Prisma ORM to Koyeb Serverless Platform. - [Deploy to Netlify](docs//orm/prisma-client/deployment/serverless/deploy-to-netlify.md): Learn how to deploy Node.js and TypeScript applications that are using Prisma Client to Netlify. - [Deploy to Railway](docs//orm/prisma-client/deployment/traditional/deploy-to-railway.md): Learn how to deploy an app that uses Prisma ORM and Prisma Postgres to Railway. - [Deploy to Render](docs//orm/prisma-client/deployment/traditional/deploy-to-render.md): Learn how to deploy a Node.js server that uses Prisma ORM to Render. - [Deploy to Sevalla](docs//orm/prisma-client/deployment/traditional/deploy-to-sevalla.md): Learn how to deploy a Node.js server that uses Prisma ORM to Sevalla. - [Deploy to Vercel](docs//orm/prisma-client/deployment/serverless/deploy-to-vercel.md): Learn how to deploy a Next.js application based on Prisma Client to Vercel. - [Deploy to Vercel Edge Functions & Middleware](docs//orm/prisma-client/deployment/edge/deploy-to-vercel.md): Learn the things you need to know in order to deploy an Edge function that uses Prisma Client for talking to a database. - [Deploying database changes with Prisma Migrate](docs//orm/prisma-client/deployment/deploy-database-changes-with-prisma-migrate.md): Learn how to deploy database changes with Prisma Migrate. - [Deploying edge functions with Prisma ORM](docs//orm/prisma-client/deployment/edge/overview.md): Learn how to deploy your Prisma-backed apps to edge functions like Cloudflare Workers or Vercel Edge Functions - [Deployment](docs//orm/prisma-client/deployment.md): How to deploy a Node.js application that uses Prisma Client and TypeScript to various cloud platforms. - [Development and production](docs//orm/prisma-migrate/workflows/development-and-production.md): Development and production - [Development environment](docs//orm/more/development-environment.md): Using env vars, editors and workspaces in your development environment - [Direct connections](docs//postgres/database/direct-connections.md): Learn about connecting directly to your Prisma Postgres database via direct TCP. - [Docs example data model](docs//about/style-guide/schema-models.md): This page describes the data models we use in our documentation examples. - [Drizzle](docs//orm/more/comparisons/prisma-and-drizzle.md): Learn how Prisma ORM compares to Drizzle. - [Edge functions](docs//orm/prisma-client/deployment/edge.md): Learn how to deploy your Prisma ORM-backed apps to edge functions like Cloudflare Workers or Vercel Edge Functions - [Editor setup](docs//orm/more/development-environment/editor-setup.md): Learn how to configure your editor and IDEs for an optimal developer experience with Prisma ORM. - [Embed Studio](docs//postgres/database/prisma-studio/embedding-studio.md): Learn how to embed Prisma Studio in your own applications to provide users with an amazing data editing experience. - [Engines](docs//orm/more/under-the-hood/engines.md): Prisma's query engine manages the communication with the database when using Prisma ORM. Learn how it works on this page. - [Environment variables reference](docs//orm/reference/environment-variables-reference.md): This page gives an overview of all environment variables available for use. - [Error message reference](docs//orm/reference/error-reference.md): Prisma Client, Migrate, Introspection error message reference - [Error reference](docs//postgres/database/api-reference/error-reference.md): Error reference documentation for Prisma Postgres. - [Evaluating](docs//accelerate/evaluating.md): Learn about evaluating Prisma Accelerate. - [Excessive number of rows returned](docs//postgres/query-optimization/recommendations/excessive-number-of-rows-returned.md): Learn about the recommendation provided by Optimize for excessive number of rows returned. - [Excluding fields](docs//orm/prisma-client/queries/excluding-fields.md): This page explains how to exclude sensitive fields from Prisma Client - [Extensions](docs//orm/prisma-client/client-extensions.md): Extend the functionality of Prisma Client - [External tables](docs//orm/prisma-schema/data-model/externally-managed-tables.md): How to declare and use externally managed tables in Prisma ORM - [FAQ](docs//optimize/faq.md): Frequently asked questions about Prisma Optimize. - [Feedback](docs//accelerate/feedback.md): Learn where to submit feedback about Accelerate. - [Fields & types](docs//orm/prisma-client/special-fields-and-types.md): Learn how to use about special fields and types with Prisma Client. - [Filtering and Sorting](docs//orm/prisma-client/queries/filtering-and-sorting.md): Use Prisma Client API to filter records by any combination of fields or related record fields, and/or sort query results. - [Fine-Grained Authorization (Permit)](docs//orm/prisma-client/client-extensions/shared-extensions/permit-rbac.md): Learn how to implement RBAC, ABAC, and ReBAC authorization in your Prisma applications - [Firebase Studio](docs//postgres/integrations/idx.md): Learn how to use Prisma Postgres in the online Firebase Studio. - [Fly.io](docs//postgres/integrations/flyio.md): Learn how to deploy applications using Prisma Postgres to Fly.io. - [From the CLI](docs//getting-started/prisma-postgres/from-the-cli.md): Start building a Prisma application with a Prisma Postgres database from the CLI - [Front matter](docs//about/docs-components/frontmatter.md): Supported front matter variables. - [Full table scans caused by LIKE operations](docs//postgres/query-optimization/recommendations/full-table-scans-caused-by-like-operations.md): Learn about the recommendation provided by Optimize for full table scans caused by Like operations. - [Full-text search](docs//orm/prisma-client/queries/full-text-search.md): This page explains how to search for text within a field. - [Fullstack](docs//orm/overview/prisma-in-your-stack/fullstack.md): This page gives explains how to build fullstack applications with Prisma. It shows how Prisma fits in with fullstack frameworks and provides practical examples - [General](docs//platform/about.md): Learn about the Console to integrate the Prisma Data Platform products. - [Generating down migrations](docs//orm/prisma-migrate/workflows/generating-down-migrations.md): How to generate down migrations - [Generating Prisma Client](docs//orm/prisma-client/setup-and-configuration/generating-prisma-client.md): This page explains how to generate Prisma Client. It also provides additional context on the generated client, typical workflows and Node.js configuration. - [Generators](docs//orm/prisma-schema/overview/generators.md): Generators in your Prisma schema specify what assets are generated when the `prisma generate` command is invoked. This page explains how to configure generators. - [Get started with the Prisma Management API](docs//guides/management-api-basic.md): Learn how to get started with the Prisma Management API - [Getting started](docs//getting-started.md): Build data-driven applications with ease using Prisma ORM, add connection pooling or global caching with Prisma Accelerate. - [Getting started](docs//postgres/getting-started.md): Learn how to quickly set up and start using Prisma Postgres. - [Getting Started](docs//optimize/getting-started.md): Learn how to quickly set up and start using Prisma Optimize. - [Getting started with Prisma Accelerate](docs//accelerate/getting-started.md): Learn how to get up and running with Prisma Accelerate. - [Getting started with Prisma Migrate](docs//orm/prisma-migrate/getting-started.md): Learn how to migrate your schema in a development environment using Prisma Migrate. - [Getting started with Prisma ORM](docs//orm/getting-started.md): This section provides a quick step-by-step guide to get started with Prisma ORM. - [GitHub Copilot](docs//orm/more/ai-tools/github-copilot.md): Learn about the features available with GitHub Copilot and Prisma ORM, plus best practices and tips. - [Glossary of common database terminology](docs//orm/more/help-and-troubleshooting/dataguide/database-glossary.md): Database terminology can be difficult to understand. This glossary was designed to help you learn important terminology by providing definitions and context in one place. - [GraphQL](docs//orm/overview/prisma-in-your-stack/graphql.md): This page gives explains how to build GraphQL servers with Prisma ORM. It shows how Prisma ORM fits into the GraphQL ecosystem and provides practical examples. - [Guides](docs//guides.md): A collection of guides for various tasks and workflows. - [Handling exceptions and errors](docs//orm/prisma-client/debugging-and-troubleshooting/handling-exceptions-and-errors.md): This page covers how to handle exceptions and errors - [Help articles](docs//orm/more/help-and-troubleshooting.md): Common problems and how to solve them. - [How to embed Prisma Studio in a Next.js app with Prisma Postgres](docs//guides/embed-studio-nextjs.md): Learn how to embed Prisma Studio directly in your Next.js application for database management - [How to manage schema changes in a team](docs//guides/implementing-schema-changes.md): Learn how to use Prisma Migrate effectively when collaborating on a project as a team - [How to migrate from Drizzle to Prisma ORM](docs//guides/migrate-from-drizzle.md): Learn how to migrate from Drizzle to Prisma ORM - [How to migrate from Mongoose to Prisma ORM](docs//guides/migrate-from-mongoose.md): Learn how to migrate from Mongoose to Prisma ORM - [How to migrate from Sequelize to Prisma ORM](docs//guides/migrate-from-sequelize.md): Learn how to migrate from Sequelize to Prisma ORM - [How to migrate from TypeORM to Prisma ORM](docs//guides/migrate-from-typeorm.md): Learn how to migrate from TypeORM to Prisma ORM - [How to provision preview databases with GitHub Actions and Prisma Postgres](docs//guides/github-actions.md): Provision and manage Prisma Postgres databases per pull request using GitHub Actions and Prisma Management API - [How to set up Datadog tracing with Prisma ORM and Prisma Postgres](docs//guides/data-dog.md): Learn how to configure Datadog tracing for a Prisma ORM project. Capture spans for every query using the @prisma/instrumentation package, dd-trace, and view them in Datadog. - [How to upgrade](docs//orm/more/upgrade-guides/upgrade-from-prisma-1/how-to-upgrade.md): Learn how to upgrade your Prisma 1 project to Prisma ORM version 2.x and later - [How to use AI SDK with Prisma ORM, Prisma Postgres, and Next.js for chat applications](docs//guides/ai-sdk-nextjs.md): Build a chat application with AI SDK, Prisma, and Next.js to store chat sessions and messages - [How to use Prisma in Docker](docs//guides/docker.md): Learn step-by-step configure a Prisma ORM app in Docker - [How to use Prisma ORM and Prisma Postgres in a pnpm workspaces monorepo](docs//guides/use-prisma-in-pnpm-workspaces.md): Learn step-by-step how to integrate Prisma ORM in a pnpm workspaces monorepo to build scalable and modular applications efficiently. - [How to use Prisma ORM and Prisma Postgres with Astro](docs//guides/astro.md): Learn how to use Prisma ORM in an Astro app - [How to use Prisma ORM and Prisma Postgres with Auth.js and Next.js](docs//guides/authjs-nextjs.md): Learn how to use Prisma ORM in a Next.js app with Auth.js - [How to use Prisma ORM and Prisma Postgres with Better Auth and Astro](docs//guides/betterauth-astro.md): Learn how to use Prisma ORM in an Astro app with Better Auth - [How to use Prisma ORM and Prisma Postgres with Better Auth and Next.js](docs//guides/betterauth-nextjs.md): Learn how to use Prisma ORM in a Next.js app with Better Auth - [How to use Prisma ORM and Prisma Postgres with Bun](docs//guides/bun.md): Learn how to use Prisma ORM in a Bun application with Prisma Postgres - [How to use Prisma ORM and Prisma Postgres with Clerk Auth and Astro](docs//guides/clerk-astro.md): Learn how to use Prisma ORM in an Astro app with Clerk Auth - [How to use Prisma ORM and Prisma Postgres with Clerk Auth and Next.js](docs//guides/clerk-nextjs.md): Learn how to use Prisma ORM in a Next.js app with Clerk Auth - [How to use Prisma ORM and Prisma Postgres with Cloudflare Workers](docs//guides/cloudflare-workers.md): Learn how to use Prisma ORM in a Cloudflare Workers project - [How to use Prisma ORM and Prisma Postgres with Elysia](docs//guides/elysia.md): Learn how to use Prisma ORM in an Elysia app - [How to use Prisma ORM and Prisma Postgres with Hono](docs//guides/hono.md): Learn how to use Prisma ORM in a Hono app - [How to use Prisma ORM and Prisma Postgres with NestJS](docs//guides/nestjs.md): Learn how to use Prisma ORM in a NestJS app - [How to use Prisma ORM and Prisma Postgres with Next.js](docs//guides/nextjs.md): Learn how to use Prisma ORM in a Next.js app and deploy it to Vercel - [How to use Prisma ORM and Prisma Postgres with Nuxt](docs//guides/nuxt.md): A step-by-step guide to setting up and using Prisma ORM and Prisma Postgres in a Nuxt app. - [How to use Prisma ORM and Prisma Postgres with React Router 7](docs//guides/react-router-7.md): Learn how to use Prisma ORM and Prisma Postgres in a React Router 7 app. - [How to use Prisma ORM and Prisma Postgres with SolidStart](docs//guides/solid-start.md): Learn how to use Prisma ORM in a SolidStart app - [How to use Prisma ORM and Prisma Postgres with SvelteKit](docs//guides/sveltekit.md): Learn how to use Prisma ORM in a SvelteKit app - [How to use Prisma ORM and Prisma Postgres with Turborepo](docs//guides/turborepo.md): Learn step-by-step how to integrate Prisma ORM with Turborepo to build modular, scalable monorepo architectures efficiently. - [How to use Prisma ORM with Cloudflare D1](docs//guides/cloudflare-d1.md): Learn how to use Prisma ORM with Cloudflare D1 - [How to use Prisma ORM with multiple databases in a single app](docs//guides/multiple-databases.md): Learn how to use multiple Prisma Clients in a single app to connect to multiple databases, handle migrations, and deploy your application to Vercel. - [How to use Prisma ORM with Permit.io](docs//guides/permit-io-access-control.md): Learn how to implement access control with Prisma ORM with Permit.io - [How to use Prisma ORM with TanStack Start](docs//guides/tanstack-start.md): Learn how to use Prisma ORM in a TanStack Start app - [How to use Prisma ORM's type system](docs//orm/prisma-client/type-safety/prisma-type-system.md): How to use Prisma ORM's type system - [How to use Prisma Postgres with Shopify](docs//guides/shopify.md): Learn how to use Prisma Postgres with Shopify - [How to write guides for Prisma ORM](docs//guides/making-guides.md): Learn how to write clear, consistent, and helpful guides for Prisma ORM documentation - [Import data from an existing MySQL database](docs//getting-started/prisma-postgres/import-from-existing-database-mysql.md): Learn how to import data from an existing MySQL database into Prisma Postgres. - [Import data from an existing PostgreSQL database](docs//getting-started/prisma-postgres/import-from-existing-database-postgresql.md): Learn how to import data from an existing PostgreSQL database into Prisma Postgres. - [Import data from an existing PostgreSQL database](docs//postgres/getting-started/import-from-existing-database.md): Learn how to import data from an existing PostgreSQL database into Prisma Postgres. - [Import data from an existing PostgreSQL database](docs//postgres/introduction/import-from-existing-database.md): Learn how to import data from an existing database into Prisma Postgres. - [Indexes](docs//orm/prisma-schema/data-model/indexes.md): How to configure index functionality and add full text indexes - [Indexing on unique columns](docs//postgres/query-optimization/recommendations/indexing-on-unique-columns.md): Learn about the recommendation provided by Optimize regarding indexing on uniquely constrained columns. - [Instant app deployment with Vercel and Prisma Postgres](docs//guides/vercel-app-deployment.md): Learn how to programmatically deploy applications with Vercel and Prisma Postgres using the instant deployment API - [Instantiating Prisma Client](docs//orm/prisma-client/setup-and-configuration/instantiate-prisma-client.md): How to create and use an instance of PrismaClient in your app. - [Integrate Prisma Postgres with Deno Deploy](docs//guides/deno-integration.md): Learn how to integrate Prisma Postgres in a Deno Deploy project using a simple Deno application. - [Integration testing](docs//orm/prisma-client/testing/integration-testing.md): Learn how to setup and run integration tests with Prisma and Docker - [Introduction to PostgreSQL connection URIs](docs//orm/more/help-and-troubleshooting/dataguide/connection-uris.md): Learn how to encode PostgreSQL connection details in connection URIs for applications and libraries - [Introduction to Prisma Client](docs//orm/prisma-client/setup-and-configuration/introduction.md): Learn how to set up Prisma Client. - [Introduction to Prisma ORM](docs//orm/overview/introduction.md): This section gives a high-level overview of what Prisma is and how it works. It's a great starting point for Prisma newcomers! - [Introduction to Prisma Postgres](docs//postgres/introduction.md): Understand the basics of Prisma Postgres, including key features and how to get started. - [Is Prisma ORM an ORM?](docs//orm/overview/prisma-in-your-stack/is-prisma-an-orm.md): Learn about how Prisma ORM implements the Data Mapper ORM pattern and how it achieves the same goal as traditional ORMs without requiring you to map classes to tables as traditional ORMs do. - [jsonProtocol changes](docs//orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-5/jsonprotocol-changes.md): Changes that need to be made to your app in Prisma ORM 5 due to the jsonProtocol - [Known limitations about Prisma Accelerate](docs//accelerate/known-limitations.md): Learn about limitations of Accelerate. - [Known limitations about Prisma Optimize](docs//optimize/known-limitations.md): Learn about known limitations of Optimize. - [Legacy Prisma Migrate](docs//orm/prisma-migrate/understanding-prisma-migrate/legacy-migrate.md): Legacy Prisma Migrate is a declarative data modeling and schema migration tool that is available via the Prisma CLI. - [Limitations and known issues](docs//orm/prisma-migrate/understanding-prisma-migrate/limitations-and-known-issues.md): The following limitations apply to Prisma Migrate. - [Local development for Prisma Accelerate](docs//accelerate/local-development.md): Learn how to use Prisma Accelerate in a development environment. - [Local development with Prisma Postgres](docs//postgres/database/local-development.md): Guide to setting up local development using Prisma Postgres (Early Access) - [Logging](docs//orm/prisma-client/observability-and-logging/logging.md): Learn how to configure Prisma Client to log the raw SQL queries it sends to the database and other information. - [Long-running transactions](docs//postgres/query-optimization/recommendations/long-running-transactions.md): Learn about the recommendation provided by Optimize for long-running transaction. - [Management API](docs//postgres/introduction/management-api.md): Management API reference documentation for Prisma Postgres. - [Management API SDK](docs//postgres/introduction/management-api-sdk.md): A TypeScript SDK for the Prisma Data Platform Management API. Use the simple client for direct API access, or the full SDK with built-in OAuth authentication and automatic token refresh. - [Managing Prisma ORM environment variables and settings](docs//orm/more/development-environment/environment-variables.md): Learn how to manage the environment variables and settings in your Prisma ORM project - [Many-to-many relations](docs//orm/prisma-schema/data-model/relations/many-to-many-relations.md): How to define and work with many-to-many relations in Prisma. - [Maturity levels](docs//platform/maturity-levels.md): Understand the maturity levels for features in Prisma Data Platform - [MCP server](docs//postgres/integrations/mcp-server.md): Manage Prisma Postgres databases using LLMs with the Prisma Model-Context-Protocol (MCP) Server - [MDX components](docs//about/docs-components/mdx-examples.md): MDX components components available on the Prisma documentation site. - [Mental model](docs//orm/prisma-migrate/understanding-prisma-migrate/mental-model.md): A mental model guide for working with Prisma Migrate in your project - [Metrics](docs//orm/prisma-client/observability-and-logging/metrics.md): Diagnose application performance with insights into Prisma Client database activity. - [Microsoft SQL Server](docs//orm/overview/databases/sql-server.md): This page explains how Prisma can connect to a Microsoft SQL Server database using the Microsoft SQL Server database connector. - [migrate](docs//reference/errors/migrate.md) - [Migrate data using the expand and contract pattern](docs//guides/data-migration.md): Learn how to perform data migrations using the expand and contract pattern with Prisma ORM - [migrate-baseline](docs//reference/errors/migrate-baseline.md) - [migrate-no-direct-ddl](docs//reference/errors/migrate-no-direct-ddl.md) - [migrate-no-foreign-keys](docs//reference/errors/migrate-no-foreign-keys.md) - [migrate-provider-switch](docs//reference/errors/migrate-provider-switch.md) - [migrate-resolve](docs//reference/errors/migrate-resolve.md) - [migrate-shadow](docs//reference/errors/migrate-shadow.md) - [Migrating to Prisma 7](docs//ai/prompts/prisma-7.md): Step-by-step guide for migration your app to use the version 7 of Prisma ORM - [Modeling and querying many-to-many relations](docs//orm/more/help-and-troubleshooting/working-with-many-to-many-relations.md): Learn how you can model and query implicit and explicit many-to-many relations with Prisma ORM - [Models](docs//orm/prisma-schema/data-model/models.md): Learn about the concepts for building your data model with Prisma: Models, scalar types, enums, attributes, functions, IDs, default values and more. - [Module bundlers](docs//orm/prisma-client/deployment/module-bundlers.md): This page gives an overview of the most important things to be aware of when using a module bundler to bundle an application that uses Prisma Client. - [mongodb-replica-set](docs//reference/errors/mongodb-replica-set.md) - [Mongoose](docs//orm/more/comparisons/prisma-and-mongoose.md): Learn how Prisma ORM compares to Mongoose. - [More resources for Prisma ORM](docs//orm/more.md): Learn more about Prisma ORM. - [More resources for Prisma Postgres](docs//postgres/more.md): Explore known limitations, troubleshooting steps, and common FAQs for Prisma Postgres. - [Multi-schema](docs//orm/prisma-schema/data-model/multi-schema.md): How to use Prisma ORM with multiple database schemas - [MySQL/MariaDB](docs//orm/overview/databases/mysql.md): This page explains how Prisma can connect to a MySQL or MariaDB database using the MySQL database connector. - [Named constraints upgrade path](docs//orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-3/named-constraints.md): Guides on how to handle named constraints using Prisma Introspect or Prisma Migrate when upgrading to Prisma 3 - [Native database functions](docs//orm/prisma-migrate/workflows/native-database-functions.md): How to enable PostgreSQL native database functions for projects that use Prisma Migrate. - [Native database types](docs//orm/prisma-migrate/workflows/native-database-types.md): Native database types - [Neon](docs//orm/overview/databases/neon.md): Guide to Neon - [Netlify](docs//postgres/integrations/netlify.md): Learn how to create Prisma Postgres databases via the official Netlify extension and deploy your applications with it. - [Netlify build dependency caching workaround](docs//orm/more/help-and-troubleshooting/netlify-caching-issue.md): Learn to configure your build process on Netlify to avoid caching-related problems - [No Rust engine](docs//orm/prisma-client/setup-and-configuration/no-rust-engine.md): Learn how to use Prisma ORM without Rust engines - [npx create-db](docs//postgres/introduction/npx-create-db.md): Learn how to provision temporary Prisma Postgres databases with npx create-db. - [Null and undefined](docs//orm/prisma-client/special-fields-and-types/null-and-undefined.md): How Prisma Client handles null and undefined - [Observability & logging](docs//orm/prisma-client/observability-and-logging.md): Observability & logging - [Old to new Nexus](docs//orm/more/upgrade-guides/upgrade-from-prisma-1/upgrading-nexus-prisma-to-nexus.md): Learn how to upgrade existing Prisma 1 projects with nexus-prisma to Prisma ORM 2 and Nexus. - [One doc tagged with "Alpine"](docs//tags/alpine.md) - [One doc tagged with "APM"](docs//tags/apm.md) - [One doc tagged with "Application Performance Monitoring"](docs//tags/application-performance-monitoring.md) - [One doc tagged with "ci-cd"](docs//tags/ci-cd.md) - [One doc tagged with "Containerization"](docs//tags/containerization.md) - [One doc tagged with "data-migration"](docs//tags/data-migration.md) - [One doc tagged with "Datadog"](docs//tags/datadog.md) - [One doc tagged with "Docker"](docs//tags/docker.md) - [One doc tagged with "Dynamic Usage"](docs//tags/dynamic-usage.md) - [One doc tagged with "Embedding"](docs//tags/embedding.md) - [One doc tagged with "expand-and-contract"](docs//tags/expand-and-contract.md) - [One doc tagged with "Framework"](docs//tags/framework.md) - [One doc tagged with "git"](docs//tags/git.md) - [One doc tagged with "guides"](docs//tags/guides.md) - [One doc tagged with "Multiple databases"](docs//tags/multiple-databases.md) - [One doc tagged with "Multiple Prisma Clients"](docs//tags/multiple-prisma-clients.md) - [One doc tagged with "NestJS"](docs//tags/nest-js.md) - [One doc tagged with "Nuxt"](docs//tags/nuxt.md) - [One doc tagged with "optimization"](docs//tags/optimization.md) - [One doc tagged with "ORM"](docs//tags/orm.md) - [One doc tagged with "pnpm workspace"](docs//tags/pnpm-workspace.md) - [One doc tagged with "postgresql"](docs//tags/postgresql.md) - [One doc tagged with "Prisma ORM"](docs//tags/prisma-orm.md) - [One doc tagged with "Prisma Postgres"](docs//tags/prisma-postgres.md) - [One doc tagged with "Prisma Studio"](docs//tags/prisma-studio.md) - [One doc tagged with "prisma-migrate"](docs//tags/prisma-migrate.md) - [One doc tagged with "Prisma"](docs//tags/prisma.md) - [One doc tagged with "production"](docs//tags/production.md) - [One doc tagged with "React Router"](docs//tags/react-router.md) - [One doc tagged with "REST API"](docs//tags/rest-api.md) - [One doc tagged with "schema-evolution"](docs//tags/schema-evolution.md) - [One doc tagged with "schema"](docs//tags/schema.md) - [One doc tagged with "Spans"](docs//tags/spans.md) - [One doc tagged with "testing"](docs//tags/testing.md) - [One doc tagged with "Tracing"](docs//tags/tracing.md) - [One doc tagged with "Turborepo"](docs//tags/turborepo.md) - [One doc tagged with "tutorials"](docs//tags/tutorials.md) - [One doc tagged with "workflows"](docs//tags/workflows.md) - [One-to-many relations](docs//orm/prisma-schema/data-model/relations/one-to-many-relations.md): How to define and work with one-to-many relations in Prisma. - [One-to-one relations](docs//orm/prisma-schema/data-model/relations/one-to-one-relations.md): How to define and work with one-to-one relations in Prisma. - [OpenTelemetry tracing](docs//orm/prisma-client/observability-and-logging/opentelemetry-tracing.md): Diagnose application performance with detailed traces of each query. - [Operating against partial structures of your model types](docs//orm/prisma-client/type-safety/operating-against-partial-structures-of-model-types.md): This page documents various scenarios for using the generated types from the Prisma namespace - [Optimizing TypeScript performance with large Prisma schemas](docs//orm/more/help-and-troubleshooting/typescript-performance-optimization.md): Learn how to dramatically improve TypeScript compilation performance when working with large Prisma schemas using type optimization strategies - [ORM](docs//orm.md): ORM - [ORM releases and maturity levels](docs//orm/more/releases.md): Learn about the release process, versioning, and maturity of Prisma ORM components and how to deal with breaking changes that might happen throughout releases. - [Overfetching](docs//postgres/query-optimization/recommendations/select-returning.md): Learn about the recommendation provided by Optimize for queries that are overfetching data. - [Overview](docs//orm/overview.md): Overview - [Overview on Prisma Migrate](docs//orm/prisma-migrate/understanding-prisma-migrate/overview.md): Learn everything you need to know about Prisma Migrate. - [Overview on Prisma Postgres](docs//postgres/introduction/overview.md): Learn everything you need to know about Prisma Postgres. - [Overview on Prisma Schema](docs//orm/prisma-schema/overview.md): The Prisma schema is the main method of configuration when using Prisma. It is typically called schema.prisma and contains your database connection and data model. - [Pagination](docs//orm/prisma-client/queries/pagination.md): Prisma Client supports both offset pagination and cursor-based pagination. Learn more about the pros and cons of different pagination approaches and how to implement them. - [Partner Database Provisioning & User Claim Flow](docs//guides/management-api.md): Learn how to use the Prisma Postgres Management API to provision and claim databases - [Patching & hotfixing](docs//orm/prisma-migrate/workflows/patching-and-hotfixing.md): How to reconcile the migration history after applying a hotfix or patch to a production environment. - [Performance metrics](docs//optimize/performance-metrics.md): Learn about the query performance metrics provided by Optimize. - [Performance metrics](docs//postgres/query-optimization/performance-metrics.md): Learn about the query performance metrics provided by Optimize. - [PlanetScale](docs//orm/overview/databases/planetscale.md): Guide to PlanetScale - [Platform](docs//platform.md): Get started with the Prisma Data Platform with its official documentation, and learn more about its features with reference documentation, guides, and more. - [Platform CLI](docs//platform/platform-cli.md): Learn about the CLI for Prisma Data Platform - [Postgres extensions](docs//postgres/database/postgres-extensions.md): Learn about using Postgres extensions with Prisma Postgres - [PostgreSQL](docs//orm/overview/databases/postgresql.md): This page explains how Prisma can connect to a PostgreSQL database using the PostgreSQL database connector. - [PostgreSQL extensions](docs//orm/prisma-schema/postgresql-extensions.md): How to install and manage PostgreSQL extensions with Prisma ORM using customized migrations, and how to use them in Prisma Client. - [Preview features](docs//orm/reference/preview-features.md): Previews are typically available behind a feature flag or require some form of opt-in. - [Prisma Accelerate](docs//accelerate.md): Prisma Accelerate is a global database cache with built-in connection pooling that helps improve database performance in Serverless and Edge applications. - [Prisma Accelerate examples](docs//accelerate/examples.md): Check out ready-to-run examples for Prisma Accelerate. - [Prisma AI](docs//optimize/prisma-ai.md): Learn about using Optimize's Prisma AI feature. - [Prisma CLI](docs//orm/tools/prisma-cli.md): The Prisma command line interface (CLI) is the primary way to interact with your Prisma project from the command line. - [Prisma CLI Preview features](docs//orm/reference/preview-features/cli-preview-features.md): Prisma CLI features that are currently in Preview. - [Prisma CLI reference](docs//orm/reference/prisma-cli-reference.md): This page gives an overview of all available Prisma CLI commands, explains their options and shows numerous usage examples. - [Prisma Client](docs//orm/prisma-client.md): Prisma Client is an auto-generated, type-safe query builder generated based on the models and attributes of your Prisma schema. - [Prisma Client & Prisma schema](docs//orm/reference/preview-features/client-preview-features.md): Prisma Client and Prisma schema features that are currently in Preview. - [Prisma Client API reference](docs//orm/reference/prisma-client-reference.md): API reference documentation for Prisma Client. - [Prisma Config reference](docs//orm/reference/prisma-config-reference.md): This page gives an overview of all Prisma config options available for use. - [Prisma Doc](docs//index.md): Get started with Prisma in the official documentation, and learn more about all Prisma's features with reference documentation, guides, and more. - [Prisma docs components](docs//about/docs-components.md): This section describes the Prisma docs file format. - [Prisma docs image guidelines](docs//about/style-guide/image-guidelines.md): This page provides guidelines for images in our docs. - [Prisma docs style guide](docs//about/style-guide.md): The Prisma style guide provides contributor guidelines for the Prisma docs. - [Prisma Migrate](docs//orm/prisma-migrate.md): Prisma Migrate is a database migration tool available via the Prisma CLI that integrates with Prisma schema for data modeling. - [Prisma Optimize](docs//optimize.md): Prisma Optimize is a tool that helps you generate insights on your queries and recommends performance optimizations. - [Prisma ORM in your stack](docs//orm/overview/prisma-in-your-stack.md): How Prisma ORM fits into your stack - [Prisma ORM MongoDB database connector](docs//orm/overview/databases/mongodb.md): How Prisma can connect to a MongoDB database using the MongoDB database connector. - [Prisma Postgres](docs//getting-started/prisma-postgres.md): Get started with Prisma ORM and your favorite database. Learn about data modeling, migrations and querying. - [Prisma Postgres](docs//postgres.md): Prisma Postgres - [Prisma Postgres FAQ](docs//postgres/more/faq.md): Learn about the FAQ regarding Prisma Postgres. - [Prisma product and component names](docs//about/style-guide/prisma-product-names.md): This section of the style guide provides guidelines on how to refer to Prisma products and components. - [Prisma schema](docs//orm/prisma-schema.md): Learn everything you need to know about the Prisma schema. - [Prisma schema reference](docs//orm/reference/prisma-schema-reference.md): API reference documentation for the Prisma Schema Language (PSL). - [Prisma Studio](docs//orm/tools/prisma-studio.md): Prisma Studio is a visual database editor. - [Prisma Studio](docs//postgres/database/prisma-studio.md): Learn about the various ways of using Prisma Studio, from running locally, to using it in VS Code to embedding it in your own application. - [Prisma validator](docs//orm/prisma-client/type-safety/prisma-validator.md): The Prisma validator is a utility function that takes a generated type and returns a type-safe object which adheres to the generated types model fields. - [prisma-binding to Nexus](docs//orm/more/upgrade-guides/upgrade-from-prisma-1/upgrading-prisma-binding-to-nexus.md): Learn how to upgrade existing Prisma 1 projects with prisma-binding to Prisma ORM 2.0 and Nexus. - [prisma-binding to SDL-first](docs//orm/more/upgrade-guides/upgrade-from-prisma-1/upgrading-prisma-binding-to-sdl-first.md): Learn how to upgrade existing Prisma 1 projects with prisma-binding to Prisma ORM 2 (SDL-first). - [Prototyping your schema](docs//orm/prisma-migrate/workflows/prototyping-your-schema.md): Prototyping your schema - [Queries](docs//orm/prisma-client/queries.md): Learn about the database queries you can send with Prisma Client. - [Queries on unindexed columns](docs//postgres/query-optimization/recommendations/queries-on-unindexed-columns.md): Learn about the recommendation provided by Optimize for queries on unindexed columns. - [Query optimization for Prisma Postgres](docs//postgres/query-optimization.md): Learn how to record, analyze, and improve query performance using Prisma Optimize in Prisma Postgres. - [Query optimization using Prisma Optimize](docs//orm/prisma-client/queries/query-optimization-performance.md): How Prisma optimizes queries under the hood - [Query optimization with Prisma AI](docs//postgres/query-optimization/prisma-ai.md): Learn about using Optimize's Prisma AI feature. - [Quickstart with Prisma ORM](docs//orm/getting-started/quickstart.md): This section provides a quick step-by-step guide to get started with Prisma ORM. - [Quickstart with Prisma ORM](docs//postgres/getting-started/quickstart.md): Create a new TypeScript project from scratch by connecting Prisma ORM to Prisma Postgres and generating a Prisma Client for database access. - [Quickstart with Prisma ORM and CockroachDB](docs//getting-started/prisma-orm/quickstart/cockroachdb.md): Create a new TypeScript project from scratch by connecting Prisma ORM to CockroachDB and generating a Prisma Client for database access. - [Quickstart with Prisma ORM and MongoDB](docs//getting-started/prisma-orm/quickstart/mongodb.md): Create a new TypeScript project from scratch by connecting Prisma ORM to MongoDB and generating a Prisma Client for database access. - [Quickstart with Prisma ORM and MySQL](docs//getting-started/prisma-orm/quickstart/mysql.md): Create a new TypeScript project from scratch by connecting Prisma ORM to MySQL and generating a Prisma Client for database access. - [Quickstart with Prisma ORM and PlanetScale](docs//getting-started/prisma-orm/quickstart/planetscale.md): Create a new TypeScript project from scratch by connecting Prisma ORM to PlanetScale MySQL and generating a Prisma Client for database access. - [Quickstart with Prisma ORM and PostgreSQL](docs//getting-started/prisma-orm/quickstart/postgresql.md): Create a new TypeScript project from scratch by connecting Prisma ORM to PostgreSQL and generating a Prisma Client for database access. - [Quickstart with Prisma ORM and Prisma Postgres](docs//getting-started/prisma-orm/quickstart/prisma-postgres.md): Create a new TypeScript project from scratch by connecting Prisma ORM to Prisma Postgres and generating a Prisma Client for database access. - [Quickstart with Prisma ORM and SQL Server](docs//getting-started/prisma-orm/quickstart/sql-server.md): Create a new TypeScript project from scratch by connecting Prisma ORM to SQL Server and generating a Prisma Client for database access. - [Quickstart with Prisma ORM and SQLite](docs//getting-started/prisma-orm/quickstart/sqlite.md): Create a new TypeScript project from scratch by connecting Prisma ORM to SQLite and generating a Prisma Client for database access. - [Raw queries](docs//orm/prisma-client/using-raw-sql/raw-queries.md): Learn how you can send raw SQL and MongoDB queries to your database using the raw() methods from the Prisma Client API. - [Read replicas](docs//orm/prisma-client/setup-and-configuration/read-replicas.md): Learn how to set up and use read replicas with Prisma Client - [Recommendations](docs//optimize/recommendations.md): Learn about using Optimize's recommendations. - [Recommendations](docs//postgres/query-optimization/recommendations.md): Learn about the recommendations provided by Optimize. - [Recordings](docs//postgres/query-optimization/recordings.md): Learn about using Optimize's recording feature. - [Recordings in Prisma Optimize](docs//optimize/recordings.md): Learn about using Optimize's recording feature. - [Reference](docs//orm/reference.md): Reference for Prisma Client API, Prisma CLI, errors & more. - [Referential actions](docs//orm/prisma-schema/data-model/relations/referential-actions.md): Referential actions let you define the update and delete behavior of related models on the database level - [Referential actions upgrade path](docs//orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-3/referential-actions.md): Guides on how to deal with referential actions using Prisma Introspect or Prisma Migrate when upgrading to Prisma 3 - [rejectOnNotFound changes](docs//orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-5/rejectonnotfound-changes.md): Sub-guide explaining how to update your code due to the removal of rejectOnNotFound in Prisma ORM 5 - [Relation mode](docs//orm/prisma-schema/data-model/relations/relation-mode.md): Manage relations between records with relation modes in Prisma - [Relation queries](docs//orm/prisma-client/queries/relation-queries.md): Prisma Client provides convenient queries for working with relations, such as a fluent API, nested writes (transactions), nested reads and relation filters. - [Relations](docs//orm/prisma-schema/data-model/relations.md): A relation is a connection between two models in the Prisma schema. This page explains how you can define one-to-one, one-to-many and many-to-many relations in Prisma. - [Repeated query](docs//postgres/query-optimization/recommendations/repeated-query.md): Learn about the recommendation provided by Optimize for repeated queries. - [REST](docs//orm/overview/prisma-in-your-stack/rest.md): This page gives an overview of the most important things when building REST APIs with Prisma. It shows practical examples and the supported libraries. - [REST API](docs//orm/more/upgrade-guides/upgrade-from-prisma-1/upgrading-a-rest-api.md): Learn how to upgrade a REST API from Prisma 1 to Prisma ORM 2. - [SafeQL & Prisma Client](docs//orm/prisma-client/using-raw-sql/safeql.md): Learn how to use SafeQL and Prisma Client extensions to work around features not natively supported by Prisma, such as PostGIS. - [Schema incompatibilities in MySQL](docs//orm/more/upgrade-guides/upgrade-from-prisma-1/schema-incompatibilities-mysql.md): Problems and workarounds for Prisma 1 and 2.0 schemas with MySQL - [Schema incompatibilities in PostgreSQL](docs//orm/more/upgrade-guides/upgrade-from-prisma-1/schema-incompatibilities-postgresql.md): Problems and workarounds for Prisma 1 and 2.0 schemas with PostgreSQL - [Schema location](docs//orm/prisma-schema/overview/location.md): Documentation regarding proper location of Prisma Schema including default naming and multiple files. - [Search the documentation](docs//search.md) - [Seeding](docs//orm/prisma-migrate/workflows/seeding.md): Learn how to seed your database using Prisma ORM's integrated seeding functionality and Prisma Client - [Select fields](docs//orm/prisma-client/queries/select-fields.md): This page explains how to select only a subset of a model's fields and/or include relations ("eager loading") in a Prisma Client query. - [Self-relations](docs//orm/prisma-schema/data-model/relations/self-relations.md): How to define and work with self-relations in Prisma. - [Sequelize](docs//orm/more/comparisons/prisma-and-sequelize.md): Learn how Prisma ORM compares to Sequelize. - [Serverless driver](docs//postgres/database/serverless-driver.md): A lightweight PostgreSQL driver for Prisma Postgres optimized for serverless and edge environments with HTTP/WebSocket support, result streaming, and minimal memory footprint. - [Serverless functions](docs//orm/prisma-client/deployment/serverless.md): Learn how to deploy your Prisma ORM-backed apps to FaaS providers like AWS Lambda, Netlify, or Vercel Serverless Functions - [Set up Astro + Prisma + Prisma Postgres](docs//ai/prompts/astro.md): Step-by-step guide for integrating Prisma ORM and Prisma Postgres in an Astro.js project. - [Set up Neon with Accelerate Connection Pool](docs//guides/neon-accelerate.md): Learn how to set up PostgreSQL on Neon with Prisma Accelerate's Connection Pool - [Set up NextJS + Prisma + Prisma Postgres](docs//ai/prompts/nextjs.md): Step-by-step guide for integrating Prisma ORM and Prisma Postgres in an NextJS project. - [Set up Supabase with Accelerate Connection Pool](docs//guides/supabase-accelerate.md): Learn how to set up PostgreSQL on Supabase with Prisma Accelerate's Connection Pool - [Set up Turborepo + Prisma + Prisma Postgres](docs//ai/prompts/turborepo.md): Step-by-step guide for integrating Prisma ORM and Prisma Postgres in a Turborepo monorepo. - [Setting up a local PostgreSQL database](docs//orm/more/help-and-troubleshooting/dataguide/setting-up-a-local-postgresql-database.md): Learn how to set up a PostgreSQL database on Windows, macOS, and Linux by following the step-by-step instructions in this practical guide. - [Setup](docs//postgres/query-optimization/setup.md): Learn how to quickly set up and start optimizing Prisma Postgres queries. - [Setup & configuration](docs//orm/prisma-client/setup-and-configuration.md): This section explains how to generate, configure, and instantiate Prisma Client, as well as when and how to manage database connections. - [Shared packages & examples](docs//orm/prisma-client/client-extensions/extension-examples.md): Explore the Prisma Client extensions that have been built by Prisma and its community - [Shared Prisma Client extensions](docs//orm/prisma-client/client-extensions/shared-extensions.md): Share extensions or import shared extensions into your Prisma project - [Should you use Prisma ORM?](docs//orm/overview/introduction/should-you-use-prisma.md): Prisma ORM is a new kind of ORM. This page explains when Prisma ORM would be a good fit, and provides alternatives for other scenarios. - [Solve package error with vercel/pkg](docs//orm/more/help-and-troubleshooting/pkg-issue.md): Solve ENOENT package error with vercel/pkg - [Special rules for referential actions in SQL Server and MongoDB](docs//orm/prisma-schema/data-model/relations/referential-actions/special-rules-for-referential-actions.md): Circular references or multiple cascade paths can cause validation errors on Microsoft SQL Server and MongoDB. Since the database does not handle these situations out of the box, learn how to solve this problem. - [Spelling, punctuation, and formatting](docs//about/style-guide/spelling-punctuation-formatting.md): This section of the style guide provides guidelines on how to present the information you add. - [SQL comments](docs//orm/prisma-client/observability-and-logging/sql-comments.md): Add metadata to your SQL queries as comments for improved observability, debugging, and tracing. - [SQL Server on Docker](docs//orm/overview/databases/sql-server/sql-server-docker.md): Download and use the Microsoft SQL Server Docker image. - [SQL Server on Windows (local)](docs//orm/overview/databases/sql-server/sql-server-local.md): Set up and configure SQL Server on Windows. - [SQLite](docs//orm/overview/databases/sqlite.md): This page explains how Prisma can connect to a SQLite database using the SQLite database connector. - [Squashing migrations](docs//orm/prisma-migrate/workflows/squashing-migrations.md): How to squash multiple migration files into a single migration - [Static IP](docs//accelerate/static-ip.md): Learn enabling Static IP for Prisma Accelerate. - [Storing large objects or BLOBs in the database](docs//postgres/query-optimization/recommendations/storing-blob-in-database.md): Learn about the recommendations for avoiding the storage of large objects or BLOBs in the database. - [Studio in VS Code](docs//postgres/database/prisma-studio/studio-in-vs-code.md): Learn how to use Prisma Studio directly in VS Code. - [Supabase](docs//orm/overview/databases/supabase.md): Guide to Supabase - [Support](docs//platform/support.md): Find the right support for any Console question. - [Supported databases](docs//orm/reference/supported-databases.md): This page lists all the databases and their versions that are supported by Prisma ORM. - [System requirements](docs//orm/reference/system-requirements.md): System requirements for running Prisma ORM - [Table inheritance](docs//orm/prisma-schema/data-model/table-inheritance.md): Learn about the use cases and patterns for table inheritance in Prisma ORM that enable usage of union types or polymorphic structures in your application. - [Tabnine](docs//orm/more/ai-tools/tabnine.md): Learn tips and best practices for using Prisma ORM with the Tabnine AI code editor. - [Tags](docs//tags.md) - [Team development](docs//orm/prisma-migrate/workflows/team-development.md): How to use Prisma Migrate when collaborating on a project as a team. - [Testing](docs//orm/prisma-client/testing.md): How to implement unit and integration testing with Prisma ORM - [Tools](docs//orm/tools.md): Learn about important Prisma tools. - [Tools & Integrations](docs//postgres/integrations.md): Discover how to use Prisma Postgres with 3rd-party platforms like Vercel, Netlify, and Firebase Studio. - [Traditional servers](docs//orm/prisma-client/deployment/traditional.md): Learn how to deploy your Prisma-backed apps to PaaS providers like Heroku, Koyeb, or AWS EC2 - [Transactions and batch queries](docs//orm/prisma-client/queries/transactions.md): This page explains the transactions API of Prisma Client. - [Troubleshooting](docs//orm/prisma-migrate/workflows/troubleshooting.md): Troubleshooting issues with Prisma Migrate in a development environment. - [Troubleshooting binary size and deployment issues](docs//orm/prisma-client/debugging-and-troubleshooting/troubleshooting-binary-size-issues.md): This page covers how to resolve large bundle sizes, slow builds, and deployment errors caused by Prisma ORM Rust engine binaries - [Troubleshooting Prisma Accelerate issues](docs//accelerate/troubleshoot.md): Troubleshooting Prisma Accelerate. - [Troubleshooting Prisma Postgres issues](docs//postgres/more/troubleshooting.md): Learn about troubleshooting Prisma Postgres issues. - [Troubleshooting relations](docs//orm/prisma-schema/data-model/relations/troubleshooting-relations.md): Modelling your schema can sometimes offer up some unexpected results. This section aims to cover the most prominent of those. - [Turso](docs//orm/overview/databases/turso.md): Guide to Turso - [Type safety](docs//orm/prisma-client/type-safety.md): Prisma Client provides full type safety for queries, even for partial queries or included relations. This page explains how to leverage the generated types and utilities. - [Type utilities](docs//orm/prisma-client/client-extensions/type-utilities.md): Advanced type safety: improve type safety in your custom model methods - [TypedSQL](docs//orm/prisma-client/using-raw-sql/typedsql.md): Learn how to use TypedSQL to write fully type-safe SQL queries that are compatible with any SQL console and Prisma Client. - [TypeORM](docs//orm/more/comparisons/prisma-and-typeorm.md): Learn how Prisma compares to TypeORM. - [Under the hood](docs//orm/more/under-the-hood.md): Learn about Prisma ORM internals and how it works "under the hood". Prisma ORM tools are based on an engine-layer which manages the communication with the database. - [Understanding Prisma Migrate](docs//orm/prisma-migrate/understanding-prisma-migrate.md): Learn about the mental model and basic building blocks of Prisma Migrate. - [Unit testing](docs//orm/prisma-client/testing/unit-testing.md): Learn how to setup and run unit tests with Prisma Client - [Unnecessary indexes](docs//postgres/query-optimization/recommendations/unnecessary-indexes.md): Learn about the recommendation provided by Optimize for using Unnecessary indexes - [Unsupported database features (Prisma Migrate)](docs//orm/prisma-migrate/workflows/unsupported-database-features.md): How to include unsupported database features for projects that use Prisma Migrate. - [Unsupported database features (Prisma Schema)](docs//orm/prisma-schema/data-model/unsupported-database-features.md): How to support database features that do not have an equivalent syntax in Prisma Schema Language. - [Upgrade from MongoDB Beta](docs//orm/more/upgrade-guides/upgrade-from-prisma-1/upgrade-from-mongodb-beta.md): Learn how to upgrade your MongoDB application running Prisma 1 to Prisma ORM 2 or later. - [Upgrade from Prisma 1](docs//orm/more/upgrade-guides/upgrade-from-prisma-1.md): Upgrading your project from Prisma 1 to Prisma ORM 2 - [Upgrade guides](docs//orm/more/upgrade-guides.md): Learn how to upgrade Prisma ORM versions. - [Upgrade to Prisma ORM 3](docs//orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-3.md): Guides on how to upgrade to Prisma ORM 3 - [Upgrade to Prisma ORM 4](docs//orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-4.md): Guides on how to upgrade to Prisma ORM 4 - [Upgrade to Prisma ORM 5](docs//orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-5.md): Guides on how to upgrade to Prisma ORM 5 - [Upgrade to Prisma ORM 6](docs//orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-6.md): Guides on how to upgrade to Prisma ORM 6 - [Upgrade to Prisma ORM 7](docs//orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-7.md): Guide on how to upgrade to Prisma ORM 7 - [Upgrading the Prisma ORM layer (MySQL)](docs//orm/more/upgrade-guides/upgrade-from-prisma-1/upgrading-the-prisma-layer-mysql.md): Learn how to upgrade the Prisma ORM layer to Prisma ORM 2 and create your Prisma schema with MySQL - [Upgrading the Prisma ORM layer (PostgreSQL)](docs//orm/more/upgrade-guides/upgrade-from-prisma-1/upgrading-the-prisma-layer-postgresql.md): Learn how to upgrade the Prisma ORM layer to Prisma ORM 2 and create your Prisma schema with PostgreSQL - [Upgrading to use Preview features](docs//orm/more/upgrade-guides/upgrading-to-use-preview-features.md): Upgrading your project to use a Preview feature. - [Upgrading versions](docs//orm/more/upgrade-guides/upgrading-versions.md): Upgrading your project to the latest version of Prisma ORM. - [Use Prisma Postgres with Drizzle ORM](docs//getting-started/prisma-postgres/quickstart/drizzle-orm.md): Get started with Drizzle ORM and Prisma Postgres. - [Use Prisma Postgres with Kysely](docs//getting-started/prisma-postgres/quickstart/kysely.md): Get started with Kysely and Prisma Postgres by creating a type-safe SQL query builder for your database. - [Use Prisma Postgres with Prisma ORM](docs//getting-started/prisma-postgres/quickstart/prisma-orm.md): Create a new TypeScript project from scratch by connecting Prisma ORM to Prisma Postgres and generating a Prisma Client for database access. - [Use Prisma Postgres with TypeORM](docs//getting-started/prisma-postgres/quickstart/typeorm.md): Get started with TypeORM and Prisma Postgres by connecting your TypeScript ORM to a managed PostgreSQL database. - [User interface (GUI) guidelines](docs//about/style-guide/user-interace-guidelines.md): On this page you can find information about the Prisma guidelines for documenting UI elements and steps to walk users through interfaces. - [Using @db.Char(n)](docs//postgres/query-optimization/recommendations/avoid-char.md): Learn about the recommendation provided by Optimize for using `@db.Char(n)` native type. - [Using @db.Money](docs//postgres/query-optimization/recommendations/avoid-db-money.md): Learn about the recommendation provided by Optimize for using `@db.Money` native type. - [Using @db.VarChar(n)](docs//postgres/query-optimization/recommendations/avoid-varchar.md): Learn about the recommendation provided by Optimize for using `@db.VarChar(n)` native type. - [Using CURRENT_TIME](docs//postgres/query-optimization/recommendations/current-time.md): Learn about the recommendation provided by Optimize for using the `CURRENT_TIME` function - [Using the Nuxt Prisma Module](docs//orm/more/help-and-troubleshooting/prisma-nuxt-module.md): Learn how to easily add Prisma ORM to your Nuxt apps, use its features, and understand its limitations. - [Using timestamp(0) or timestamptz(0)](docs//postgres/query-optimization/recommendations/avoid-timestamp-timestampz-0.md): Learn about the recommendation provided by Optimize for using `timestamp(0)` or `timestamptz(0)` native type. - [Vercel](docs//postgres/integrations/vercel.md): Learn how to create Prisma Postgres databases via the Vercel Marketplace and deploy your applications with it. - [Vercel build dependency caching workaround](docs//orm/more/help-and-troubleshooting/vercel-caching-issue.md): Learn to configure your build process on Vercel to avoid caching-related problems - [Vibe Code a Linktree Clone SaaS with Next.js, Prisma & Clerk](docs//ai/tutorials/linktree-clone.md): A complete vibe coding tutorial: build a full Linktree clone SaaS application from scratch using Next.js, Prisma ORM, Prisma Postgres, and Clerk authentication with AI assistance. - [Viewing data](docs//postgres/integrations/viewing-data.md): Viewing and editing data in Prisma Postgres via Prisma Studio or other database GUIs. - [Views](docs//orm/prisma-schema/data-model/views.md): How to include views in your Prisma schema - [VS Code](docs//postgres/integrations/vscode.md): The Prisma VS Code extension provides a management UI for Prisma Postgres and superpowers for Copilot agent mode. - [What is introspection?](docs//orm/prisma-schema/introspection.md): Learn how you can introspect your database to generate a data model into your Prisma schema. - [What is Prisma ORM?](docs//orm/overview/introduction/what-is-prisma.md): This page gives a high-level overview of what Prisma ORM is and how it works. It's a great starting point for Prisma newcomers! - [Why Prisma ORM?](docs//orm/overview/introduction/why-prisma.md): Learn about the motivation for Prisma ORM and how it compares to other Node.js and TypeScript database tools like ORMs and SQL query builders. - [Windsurf](docs//orm/more/ai-tools/windsurf.md): Learn tips and best practices for using Prisma ORM with the Windsurf AI code editor. - [Word choice](docs//about/style-guide/word-choice.md): This section of the style guide provides guidelines on what terms and phrase constructions to use. - [Workflows](docs//orm/prisma-migrate/workflows.md): Learn about important Prisma Migrate workflows, like seeding, prototyping, baselining, & more. - [Working with compound IDs and unique constraints](docs//orm/prisma-client/special-fields-and-types/working-with-composite-ids-and-constraints.md): How to read, write, and filter by compound IDs and unique constraints. - [Working with dates in PostgreSQL](docs//orm/more/help-and-troubleshooting/dataguide/date-types.md): Read on to learn about how to work with date types in PostgreSQL, including information on formats, functions, and more. - [Working with Json fields](docs//orm/prisma-client/special-fields-and-types/working-with-json-fields.md): How to read, write, and filter by Json fields. - [Working with scalar lists](docs//orm/prisma-client/special-fields-and-types/working-with-scalar-lists-arrays.md): How to read, write, and filter by scalar lists / arrays. - [Write your own SQL](docs//orm/prisma-client/using-raw-sql.md): Learn how to use raw SQL queries in Prisma Client. - [Writing style](docs//about/style-guide/writing-style.md): This section of the style guide provides guidelines on tone of voice, audience, and other tonal matters. - [Writing template](docs//about/template.md): A template for writing Prisma Docs.