Prisma ORM
Create a Prisma ORM app backed by Prisma Postgres.
bun create prisma@latestpnpm create prisma@latestyarn create prisma@latestnpm create prisma@latestRun this from a Node.js 22.18 or newer (on the 24 line, 24.11 or newer) environment; Node.js 24 is recommended. When prompted, choose PostgreSQL, and answer No to Deploy to Prisma now?.
Setup adds a starter contract, creates prisma-8.md, installs project-level Prisma ORM skills for your coding agent, and adds package scripts for the database steps below. Choose the minimal template if you want the fastest first run, or a framework template when you want the first query wired into an app route or page.
Run this from a Node.js 22.18 or newer (on the 24 line, 24.11 or newer) environment; Node.js 24 is recommended. When prompted, choose PostgreSQL, and answer No to Deploy to Prisma now?.
Setup adds a starter contract, creates prisma-8.md, installs project-level Prisma ORM skills for your coding agent, and adds package scripts for the database steps below. Choose the minimal template if you want the fastest first run, or a framework template when you want the first query wired into an app route or page.
Create a Prisma Postgres database from the terminal and export its connection string. The generated scripts read the environment variable, not .env:
bunx create-db@latestpnpm dlx create-db@latestyarn dlx create-db@latestnpx create-db@latestexport DATABASE_URL="<the connection string create-db printed>"The command also prints a claim URL; open it within 24 hours to keep the database in your account.
export DATABASE_URL="<the connection string create-db printed>"The command also prints a claim URL; open it within 24 hours to keep the database in your account.
From the generated project directory, run db:init to apply the starter schema to Prisma Postgres and sign the database.
bun run db:initpnpm run db:inityarn db:initnpm run db:initSample users are seeded automatically the first time the app queries the database, so there is no separate seed step.
Start the app and confirm the sample query runs successfully.
bun run devpnpm run devyarn devnpm run devUse the URL or terminal output shown by your template to confirm the sample query runs successfully.
- Open the generated contract and change the starter model.
- Use Import from PostgreSQL or Import from MySQL when you want to move an existing database to Prisma Postgres.
- Use the PostgreSQL existing-project guide when your app already has a Prisma Postgres database.