postgres
Create and manage Prisma Postgres databases.
Use postgres commands to manage Prisma Postgres databases in a project. Most commands let you target a specific project with --project <id-or-name> and a branch with --branch <git-name>.
Usage
bunx prisma@latest postgres list
bunx prisma@latest postgres create mydbCommands
| Command | Description |
|---|---|
postgres list | List databases |
postgres show <database> | Show database metadata without secret values |
postgres create <name> | Create a database and print its one-time connection URL. --region sets the Prisma Postgres region |
postgres usage <database> | Show usage metrics for a database |
postgres delete <database> | Permanently delete a database, after exact id confirmation |
postgres backup list <database> | List platform-created backups for a database |
postgres backup restore <database> | Restore from a backup, after exact id confirmation |
postgres connection list <database> | List a database's connections |
postgres connection create <database> | Create a database connection and print its one-time connection URL |
postgres connection rotate <connection-id> | Rotate connection credentials and print the new one-time connection URL |
postgres connection delete <connection-id> | Permanently delete a database connection, after exact id confirmation |