query
Execute read-only SQL queries against MacroFactor data including nutrition, workouts, body metrics, and Garmin stats to extract specific insights.
Instructions
Run a custom SQL query against the MacroFactor database.
Available tables:
- daily: date, calories, macros, targets, weight, expenditure, steps, micros
- food_log: date, time, food details (from Quick Export)
- workouts: date, exercise, sets, reps, weight (from Quick Export)
- muscle_sets: date, muscle_group, sets
- muscle_volume: date, muscle_group, volume_kg
- exercise_tracking: date, exercise, metric, value (from All-Time)
- body_metrics: date, metric, value
- custom_foods: food_name, nutrition info
- nutrition_targets: program_date, weekday, targets
- food_log_notes: date, name, note
- garmin_daily_stats: date, steps, calories, HR, stress, body battery
- garmin_activities: activity_id, date, type, duration, distance, HR, power
- garmin_sleep: date, sleep phases, score, HRV, SpO2
- garmin_training_status: date, status, VO2max, training load, FTP
- garmin_body_fat: date, body_fat_pct
- garmin_sync_log: sync history
Use `data_status` to see what's loaded.
Args:
sql: SQL query (read-only SELECT statements only).
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |