Skip to main content
Ultron uses Supabase (PostgreSQL) with Row Level Security.

Tables Overview

TableDepartmentDescription
profilesCoreUser profiles, business info, workspace code, plan
plan_limitsCorePlan tiers and feature limits
integrationsCoreEncrypted API keys and OAuth tokens
conversationsCoreChat conversation records
messagesCoreIndividual chat messages
leadsSalesLead records with enrichment and scoring
campaignsSalesOutreach campaign tracking
dealsSalesDeal pipeline records
contentCreatesContent pieces with platform and status
content_researchCreatesContent research and trend analysis
agentsBuildsDeployed agent configurations
agent_tasksBuildsIndividual task logs per agent
channel_connectionsChannelsTelegram/Slack/WhatsApp links
google_tokensIntegrationsEncrypted Google OAuth tokens
usage_trackingBillingDaily usage counts per user
billing_eventsBillingStripe webhook events
activity_feedCoreAuto-logged activity stream

Auto-Triggers

TriggerAction
User signupAuto-creates profile with workspace code
New conversationIncrements daily usage counter
New leadLogs to activity feed
Deal stage changeLogs to activity feed
New contentLogs to activity feed
Any record updateUpdates updated_at timestamp