DatabaseDatabase providers
Local (Docker)
PostgreSQL 15 via docker-compose — the recommended local default.
The recommended database for local development is Postgres 15 from docker-compose.yml.
| Setting | Default |
|---|---|
| Image | postgres:15 |
| User | admin |
| Password | root |
| Database | turbojet |
| Host port | ${POSTGRES_PORT:-5432} |
Compose also starts Mailpit for email testing. See Environment for DATABASE_URL, DIRECT_URL, and POSTGRES_PORT.
1. Start containers
pnpm docker:up2. Configure environment variables
For local Docker, DATABASE_URL and DIRECT_URL can be the same connection string:
DATABASE_URL="postgresql://admin:root@localhost:5432/turbojet"
DIRECT_URL="postgresql://admin:root@localhost:5432/turbojet"Adjust the port if you set POSTGRES_PORT.
3. Migrate and generate
pnpm prisma:migrate
pnpm --filter @repo/database db:generateOptional seed (verified onboarded users):
pnpm --filter @repo/database db:seed4. Verify
pnpm --filter @repo/database db:studio
# or
pnpm dev