New Machine Setup

git clone https://github.com/brainstormerio/brainstormerv2.git
cd brainstormerv2

# Start infrastructure containers
# If containers don't exist, see Docker Setup guide for initial creation
docker start brainstormer-postgres brainstormer-redis brainstormer-chroma

# Verify containers are running
docker ps --format "table {{.Names}}\t{{.Status}}\t{{.Ports}}"

# Test PostgreSQL connection
docker exec brainstormer-postgres pg_isready -U brainstormer

# Run ALL migrations in order
for migration in infrastructure/postgres/migrations/*.sql; do
  echo "Running migration: $migration"
  docker exec -i brainstormer-postgres psql -U brainstormer -d brainstormer < "$migration"
done

# Verify tables
docker exec brainstormer-postgres psql -U brainstormer -d brainstormer -c "\dt"

npm install

cp .env.example .env

npm run dev

# Check tables exist
docker exec brainstormer-postgres psql -U brainstormer -d brainstormer -c "\dt"

# Check views
docker exec brainstormer-postgres psql -U brainstormer -d brainstormer -c "\dv"
# Should show: kb_summary, document_usage_stats

curl http://localhost:4000/health  # Gateway
curl http://localhost:4001/health  # Auth
curl http://localhost:4002/health  # Bot
curl http://localhost:4003/health  # Realtime Audio
curl http://localhost:4005/health  # Knowledge

docker exec brainstormer-redis redis-cli ping
# Should return: PONG

# Complete startup
docker start brainstormer-postgres brainstormer-redis brainstormer-chroma
npm install
npm run dev
open http://localhost:3000

# Type check
npm run typecheck

# Build
npm run build

# Run migrations
for f in infrastructure/postgres/migrations/*.sql; do
  docker exec -i brainstormer-postgres psql -U brainstormer -d brainstormer < "$f"
done