Set up a brand-new Prisma ORM v7 project: initialize the CLI, configure prisma.config.ts and schema.prisma with a datasource, install a driver adapter, and generate a working Prisma Client.

Documented steps

1. Create and enter a project directory, then init a TypeScript project: `mkdir my-app && cd my-app && npm init -y && npm install typescript tsx @types/node --save-dev && npx tsc --init`. Set `"type": "module"` in package.json and in tsconfig.json set `module: "ESNext"`, `moduleResolution: "bundler"`, `target: "ES2023"` (Prisma's generated client is ESM-first as of v7).
2. Install Prisma CLI and client packages, plus the driver adapter for your database, e.g. for Postgres: `npm install prisma --save-dev && npm install @prisma/client @prisma/adapter-pg dotenv`. (SQLite: `@prisma/adapter-better-sqlite3`; other DBs have their own `@prisma/adapter-*` package.)
3. Run `npx prisma init --datasource-provider postgresql` (or `sqlite`, `mysql`, `sqlserver`, `mongodb`, `cockroachdb`). This scaffolds `prisma/schema.prisma`, a `prisma.config.ts` file, a `.env` file with `DATABASE_URL=...`, and `.gitignore` entries.
4. In `prisma.config.ts`, confirm the datasource URL is wired to the env var: `import { defineConfig, env } from "prisma/config"; export default defineConfig({ schema: "prisma/schema.prisma", migrations: { path: "prisma/migrations" }, datasource: { url: env("DATABASE_URL") } });`. Prisma v7 reads the connection URL from this config file, not from `schema.prisma`.
5. Edit `prisma/schema.prisma` to add your models under the existing `generator client { provider = "prisma-client" output = "../generated/prisma" }` and `datasource db { provider = "postgresql" }` blocks.
6. Create the database schema and generate the client: `npx prisma migrate dev --name init` (creates tables) then `npx prisma generate` (Prisma v7 no longer runs `generate` automatically after `migrate dev`).
7. Instantiate Prisma Client with the driver adapter (required in v7): `import { PrismaClient } from "../generated/prisma/client"; import { PrismaPg } from "@prisma/adapter-pg"; const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL }); const prisma = new PrismaClient({ adapter });`
8. Reference: https://www.prisma.io/docs/prisma-orm/quickstart/sqlite, https://www.prisma.io/docs/cli/init, https://www.prisma.io/docs/orm/reference/prisma-config-reference