Get an Instant Quote

Connect this quote manager to your live Supabase project to persist services, add-ons, and customer quote requests. If left empty, the app runs with zero-config in local storage demo mode.

⚡ Test Connection 🔄 Reset to Demo Seeds

-- Table 1: services
create table if not exists services (
  id text primary key,
  name text not null,
  base_price numeric(10,2) not null check (base_price >= 0),
  description text,
  icon text default 'lawn',
  status text not null default 'Published',
  display_order integer default 0,
  created_at timestamptz default now()
);

-- Table 2: addons
create table if not exists addons (
  id text primary key,
  name text not null,
  price numeric(10,2) not null check (price >= 0),
  description text,
  status text not null default 'Published',
  display_order integer default 0,
  created_at timestamptz default now()
);

-- Table 3: quote_requests
create table if not exists quote_requests (
  id text primary key,
  request_number text not null,
  customer_name text not null,
  customer_email text not null,
  customer_phone text,
  service_id text references services(id) on delete set null,
  service_name text not null,
  service_price numeric(10,2) not null default 0,
  addons jsonb default '[]'::jsonb,
  property_type text default 'Residential',
  yard_size text default 'Medium (1,000 - 5,000 sq ft)',
  service_frequency text default 'One-time Service',
  preferred_date text,
  notes text,
  subtotal numeric(10,2) not null,
  service_fee numeric(10,2) not null default 0,
  estimated_total numeric(10,2) not null,
  status text not null default 'Pending',
  created_at timestamptz default now()
);