ANSES Ciqual MCP Server
Provides SQL access to the French ANSES Ciqual nutritional database containing detailed composition data for over 3,000 foods. Query nutrients, vitamins, minerals and macros using standard SQL with fuzzy search support.
What it does
- Query nutritional data for 3,000+ French foods via SQL
- Search foods using fuzzy text matching with typo tolerance
- Access 60+ nutrient values including vitamins and minerals
- Retrieve bilingual food names in French and English
Best for
Tools (1)
Execute SQL query on ANSES Ciqual French food composition database. ⚠️ EFFICIENCY: Follow this 2-step workflow to minimize queries! STEP 1 - SEARCH (one query): SELECT alim_code, alim_nom_fr FROM foods_fts WHERE foods_fts MATCH 'steak OR boeuf'; Note: FTS uses OR between words. For "steak sauce poivre", search "steak" first. STEP 2 - GET ALL NUTRIENTS (one query with JOIN): SELECT f.alim_nom_fr, n.const_nom_fr, c.teneur, n.unit FROM foods f JOIN composition c ON f.alim_code = c.alim_code JOIN nutrients n ON c.const_code = n.const_code WHERE f.alim_code = <code_from_step1>; 🛑 STOP after finding a matching food! Don't keep searching with different terms. COMPOUND DISHES (steak + sauce): - CIQUAL has individual ingredients, not full recipes - Search each component: "steak" then "sauce poivre" - Sum the calories (typical portions: meat 150g, sauce 30g) QUICK CALORIE LOOKUP (const_code 328 = kcal/100g): SELECT f.alim_nom_fr, c.teneur as kcal_100g FROM foods f JOIN composition c ON f.alim_code = c.alim_code WHERE f.alim_code = <code> AND c.const_code = 328; KEY NUTRIENT CODES: Energy: 328 (kcal), 327 (kJ) Macros: 25000 (protein), 31000 (carbs), 40000 (fat), 34100 (fiber), 32000 (sugars) Minerals: 10110 (sodium), 10200 (calcium), 10260 (iron), 10190 (potassium), 10120 (magnesium) Vitamins: 55100 (vit C), 52100 (vit D), 56600 (vit B12), 53100 (vit E), 56700 (folates) SCHEMA: - foods: alim_code (PK), alim_nom_fr, alim_nom_eng, alim_grp_code - nutrients: const_code (PK), const_nom_fr, const_nom_eng, unit - composition: alim_code, const_code, teneur (value per 100g), code_confiance - food_groups: grp_code, grp_nom_fr, grp_nom_eng - foods_fts: FTS5 virtual table for full-text search (alim_code, alim_nom_fr, alim_nom_eng)
