Supabase
Postgres tables created by Kasy, main fields, and Quick mode scope.
Postgres is relational: each entity is a table with fixed columns. kasy new copies only migrations for selected features.
Back to schema index. Functions and secrets: Edge Functions, Secrets.
Base (every project)
| Table | Stores | Main fields |
|---|---|---|
users | Profile | id, name, email, avatar_url, onboarded, locale, role |
devices | FCM tokens | user_id, installation_id, token, operatingSystem |
subscriptions | Subscription | user_id, status, sku_id, offer_id, period_end_date, trial_end, store |
notifications | In-app notifications | user_id, title, body, type, read_date, data |
user_infos | Onboarding | user_id, info_key, info_value |
Per feature
Feedback — Quick: yes
| Table | Main fields |
|---|---|
feature_requests | title, description (i18n JSON), votes, active |
feature_votes | user_uid, feature_id |
Stripe — Quick: yes
stripe_customers (user_id, customer_id); subscriptions.trial_end.
RevenueCat — Quick: yes
No new table: webhook updates subscriptions.
Ads — Quick: yes
ad_rewards; users.ad_reward_balance.
AI Chat — Quick: yes
ai_conversations, ai_messages.
Kanban — Quick: yes
kanban_columns, kanban_tasks.
Drive — Quick: no
drivers, rides (+ PostGIS). Add with kasy add drive.
Facebook — Quick: yes
No table. Edge Function meta-track-event only.
Quick mode table list
users, devices, subscriptions, notifications, user_infos, feature_requests, feature_votes, stripe_customers, ad_rewards, ai_conversations, ai_messages, kanban_columns, kanban_tasks.
No drivers or rides.
Last updated on 08/02/2026