Prisma llms.txt · AI Docs Browser · mdream [llms.txt Tools](https://mdream.dev/llms-txt/prisma/llms-txt) # Prisma llms.txt Browse Prisma documentation as markdown. Click any page in the sidebar to view it, or copy the full llms.txt for your AI tools. www.prisma.io/llms.txt [Raw llms.txt](https://www.prisma.io/docs/llms.txt) [Raw llms-full.txt](https://www.prisma.io/llms-full.txt) Copy Markdown [](https://www.prisma.io/llms.txt) llms.txt Common Queries Check the Prisma changelog for recent changes Start a new Prisma ORM project Connect to Prisma Postgres Run Prisma Postgres locally Manage database connections Create and apply migrations Deploy migrations safely Use Query Insights Set up the Prisma MCP server Use the Prisma Client API Use the Prisma CLI Troubleshoot Prisma ORM errors Troubleshoot Prisma Postgres Review pricing Use Prisma Postgres with Next.js Use Prisma Postgres with SvelteKit Use Prisma Postgres with Nuxt Use Prisma Postgres with Hono on Cloudflare Workers Product Area Indexes Prisma ORM Prisma Postgres Query Insights Prisma MCP Latest @prisma/cli ``client: Add methods to Prisma Client ``model: Add custom methods to your models ``query: Create custom Prisma Client queries ``result: Add custom fields and methods to query results About migration histories About the shadow database About the shadow database Add custom fields and methods to query results Add custom methods to your models Add methods to Prisma Client Advanced queries Agent Skills Aggregation, grouping, and summarizing Aggregation, grouping, and summarizing AI SDK (with Next.js) Alchemy API patterns Applying a migration Astro Astro Astro + Prisma Auth.js (with Next.js) Authentication Author in PSL Author in TypeScript Authoring custom middleware Backups Baselining a database Baselining a database Best Postgres for AI apps Best practices Better Auth (with Astro) Better Auth (with Next.js) Branching Build a Tweet SaaS with Next.js, Prisma Postgres, and Ollama Build faster with Prisma + AI Built-in: budgets Built-in: cache Built-in: lints Bun Bun Bun workspaces Bundler issues Bundler issues Capabilities Case sensitivity Caveats when deploying to AWS platforms Caveats when deploying to AWS platforms ChatGPT ChatGPT Check constraints Check constraints Choose a setup path Choose a setup path Clerk (with Astro) Clerk (with Next.js) CLI configuration CLI Overview CLI reference Cloudflare D1 Cloudflare D1 Cloudflare Workers CockroachDB CockroachDB CockroachDB Codex Composite types Composite types Computed fields Concepts Config API Configuration Configure Prisma Client with PgBouncer Configure Prisma Client with PgBouncer Configuring error formatting Configuring error formatting Connecting to your database Connection management Connection management Connection pool Connection pool Connection pooling Connection URLs Connection URLs Console Create connection Create custom Prisma Client queries Create database Create database Create database connection string Create project with a postgres database create-db CRUD CRUD Cursor Cursor Custom model and field names Custom model and field names Custom models Custom validation Customizing migrations Customizing migrations Data migrations Data modeling Data modeling Data sources Data sources Database Database connections Database connections Database drivers Database drivers Database Features Database features matrix Database mapping Database mapping Database Metrics Database polyfills Database polyfills Datadog db debug Debugging Debugging Delete connection Delete database Delete integration Delete project Deno Deno deploy Deploy migrations from a local environment Deploy migrations from a local environment Deploy Prisma ORM Deploy Prisma ORM Deploy to a different OS Deploy to AWS Lambda Deploy to AWS Lambda Deploy to Azure Functions Deploy to Azure Functions Deploy to Cloudflare Workers & Pages Deploy to Cloudflare Workers & Pages Deploy to Deno Deploy Deploy to Deno Deploy Deploy to Fly.io Deploy to Fly.io Deploy to Heroku Deploy to Heroku Deploy to Koyeb Deploy to Koyeb Deploy to Netlify Deploy to Netlify Deploy to Railway Deploy to Railway Deploy to Render Deploy to Render Deploy to Sevalla Deploy to Sevalla Deploy to Vercel Deploy to Vercel Deploy to Vercel Edge Functions & Middleware Deploy to Vercel Edge Functions & Middleware Deploy your first app Deploying database changes with Prisma Migrate Deploying database changes with Prisma Migrate Deploying edge functions with Prisma ORM Deploying edge functions with Prisma ORM Deployments dev dev Dev environment Development and production Development and production diff Docker Domains Drizzle Drizzle Drizzle Drizzle ORM Edge functions Editing a migration Editor setup Editor setup Elysia Elysia Embed Studio Embedded Prisma Studio (with Next.js) Engines Environment variables Environment variables Environment variables Environment Variables Environment variables reference Error message reference Error reference Error Reference Excluding fields Excluding fields execute Expand-and-contract migrations Extensions Extensions External tables External tables FAQ Feature Maturity Fields & types Fields & types Filtering and sorting Filtering and Sorting Fine-Grained Authorization (Permit) Fine-Grained Authorization (Permit) Firebase Studio Fly.io format From the CLI From the CLI From v1 Full-text search Full-text search Fullstack generate Generating a migration Generating down migrations Generating down migrations Generating Prisma Client Generating Prisma Client Generators Generators Get all regions Get connection Get current authenticated principal Get database Get database usage metrics Get integration by ID Get list of backups Get list of database connections Get list of databases Get list of integrations Get list of integrations Get list of projects Get list of workspaces Get Prisma Postgres regions Get project Get workspace Getting Started Getting Started Getting Started Getting started with Prisma Migrate Getting started with Prisma Migrate GitHub GitHub Actions GitHub Copilot GitHub Copilot GraphQL GraphQL autocompletion GraphQL autocompletion Guides Handling exceptions and errors Handling exceptions and errors Hono Hono How middleware works How migrations work How to use Prisma ORM's type system How to use Prisma ORM's type system Image Transformations Import from existing database Import from MySQL Import from MySQL Import from PostgreSQL Import from PostgreSQL Indexes Indexes init Instantiating Prisma Client Integration testing Integration testing Introduction to Prisma Introduction to Prisma Client Introduction to Prisma Client Introduction to Prisma Next Is Prisma ORM an ORM? Keeping instances awake Known limitations Kysely Legacy Prisma Migrate Limitations and known issues Limitations and known issues Linktree Clone SaaS List connections List databases Local development Logging Logging ls Management API Many-to-many relations Many-to-many relations Many-to-many relations Many-to-many relations MCP server Mental model Metrics Microsoft SQL Server migrate Migrate to Prisma v7 Migration histories Models Models Module bundlers MongoDB MongoDB MongoDB MongoDB MongoDB MongoDB data modeling Mongoose Mongoose Mongoose Multi-schema Multi-schema Multiple databases MySQL MySQL MySQL MySQL/MariaDB Native database functions Native database functions Native database types Native database types Neon Neon NestJS NestJS Netlify Next.js Next.js Next.js Next.js Next.js + Prisma No Rust engine Null and undefined Null and undefined Nuxt Nuxt Nuxt Nuxt Nuxt + Prisma Older versions One-to-many relations One-to-many relations One-to-one relations One-to-one relations OpenTelemetry tracing OpenTelemetry tracing Operating against partial structures of your model types Operating against partial structures of your model types ORM client reference ORM releases and maturity levels ORM releases and maturity levels Overview Overview Overview Overview of Prisma Migrate Overview of Prisma Schema Overview on Prisma Migrate Overview on Prisma Schema Pagination Pagination Partner Integration Patching & hotfixing Patching & hotfixing Permit.io pgfence Pipeline builder reference PlanetScale PlanetScale PlanetScale platform pnpm workspaces PostgreSQL PostgreSQL PostgreSQL PostgreSQL PostgreSQL PostgreSQL PostgreSQL extensions PostgreSQL extensions Preview features Preview features Pricing Prisma CLI Prisma CLI Preview features Prisma CLI Preview features Prisma CLI reference Prisma CLI reference Prisma Client Prisma Client & Prisma schema Prisma Client & Prisma schema Prisma Client API Prisma Client API reference Prisma Compute Prisma Config reference Prisma Error Reference Prisma Error Reference Prisma Next Prisma Next Prisma Next API reference Prisma Next CLI Prisma ORM Prisma ORM Prisma ORM Prisma ORM MongoDB database connector Prisma Postgres Prisma Postgres Prisma Postgres Prisma Postgres FAQ Prisma Postgres on Deno Prisma schema reference Prisma Studio Prisma Studio Prisma validator prisma-next contract emit prisma-next contract infer prisma-next db init prisma-next db schema prisma-next db sign prisma-next db update prisma-next db verify prisma-next init prisma-next migration apply prisma-next migration new prisma-next migration plan prisma-next migration ref prisma-next migration show prisma-next migration status Prototyping your schema Prototyping your schema pull Pulumi push Query Insights Query Insights Query optimization Query optimization Raw queries Raw queries Raw queries reference Raw SQL comparisons Raw SQL comparisons Raycast React Router 7 Read replicas Read replicas Reading data Referential actions Referential actions Relation mode Relation mode Relation queries Relation queries Relational data modeling Relations Relations Relations and joins reset resolve REST Restore database (destructive) Revoke integration tokens rm Rollbacks and recovery Rotate connection credentials SafeQL & Prisma Client SafeQL & Prisma Client Schema API Schema location Schema location Schema management in teams SDK seed Seeding Seeding Select fields Select fields Self-relations Self-relations Sequelize Sequelize Serverless driver Serverless functions Shared packages & examples Shared packages & examples Shared Prisma Client extensions Shared Prisma Client extensions Shopify Should you use Prisma ORM? SolidStart Special rules for referential actions in SQL Server and MongoDB SQL comments SQL comments SQL ORMs SQL query builder reference SQL Server SQL Server SQL Server SQL Server on Docker SQL Server on Windows (local) SQLite SQLite SQLite SQLite Squashing migrations Squashing migrations start status status stop studio Studio in VS Code Studio with Prisma Next Supabase Supabase Support Supported databases Supported databases SvelteKit SvelteKit System requirements System requirements Table inheritance Table inheritance Tabnine Tabnine TanStack Start TanStack Start Team development Terraform Testing The data contract The emitted artifacts The migration graph To v7 Traditional servers Transactions Transactions and batch queries Transactions and batch queries Transactions and runtime reference Transfer project Troubleshooting Troubleshooting Troubleshooting Troubleshooting binary size and deployment issues Troubleshooting relations Troubleshooting relations Turborepo Turborepo + Prisma Turso Type safety Type safety Overview Type utilities Type utilities TypedSQL TypedSQL TypeORM TypeORM TypeORM TypeScript performance TypeScript performance Understanding Migrations Unit testing Unit testing Unsupported database features (Prisma Migrate) Unsupported database features (Prisma Migrate) Unsupported database features (Prisma Schema) Unsupported database features (Prisma Schema) Update database Update project Upgrade to v1 Upgrade to v3 Upgrade to v4 Upgrade to v5 Upgrade to v6 Upgrade to v7 Using API Clients Using extensions validate Vercel Vercel app deployment version Viewing data Views Views VS Code What are Client Extensions What is introspection? What is introspection? What is Prisma ORM? Why Prisma ORM? Windsurf Windsurf Working with compound IDs and unique constraints Working with compound IDs and unique constraints Working with Json fields Working with Json fields Working with scalar lists Working with scalar lists Write your own SQL Write your own SQL Writing data Writing guides Options Full documentation with content ## What is Prisma's llms.txt? Prisma publishes an `/llms.txt` file that provides AI systems with a structured index of its documentation. It follows the [llms.txt specification](https://llmstxt.org), organizing links to guides, API references, and tutorials under section headings so that LLMs like ChatGPT, Claude, and Gemini can quickly understand what Prisma offers and where to find details. Pass Spec 4 Sections 637 Links 112.2 KB Size ~28.7k Tokens Sections: Common Queries · Product Area Indexes · Latest · Options ## Add Prisma Docs to Your AI Assistant Select your tool to see how to add Prisma's llms.txt as a documentation source. Cursor Windsurf Claude Code ChatGPT Zed Copilot 1. 1 Open any chat or composer panel 2. 2 Type @Docs and select "Add new doc" 3. 3 Paste the URL: https://www.prisma.io/llms.txt 4. 4 Wait for the green dot (indexing complete) 5. 5 Reference @Docs in chat when asking about Prisma Cursor crawls the URL and indexes all subpages. Add a trailing slash to index child pages too. ## Spec Compliance 2 notes ## Frequently Asked Questions Where is Prisma's llms.txt file? Prisma publishes its llms.txt at https://www.prisma.io/llms.txt. This file provides a structured, markdown-formatted index of Prisma's documentation that AI systems can consume to understand the project's APIs, guides, and references. How do I use Prisma's llms.txt with AI coding assistants? Copy the llms.txt content and paste it into your AI assistant (Cursor, Windsurf, Claude, ChatGPT) as context. This gives the AI an accurate map of Prisma's documentation so it can provide better code suggestions and answers about Prisma. What does Prisma's llms.txt contain? Prisma's llms.txt contains 4 sections and 637 documentation links in 112.2 KB (~28.7k tokens). Key sections include Common Queries, Product Area Indexes, Latest, Options. How many tokens does Prisma's llms.txt use? The concise llms.txt index is approximately 28.7k tokens (112.2 KB). Most AI assistants can fit this within their context window. For the full expanded documentation, look for an llms-full.txt variant which embeds all content inline. What is Prisma? Next-generation Node.js and TypeScript ORM. Prisma's llms.txt file helps AI systems understand this by providing a structured overview of its documentation, making it easier for developers to get accurate AI-assisted help when working with Prisma. Can I generate an llms.txt for my own project? Yes. Use the free llms.txt generator at mdream.dev/tools/llms-txt/generator to crawl your site and produce a spec-compliant llms.txt file. You can also validate existing files with the llms.txt validator. ## Browse More llms.txt Files [Neon Serverless Postgres](https://mdream.dev/llms-txt/prisma/llms-txt/neon) [Drizzle TypeScript ORM that is lightweight and serverless-ready](https://mdream.dev/llms-txt/prisma/llms-txt/drizzle) [PlanetScale The database for developers](https://mdream.dev/llms-txt/prisma/llms-txt/planetscale) [Mastra The TypeScript AI agent framework](https://mdream.dev/llms-txt/prisma/llms-txt/mastra) [Convex The reactive fullstack database platform](https://mdream.dev/llms-txt/prisma/llms-txt/convex) [NativeWind Tailwind CSS for React Native](https://mdream.dev/llms-txt/prisma/llms-txt/nativewind) [MongoDB The developer data platform](https://mdream.dev/llms-txt/prisma/llms-txt/mongodb) [Tiptap The headless rich text editor framework](https://mdream.dev/llms-txt/prisma/llms-txt/tiptap) [View all 99 projects ](https://mdream.dev/llms-txt/prisma/llms-txt) ## Related Tools [

llms.txt Generator

Generate an llms.txt for your own project.](https://mdream.dev/llms-txt/prisma/tools/llms-txt/generator) [

llms.txt Validator

Validate your llms.txt against the official spec.](https://mdream.dev/llms-txt/prisma/tools/llms-txt/validator) © 2026 [Harlan Wilton](https://github.com/harlan-zw) · [MIT](https://github.com/harlan-zw/mdream/blob/main/license) [GitHub](https://github.com/harlan-zw/mdream) [Discord](https://discord.com/invite/275MBUBvgP)