Build Your Own
Roofing CRM for Under $100

I need you to write SQL for my Supabase database. I'm building a roofing CRM. I need these tables: - customers (name, phone, email, address, job type, status, notes) - jobs (customer, title, description, status, scheduled date, crew, estimated cost, actual cost) - materials (job, name, quantity, unit price, total price) Write the SQL so I can paste it into Supabase's SQL Editor and hit Run. Add basic security rules so the database works for now (I'll lock it down later).

Build me a roofing CRM app. Here's what I need: MAIN DASHBOARD: - Show total customers, active jobs, money made this month, and jobs that need follow-up - Show a list of recent jobs - A button to quickly add a new customer or job CUSTOMERS PAGE: - List all customers with a search bar - Click a customer to see their info and job history - Form to add or edit customers (name, phone, email, address, job type, notes) JOBS PAGE: - A board where I can drag jobs between columns: Lead, Scheduled, In Progress, Completed, Invoiced - Click a job to see details: customer, crew, materials, costs Connect it to my Supabase database. Here are my credentials: - Supabase URL: [paste your Project URL from Step 3] - Supabase anon key: [paste your anon key from Step 3] Make it look clean and modern with a dark theme and blue accents. Make sure it works on my phone.

Add email alerts to my roofing CRM using Resend. Send an email to [your email address] whenever: 1. A new customer is added — subject: "New Customer: [name]" 2. A job is scheduled — subject: "Job Scheduled: [job title]" 3. A job is completed — subject: "Job Completed: [job title]" Here is my Resend API key: [paste your Resend API key] Make the email look clean and simple with the customer or job details in it.

Add these features to my roofing CRM: 1. JOB BOARD — Let me drag and drop jobs between stages (Lead, Inspection, Estimate, Scheduled, In Progress, Completed, Invoiced). Show customer name, job type, and dollar amount on each card. 2. CREWS — Let me create crews with names and members. Assign crews to jobs. Show a calendar of which crews are working which days. 3. MATERIALS — For each job, let me add materials with supplier name, quantity, cost per unit, and total cost. Show me the total material cost vs. how much the job pays. 4. INSURANCE CLAIMS — Track insurance claims: claim number, adjuster name, insurance company, approved amount, deductible. Link claims to jobs. 5. PHOTOS — Let me upload photos to each job (roof damage, before/after, permits, contracts). 6. MOBILE — Make sure everything works great on my phone. Big buttons, no sideways scrolling, forms that are easy to fill out. Make the job cards color-coded: red = urgent, yellow = this week, green = scheduled. Add a search bar that searches across customers, jobs, and claims.