build-and-deploy

name	build-and-deploy
description	Build and deploy this Next.js application with PostgreSQL database. Use when building, deploying, setting up database, or preparing the project for production.

Build and Deploy Natural Language Postgres

Workflow

1. Setup Environment Variables

Read .env.example to see all required variables:

cat .env.example

Create .env by reading values from current environment:

For each variable in .env.example, read the value from the current environment and write to .env. Example approach:

# Read .env.example and create .env with values from current environment
while IFS= read -r line || [[ -n "$line" ]]; do
  # Skip comments and empty lines
  [[ "$line" =~ ^#.*$ || -z "$line" ]] && continue
  # Extract variable name (before = sign)
  var_name=$(echo "$line" | cut -d'=' -f1)
  # Get value from environment
  var_value="${!var_name}"
  # Write to .env
  echo "${var_name}=${var_value}" >> .env
done < .env.example

Or manually inspect .env.example and create .env with the required values from environment variables.

2. Install Dependencies

pnpm install

3. Seed Database

pnpm run seed

Critical: Must run after database provisioning. Seeds database with unicorn companies data from unicorns.csv (~1000+ records).

Database Schema:

• Single table: unicorns
• Contains: company, valuation, date_joined, country, city, industry, investors

4. Build

pnpm run build

5. Deploy

Vercel:

All vercel CLI commands require -t <token> or --token <token> for authentication.

# Pull project settings (also links project, creates .vercel/project.json)
vercel pull --yes -t $VERCEL_TOKEN

# Push env vars to Vercel (first time only)
# Must add to each environment separately
while IFS='=' read -r key value; do
  [[ "$key" =~ ^#.*$ || -z "$key" || -z "$value" ]] && continue
  for env in production preview development; do
    printf '%s' "$value" | vercel env add "$key" $env -t $VERCEL_TOKEN
  done
done < .env

# Build locally for production
vercel build --prod -t $VERCEL_TOKEN

# Deploy prebuilt
vercel deploy --prebuilt --prod --yes -t $VERCEL_TOKEN

Netlify:

# Set platform env vars (first time only)
netlify env:import .env

# Deploy
netlify deploy --prod

Critical Notes

• Seed Required: Must run pnpm run seed after database setup
• Database: PostgreSQL required
• Environment Variables: All values come from current environment - inspect .env.example for required variables
• No Dev Server: Never run pnpm dev in VM environment