Up to 1000x faster database queries with Accelerate -> Sign up for Early Access
prisma_logo
Product

Prisma ORM

Client
Write Queries the way you think
Migrate
Generate customisable SQL migrations

Prisma Data Platform

Accelerateearly access
Query up to 1000x faster
Data Browser
Explore and manipulate data in your projects
Data Proxy
Manage and scale your connection pool
Docs
Developer
Get Started
Tutorials
Playground
Prisma Examples
Prisma in your Stack
Support
Ecosystem
Community
Data Guide
Prisma
Playground
Use Cases
Customer Stories
Learn about applications built with Prisma
Enterprise
Up-level your applications with our Data Platform
Company
About
Blog
Careers
Events
Causes

Latest from the blog

Get Started
Get StartedConceptsGuidesReferencePrisma Data PlatformAbout
Docs
    • Concepts
      • Overview
        • What is Prisma?
        • Why Prisma?
        • Should you use Prisma?
        • Prisma in your stack
      • Components
        • Prisma schema
        • Prisma Client
        • Prisma Migrate
          • Mental model
          • Get started with Prisma Migrate
          • About migration histories
          • Prisma Migrate in development and production
          • Supported database types and features
          • Prototype your schema
          • About the shadow database
          • Prisma Migrate limitations and known issues
        • Introspection
        • Prisma CLI
        • Prisma Studio
        • Prisma engines
        • Preview features
      • Database connectors
        • PostgreSQL
        • MySQL
        • SQLite
        • MongoDB
        • CockroachDB
        • Microsoft SQL Server
      • More
        • Telemetry
        • Comparing Prisma
Concepts / Components

Prisma Migrate

Does not apply for MongoDB
Instead of migrate dev and related commands, use db push for MongoDB.

Prisma Migrate is an imperative database schema migration tool that enables you to:

  • Keep your database schema in sync with your Prisma schema as it evolves and
  • Maintain existing data in your database

Prisma Migrate generates a history of .sql migration files, and plays a role in both development and deployment.

If you are prototyping, consider using the db push command - see Schema prototyping with db push for examples.

In this section

  • Mental model
  • Get started with Prisma Migrate
  • About migration histories
  • Prisma Migrate in development and production
  • Supported database types and features
  • Prototype your schema
  • About the shadow database
  • Prisma Migrate limitations and known issues

Was this helpful?

Edit this page on GitHub

Product

ClientMigrateData BrowserData ProxyPricing

Developers

DocsGet StartedPrisma ExamplesData GuidePrisma in your StackSupportCommunityData Platform Status

Use Cases

Customer StoriesEnterprise

Company

AboutBlogCareers EventsCausesTerms & Privacy

Newsletter

prisma_logo
© 2023 Prisma Data, Inc.