⚡

Connect Your Real Backend

Takes about 5 minutes. Do this once — then your platform is live forever.

Step 1 — Create your free Supabase database

Supabase is your real database — it stores all your customers, logins, tickets, and subscriptions.
It's completely free to start.

1️⃣ Go to supabase.com → Create account → New Project

2️⃣ Pick any name (e.g. "floi-ai") and a strong password → Create

3️⃣ Wait ~2 minutes for setup to finish

4️⃣ Go to Project Settings → API

5️⃣ Copy your Project URL and anon public key

Supabase Project URL

Supabase Anon Key (public)

Your Owner Email (gets Platform Admin access)

Stripe Publishable Key (optional — add later)

Step 2 — Create your tables

Copy this SQL and run it in your Supabase dashboard: SQL Editor → New Query → Paste → Run

-- ═══════════════════════════════════════════════
-- FLOI AI — SUPABASE DATABASE SCHEMA
-- Paste this in: Supabase Dashboard → SQL Editor → Run
-- ═══════════════════════════════════════════════

-- Enable UUID extension
create extension if not exists "uuid-ossp";

-- ── USER PROFILES ──
create table if not exists profiles (
  id uuid references auth.users(id) on delete cascade primary key,
  email text not null,
  full_name text,
  plan text not null default 'Starter',
  workspace_id uuid not null default gen_random_uuid(),
  stripe_customer_id text,
  brand_name text,
  industry text default 'saas',
  created_at timestamptz not null default now(),
  updated_at timestamptz not null default now()
);
alter table profiles enable row level security;
create policy "Users can view own profile" on profiles for select using (auth.uid() = id);
create policy "Users can update own profile" on profiles for update using (auth.uid() = id);
create policy "Users can insert own profile" on profiles for insert with check (auth.uid() = id);

-- ── LOGIN EVENTS ──
create table if not exists login_events (
  id uuid default gen_random_uuid() primary key,
  user_id uuid references auth.users(id) on delete cascade,
  email text,
  user_agent text,
  ip text,
  workspace_id uuid,
  created_at timestamptz not null default now()
);
alter table login_events enable row level security;
create policy "Users can insert own login" on login_events for insert with check (auth.uid() = user_id);
create policy "Users can view own logins" on login_events for select using (auth.uid() = user_id);

-- ── SUPPORT TICKETS ──
create table if not exists tickets (
  id uuid default gen_random_uuid() primary key,
  workspace_id uuid not null,
  user_id uuid references auth.users(id) on delete cascade,
  user_name text,
  user_email text,
  subject text not null,
  message text,
  status text not null default 'open',
  priority text default 'medium',
  ai_reply text,
  created_at timestamptz not null default now(),
  updated_at timestamptz not null default now()
);
alter table tickets enable row level security;
create policy "Workspace members can view tickets" on tickets for select using (workspace_id = (select workspace_id from profiles where id = auth.uid()));
create policy "Workspace members can insert tickets" on tickets for insert with check (workspace_id = (select workspace_id from profiles where id = auth.uid()));
create policy "Workspace members can update tickets" on tickets for update using (workspace_id = (select workspace_id from profiles where id = auth.uid()));

-- ── DATA SUBSCRIPTIONS ──
create table if not exists data_subscriptions (
  id uuid default gen_random_uuid() primary key,
  workspace_id uuid not null,
  user_id uuid references auth.users(id) on delete cascade,
  dataset_id text not null,
  stripe_subscription_id text,
  status text default 'active',
  created_at timestamptz not null default now(),
  unique(workspace_id, dataset_id)
);
alter table data_subscriptions enable row level security;
create policy "Users can view own subscriptions" on data_subscriptions for select using (workspace_id = (select workspace_id from profiles where id = auth.uid()));
create policy "Users can insert own subscriptions" on data_subscriptions for insert with check (user_id = auth.uid());

-- ── WORKSPACE MEMBERS ──
create table if not exists workspace_members (
  id uuid default gen_random_uuid() primary key,
  workspace_id uuid not null,
  invited_by uuid references auth.users(id),
  name text not null,
  email text not null,
  role text not null default 'Viewer',
  status text default 'active',
  created_at timestamptz not null default now(),
  unique(workspace_id, email)
);
alter table workspace_members enable row level security;
create policy "Workspace members can view members" on workspace_members for select using (workspace_id = (select workspace_id from profiles where id = auth.uid()));
create policy "Workspace admins can insert members" on workspace_members for insert with check (workspace_id = (select workspace_id from profiles where id = auth.uid()));

-- ── PLATFORM ADMIN VIEW (owner sees all — bypasses RLS via service role) ──
-- When you query with the SERVICE ROLE key, RLS is bypassed and you see all rows.
-- NEVER expose your service role key in the frontend.
-- For the Platform Admin panel, all queries use the anon key + owner check via email.
-- The app grants "owner" status if the logged-in email matches the owner email you set in Setup.

-- ── AUTO-UPDATE updated_at ──
create or replace function update_updated_at()
returns trigger as $$
begin new.updated_at = now(); return new; end;
$$ language plpgsql;

create trigger trg_profiles_updated before update on profiles for each row execute function update_updated_at();
create trigger trg_tickets_updated before update on tickets for each row execute function update_updated_at();

Open Supabase →

🚀 AI-powered business platform

The AI Operating System
for Every Business

Automate support, generate reports, draft content, and integrate your entire stack — one platform, any industry.

10k+

Businesses

98%

Accuracy rate

5×

Faster operations

Industries

Features

Everything your business needs

One platform for all AI-powered operations — no separate tools needed.

🎨

Custom Branding

White-label the entire platform with your company name, colors, and logo. Every client sees your brand, not ours.

🤖

AI Business Assistant

Chat with a business-grade AI tuned to your industry — SaaS, E-Commerce, Healthcare, Finance, or Agency.

🎫

Customer Support

Triage, route, and auto-reply to tickets. AI drafts replies in your brand voice — approve and send in one click.

📊

Report Builder

Turn raw questions into polished reports — sales, financial, marketing, operations. Generated in seconds.

✍️

Content Studio

Draft emails, proposals, and social posts instantly. Adapts to your industry and brand voice automatically.

💾

Persistent Database

All your data — tickets, reports, settings — saved locally and exportable. Your data, your control.

How it works

Up and running in 3 minutes

No engineers. No setup fees. No long contracts.

Brand it

Set your company name, color, and logo in Settings. The entire platform reflects your brand instantly.

Pick your industry

Select SaaS, E-Commerce, Healthcare, Finance, or Agency. Dashboard, tickets, and AI prompts all adapt.

Add AI & deploy

Paste your OpenAI key to enable AI. Deploy to Netlify in 60 seconds and share your custom domain URL.

Pricing

Simple, transparent pricing

Start free, scale as you grow.

Starter

^$0

forever free

5,000 AI messages/month
1 workspace
Custom branding
All 5 industry presets
Data export

Ready to transform your business?

Join thousands of businesses already running on Floi AI.

Connected Apps

💬

Slack

Post AI summaries and alerts to your Slack channels.

Connected

📮

Gmail

Sync inbox, draft AI replies to incoming messages.

Connected

📊

HubSpot

Sync CRM data for AI-powered sales analysis.

Not connected

🗂️

Notion

Export reports and summaries to Notion.

Not connected

💳

Stripe

Pull billing data for automated financial reports.

Not connected

📁

Google Drive

Read docs and export generated content to Drive.

Connected

REST API

Your API Key

API Reference

POST/v1/chat— Send a message to the AI

curl -X POST https://api.floiai.ai/v1/chat \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"message": "Summarize sales this week"}'

GET/v1/tickets— List support tickets

curl https://api.floiai.ai/v1/tickets?status=open \
  -H "Authorization: Bearer YOUR_KEY"

POST/v1/reports/generate— Generate a report

curl -X POST https://api.floiai.ai/v1/reports/generate \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"type":"sales","period":"Q2 2026"}'

The AI Operating System
for Every Business

Everything your business needs

Custom Branding

AI Business Assistant

Customer Support

Report Builder

Content Studio

Persistent Database

Up and running in 3 minutes

Brand it

Pick your industry

Add AI & deploy

Simple, transparent pricing

Ready to transform your business?

Connected Apps

REST API

🎨 Custom Branding

🏭 Industry Workflow

🔑 AI Configuration

🚀 Deploy to a Real Domain

Export this app

Go to Netlify Drop

Drag & drop the file

Add a custom domain (optional)

🔔 Notifications

🔐 Owner Account (Platform Admin Access)

💾 Data Management

The AI Operating Systemfor Every Business

Everything your business needs

Custom Branding

AI Business Assistant

Customer Support

Report Builder

Content Studio

Persistent Database

Up and running in 3 minutes

Brand it

Pick your industry

Add AI & deploy

Simple, transparent pricing

Ready to transform your business?

Connected Apps

REST API

🎨 Custom Branding

🏭 Industry Workflow

🔑 AI Configuration

🚀 Deploy to a Real Domain

Export this app

Go to Netlify Drop

Drag & drop the file

Add a custom domain (optional)

🔔 Notifications

🔐 Owner Account (Platform Admin Access)

💾 Data Management

The AI Operating System
for Every Business