How to set up Supabase FDC database for self-hosting?

[h4rib0]

Hi, I'm trying to self-host OpenNutriTracker and I've set up my own Supabase project. I can see the app uses Supabase as a FDC food database (fdc_food, fdc_portions, fdc_nutrients tables), but I can't find any documentation on how to populate these tables.

Could you provide:

The database schema (table structure)
How to import the USDA FDC data into Supabase
Any migration scripts used

[h4rib0]

Looks like the necessary files are to big for the free plan of supabase.

[h4rib0]

The full dataset includes hundreds of thousands of branded products that would exceed Supabase's 500 MB free limit.
It would be possible to Filter food.csv to keep only Foundation and SR Legacy rows (~9 000 items total).
At the moment, I am not pursuing this idea any further.