location_sql
Run read-only SQL queries to access detailed location history, including stays, trips, places, and daily movement patterns, for custom analysis beyond predefined tools.
Instructions
Read-only SELECT for questions the other tools do not shape. Tables: location_visits(started_at, ended_at, start_offset_m, place_id, semantic_type), location_activities(started_at, ended_at, mode, distance_m, start_lat, start_lon, end_lat, end_lon), location_places(id, lat, lon, address, label, city, admin, country, country_code, tz), location_pings, location_raw_positions(altitude_m, speed_ms), location_trips. Views: location_v_stays (the history spine), location_m_day_home (one row per day with the anchor place and km from home), location_v_records, location_v_home_periods. With the people bridge installed: location_trip_people, location_v_trip_people, people_v_trips.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Row cap. Default 200. | |
| query | Yes | A single SELECT statement. |