Life OS Knowledge Base
Personal knowledge system for the Shapira family. Stores hotels, venues, travel logistics, and location-based preferences.
Data Storage
Database: Supabase mocerqjnksmhcjzxrewo.supabase.co
Table: insights (using insight_type for categorization)
Schema
Uses the existing insights table with these insight_types:
HOTEL - Hotels and lodgingSWIM_VENUE - Competition pools and swim facilities RESTAURANT - Dining locationsSERVICE_PROVIDER - Contractors, professionalsTRAVEL_ROUTE - Common drives and logistics
Key Fields
| Field |
Usage |
| insight_type |
Category: HOTEL, SWIM_VENUE, etc. |
| title |
Location name |
| description |
JSON with full details (address, city, state, notes) |
| confidence |
Rating 1-5 |
| related_date |
Last visited date |
| source |
Always "life_os_knowledge" |
Query Examples
Find hotels in a city
GET /rest/v1/insights?insight_type=eq.HOTEL&description=cs."Ocala"
Find swim venues
GET /rest/v1/insights?insight_type=eq.SWIM_VENUE&order=confidence.desc
Insert New Location
import httpx, json
data = {
"insight_type": "HOTEL",
"title": "Hotel Name",
"description": json.dumps({
"address": "123 Main St",
"city": "City",
"state": "FL",
"context": "Why we use this",
"room_type": "king suite",
"amenities": ["pool", "breakfast"],
"value": "excellent"
}),
"related_date": "2025-12-04",
"priority": "medium",
"status": "active",
"source": "life_os_knowledge",
"confidence": 5
}
r = client.post(f"{SUPABASE_URL}/rest/v1/insights", headers=headers, json=data)
Reference Files
references/hotels.md - Hotel reviewsreferences/swim-venues.md - Swim venue detailsreferences/travel.md - Travel routes
Current Data (Dec 2025)
Hotels
- Staybridge Suites Ocala ⭐⭐⭐⭐⭐ - 4627 NW Blitchton Rd, Ocala FL
- Context: Michael swim meets at Ocala Aquatic Center
- Room: Studio with queen beds, full kitchen
- Value: Excellent
Swim Venues
- Ocala Aquatic Center ⭐⭐⭐⭐⭐ - 2500 E Fort King St, Ocala FL
- Pool: FAST, 50m outdoor
- Drive from Satellite Beach: 2.5 hours (142 mi)
- Preferred hotel: Staybridge Suites Ocala
1---2name: life-os-knowledge3description: Personal knowledge base for Shapira family daily life. Use when querying or storing information about hotels, swim meet venues, travel logistics, restaurants, service providers, or any location-based preferences. Triggers on phrases like "remember this hotel", "where did we stay", "next time in [city]", "log this location", or references to past stays/visits.4---5
6# Life OS Knowledge Base
7
8Personal knowledge system for the Shapira family. Stores hotels, venues, travel logistics, and location-based preferences.
9
10## Data Storage
11
12**Database:** Supabase mocerqjnksmhcjzxrewo.supabase.co
13**Table:** `insights` (using insight_type for categorization)
14
15## Schema
16
17Uses the existing `insights` table with these insight_types:
18- `HOTEL` - Hotels and lodging
19- `SWIM_VENUE` - Competition pools and swim facilities
20- `RESTAURANT` - Dining locations
21- `SERVICE_PROVIDER` - Contractors, professionals
22- `TRAVEL_ROUTE` - Common drives and logistics
23
24### Key Fields
25| Field | Usage |
26|-------|-------|
27| insight_type | Category: HOTEL, SWIM_VENUE, etc. |
28| title | Location name |
29| description | JSON with full details (address, city, state, notes) |
30| confidence | Rating 1-5 |
31| related_date | Last visited date |
32| source | Always "life_os_knowledge" |
33
34## Query Examples
35
36### Find hotels in a city
37```python
38GET /rest/v1/insights?insight_type=eq.HOTEL&description=cs."Ocala"
39```
40
41### Find swim venues
42```python
43GET /rest/v1/insights?insight_type=eq.SWIM_VENUE&order=confidence.desc
44```
45
46## Insert New Location
47
48```python
49import httpx, json
50
51data = {
52 "insight_type": "HOTEL",
53 "title": "Hotel Name",
54 "description": json.dumps({
55 "address": "123 Main St",
56 "city": "City",
57 "state": "FL",
58 "context": "Why we use this",
59 "room_type": "king suite",
60 "amenities": ["pool", "breakfast"],
61 "value": "excellent"
62 }),
63 "related_date": "2025-12-04",
64 "priority": "medium",
65 "status": "active",
66 "source": "life_os_knowledge",
67 "confidence": 5
68}
69r = client.post(f"{SUPABASE_URL}/rest/v1/insights", headers=headers, json=data)
70```
71
72## Reference Files
73
74- `references/hotels.md` - Hotel reviews
75- `references/swim-venues.md` - Swim venue details
76- `references/travel.md` - Travel routes
77
78## Current Data (Dec 2025)
79
80### Hotels
81- **Staybridge Suites Ocala** ⭐⭐⭐⭐⭐ - 4627 NW Blitchton Rd, Ocala FL
82 - Context: Michael swim meets at Ocala Aquatic Center
83 - Room: Studio with queen beds, full kitchen
84 - Value: Excellent
85
86### Swim Venues
87- **Ocala Aquatic Center** ⭐⭐⭐⭐⭐ - 2500 E Fort King St, Ocala FL
88 - Pool: FAST, 50m outdoor
89 - Drive from Satellite Beach: 2.5 hours (142 mi)
90 - Preferred hotel: Staybridge Suites Ocala
majiayu000