MyFitnessPal

Promptfree, for everyone, and the only version there is

Open the prompt in Claude CodeOpen the prompt in CodexOpen the prompt in Cursor

Copy

Build me a food diary over an open food database. The database is the whole problem — treat it as such.

STACK
- Astro with a Node adapter, SQLite via better-sqlite3, installable as a progressive web app
- Open Food Facts as the product source, imported locally rather than queried live

THE DATABASE
- Import the Open Food Facts dump for your countries, keeping barcode, name, brand, serving size and nutrients per 100g
- Rebuild the import monthly; keep the version so a changed product does not silently rewrite old entries
- A local foods table for things with no barcode, owned by you and never overwritten by an import

LOGGING
- Barcode scan in the browser with the device camera, falling back to search
- Search ranked by: exact barcode, then brand plus name prefix, then fuzzy, and only within your country's set
- Recent and frequent foods first, because that is what makes logging take five seconds instead of a minute

PORTIONS
- Serving sizes per food with a gram equivalent; store grams, display the serving
- Never store a portion as a label alone

GOALS
- Daily energy and macro targets, with a weekly average shown more prominently than the daily number
- Trend weight using an exponentially weighted average, not raw daily readings

PRIVACY
- Everything local; no account, no upload, and the README says so

Include a README on the import job, the ranking rules and the storage size of the food table.