Database Setup

Configure Prisma database for Portfolio OS dashboard

Database Setup

Configure the database for Portfolio OS dashboard using Prisma ORM.

Development Setup

1

Navigate to Dashboard

cd apps/dashboard
2

Configure Database URL

# apps/dashboard/.env.local
DATABASE_URL="file:./dev.db"
3

Generate Prisma Client

pnpm prisma generate
4

Run Migrations

pnpm prisma migrate dev --name init
5

Seed Database (Optional)

pnpm prisma db seed

Production Setup

PostgreSQL

# apps/dashboard/.env.production
DATABASE_URL="postgresql://user:password@host:5432/dbname?schema=public"

Deploy Migrations

# Apply migrations to production
pnpm prisma migrate deploy

Prisma Studio

# Open database GUI
pnpm prisma studio

Opens at http://localhost:5555

Common Operations

Create Migration

pnpm prisma migrate dev --name add_user_table

Reset Database

pnpm prisma migrate reset

Update Schema

  1. Edit prisma/schema.prisma
  2. Run pnpm prisma migrate dev --name description
  3. Prisma client auto-regenerates

Troubleshooting

Migration Fails

# Reset and re-migrate
pnpm prisma migrate reset
pnpm prisma migrate dev

Client Out of Sync

# Regenerate client
pnpm prisma generate

Next Steps