MCP Quoting System

# Quick Start: GitHub + Railway + Vercel **Complete setup in 20 minutes** --- ## ⚡ Super Quick Setup (TL;DR) ```bash # 1. Initialize Git git-init.bat # 2. Create GitHub repo at https://github.com/new # Name: mcp-quoting-system # Private repo # 3. Push to GitHub git commit -m "Initial commit: MCP Quoting System v1.1.0" git remote add origin https://github.com/YOUR_USERNAME/mcp-quoting-system.git git branch -M main git push -u origin main # 4. Setup Railway PostgreSQL # - Go to https://railway.app/dashboard # - New Project → Add PostgreSQL # - Run: psql [connection-string] # - CREATE EXTENSION vector; # - CREATE DATABASE quoting_db; # - \c quoting_db # - CREATE EXTENSION vector; # 5. Connect Railway to GitHub # - Railway Dashboard → New → GitHub Repo # - Select mcp-quoting-system # - Add environment variables # 6. Auto-deploy! 🚀 # Every git push to main now deploys automatically! ``` --- ## 📋 Step-by-Step Checklist ### Part 1: GitHub (5 min) - [ ] Run `git-init.bat` to prepare repo - [ ] Create repo on GitHub (https://github.com/new) - [ ] Name: `mcp-quoting-system` - [ ] Visibility: Private - [ ] Don't initialize (we have files) - [ ] Copy the git commands GitHub shows - [ ] Push your code to GitHub - [ ] Verify .env is NOT in repo ### Part 2: Railway Database (5 min) - [ ] Login to Railway (https://railway.app) - [ ] Create new project - [ ] Add PostgreSQL database - [ ] Copy PSQL connection command - [ ] Connect via psql and run: ```sql CREATE EXTENSION vector; CREATE DATABASE quoting_db; \c quoting_db CREATE EXTENSION vector; \q ``` - [ ] Copy DATABASE_URL from Railway Variables tab - [ ] Change `railway` to `quoting_db` in URL ### Part 3: Railway Auto-Deploy (5 min) - [ ] In Railway: New → GitHub Repo - [ ] Select your repo - [ ] Configure: - Build: `npm install && npm run build` - Start: `npm start` - [ ] Add environment variables: - `DATABASE_URL` → Link to PostgreSQL - `OPENAI_API_KEY` → Your key - `NODE_ENV` → production - [ ] Enable auto-deploy on push - [ ] Push a test commit → Watch it deploy! ### Part 4: Local Setup (5 min) - [ ] Update local `.env` with Railway DATABASE_URL - [ ] Run: `npm install` - [ ] Run: `npm run db:setup` - [ ] Run: `npm run db:migrate` - [ ] Run: `npm run dev` - [ ] Test: http://localhost:3789/health --- ## 🔗 Your URLs After Setup ``` GitHub Repo: https://github.com/YOUR_USERNAME/mcp-quoting-system Railway Dashboard: https://railway.app/project/YOUR_PROJECT_ID Railway App (after deployment): https://your-app-name.up.railway.app Prisma Studio (local): http://localhost:5555 ``` --- ## 🎯 Daily Workflow ```bash # Make changes to code # ... edit files ... # Test locally npm run dev # Commit and push git add . git commit -m "feat: description of changes" git push # Railway auto-deploys! # Check Railway dashboard to watch deployment ``` --- ## 🚨 Important Reminders **NEVER commit to Git:** - `.env` file (contains secrets) - Database files with real data - API keys or passwords - User uploads **ALWAYS commit:** - `.env.example` (template) - Source code (.ts files) - Documentation (.md files) - Configuration files --- ## 🐛 Quick Troubleshooting **Git won't push:** ```bash git pull origin main # Resolve any conflicts git push origin main ``` **Railway deploy failed:** - Check logs in Railway dashboard - Verify environment variables set - Check DATABASE_URL is correct **.env accidentally committed:** ```bash git rm --cached .env git commit -m "Remove .env from tracking" git push # Then change all secrets immediately! ``` **Database connection failed:** - Verify Railway PostgreSQL is running - Check DATABASE_URL in Railway variables - Ensure quoting_db database exists - Verify pgvector extension installed --- ## 📚 Full Documentation - **GIT-SETUP.md** - Complete Git setup guide - **RAILWAY-SETUP.md** - Railway deployment guide - **DEPLOYMENT-OPTIONS.md** - Architecture decisions - **DATABASE-SETUP.md** - Database configuration --- ## ✅ Success Checklist After setup, you should have: - [ ] Code on GitHub (private repo) - [ ] Railway PostgreSQL with pgvector - [ ] Railway app auto-deploying - [ ] Environment variables configured - [ ] Local development working - [ ] Health check passing - [ ] Auto-deploy on git push working --- ## 🎉 You're Done When... You can: 1. Push code to GitHub ✓ 2. See it auto-deploy on Railway ✓ 3. Visit your Railway app URL ✓ 4. Get "healthy" status from health check ✓ **Estimated total time: 20 minutes** Good luck! 🚀