prisma · Prisma Docs
Prisma Local development (/docs/postgres/database/local-development)
This page serves as a landing hub for managing local development workflows with Prisma Postgres, including backups, connection string configuration, connection pooling, extensions, and query insights.
Derived skill
Files assembled from official documentation
Viewing SKILL.md
Prisma Local development (/docs/postgres/database/local-development)
This page serves as a landing hub for managing local development workflows with Prisma Postgres, including backups, connection string configuration, connection pooling, extensions, and query insights.
When To Use
Use when setting up a local development environment with Prisma Postgres and needing to configure backups, connection strings, pooling, or extensions.
Reference Files
| File | Contains | Use For |
|---|---|---|
SKILL.md | Entry point: scope, routing table, and workflow. | Start here. |
docs/prisma-local-development-docs-postgres-database-workflow-guide.md | A guide detailing the steps and best practices for setting up and managing a local PostgreSQL database environment for Prisma development. | Questions about a guide detailing the steps and best practices for setting up and managing a local PostgreSQL database environment fo... |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de.bash | A bash command demonstrating how to initialize local development using npx prisma dev for a PostgreSQL database. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to initialize local development using npx prisma dev for a PostgreSQL database. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-2.bash | A bash command using pnpm to execute the prisma dev utility for local PostgreSQL development. | Exact payloads, commands, or snippets shown in A bash command using pnpm to execute the prisma dev utility for local PostgreSQL development. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-3.bash | Bash commands for setting up a local PostgreSQL database environment using Prisma. | Exact payloads, commands, or snippets shown in Bash commands for setting up a local PostgreSQL database environment using Prisma. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-4.bash | A bash command demonstrating how to use bunx to run the prisma dev command for local PostgreSQL development. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to use bunx to run the prisma dev command for local PostgreSQL development. |
examples/prisma-local-development-docs-postgres-database-prisma-local-development.text | Terminal output showing the successful execution of the npx prisma dev command for a local Postgres database setup. | Exact payloads, commands, or snippets shown in Terminal output showing the successful execution of the npx prisma dev command for a local Postgres database setup. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de.text | A text file demonstrating the connection string format for local PostgreSQL development using Prisma Accelerate. | Exact payloads, commands, or snippets shown in A text file demonstrating the connection string format for local PostgreSQL development using Prisma Accelerate. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-5.bash | A bash command demonstrating how to start a local PostgreSQL database using the npx prisma dev --detach flag. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to start a local PostgreSQL database using the npx prisma dev --detach flag. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-6.bash | A bash command using pnpm to run prisma dev in detached mode for local postgres development. | Exact payloads, commands, or snippets shown in A bash command using pnpm to run prisma dev in detached mode for local postgres development. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-7.bash | Bash commands for setting up a local PostgreSQL database environment using the Prisma CLI. | Exact payloads, commands, or snippets shown in Bash commands for setting up a local PostgreSQL database environment using the Prisma CLI. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-8.bash | A bash command using bunx to run prisma dev in detached mode for local postgres development. | Exact payloads, commands, or snippets shown in A bash command using bunx to run prisma dev in detached mode for local postgres development. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-9.bash | A bash command demonstrating how to run prisma migrate dev for local PostgreSQL development. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to run prisma migrate dev for local PostgreSQL development. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-10.bash | A bash command demonstrating how to run prisma migrate dev using pnpm to set up a local PostgreSQL database. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to run prisma migrate dev using pnpm to set up a local PostgreSQL database. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-11.bash | A bash command demonstrating how to run prisma migrate dev for local postgres development using yarn dlx. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to run prisma migrate dev for local postgres development using yarn dlx. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-12.bash | A bash command using bunx to run prisma migrate dev for local postgres development. | Exact payloads, commands, or snippets shown in A bash command using bunx to run prisma migrate dev for local postgres development. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-13.bash | A bash command demonstrating how to initialize a local PostgreSQL database using the npx prisma dev command. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to initialize a local PostgreSQL database using the npx prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-14.bash | A bash command using pnpm to initialize a local PostgreSQL database development environment with Prisma. | Exact payloads, commands, or snippets shown in A bash command using pnpm to initialize a local PostgreSQL database development environment with Prisma. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-15.bash | A bash command to initialize a local PostgreSQL database using the Prisma CLI development command. | Exact payloads, commands, or snippets shown in A bash command to initialize a local PostgreSQL database using the Prisma CLI development command. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-16.bash | A bash command using bunx to initialize a local PostgreSQL database development environment with Prisma. | Exact payloads, commands, or snippets shown in A bash command using bunx to initialize a local PostgreSQL database development environment with Prisma. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-start-postgre.bash | A bash command demonstrating how to use npx prisma dev start to initiate local development for a PostgreSQL database. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to use npx prisma dev start to initiate local development for a PostgreSQL database. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-17.bash | A bash command using pnpm to start a local PostgreSQL development environment with Prisma. | Exact payloads, commands, or snippets shown in A bash command using pnpm to start a local PostgreSQL development environment with Prisma. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-start-postgre-2.bash | A bash command demonstrating how to use yarn dlx prisma dev start to initiate local development for a PostgreSQL database. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to use yarn dlx prisma dev start to initiate local development for a PostgreSQL data... |
examples/prisma-local-development-docs-postgres-database-prisma-dev-start-bunx-co.bash | A bash command demonstrating how to use bunx to start the Prisma local development environment. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to use bunx to start the Prisma local development environment. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-start-postgre-3.bash | A bash command to start a local PostgreSQL database named mydb in the background using the Prisma CLI. | Exact payloads, commands, or snippets shown in A bash command to start a local PostgreSQL database named mydb in the background using the Prisma CLI. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-start-postgre-4.bash | A bash command to start a local PostgreSQL database named mydb in the background using the Prisma CLI. | Exact payloads, commands, or snippets shown in A bash command to start a local PostgreSQL database named mydb in the background using the Prisma CLI. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-start-postgre-5.bash | A bash command to start a local PostgreSQL database named mydb in the background using the Prisma CLI. | Exact payloads, commands, or snippets shown in A bash command to start a local PostgreSQL database named mydb in the background using the Prisma CLI. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-18.bash | A bash command using bunx to start a local PostgreSQL database named mydb via the Prisma CLI. | Exact payloads, commands, or snippets shown in A bash command using bunx to start a local PostgreSQL database named mydb via the Prisma CLI. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-19.bash | A bash command demonstrating how to start existing PostgreSQL databases using the npx prisma dev start command. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to start existing PostgreSQL databases using the npx prisma dev start command. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-start-postgre-6.bash | A bash command using pnpm to start all existing databases starting with a specific prefix for local development. | Exact payloads, commands, or snippets shown in A bash command using pnpm to start all existing databases starting with a specific prefix for local development. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-start-postgre-7.bash | A bash command demonstrating how to use yarn dlx prisma dev start to launch existing databases starting with a specific prefix. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to use yarn dlx prisma dev start to launch existing databases starting with a specif... |
examples/prisma-local-development-docs-postgres-database-prisma-local-development.bash | A bash command using bunx to start all existing PostgreSQL databases starting with a specific prefix. | Exact payloads, commands, or snippets shown in A bash command using bunx to start all existing PostgreSQL databases starting with a specific prefix. |
examples/prisma-local-development-docs-postgres-database-prisma-local-development-2.bash | A bash command demonstrating how to list local development databases using the npx prisma dev ls command. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to list local development databases using the npx prisma dev ls command. |
examples/prisma-local-development-docs-postgres-database-prisma-local-development-3.bash | A bash command using pnpm to list local development environments for a PostgreSQL database with Prisma. | Exact payloads, commands, or snippets shown in A bash command using pnpm to list local development environments for a PostgreSQL database with Prisma. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-ls-command.bash | A bash command demonstrating the use of the prisma dev ls utility for local development. | Exact payloads, commands, or snippets shown in A bash command demonstrating the use of the prisma dev ls utility for local development. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-20.bash | A bash command using bunx to run the prisma dev command for local postgres development. | Exact payloads, commands, or snippets shown in A bash command using bunx to run the prisma dev command for local postgres development. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-command.bash | A bash command example demonstrating how to use npx prisma dev stop to terminate local development processes. | Exact payloads, commands, or snippets shown in A bash command example demonstrating how to use npx prisma dev stop to terminate local development processes. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-command-2.bash | A bash command demonstrating how to stop a local Prisma development environment using pnpm. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to stop a local Prisma development environment using pnpm. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-command-3.bash | A bash command demonstrating how to stop a local Prisma development environment using the yarn dlx prisma dev stop command. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to stop a local Prisma development environment using the yarn dlx prisma dev stop co... |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-command-4.bash | A bash command demonstrating how to stop a running Prisma local development instance using bunx. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to stop a running Prisma local development instance using bunx. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-command-5.bash | A bash command demonstrating how to stop a local database instance named mydb using the npx prisma dev command. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to stop a local database instance named mydb using the npx prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-database.bash | A bash command demonstrating how to stop a local development database using the prisma dev command. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to stop a local development database using the prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-database-2.bash | A bash command demonstrating how to stop a local development database using the prisma dev command. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to stop a local development database using the prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-command-6.bash | A bash command demonstrating how to stop a local development database using the prisma dev command. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to stop a local development database using the prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-command-7.bash | A bash command demonstrating how to use npx prisma dev stop to terminate all database instances starting with a specific prefix. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to use npx prisma dev stop to terminate all database instances starting with a speci... |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-command-8.bash | A bash command demonstrating how to use pnpm dlx prisma dev stop to terminate all databases starting with a specific prefix. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to use pnpm dlx prisma dev stop to terminate all databases starting with a specific... |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-command-9.bash | A bash command demonstrating how to use yarn dlx prisma dev stop to terminate all database instances starting with a specific prefix. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to use yarn dlx prisma dev stop to terminate all database instances starting with a... |
examples/prisma-local-development-docs-postgres-database-prisma-dev-stop-command-10.bash | A bash command demonstrating how to use bunx to stop all local databases starting with a specific prefix using the prisma dev command. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to use bunx to stop all local databases starting with a specific prefix using the pr... |
examples/prisma-local-development-docs-postgres-database-prisma-local-development-4.bash | A bash command demonstrating how to use npx prisma dev to remove local development resources. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to use npx prisma dev to remove local development resources. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-21.bash | A bash command using pnpm to execute the prisma dev rm operation for local postgres development. | Exact payloads, commands, or snippets shown in A bash command using pnpm to execute the prisma dev rm operation for local postgres development. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-22.bash | A bash command using yarn dlx prisma dev rm to remove local development resources for a PostgreSQL database. | Exact payloads, commands, or snippets shown in A bash command using yarn dlx prisma dev rm to remove local development resources for a PostgreSQL database. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-23.bash | A bash command using bunx to run the prisma dev rm operation for local postgres development. | Exact payloads, commands, or snippets shown in A bash command using bunx to run the prisma dev rm operation for local postgres development. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-24.bash | A bash command demonstrating how to remove a specific database named mydb using the npx prisma dev command. | Exact payloads, commands, or snippets shown in A bash command demonstrating how to remove a specific database named mydb using the npx prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-25.bash | A bash command using pnpm to remove a local PostgreSQL database named mydb via the Prisma CLI. | Exact payloads, commands, or snippets shown in A bash command using pnpm to remove a local PostgreSQL database named mydb via the Prisma CLI. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-remove-databa.bash | A bash command using yarn dlx prisma dev to remove a specific local database named mydb. | Exact payloads, commands, or snippets shown in A bash command using yarn dlx prisma dev to remove a specific local database named mydb. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-26.bash | A bash command using bunx to remove a specific local PostgreSQL database named mydb via the prisma dev command. | Exact payloads, commands, or snippets shown in A bash command using bunx to remove a specific local PostgreSQL database named mydb via the prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-27.bash | A bash command to remove all databases starting with a specific prefix using the Prisma CLI. | Exact payloads, commands, or snippets shown in A bash command to remove all databases starting with a specific prefix using the Prisma CLI. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-remove-databa-2.bash | A bash command using pnpm to remove databases starting with a specific prefix during local development. | Exact payloads, commands, or snippets shown in A bash command using pnpm to remove databases starting with a specific prefix during local development. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-remove-databa-3.bash | A bash command using yarn dlx prisma dev rm to remove databases starting with a specific prefix. | Exact payloads, commands, or snippets shown in A bash command using yarn dlx prisma dev rm to remove databases starting with a specific prefix. |
examples/prisma-local-development-docs-postgres-database-prisma-dev-remove-databa-4.bash | A bash command using bunx to remove all databases starting with a specific prefix via the prisma dev command. | Exact payloads, commands, or snippets shown in A bash command using bunx to remove all databases starting with a specific prefix via the prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-28.bash | A bash command to force remove a local development database named mydb using the Prisma CLI. | Exact payloads, commands, or snippets shown in A bash command to force remove a local development database named mydb using the Prisma CLI. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-29.bash | A bash command to force remove a local postgres database using the prisma dev command. | Exact payloads, commands, or snippets shown in A bash command to force remove a local postgres database using the prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-30.bash | A bash command to force remove a local postgres database using the prisma dev command. | Exact payloads, commands, or snippets shown in A bash command to force remove a local postgres database using the prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-31.bash | A bash command to force remove a local postgres database using the prisma dev command. | Exact payloads, commands, or snippets shown in A bash command to force remove a local postgres database using the prisma dev command. |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de.ts | A TypeScript function demonstrating how to start a local Prisma development server with specific port configurations for PostgreSQL. | Exact payloads, commands, or snippets shown in A TypeScript function demonstrating how to start a local Prisma development server with specific port configurations... |
examples/prisma-local-development-docs-postgres-database-prisma-postgres-local-de-2.ts | A TypeScript code snippet demonstrating how to configure ServerOptions for local PostgreSQL development using the @prisma/dev package. | Exact payloads, commands, or snippets shown in A TypeScript code snippet demonstrating how to configure ServerOptions for local PostgreSQL development using the @pr... |
What This Skill Covers
-
- Backups: Manage and restore database backups in Prisma Postgres - Connecting to your database: Choose the right Prisma Postgres connection string for your...
- Main sections:
Related pages.
Workflow
- Open the most relevant file under
docs/for the exact documented workflow and wording. - Open
schemas/files for exact structured contracts. - Open
examples/files for concrete requests, commands, snippets, and manifests. - Do not add behavior or configuration that is not present in the attached source files.
Canonical source: https://www.prisma.io/docs/postgres/database/local-development