KasyKasy
Database schema

Overview

Data parity across backends, when schema is created, and links to Supabase and Firebase.

Kasy creates only the schema for features you selected in kasy new. With kasy add <feature>, that feature's tables or collections are added.

Do not rename tables, collections, or fields. Names are in English on purpose and the app uses these exact identifiers.

Where to look

PageContent
SupabasePostgres tables, main fields, Quick mode list
FirebaseFirestore paths and what each collection stores
Edge FunctionsSupabase server functions
Cloud FunctionsFirebase server functions
SecretsAPI keys on both backends

When schema appears

WhenWhat happens
kasy new (Quick)Base + features below, except Drive
kasy new (Advanced)Only what you checked
kasy add <feature>That feature's schema
SupabaseTables visible after db push
FirebaseCollections visible after the first document

Quick mode (data)

Feedback, Stripe, RevenueCat, Ads, AI Chat, Kanban + base. No Drive. Facebook has no table (edge function only).

REST API

The API backend does not run Supabase migrations or create Firestore data collections. Implement the same model on your server. Use Supabase and Firebase pages as concept maps.

Push may use a companion Firebase project (FCM), like Supabase.

Same concept, different field names

ConceptFirebaseSupabase
AvataravatarPathavatar_url
Read notificationseen_dateread_date
Subscription SKUproduct_idsku_id
Period endexpiration_dateperiod_end_date
Kanban orderorderposition

The app maps this in api/. Do not change in the database.

See also Backends and Commands.

Last updated on 08/02/2026