Backend Setup - Quick Guide

If u want help contact me : insta : https://www.instagram.com/naveen._.s.h/ Linkedin : https://www.linkedin.com/in/naveen-sh-a7594b323/

Step 1: Create Supabase Database (2 minutes)

1. Go to supabase.com and sign up (free)
2. Click "New Project"
3. Set a name and password → Click "Create"
4. Wait for project to be ready

Step 2: Run Database Queries

1. In Supabase, click "SQL Editor" (left sidebar)
2. Click "New query"
3. Copy and paste this schema:

-- Users Table
CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  email TEXT UNIQUE NOT NULL,
  services TEXT[],
  created_at TIMESTAMPTZ DEFAULT now(),
  plan TEXT DEFAULT "free"
);

-- APIs Table
CREATE TABLE apis (
  id SERIAL PRIMARY KEY,
  user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
  name VARCHAR(100),
  url TEXT NOT NULL,
  api_type TEXT,
  plan TEXT,
  api_key TEXT,
  created_at TIMESTAMP DEFAULT NOW()
);

-- Uptimes Table
CREATE TABLE uptimes (
  id SERIAL PRIMARY KEY,
  api_id INTEGER NOT NULL REFERENCES apis(id) ON DELETE CASCADE,
  status VARCHAR(10) CHECK (status IN ('up', 'down')),
  latency INTEGER,
  started_at TIMESTAMP NOT NULL,
  ended_at TIMESTAMP,
  email_sent BOOLEAN DEFAULT false
);

-- Logs Table
CREATE TABLE logs (
  id SERIAL PRIMARY KEY,
  api_id INTEGER NOT NULL REFERENCES apis(id) ON DELETE CASCADE,
  user_email TEXT NOT NULL,
  timestamp TIMESTAMP DEFAULT NOW(),
  method TEXT,
  response_code INTEGER,
  ip_address TEXT,
  country TEXT,
  city TEXT,
  endpoint TEXT
);

1. Click "Run" → You should see ✅ Success

Step 3: Get Database URL

1. In Supabase, go to Settings → Database
2. Find "Connection string" section
3. Click "URI" tab
4. Copy the connection string
5. Replace [YOUR-PASSWORD] with your actual password

Step 4: Setup Backend Environment