# Prisma

> Documentation corpus for Prisma. 141 pages.

## Concept Index

- **prerequisitesprerequisites** — [`prisma/docs/orm/prisma-schema/postgresql-extensions/index.md`](prisma/docs/orm/prisma-schema/postgresql-extensions/index.md)
- **planetscaleplanetscale** — [`prisma/docs/orm/core-concepts/supported-databases/mysql/index.md`](prisma/docs/orm/core-concepts/supported-databases/mysql/index.md)
- **connection poolingconnection-pooling** — [`prisma/docs/orm/more/best-practices/index.md`](prisma/docs/orm/more/best-practices/index.md)
- **relationsrelations** — [`prisma/docs/orm/prisma-schema/introspection/index.md`](prisma/docs/orm/prisma-schema/introspection/index.md)
- **solutionsolution-1** — [`prisma/docs/orm/more/troubleshooting/nextjs/index.md`](prisma/docs/orm/more/troubleshooting/nextjs/index.md)
- **exampleexample** — [`prisma/docs/orm/prisma-client/client-extensions/index.md`](prisma/docs/orm/prisma-client/client-extensions/index.md)
- **solutionsolution** — [`prisma/docs/orm/prisma-schema/data-model/relations/troubleshooting-relations/index.md`](prisma/docs/orm/prisma-schema/data-model/relations/troubleshooting-relations/index.md)
- **mongodbmongodb** — [`prisma/docs/orm/reference/connection-urls/index.md`](prisma/docs/orm/reference/connection-urls/index.md)
- **constraintsconstraints** — [`prisma/docs/orm/reference/database-features/index.md`](prisma/docs/orm/reference/database-features/index.md)
- **cockroachdbcockroachdb** — [`prisma/docs/orm/reference/connection-urls/index.md`](prisma/docs/orm/reference/connection-urls/index.md)
- **filteringfiltering** — [`prisma/docs/orm/more/comparisons/prisma-and-drizzle/index.md`](prisma/docs/orm/more/comparisons/prisma-and-drizzle/index.md)
- **problemproblem-1** — [`prisma/docs/orm/more/troubleshooting/nextjs/index.md`](prisma/docs/orm/more/troubleshooting/nextjs/index.md)
- **mysqlmysql** — [`prisma/docs/orm/reference/connection-urls/index.md`](prisma/docs/orm/reference/connection-urls/index.md)
- **sqlitesqlite** — [`prisma/docs/orm/reference/connection-urls/index.md`](prisma/docs/orm/reference/connection-urls/index.md)
- **enable only prismaclient-level debugging output** — [`prisma/docs/orm/reference/environment-variables-reference/index.md`](prisma/docs/orm/reference/environment-variables-reference/index.md)
- **using prisma postgresusing-prisma-postgres** — [`prisma/docs/orm/prisma-client/deployment/edge/deploy-to-vercel/index.md`](prisma/docs/orm/prisma-client/deployment/edge/deploy-to-vercel/index.md)
- **using an edge-compatible driverusing-an-edge-compatible-driver** — [`prisma/docs/orm/prisma-client/deployment/edge/deploy-to-vercel/index.md`](prisma/docs/orm/prisma-client/deployment/edge/deploy-to-vercel/index.md)
- **setting your database connection url as an environment variablesetting-your-database-connection-url-as-an-environment-variable** — [`prisma/docs/orm/prisma-client/deployment/edge/deploy-to-vercel/index.md`](prisma/docs/orm/prisma-client/deployment/edge/deploy-to-vercel/index.md)
- **size limits on free accountssize-limits-on-free-accounts** — [`prisma/docs/orm/prisma-client/deployment/edge/deploy-to-vercel/index.md`](prisma/docs/orm/prisma-client/deployment/edge/deploy-to-vercel/index.md)
- **create a task** — [`prisma/docs/orm/prisma-client/deployment/edge/deploy-to-deno-deploy/index.md`](prisma/docs/orm/prisma-client/deployment/edge/deploy-to-deno-deploy/index.md)
- **web applicationweb-application** — [`prisma/docs/orm/prisma-client/deployment/traditional/deploy-to-flyio/index.md`](prisma/docs/orm/prisma-client/deployment/traditional/deploy-to-flyio/index.md)
- **prisma schema and migrationsprisma-schema-and-migrations** — [`prisma/docs/orm/prisma-client/deployment/traditional/deploy-to-flyio/index.md`](prisma/docs/orm/prisma-client/deployment/traditional/deploy-to-flyio/index.md)
- **create a single recordcreate-a-single-record** — [`prisma/docs/orm/prisma-client/queries/crud/index.md`](prisma/docs/orm/prisma-client/queries/crud/index.md)
- **create multiple recordscreate-multiple-records** — [`prisma/docs/orm/prisma-client/queries/crud/index.md`](prisma/docs/orm/prisma-client/queries/crud/index.md)
- **create and return multiple recordscreate-and-return-multiple-records** — [`prisma/docs/orm/prisma-client/queries/crud/index.md`](prisma/docs/orm/prisma-client/queries/crud/index.md)
- **get record by id or unique fieldget-record-by-id-or-unique-field** — [`prisma/docs/orm/prisma-client/queries/crud/index.md`](prisma/docs/orm/prisma-client/queries/crud/index.md)
- **get all recordsget-all-records** — [`prisma/docs/orm/prisma-client/queries/crud/index.md`](prisma/docs/orm/prisma-client/queries/crud/index.md)
- **get first matching recordget-first-matching-record** — [`prisma/docs/orm/prisma-client/queries/crud/index.md`](prisma/docs/orm/prisma-client/queries/crud/index.md)
- **filter recordsfilter-records** — [`prisma/docs/orm/prisma-client/queries/crud/index.md`](prisma/docs/orm/prisma-client/queries/crud/index.md)
- **select fieldsselect-fields** — [`prisma/docs/orm/prisma-client/queries/crud/index.md`](prisma/docs/orm/prisma-client/queries/crud/index.md)
- **-e exit immediately when a command returns a non-zero status** — [`prisma/docs/orm/prisma-migrate/workflows/seeding/index.md`](prisma/docs/orm/prisma-migrate/workflows/seeding/index.md)
- **-x print commands before they are executed** — [`prisma/docs/orm/prisma-migrate/workflows/seeding/index.md`](prisma/docs/orm/prisma-migrate/workflows/seeding/index.md)
- **examplesexamples** — [`prisma/docs/orm/prisma-schema/overview/generators/index.md`](prisma/docs/orm/prisma-schema/overview/generators/index.md)
- **environment variables declared in this file are automatically made available to prisma** — [`prisma/docs/orm/reference/prisma-cli-reference/index.md`](prisma/docs/orm/reference/prisma-cli-reference/index.md)
- **api patterns** — [`prisma/docs/orm/core-concepts/api-patterns/index.md`](prisma/docs/orm/core-concepts/api-patterns/index.md)
- **supported frameworkssupported-frameworks** — [`prisma/docs/orm/core-concepts/api-patterns/index.md`](prisma/docs/orm/core-concepts/api-patterns/index.md)
- **example routesexample-routes** — [`prisma/docs/orm/core-concepts/api-patterns/index.md`](prisma/docs/orm/core-concepts/api-patterns/index.md)
- **supported toolssupported-tools** — [`prisma/docs/orm/core-concepts/api-patterns/index.md`](prisma/docs/orm/core-concepts/api-patterns/index.md)
- **framework integrationsframework-integrations** — [`prisma/docs/orm/core-concepts/api-patterns/index.md`](prisma/docs/orm/core-concepts/api-patterns/index.md)
- **prismas roleprismas-role** — [`prisma/docs/orm/core-concepts/api-patterns/index.md`](prisma/docs/orm/core-concepts/api-patterns/index.md)
- **supported frameworkssupported-frameworks-1** — [`prisma/docs/orm/core-concepts/api-patterns/index.md`](prisma/docs/orm/core-concepts/api-patterns/index.md)
- **supported runtimessupported-runtimes** — [`prisma/docs/orm/core-concepts/api-patterns/index.md`](prisma/docs/orm/core-concepts/api-patterns/index.md)
- **data modeling on the database leveldata-modeling-on-the-database-level** — [`prisma/docs/orm/core-concepts/data-modeling/index.md`](prisma/docs/orm/core-concepts/data-modeling/index.md)
- **data modeling on the application leveldata-modeling-on-the-application-level** — [`prisma/docs/orm/core-concepts/data-modeling/index.md`](prisma/docs/orm/core-concepts/data-modeling/index.md)
- **data modeling with ormsdata-modeling-with-orms** — [`prisma/docs/orm/core-concepts/data-modeling/index.md`](prisma/docs/orm/core-concepts/data-modeling/index.md)
- **using only prisma clientusing-only-prisma-client** — [`prisma/docs/orm/core-concepts/data-modeling/index.md`](prisma/docs/orm/core-concepts/data-modeling/index.md)
- **using prisma client and prisma migrateusing-prisma-client-and-prisma-migrate** — [`prisma/docs/orm/core-concepts/data-modeling/index.md`](prisma/docs/orm/core-concepts/data-modeling/index.md)
- **database driver adaptersdatabase-driver-adapters** — [`prisma/docs/orm/core-concepts/supported-databases/database-drivers/index.md`](prisma/docs/orm/core-concepts/supported-databases/database-drivers/index.md)
- **serverless driver adaptersserverless-driver-adapters** — [`prisma/docs/orm/core-concepts/supported-databases/database-drivers/index.md`](prisma/docs/orm/core-concepts/supported-databases/database-drivers/index.md)
- **community-maintained database driver adapterscommunity-maintained-database-driver-adapters** — [`prisma/docs/orm/core-concepts/supported-databases/database-drivers/index.md`](prisma/docs/orm/core-concepts/supported-databases/database-drivers/index.md)

## Pages by Area

### docs
- [API patterns](prisma/docs/orm/core-concepts/api-patterns/index.md)
- [Data modeling](prisma/docs/orm/core-concepts/data-modeling/index.md)
- [Database drivers](prisma/docs/orm/core-concepts/supported-databases/database-drivers/index.md)
- [Overview](prisma/docs/orm/core-concepts/supported-databases/index.md)
- [MongoDB](prisma/docs/orm/core-concepts/supported-databases/mongodb/index.md)
- [MySQL](prisma/docs/orm/core-concepts/supported-databases/mysql/index.md)
- [PostgreSQL](prisma/docs/orm/core-concepts/supported-databases/postgresql/index.md)
- [SQL Server](prisma/docs/orm/core-concepts/supported-databases/sql-server/index.md)
- [SQLite](prisma/docs/orm/core-concepts/supported-databases/sqlite/index.md)
- [Prisma ORM](prisma/docs/orm/index.md)
- [Best practices](prisma/docs/orm/more/best-practices/index.md)
- [Drizzle](prisma/docs/orm/more/comparisons/prisma-and-drizzle/index.md)
- [Mongoose](prisma/docs/orm/more/comparisons/prisma-and-mongoose/index.md)
- [Sequelize](prisma/docs/orm/more/comparisons/prisma-and-sequelize/index.md)
- [TypeORM](prisma/docs/orm/more/comparisons/prisma-and-typeorm/index.md)
- [Editor setup](prisma/docs/orm/more/dev-environment/editor-setup/index.md)
- [Environment variables](prisma/docs/orm/more/dev-environment/environment-variables/index.md)
- [ORM releases and maturity levels](prisma/docs/orm/more/releases/index.md)
- [Bundler issues](prisma/docs/orm/more/troubleshooting/bundler-issues/index.md)
- [Check constraints](prisma/docs/orm/more/troubleshooting/check-constraints/index.md)
- [GraphQL autocompletion](prisma/docs/orm/more/troubleshooting/graphql-autocompletion/index.md)
- [Many-to-many relations](prisma/docs/orm/more/troubleshooting/many-to-many-relations/index.md)
- [Next.js](prisma/docs/orm/more/troubleshooting/nextjs/index.md)
- [Nuxt](prisma/docs/orm/more/troubleshooting/nuxt/index.md)
- [Raw SQL comparisons](prisma/docs/orm/more/troubleshooting/raw-sql-comparisons/index.md)
- [TypeScript performance](prisma/docs/orm/more/troubleshooting/typescript-performance/index.md)
- [Add methods to Prisma Client](prisma/docs/orm/prisma-client/client-extensions/client/index.md)
- [Shared packages & examples](prisma/docs/orm/prisma-client/client-extensions/extension-examples/index.md)
- [What are Client Extensions](prisma/docs/orm/prisma-client/client-extensions/index.md)
- [Add custom methods to your models](prisma/docs/orm/prisma-client/client-extensions/model/index.md)
- [Create custom Prisma Client queries](prisma/docs/orm/prisma-client/client-extensions/query/index.md)
- [Add custom fields and methods to query results](prisma/docs/orm/prisma-client/client-extensions/result/index.md)
- [Shared Prisma Client extensions](prisma/docs/orm/prisma-client/client-extensions/shared-extensions/index.md)
- [Fine-Grained Authorization (Permit)](prisma/docs/orm/prisma-client/client-extensions/shared-extensions/permit-rbac/index.md)
- [Type utilities](prisma/docs/orm/prisma-client/client-extensions/type-utilities/index.md)
- [Debugging](prisma/docs/orm/prisma-client/debugging-and-troubleshooting/debugging/index.md)
- [Handling exceptions and errors](prisma/docs/orm/prisma-client/debugging-and-troubleshooting/handling-exceptions-and-errors/index.md)
- [Caveats when deploying to AWS platforms](prisma/docs/orm/prisma-client/deployment/caveats-when-deploying-to-aws-platforms/index.md)
- [Deploying database changes with Prisma Migrate](prisma/docs/orm/prisma-client/deployment/deploy-database-changes-with-prisma-migrate/index.md)
- [Deploy migrations from a local environment](prisma/docs/orm/prisma-client/deployment/deploy-migrations-from-a-local-environment/index.md)
- [Deploy Prisma ORM](prisma/docs/orm/prisma-client/deployment/deploy-prisma/index.md)
- [Deploy to Cloudflare Workers & Pages](prisma/docs/orm/prisma-client/deployment/edge/deploy-to-cloudflare/index.md)
- [Deploy to Deno Deploy](prisma/docs/orm/prisma-client/deployment/edge/deploy-to-deno-deploy/index.md)
- [Deploy to Vercel Edge Functions & Middleware](prisma/docs/orm/prisma-client/deployment/edge/deploy-to-vercel/index.md)
- [Deploying edge functions with Prisma ORM](prisma/docs/orm/prisma-client/deployment/edge/overview/index.md)
- [Deploy to AWS Lambda](prisma/docs/orm/prisma-client/deployment/serverless/deploy-to-aws-lambda/index.md)
- [Deploy to Azure Functions](prisma/docs/orm/prisma-client/deployment/serverless/deploy-to-azure-functions/index.md)
- [Deploy to Netlify](prisma/docs/orm/prisma-client/deployment/serverless/deploy-to-netlify/index.md)
- [Deploy to Vercel](prisma/docs/orm/prisma-client/deployment/serverless/deploy-to-vercel/index.md)
- [Deploy to Fly.io](prisma/docs/orm/prisma-client/deployment/traditional/deploy-to-flyio/index.md)
- [Deploy to Heroku](prisma/docs/orm/prisma-client/deployment/traditional/deploy-to-heroku/index.md)
- [Deploy to Koyeb](prisma/docs/orm/prisma-client/deployment/traditional/deploy-to-koyeb/index.md)
- [Deploy to Railway](prisma/docs/orm/prisma-client/deployment/traditional/deploy-to-railway/index.md)
- [Deploy to Render](prisma/docs/orm/prisma-client/deployment/traditional/deploy-to-render/index.md)
- [Deploy to Sevalla](prisma/docs/orm/prisma-client/deployment/traditional/deploy-to-sevalla/index.md)
- [Logging](prisma/docs/orm/prisma-client/observability-and-logging/logging/index.md)
- [OpenTelemetry tracing](prisma/docs/orm/prisma-client/observability-and-logging/opentelemetry-tracing/index.md)
- [SQL comments](prisma/docs/orm/prisma-client/observability-and-logging/sql-comments/index.md)
- [Query optimization](prisma/docs/orm/prisma-client/queries/advanced/query-optimization-performance/index.md)
- [Aggregation, grouping, and summarizing](prisma/docs/orm/prisma-client/queries/aggregation-grouping-summarizing/index.md)
- [CRUD](prisma/docs/orm/prisma-client/queries/crud/index.md)
- [CRUD](prisma/docs/orm/prisma-client/queries/relation-queries/index.md)
- [Transactions and batch queries](prisma/docs/orm/prisma-client/queries/transactions/index.md)
- [Custom model and field names](prisma/docs/orm/prisma-client/setup-and-configuration/custom-model-and-field-names/index.md)
- [Database polyfills](prisma/docs/orm/prisma-client/setup-and-configuration/database-polyfills/index.md)
- [Connection management](prisma/docs/orm/prisma-client/setup-and-configuration/databases-connections/connection-management/index.md)
- [Connection pool](prisma/docs/orm/prisma-client/setup-and-configuration/databases-connections/connection-pool/index.md)
- [Database connections](prisma/docs/orm/prisma-client/setup-and-configuration/databases-connections/index.md)
- [Configure Prisma Client with PgBouncer](prisma/docs/orm/prisma-client/setup-and-configuration/databases-connections/pgbouncer/index.md)
- [Configuring error formatting](prisma/docs/orm/prisma-client/setup-and-configuration/error-formatting/index.md)
- [Introduction to Prisma Client](prisma/docs/orm/prisma-client/setup-and-configuration/introduction/index.md)
- [Read replicas](prisma/docs/orm/prisma-client/setup-and-configuration/read-replicas/index.md)
- [Composite types](prisma/docs/orm/prisma-client/special-fields-and-types/composite-types/index.md)
- [Fields & types](prisma/docs/orm/prisma-client/special-fields-and-types/index.md)
- [Null and undefined](prisma/docs/orm/prisma-client/special-fields-and-types/null-and-undefined/index.md)
- [Working with compound IDs and unique constraints](prisma/docs/orm/prisma-client/special-fields-and-types/working-with-composite-ids-and-constraints/index.md)
- [Working with geometry fields](prisma/docs/orm/prisma-client/special-fields-and-types/working-with-geometry-fields/index.md)
- [Working with Json fields](prisma/docs/orm/prisma-client/special-fields-and-types/working-with-json-fields/index.md)
- [Working with scalar lists](prisma/docs/orm/prisma-client/special-fields-and-types/working-with-scalar-lists-arrays/index.md)
- [Integration testing](prisma/docs/orm/prisma-client/testing/integration-testing/index.md)
- [Unit testing](prisma/docs/orm/prisma-client/testing/unit-testing/index.md)
- [Type safety Overview](prisma/docs/orm/prisma-client/type-safety/index.md)
- [Operating against partial structures of your model types](prisma/docs/orm/prisma-client/type-safety/operating-against-partial-structures-of-model-types/index.md)
- [How to use Prisma ORM's type system](prisma/docs/orm/prisma-client/type-safety/prisma-type-system/index.md)
- [Write your own SQL](prisma/docs/orm/prisma-client/using-raw-sql/index.md)
- [Raw queries](prisma/docs/orm/prisma-client/using-raw-sql/raw-queries/index.md)
- [SafeQL & Prisma Client](prisma/docs/orm/prisma-client/using-raw-sql/safeql/index.md)
- [TypedSQL](prisma/docs/orm/prisma-client/using-raw-sql/typedsql/index.md)
- [Getting started with Prisma Migrate](prisma/docs/orm/prisma-migrate/getting-started/index.md)
- [Overview of Prisma Migrate](prisma/docs/orm/prisma-migrate/index.md)
- [Limitations and known issues](prisma/docs/orm/prisma-migrate/understanding-prisma-migrate/limitations-and-known-issues/index.md)
- [Understanding Migrations](prisma/docs/orm/prisma-migrate/understanding-prisma-migrate/mental-model/index.md)
- [Migration histories](prisma/docs/orm/prisma-migrate/understanding-prisma-migrate/migration-histories/index.md)
- [About the shadow database](prisma/docs/orm/prisma-migrate/understanding-prisma-migrate/shadow-database/index.md)
- [Baselining a database](prisma/docs/orm/prisma-migrate/workflows/baselining/index.md)
- [Customizing migrations](prisma/docs/orm/prisma-migrate/workflows/customizing-migrations/index.md)
- [Development and production](prisma/docs/orm/prisma-migrate/workflows/development-and-production/index.md)
- [Generating down migrations](prisma/docs/orm/prisma-migrate/workflows/generating-down-migrations/index.md)
- [Native database functions](prisma/docs/orm/prisma-migrate/workflows/native-database-functions/index.md)
- [Native database types](prisma/docs/orm/prisma-migrate/workflows/native-database-types/index.md)
- [Patching & hotfixing](prisma/docs/orm/prisma-migrate/workflows/patching-and-hotfixing/index.md)
- [Prototyping your schema](prisma/docs/orm/prisma-migrate/workflows/prototyping-your-schema/index.md)
- [Seeding](prisma/docs/orm/prisma-migrate/workflows/seeding/index.md)
- [Squashing migrations](prisma/docs/orm/prisma-migrate/workflows/squashing-migrations/index.md)
- [Troubleshooting](prisma/docs/orm/prisma-migrate/workflows/troubleshooting/index.md)
- [Unsupported database features (Prisma Migrate)](prisma/docs/orm/prisma-migrate/workflows/unsupported-database-features/index.md)
- [Database mapping](prisma/docs/orm/prisma-schema/data-model/database-mapping/index.md)
- [External tables](prisma/docs/orm/prisma-schema/data-model/externally-managed-tables/index.md)
- [Indexes](prisma/docs/orm/prisma-schema/data-model/indexes/index.md)
- [Models](prisma/docs/orm/prisma-schema/data-model/models/index.md)
- [Multi-schema](prisma/docs/orm/prisma-schema/data-model/multi-schema/index.md)
- [Relations](prisma/docs/orm/prisma-schema/data-model/relations/index.md)
- [Many-to-many relations](prisma/docs/orm/prisma-schema/data-model/relations/many-to-many-relations/index.md)
- [One-to-many relations](prisma/docs/orm/prisma-schema/data-model/relations/one-to-many-relations/index.md)
- [One-to-one relations](prisma/docs/orm/prisma-schema/data-model/relations/one-to-one-relations/index.md)
- [Referential actions](prisma/docs/orm/prisma-schema/data-model/relations/referential-actions/index.md)
- [Relation mode](prisma/docs/orm/prisma-schema/data-model/relations/relation-mode/index.md)
- [Self-relations](prisma/docs/orm/prisma-schema/data-model/relations/self-relations/index.md)
- [Troubleshooting relations](prisma/docs/orm/prisma-schema/data-model/relations/troubleshooting-relations/index.md)
- [Table inheritance](prisma/docs/orm/prisma-schema/data-model/table-inheritance/index.md)
- [Unsupported database features (Prisma Schema)](prisma/docs/orm/prisma-schema/data-model/unsupported-database-features/index.md)
- [Views](prisma/docs/orm/prisma-schema/data-model/views/index.md)
- [What is introspection?](prisma/docs/orm/prisma-schema/introspection/index.md)
- [Data sources](prisma/docs/orm/prisma-schema/overview/data-sources/index.md)
- [Generators](prisma/docs/orm/prisma-schema/overview/generators/index.md)
- [Overview of Prisma Schema](prisma/docs/orm/prisma-schema/overview/index.md)
- [Schema location](prisma/docs/orm/prisma-schema/overview/location/index.md)
- [PostgreSQL extensions](prisma/docs/orm/prisma-schema/postgresql-extensions/index.md)
- [Connection URLs](prisma/docs/orm/reference/connection-urls/index.md)
- [Database Features](prisma/docs/orm/reference/database-features/index.md)
- [Environment Variables](prisma/docs/orm/reference/environment-variables-reference/index.md)
- [Error Reference](prisma/docs/orm/reference/error-reference/index.md)
- [Prisma Error Reference](prisma/docs/orm/reference/errors/index.md)
- [Prisma CLI Preview features](prisma/docs/orm/reference/preview-features/cli-preview-features/index.md)
- [Prisma Client & Prisma schema](prisma/docs/orm/reference/preview-features/client-preview-features/index.md)
- [Prisma CLI reference](prisma/docs/orm/reference/prisma-cli-reference/index.md)
- [Prisma Client API](prisma/docs/orm/reference/prisma-client-reference/index.md)
- [Config API](prisma/docs/orm/reference/prisma-config-reference/index.md)
- [Schema API](prisma/docs/orm/reference/prisma-schema-reference/index.md)
- [Supported databases](prisma/docs/orm/reference/supported-databases/index.md)
- [System requirements](prisma/docs/orm/reference/system-requirements/index.md)
