db
Manage your database schema and lifecycle during development
The prisma db command group provides tools to manage your database schema and lifecycle during development.
Usage
prisma db [command] [options]Global options
| Option | Description |
|---|---|
-h, --help | Display help message |
--config | Custom path to your Prisma config file |
--schema | Custom path to your Prisma schema |
Subcommands
| Command | Description |
|---|---|
prisma db pull | Pull the state from the database to the Prisma schema using introspection |
prisma db push | Push the state from Prisma schema to the database during prototyping |
prisma db seed | Seed your database |
prisma db execute | Execute native commands to your database |
Examples
# Pull schema from database
prisma db pull
# Push schema to database
prisma db push
# Seed the database
prisma db seed
# Execute a SQL script
prisma db execute --file ./script.sql