Javascript

pnpm i prisma -D
pnpm i @prisma/client @prisma/adapter-pg
npx prisma init

Create db in pgsql

psql -U postgres
CREATE TABLE dbname

Add .env file at root

DATABASE_URL="postgres://postgres:password@localhost:5432/dbname"

For js remove output path and change provider in schema

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
}

For quick check

npx prisma db push
npx prisma generate

Config File

const { PrismaClient } = require("@prisma/client");
const { PrismaPg } = require("@prisma/adapter-pg");

const connectionString = `${process.env.DATABASE_URL}`;

const adapter = new PrismaPg({ connectionString });

const prisma = new PrismaClient({ adapter });

module.exports = prisma;

Javascript

For typescript