Database Management

Supabase connection readiness — environment, migrations, RLS, verification, and deployment

🗄️
Supabase Configured — Manual Apply Pending
15 migrations · 94 tables · 177 RLS policies · 9 verification scripts · 48 agents

Next Steps

1️⃣
Apply Migrations in SQL Editor
Run files 0001–0015 from database/migrations/
2️⃣
Run Verification SQL
Execute all 9 scripts from database/verification/
3️⃣
Test Tenant Isolation
Follow SUPABASE_TENANT_ISOLATION_TESTING.md

Supabase Environment

NEXT_PUBLIC_SUPABASE_URL● Set
NEXT_PUBLIC_SUPABASE_ANON_KEY● Set
SUPABASE_SERVICE_ROLE_KEY◉ Server-Only
Overall Status◉ Configured — Not Verified

Deployment Status

Database Deployment◎ Manual Apply Pending
Schema Applied◎ Not Applied
RLS Applied◎ Not Applied
Seed Data Applied◎ Not Applied
Live Database Claim◌ Not Claimed Live
ℹ️ Database deployment requires manual SQL application in Supabase SQL Editor. No automatic deployment is performed.

Database Status

Supabase Connection● Configured
Schema◉ Migration Package Prepared
RLS Policies◉ Migration Package Prepared
Deployment◎ Pending Apply

Tenant Isolation

RLS Policies◉ 177 Policies Prepared
Tenant ID Coverage● All Tenant Tables Covered
Cross-Tenant Testing◎ Pending — Post-Deployment
Service Role Isolation◉ Server-Only Access
🚫 No real tenant data until cross-tenant isolation is verified in Supabase.

Row Level Security

🔒
RLS-Enabled Tables
93+
📋
Total Policies
177
🏢
Tenant Isolation
Designed
✅
Verification SQL
Ready
⚠️ RLS must be tested with verify_tenant_isolation.sql in Supabase before allowing real tenant data.

Seed Data

👤
Roles
8
💳
Plans
3
🤖
Agents
48
🏥
Demo Tenant
1
📊
Demo Leads
5
📝
Templates
3
All demo data uses @example.com emails, +1 555 phone numbers, and "(Sample)" labels. No real customer data.

Deployment Readiness

Migration Package (15 files)● Ready
Consolidated Schema (94 tables)● Ready
Consolidated RLS (177 policies)● Ready
Seed Data (48 agents, roles, plans)● Ready
Verification SQL (9 scripts)● Ready
Schema Applied to Supabase◎ Pending Manual Apply
RLS Verified in Supabase◎ Not Verified
Tenant Isolation Tested◎ Not Tested
Live Database◌ Not Claimed

Migration Package

15 files · 94 tables · Manual apply via Supabase SQL Editor
✓0001Extensions & Core
✓0002Auth, Tenants, Roles7 tables
✓0003Billing, Stripe, Trial9 tables
✓0004CRM, Leads, Pipeline16 tables
✓0005Calls, Voice, Recovery14 tables
✓0006Channels, Messages, Calendar8 tables
✓0007Agent Runtime, Scheduler23 tables
✓0008Marketing (Placeholder)
✓0009Tracking, Analytics18 tables
✓0010Indexes, Comments
✓0011RLS Enable
✓0012RLS Policies (177)
✓0013Seed: Plans, Roles
✓0014Seed: 48 Agents
✓0015Seed: Demo Data

Verification SQL

Run these in Supabase SQL Editor after deployment
verify_tables.sqlCheck 94 tables exist94 tables
verify_indexes.sqlCheck ~188 indexes exist~188 indexes
verify_rls_enabled.sqlCheck RLS enabled on 93+ tables93+ enabled
verify_tenant_isolation.sqlTest cross-tenant isolationNo cross-access
verify_seed_data.sqlCheck roles, plans, demo tenant8 roles, 3 plans
verify_agents_count.sqlVerify 48 agents in registry48 agents
verify_runtime_defaults.sqlCheck runtime is disabled0 active
verify_no_destructive_sql.sqlNo DROP/TRUNCATE/DELETE0 matches
verify_no_secrets.sqlNo leaked credentials0 matches

Manual Apply Checklist

Follow these steps in order to deploy to Supabase
1Create Supabase project (or select existing)
2Copy URL and anon key to .env.localSUPABASE_ENV_LOCAL_SETUP_GUIDE.md
3Open Supabase SQL Editor
4Run migrations 0001–0010 (schema)SUPABASE_SQL_EDITOR_APPLY_GUIDE.md
5Run migration 0011 (enable RLS)
6Run migration 0012 (RLS policies)
7Run migrations 0013–0015 (seed data)
8Run all 9 verification SQL scriptsSUPABASE_VERIFICATION_WORKFLOW.md
9Test tenant isolationSUPABASE_TENANT_ISOLATION_TESTING.md
10Restart SaaS app and check /api/supabase/status

Status API Routes

/api/supabase/statusSupabase connection and readiness
/api/supabase/readinessFull deployment readiness detail
/api/db/statusDatabase and migration status
/api/tenants/statusTenant system and RLS status
/api/runtime/statusAgent runtime status
/api/billing/statusStripe billing status