query
Execute SQL queries to retrieve comprehensive nutritional data from the ANSES Ciqual French food composition database, supporting analysis of over 3,000 foods and 60+ nutrients per query.
Instructions
Execute SQL query on ANSES Ciqual French food composition database.
IMPORTANT: Get ALL nutrients in ONE query! Don't make multiple queries for the same food.
EXAMPLE - Get complete nutrition for a food: SELECT f.alim_nom_eng, n.const_nom_eng, 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 = 23000; -- Returns ALL 60+ nutrients in one query!
SCHEMA: • foods: 3,185+ foods with French/English names
alim_code (PK), alim_nom_fr, alim_nom_eng, alim_grp_code
• nutrients: ~60+ nutrients with units
const_code (PK), const_nom_fr, const_nom_eng, unit
• composition: nutritional values per 100g
alim_code, const_code, teneur (value), code_confiance (A/B/C/D)
• foods_fts: full-text search for fuzzy matching
Use: WHERE foods_fts MATCH 'search term'
COMMON QUERIES:
Search foods: SELECT * FROM foods_fts WHERE foods_fts MATCH 'cake';
Get ALL nutrients: JOIN all 3 tables, no WHERE clause on nutrients
Get specific nutrients: Use IN clause with multiple codes at once
KEY NUTRIENT CODES: Energy: 327 (kJ), 328 (kcal) Macros: 25000 (protein g), 31000 (carbs g), 40000 (fat g), 34100 (fiber g), 32000 (sugars g) Minerals: 10110 (sodium mg), 10200 (calcium mg), 10260 (iron mg), 10190 (potassium mg) Vitamins: 55400 (vit C mg), 56400 (vit D µg), 51330 (vit B12 µg), 56310 (vit E mg)
The database is read-only. Use SELECT queries only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes |