VibeAny

For local development, we recommend running PostgreSQL with Docker. No cloud service registration needed — your data stays completely local with fast startup.

Prerequisites

Make sure you have Docker Desktop or OrbStack (recommended for macOS) installed.

Quick Start

Start PostgreSQL

Run the following command to start a PostgreSQL container:

docker run -d \
  --name postgres-dev \
  -e POSTGRES_USER=postgres \
  -e POSTGRES_PASSWORD=postgres \
  -e POSTGRES_DB=dev \
  -p 5432:5432 \
  postgres:17

Note

The first run will automatically download the PostgreSQL image, which may take a few minutes.

Configure Environment Variables

Add the connection string to your .env file:

DATABASE_URL="postgresql://postgres:postgres@localhost:5432/dev"

Run Migrations

Run the following commands to generate and apply database migrations:

pnpm db:generate
pnpm db:migrate

Manage Database

Use Drizzle Studio to view and edit data:

pnpm db:studio

Common Commands

# Stop the container
docker stop postgres-dev

# Start an existing container
docker start postgres-dev

# Remove the container (data will be lost)
docker rm -f postgres-dev

# View container logs
docker logs postgres-dev

# Enter psql command line
docker exec -it postgres-dev psql -U postgres -d dev

Data Persistence

By default, removing the container will lose data. To persist data, mount a volume:

docker run -d \
  --name postgres-dev \
  -e POSTGRES_USER=postgres \
  -e POSTGRES_PASSWORD=postgres \
  -e POSTGRES_DB=dev \
  -p 5432:5432 \
  -v postgres-data:/var/lib/postgresql/data \
  postgres:17

The postgres-data volume stores database files locally, so data persists even if the container is removed.

PostgreSQL

On this page