Manage your application data in one place with the Prisma Data Platform. Learn more ->
  • Quickstart
  • Docs
  • FAQ
  • Community
  • Blog
  • GitHub
Getting StartedConceptsGuidesReferenceSupportAbout
Prisma 1 Docs   
Docs
    • Concepts
      • Overview
        • What is Prisma?
        • Why Prisma?
        • Should you use Prisma?
        • Prisma in your stack
      • Components
        • Prisma schema
        • Prisma Client
        • Prisma Migrate
        • Introspection
        • Prisma CLI
        • Prisma Studio
        • Prisma engines
        • Preview features
      • Prisma Data PlatformEarly Access
        • About the Prisma Data Platform
        • Static egress IP addresses
        • Prisma Data Proxy
      • Database connectors
        • PostgreSQL
        • MySQL
        • SQLite
        • MongoDB
        • CockroachDB
        • Microsoft SQL Server
      • More
        • Telemetry
        • Comparing Prisma
Concepts

Components

In this section

  • Prisma schema
    • Data sources
    • Generators
    • Data model
    • Relations
    • Names in the underlying database
    • Supporting features without a PSL equivalent
    • Indexes
  • Prisma Client
    • Working with PrismaClient
    • CRUD
    • Select fields
    • Relation queries
    • Filtering and sorting
    • Working with fields
    • Advanced type safety
    • Middleware
    • Pagination
    • Aggregation, grouping, and summarizing
    • Composite types
    • Transactions and batch queries
    • Full-text search
    • Custom Validation
    • Computed fields
    • Excluding fields
    • Custom models
    • Case sensitivity
    • Null and undefined
    • Raw database access
    • Debugging
    • Module bundlers
    • Database polyfills
    • Handling exceptions and errors
  • Prisma Migrate
    • Supported database types and features
    • Schema Prototyping
    • Shadow database
    • Prisma Migrate limitations and known issues
  • Introspection
  • Prisma CLI
    • Installing the Prisma CLI
  • Prisma Studio
  • Prisma engines
    • Query engine
  • Preview features
    • Prisma Client and schema preview features
    • Prisma CLI Preview features

Was this helpful?

Edit this page on GitHub
Prisma Logo

Products

Prisma ClientPrisma MigratePrisma StudioPrisma 1 CloudPrisma Data PlatformProduct Roadmap

Resources

DocsGet StartedAPI ReferenceExamplesHow to GraphQLData Guide

Prisma With

Prisma with Next.jsPrisma with TypeScriptPrisma with GraphQLPrisma with ApolloPrisma with NestJSPrisma with ExpressPrisma with hapiPrisma with PlanetscalePrisma with MongoDB

Community

Prisma AmbassadorMeet the CommunitySlackGitHubDiscussionsEvents

Company

AboutShowcaseJobs We're hiring!Prisma EnterpriseCauses 🇺🇦ScholarshipBlogTerms & PrivacyHTML Sitemap

Newsletter

Stay up to date with the latest features and changes to Prisma

Find Us

Find us on TwitterFind us on YouTubeJoin us on SlackFind us on GitHub

Prisma © 2018-2022.

Made with ❤️ in Berlin and worldwide