Tushar Patil

Posted on May 18

🚀 Setting Up PostgreSQL with Prisma ORM in a Node.js Project (Using Docker)

#node #postgressql #prisma #docker

In my recent Node.js project, I set up a PostgreSQL database using Prisma ORM—one of the most efficient and type-safe ORMs available. I used docker to run postgres on my linux machine

Here’s a detailed walkthrough of the setup—from pulling the Docker image to generating the Prisma client. If you're getting started with Prisma and PostgreSQL in Node.js, this guide is for you.

🛠️ Prerequisites

Make sure the following are installed:

✅ Node.js (v14+ recommended)
✅ Docker
✅ npm

Step 1: Pull PostgreSQL Docker Image

docker pull postgres

Step 2: Run PostgreSQL Container

docker run --name my-postgres -e POSTGRES_USER=admin -e POSTGRES_PASSWORD=secret -e POSTGRES_DB=mydb -p 5432:5432 -d postgres

🔍 This sets up a PostgreSQL container with:

Username: admin
Password: secret
Database name: mydb
Port: Exposes DB on localhost:5432

Step 3: Init NodeJs project

npm init -y

Step 4: Install Prisma

npm install prisma --save-dev
npm install @prisma/client
npx prisma init

🔐 Step 5: Configure .env

add DATABASE_URL in .env file
DATABASE_URL="postgresql://admin:secret@localhost:5432/mydb?schema=public"

admin: PostgreSQL username
secret: PostgreSQL password
localhost: Host of the DB server
5432: PostgreSQL's default port
mydb: Database name
schema=public: Default schema in PostgreSQL

📝 Step 6: Define Your Prisma Schema

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

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  createdAt DateTime @default(now())
}

⚙️ Step 7: Migrate and Generate Prisma Client

npx prisma migrate dev --name init
npx prisma generate

--
migrate dev creates migration files and updates the DB
generate creates the Prisma client for querying

Step 8: Test the Database Connection

Let’s write a quick script to ensure everything’s working as expected.

Create a script.js file:

const { PrismaClient } = require('@prisma/client');
const prisma = new PrismaClient();

async function main() {
  const user = await prisma.user.create({
    data: {
      email: '[email protected]',
      name: 'Tushar',
    },
  });

  console.log('User created:', user);

  const allUsers = await prisma.user.findMany();
  console.log('All users:', allUsers);
}

main()
  .catch(e => {
    console.error(e);
    process.exit(1);
  })
  .finally(async () => {
    await prisma.$disconnect();
  });

Run the Script

node script.js

You should see something like:

User created: { id: 1, email: '[email protected]', name: 'Tushar', createdAt: 2025-05-18T... }
All users: [ { id: 1, email: '[email protected]', name: 'Tushar', createdAt: 2025-05-18T... } ]

🎉 Congratulations! You've successfully connected Node.js to a PostgreSQL database running inside a Docker container using Prisma.

DEV Community