Lodi Kids Activities

Pending editorial guide drafts.

Top parent search queries in the last 30d. Reads parent_search_queries.

Aggregate stats for a city: # programs, # daycares, % claimed by owners, % with Spanish description, % free, category breakdown. Useful for AIs answering 'how many youth programs are there in Lodi' or comparing Lodi to other cities.

Get current capacity by age band for the daycare(s) this org owns.

Submitted applications for the org's daycare.

Tour requests for the org's daycare(s).

Current waitlist queue for the org's daycare.

Respond to a tour request — confirm with a date/time, propose alternates via notes, or decline.

Upsert capacity for one age band on a daycare. Age bands: infant, toddler, twos, threes, fours, prek, kindergarten.

Returns the currently-promoted programs on the LKA homepage. Reads from featured_listings table within the active date window.

Get full details for a single daycare by slug, including capacity by age band (infant / toddler / 2s / 3s / 4s / pre-K / kindergarten) when the daycare has filled it in. Use after `search_daycares` to surface specifics.

Get full details for a single event by slug. Use after `list_upcoming_events`.

Fetch the full markdown body of a published editorial guide by slug.

Get full details for a single program by slug. Use this after `search_programs` returned a result and the user wants to know more — full description, schedule, registration timing, contact info.

Returns the distinct program categories currently active in the LKA directory (e.g. Sports, Music, Arts, Academics, Swimming, Dance). Use this before search_programs to suggest exact category strings.

Returns the cities Lodi Kids Activities currently serves. Today: Lodi, CA only. Other cities are seeded but inactive; do not surface as active to users.

Lists editorial guides published on LKA — parent-facing articles like 'How to pick a summer camp,' 'Lodi after-school programs by neighborhood,' etc. Useful when a parent is researching a topic rather than searching a specific program.

Public reviews for a program or daycare. Returns rating, text, reviewer first name only, season. Used by AIs to surface parent sentiment when recommending a program.

List upcoming family events in Lodi, CA — open houses, workshops, community days, storytimes, sports clinics. Different from `search_programs` (ongoing classes) — these are single-day or short-window events.

Programs within a radius (miles) of a lat/lng point. Useful for AIs answering 'what's near 95240' style questions. Uses naive Haversine — accurate enough for a single city.

Add a single event (practice, game, scrimmage, picture day, cancellation, etc.) to a program's calendar.

Org-level analytics — page views, saves, contacts in a date window.

Soft-archive a program (active=false). Hides from public directory but preserves history.

Mark a program event as canceled. Enrolled parents see this in their hub + iCal.

Confirm a program listing is still accurate (resets the stale-nudge timer).

Org dashboard summary — program count, leads in last 7d, new saves in last 7d, listing-status breakdown.

Returns a URL to the org's downloadable promo kit (QR poster + share card) for a given program.

Returns recent daycare leads + program saves for the org.

List upcoming events for a program owned by this org.

Returns the org's programs.

Post an org response to a review. Requires consent. Replies are one-shot per review.

Update the org's profile (website, phone, email, logo_url, instagram).

Update an existing program's editable fields.

Set the listing status on a program (accepting / full / waitlist_only / closed_for_season). Requires consent.

Accept a household invite using the token from the invite link.

Add a kid to the parent's account. Requires consent.

Returns the parent's personal iCal feed URL — subscribe in Google/Apple/Outlook Calendar to see practices + games in your normal calendar app. Refreshes hourly.

Cancel a tour request you previously submitted.

Export everything LKA has on you in a single JSON payload (kids, saves, enrollments, tours, reviews, household membership).

Invite a co-parent / partner / grandparent to share this household. They receive a one-time invite link by email; on accept, they join the household and can see all kids + saves.

Leave the current household. If you're the owner and there are other members, ownership transfers to the longest-tenured member.

Returns the parent's enrollments (programs their kid is signed up for).

Returns the parent's kids on file (names + ages, no PII beyond what they shared).

Returns the signed-in parent's saved (hearted) programs AND daycares. Each row has a `kind` field of 'program' or 'daycare' so callers can route to the right detail page. Previously this tool returned `{program_id: null}` for daycare rows with no other data — a hangover from when only programs could be saved.

Returns the parent's daycare tour requests with status.

Returns the signed-in parent's profile + preferences.

Daycare applications the parent has submitted.

Returns the parent's household members + shared kids. If no household exists yet, returns null.

Reviews the parent has submitted.

Upcoming program events (practices, games, scrimmages) for the parent's enrolled programs. Covers next 30 days by default. Cancellations included as 'canceled' status.

Daycare waitlists the parent is on, with current position.

Programs matched to the parent's primary kid's age + interests. Simple matcher today — surfaces top 10 active programs that include the kid's age in their range, weighted by interest overlap.

Remove a kid from the parent's account. Irreversible — deletes the kid record and any kid-linked enrollments/reviews remain but become orphaned (kid_id set null).

Self-report that the parent enrolled their kid in a program outside the LKA RegFlow ('I'm In'). Accepts program UUID or slug.

Submit a daycare tour request. Returns the tour id + status='requested'.

Revoke ALL MCP tokens issued under your parent account. Use this if you suspect an AI agent has misused your access.

Save a daycare to the parent's hub.

Save a program to the parent's hub. Accepts either the program UUID or its slug (e.g. 'youth-soccer-league'). Optionally associate the save with one or more specific kids (by UUID or name) so the kid filter in /account → Saved Programs picks it up. Requires consent.

Submit a review for a program or daycare. One review per (parent, program). Use parent_update_review to edit afterward.

Remove a saved program from the parent's hub. Accepts either the program UUID or its slug. Requires consent.

Update a kid record (birthdate, interests, school, special_needs).

Update parent notification + language preferences.

Upcoming events (practices, games, scrimmages, cancellations) for a specific program. Returns next 30 days. Use this to answer 'is there a game this Saturday?' style questions, and to power Add-to-Calendar flows.

Search licensed daycares in Lodi, CA. Filter by child age (in MONTHS — daycares think in months for under-5s), program kind (daycare / preschool / after_school), facility setting (in_home / center), or claimed-only (more reliable data). Returns up to 10 daycares with hours + tuition where available. For subsidy / bilingual / curriculum filters, follow up with `get_daycare` on a slug.

Search youth programs in Lodi, CA. Filter by free-text query (program name or description), category (Sports, Music, Arts, Academics, Swimming, etc.), child age (integer in years — programs that accept that age), free-only flag, or season. Returns up to 15 matching programs with full details for decision-making (cost, schedule, location, registration status).

Structured map of LKA's public URLs and content sections. Equivalent to llms.txt — gives an AI grounding agent the full topology of the site so it knows what's worth crawling/calling.

Programs whose registration window is opening soon (within the next 60 days). Useful for parents planning ahead.