Nba MCP Server vs Macrofactor MCP

setup_check

Check local setup and explain the easiest next action. Use this first when the MCP seems empty, stale, misconfigured, or when you are not sure which tool to call next. Args: show_workflows: Include common question-to-tool workflows.

import_export

Import a MacroFactor .xlsx export file into the database. Supports both Quick Export and All-Time Data formats. If filename is empty, auto-detects the most recent .xlsx in the data directory. Args: filename: Path to .xlsx file, or empty to auto-detect.

clear_data

Clear all imported data so you can reimport fresh exports.

data_status

Check what data is currently loaded — date ranges, row counts, last import.

query

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).

get_nutrition_summary

Get nutrition summary for a specific date. Args: date_str: Date in YYYY-MM-DD format. Empty = today.

get_nutrition_range

Get daily nutrition data for a date range. Args: start_date: Start date (YYYY-MM-DD) end_date: End date (YYYY-MM-DD)

get_food_log

Get all foods logged on a specific date. Args: date_str: Date (YYYY-MM-DD). Default: today.

search_food

Search logged foods by name across all dates. Also searches custom foods if no log results found. Args: query: Search term (case-insensitive). limit: Max results (default 20).

get_weight_trend

Get weight trend data. Defaults to last 30 days. Args: start_date: Start date (YYYY-MM-DD). Default: 30 days ago. end_date: End date (YYYY-MM-DD). Default: today.

get_workout_log

Get workout details for a specific date. Args: date_str: Date (YYYY-MM-DD). Default: most recent workout.

get_workout_history

Get a summary of all workouts in a date range. Defaults to last 30 days. Args: start_date: Start date (YYYY-MM-DD) end_date: End date (YYYY-MM-DD)