MCP Quoting System

@echo off REM Phase 1 Database Setup - Quick Start REM Automates PostgreSQL setup and configuration title Phase 1 Setup - MCP Quoting System color 0A echo. echo ======================================== echo Phase 1: Database Setup echo MCP Quoting System v1.1.0 echo ======================================== echo. REM Check if PostgreSQL is installed echo [1/7] Checking for PostgreSQL... where psql >nul 2>&1 if %ERRORLEVEL% NEQ 0 ( echo. echo [!] PostgreSQL not found echo. echo Please install PostgreSQL first: echo 1. Download from: https://www.postgresql.org/download/windows/ echo 2. Run installer ^(keep default port 5432^) echo 3. Remember your postgres password echo 4. Run this script again echo. pause exit /b 1 ) echo [OK] PostgreSQL found echo. REM Check if Node.js is installed echo [2/7] Checking for Node.js... where node >nul 2>&1 if %ERRORLEVEL% NEQ 0 ( echo [!] Node.js not found echo Please install Node.js first: https://nodejs.org/ pause exit /b 1 ) echo [OK] Node.js found echo. REM Install npm dependencies echo [3/7] Installing dependencies... echo This may take a few minutes... call npm install --silent if %ERRORLEVEL% NEQ 0 ( echo [!] Failed to install dependencies pause exit /b 1 ) echo [OK] Dependencies installed echo. REM Check if .env exists echo [4/7] Checking configuration... if not exist .env ( echo [i] Creating .env from template... copy .env.example .env >nul echo. echo [!] IMPORTANT: Please edit .env file and configure: echo - DATABASE_URL with your PostgreSQL password echo - OPENAI_API_KEY ^(optional, for vector search^) echo. echo Example DATABASE_URL: echo DATABASE_URL="postgresql://postgres:YOUR_PASSWORD@localhost:5432/quoting_db" echo. set /p CONTINUE=" Press ENTER after editing .env, or Ctrl+C to exit..." ) echo [OK] Configuration file exists echo. REM Create database echo [5/7] Creating database... echo You will be prompted for postgres password echo. psql -U postgres -c "CREATE DATABASE quoting_db;" 2>nul if %ERRORLEVEL% EQU 0 ( echo [OK] Database created ) else ( echo [i] Database may already exist ^(this is OK^) ) echo Installing pgvector extension... psql -U postgres -d quoting_db -c "CREATE EXTENSION IF NOT EXISTS vector;" 2>nul if %ERRORLEVEL% EQU 0 ( echo [OK] pgvector extension installed ) else ( echo [!] Could not install pgvector echo Please install pgvector manually: https://github.com/pgvector/pgvector ) echo. REM Generate Prisma Client and push schema echo [6/7] Setting up database schema... call npm run db:setup if %ERRORLEVEL% NEQ 0 ( echo [!] Failed to setup database echo Please check your DATABASE_URL in .env pause exit /b 1 ) echo [OK] Database schema created echo. REM Migrate existing data (if any) echo [7/7] Migrating existing quotes... if exist data\quotes.json ( call npm run db:migrate if %ERRORLEVEL% EQU 0 ( echo [OK] Quotes migrated ) else ( echo [i] Migration skipped ^(this is OK^) ) ) else ( echo [i] No existing quotes to migrate ) echo. REM Success message echo ======================================== echo Setup Complete! echo ======================================== echo. echo Next steps: echo 1. Start the server: START.bat ^(option 2^) echo 2. Test the system: quick-test.bat echo 3. View database: npm run prisma:studio echo. echo Documentation: echo - DATABASE-SETUP.md for detailed setup echo - PHASE-1-PLAN.md for implementation plan echo - PHASE-1-PROGRESS.md for status echo. echo Press any key to open Prisma Studio ^(database browser^) pause >nul start cmd /c "npm run prisma:studio" echo. echo Prisma Studio will open at http://localhost:5555 echo. pause