{"summary":{"total_products_unified":5193,"total_kroger_products":6346,"total_products_all":11539,"kroger_with_nutrition":5181,"total_nutrient_records":67187,"total_recalls":5000,"total_commodity_prices":20,"total_retail_prices":39},"products_by_source":[{"data_source":"openfoodfacts","cnt":1045},{"data_source":"usda","cnt":4148},{"data_source":"kroger","cnt":6346}],"sources":[{"id":9,"source":"bls_cpi","description":"BLS Average Retail Prices — ~70 food items monthly. National + metro areas.","total_records":39,"last_ingested":"2026-05-24 17:18:31","api_url":"https://api.bls.gov/publicAPI/v2/","has_mcp":"NO — Food Intel is first MCP for this source","notes":"Free (v2 needs key for 500 req/day). Monthly avg prices for eggs, milk, bread, beef, etc.","freshness":"Last ingested: 2026-05-24 17:18:31"},{"id":5,"source":"edamam","description":"Edamam Food Database — Large coverage, UPC lookup, image analysis.","total_records":0,"last_ingested":null,"api_url":"https://api.edamam.com/","has_mcp":"YES — existing MCP server(s) available","notes":"PAID: $14-299/mo. 2-tool MCP (get_food_nutrition, analyze_food_image).","freshness":"Not yet ingested"},{"id":6,"source":"fatsecret","description":"FatSecret — 2.3M+ branded + restaurant foods.","total_records":0,"last_ingested":null,"api_url":"https://platform.fatsecret.com/rest/","has_mcp":"NO — Food Intel is first MCP for this source","notes":"Freemium. No MCP. OAuth1 auth.","freshness":"Not yet ingested"},{"id":10,"source":"fred","description":"FRED (St. Louis Fed) — Food CPI, commodity indices, ag futures.","total_records":0,"last_ingested":null,"api_url":"https://api.stlouisfed.org/fred/","has_mcp":"NO — Food Intel is first MCP for this source","notes":"Free API key. Food-at-home CPI (CUSR0000SAF11), food-away-from-home, etc.","freshness":"Not yet ingested"},{"id":7,"source":"kroger","description":"Kroger Product API — Real-time catalog, pricing, availability.","total_records":6840,"last_ingested":"2026-05-24 17:51:08","api_url":"https://api.kroger.com/v1/","has_mcp":"NO — Food Intel is first MCP for this source","notes":"Free with OAuth. NO MCP. Requires app registration. Nutrition data unclear.","freshness":"Last ingested: 2026-05-24 17:51:08"},{"id":3,"source":"openfda","description":"openFDA — Food recalls + adverse events. Updated weekly.","total_records":5000,"last_ingested":"2026-05-24 17:16:56","api_url":"https://api.fda.gov/food/","has_mcp":"NO — Food Intel is first MCP for this source","notes":"No MCP server exists. Free, no key needed (1000 req/day with key).","freshness":"Last ingested: 2026-05-24 17:16:56"},{"id":2,"source":"openfoodfacts","description":"Open Food Facts — 4M+ products worldwide, crowdsourced, UPC/barcode linked.","total_records":1045,"last_ingested":"2026-05-24 17:20:48","api_url":"https://world.openfoodfacts.org/api/v2/","has_mcp":"YES — existing MCP server(s) available","notes":"9-tool MCP server exists. 100 req/min. Open Database License.","freshness":"Last ingested: 2026-05-24 17:20:48"},{"id":8,"source":"usda_ams","description":"USDA AMS Market News — Commodity prices (produce, meat, dairy, grain). Free. 100 years of data.","total_records":20,"last_ingested":"2026-05-24 17:18:31","api_url":"https://mymarketnews.ams.usda.gov/mymarketnews-api","has_mcp":"NO — Food Intel is first MCP for this source","notes":"Free API. Specialty crops (lettuce!), livestock, dairy, grain. MyMarketNews API.","freshness":"Last ingested: 2026-05-24 17:18:31"},{"id":1,"source":"usda_fdc","description":"USDA FoodData Central — 380K+ foods, nutrition facts, ingredients. Public domain (CC0).","total_records":3525,"last_ingested":"2026-05-24 21:30:47","api_url":"https://api.nal.usda.gov/fdc/v1/","has_mcp":"YES — existing MCP server(s) available","notes":"Free API key from data.gov. 1000 req/hr. Basic MCP wrappers exist (lobehub, medium articles).","freshness":"Last ingested: 2026-05-24 21:30:47"},{"id":4,"source":"usda_organic","description":"USDA Organic Integrity Database — Every certified organic operation in the US.","total_records":0,"last_ingested":null,"api_url":"https://organic.ams.usda.gov/integrity/","has_mcp":"NO — Food Intel is first MCP for this source","notes":"Searchable web UI, no proper API. Would need scraping or FOIA bulk download.","freshness":"Not yet ingested"}],"origin_policy":"Every record in Food Intel carries a data_source field identifying exactly where it came from. Every API response includes a data_origin block with source URL, license, and attribution. Full provenance chain.","ai_gap_analysis":{"problem":"No single database has complete US food data. USDA has nutrition but no prices. OFF has barcodes but sparse US coverage. FDA has recalls but no products.","food_intel_solution":"Aggregate all free public sources, maintain origin on every record, serve unified MCP tools to any AI.","new_product_gap":"New products enter USDA via voluntary manufacturer submission (months). Open Food Facts depends on crowdsourced barcode scans (days-weeks). Kroger has real-time data but no MCP. The FSMA 204 data (farm-to-shelf) exists but is locked in proprietary systems.","maha_opportunity":"Make America Healthy Again requires food transparency. The data exists across 10+ databases. Nobody is unifying it for AI access. That is what Food Intel does."}}