Orchard Lab

A place to share my thoughts and learnings

Bun + Prisma

Posted at — Sep 17, 2023

I just can’t stop having fun using bun

I have an old postgresql database backup. I need to quickly inspect the tables/models in the database and then extract data from it.

Spin up postgres

After having the backup sql ready output-backup.sql. I created a docker-compose.yml file to quickly spin up a postgres instance.

version: '3.1'

    image: postgres:latest
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
      POSTGRES_DB: example_dev
      - "54321:5432"
      - postgres_data:/var/lib/postgresql/data


Now let’s re-dump the data back into the local database.

psql -U postgres -h localhost -p 54321 -d example_dev -f output-backup.sql

Okay the fun parts begin.

Bun + Prisma Fastlane

Set up a new package using bun:

mkdir data-explorer
cd data-explorer && bun init -y

Now let’s add prisma:

bun add prisma
bunx prisma init --datasource-provider postgresql

Remember to change the DATABASE_URL to our local one in .env:


Inspect the database now:

bunx prisma db pull

Generate prisma client:

bunx prisma generate


Now we can play with the database:

import { PrismaClient } from "@prisma/client";
const prisma = new PrismaClient();

const allUsers = await prisma.users.findMany();

See it now:

bun run index.ts

The beauty of Prisma is that the generated schema.prisma is like a X-Ray to the database. Not only we can see the tables and relations, but also we can manupulate it in a type safe way (with autocompletion of course).

Such a joyful experience.


I still can’t believe how easy it is to run a TypeScript project using bun with massive npm modules without losing my mind.


https://bun.sh/guides/ecosystem/prisma https://www.prisma.io/docs/getting-started/setup-prisma/add-to-existing-project/relational-databases/introspection-typescript-postgresql